crmd_service_requests

Database

prod_bank_wealth

Schema

sor_crmd

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 crmd_serv_hiid bigint 64
2 run_date timestamp without time zone
3 delta_type character varying 3
4 service_number character varying 192
5 assoc_contact character varying 90
6 external_system_id character varying 90
7 account character varying 120
8 business_customer character varying 90
9 category character varying 150
10 closed_ts timestamp without time zone
11 customer_id_from character varying 120
12 customer_id_to character varying 120
13 due_on timestamp without time zone
14 e_mail character varying 300
15 open_ts timestamp without time zone
16 owner character varying 90
17 priority character varying 90
18 refund character varying 60
19 resolution_1 character varying 90
20 resolution_2 character varying 90
21 sla_in_days character varying 90
22 source character varying 90
23 sr_status character varying 90
24 sub_category character varying 90
25 subject character varying 6000
26 system_status character varying 90
27 type_1 character varying 90
28 type_2 character varying 90
29 enterprise_owner_id character varying 120
30 enterprise_owner_name character varying 765
31 work_ph character varying 105
32 created_by character varying 300
33 created_user character varying 60
34 created_ts timestamp without time zone
35 modified_ts timestamp without time zone
36 modified_user character varying 60
37 effective_strt_dt timestamp without time zone
38 effective_end_dt timestamp without time zone