| 1 |
account_number |
text |
|
| 2 |
scope_account_id_number |
text |
|
| 3 |
submission_id |
text |
|
| 4 |
migrated_date |
timestamp without time zone |
|
| 5 |
first_home_owner_grant_flag |
character varying |
3 |
| 6 |
orig_lvr |
numeric |
8 |
| 7 |
orig_app_capture_user_dt |
timestamp without time zone |
|
| 8 |
cdtl_approval_date |
timestamp without time zone |
|
| 9 |
uncdtl_approval_date |
timestamp without time zone |
|
| 10 |
dim_migrated_date_open |
timestamp without time zone |
|
| 11 |
account_opening_date |
timestamp without time zone |
|
| 12 |
obp_facility_id |
text |
|
| 13 |
obp_account_id_number |
text |
|
| 14 |
migration_status |
character varying |
24 |
| 15 |
obp_effective_start_date |
timestamp without time zone |
|
| 16 |
obp_effective_end_date |
timestamp without time zone |
|
| 17 |
sln_appln_id |
character varying |
60 |
| 18 |
sln_loan_acct |
character varying |
60 |
| 19 |
sln_facility_id |
character varying |
60 |
| 20 |
add_loan_fl |
character varying |
3 |
| 21 |
add_loan_date |
timestamp without time zone |
|
| 22 |
is_split |
character varying |
3 |
| 23 |
product_code |
character varying |
18 |
| 24 |
loan_purpose_code |
character varying |
180 |
| 25 |
loan_sub_purpose_code |
character varying |
180 |
| 26 |
payment_type |
character varying |
72 |
| 27 |
loan_use |
character varying |
180 |
| 28 |
loan_amt |
numeric |
13 |
| 29 |
sln_settlement_date |
timestamp without time zone |
|
| 30 |
sln_effective_start_date |
date |
|
| 31 |
sln_effective_end_date |
date |
|
| 32 |
monthend_date |
date |
|