fct_obp_crai_collection_case_insight

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 account_number character varying 120
2 source_system_code character varying 15
3 collection_account_id character varying 30
4 collection_case_id character varying 30
5 person_id character varying 30
6 collection_case_type character varying 36
7 collection_case_type_description character varying 180
8 collection_case_status character varying 36
9 collection_case_status_description character varying 180
10 collection_case_creation_timestamp timestamp without time zone
11 collection_case_approver_id character varying 765
12 collection_case_approver character varying 603
13 collection_case_approve_timestamp timestamp without time zone
14 collection_case_created_by character varying 765
15 collection_case_created_timestamp timestamp without time zone
16 next_collection_action_type_code character varying 36
17 next_collection_action_timestamp timestamp without time zone
18 collection_hold_reason_code character varying 12
19 collection_hold_till_date timestamp without time zone
20 collection_hold_by_case character varying 30
21 lmi_insured_sw character varying 3
22 is_deleted character varying 48
23 collection_customer_number character varying 120
24 contact_person_id character varying 30
25 collection_contact_method_flag character varying 12
26 collection_case_cond_flag character varying 12
27 collection_contact_instructions character varying 6000
28 collection_phone_type_code character varying 36
29 collection_phone character varying 72
30 collection_extension character varying 18
31 collections_party_uid character varying 30
32 collection_party_type character varying 12
33 collections_party_id character varying 30
34 collections_case_category character varying 12
35 collections_reallocate_yn character varying 3
36 collections_create_mode character varying 3
37 is_current character varying 3
38 effective_end_timestamp timestamp without time zone
39 effective_start_timestamp timestamp without time zone
40 business_end_of_day_date timestamp without time zone
41 is_current_for_end_of_day character varying 3