bank_efs_loan_purpose_phase2

Database

prod_bank_wealth

Schema

sor_rdm

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 id integer 32
2 muid character varying 4096
3 versionname character varying 150
4 versionnumber integer 32
5 version_id integer 32
6 versionflag character varying 150
7 name character varying 750
8 code character varying 750
9 changetrackingmask integer 32
10 source_system_code character varying 300
11 product_id character varying 300
12 owner_occupied character varying 300
13 loan_purpose character varying 300
14 loan_sub_purpose character varying 300
15 product_description character varying 300
16 purpose_description character varying 300
17 sub_purpose_description character varying 300
18 loan_type character varying 300
19 purpose_type character varying 300
20 rv_purpose character varying 300
21 adj_prop_rights character varying 300
22 class_code character varying 9
23 class_desc character varying 300
24 enterdatetime timestamp without time zone
25 enterusername character varying 300
26 enterversionnumber integer 32
27 lastchgdatetime timestamp without time zone
28 lastchgusername character varying 300
29 lastchgversionnumber integer 32
30 validationstatus character varying 750