DIM_SDW_HOGAN_MIGRATED_ACCOUNTS_INSIGHT
Description
Synonyms
SDSNZP02_BANK..ATOCRS_DIM_SDW_HOGAN_MIGRATED_ACCOUNTS_INSIGHT
SDSNZP02_BANK..EFS_DIM_SDW_HOGAN_MIGRATED_ACCOUNTS_INSIGHT
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 2 | ACCOUNT_NUMBER | CHARACTER VARYING(21) | 21 |
| 3 | SDW_ACCOUNT_NUMBER | CHARACTER VARYING(20) | 20 |
| 4 | MIGRATED_DATE | DATE | 4 |
| 5 | AR_ID | BIGINT | 8 |
| 6 | ORIGINATION_CHANNEL | CHARACTER VARYING(30) | 30 |
| 8 | SLN_ARRANGEMENT_ID | CHARACTER VARYING(20) | 20 |
| 9 | ORIG_LVR | NUMERIC(8,3) | 19 |
| 10 | ORIG_TERM | BIGINT | 8 |
| 11 | ADD_LOAN_FLAG | CHARACTER VARYING(1) | 1 |
| 12 | ADD_LOAN_TYPE | CHARACTER VARYING(100) | 100 |
| 13 | ADD_LOAN_DATE | TIMESTAMP | 8 |
| 14 | CDTL_APPROVAL_DATE | TIMESTAMP | 8 |
| 15 | UNCDTL_APPROVAL_DATE | TIMESTAMP | 8 |
| 16 | DATA_ENTRY_BRANCH | CHARACTER VARYING(5) | 5 |
| 17 | APPLICATION_BRANCH | CHARACTER VARYING(5) | 5 |
| 18 | ORIG_APP_CAPTURE_USER_DT | TIMESTAMP | 8 |
| 19 | SALES_OFFICER_ID | CHARACTER VARYING(12) | 12 |
| 20 | SALES_OFFICER_NAME | CHARACTER VARYING(80) | 80 |
| 21 | MORTGAGE_INSURANCE_FLAG | CHARACTER VARYING(1) | 1 |
| 22 | MORTGAGE_INSURANCE_PROVIDER | CHARACTER VARYING(80) | 80 |
| 23 | DATE_OPEN | TIMESTAMP | 8 |
| 24 | DATE_CLOSED | TIMESTAMP | 8 |
| 25 | FIRST_HOME_OWNER_GRANT_FLAG | CHARACTER VARYING(1) | 1 |
| 26 | ELECTRONIC_LODGEMENT_NO | CHARACTER VARYING(30) | 30 |
| 27 | BROKER_CODE | CHARACTER VARYING(5) | 5 |
| 28 | ACCREDITED_BROKER_CODE | CHARACTER VARYING(7) | 7 |
| 29 | LENDER_ID | CHARACTER VARYING(100) | 100 |
| 30 | CDTL_APPROVAL_OFFICER | CHARACTER VARYING(12) | 12 |
| 31 | UNCDTL_APPROVAL_OFFICER | CHARACTER VARYING(12) | 12 |
| 32 | VERIFIED_BY | CHARACTER VARYING(100) | 100 |
| 33 | SUPPORT_OFFICER_ID | CHARACTER VARYING(100) | 100 |
| 34 | ORIG_SALES_OFFICER_ID | CHARACTER VARYING(12) | 12 |
| 35 | ORIG_SALES_OFFICER_NAME | CHARACTER VARYING(80) | 80 |
| 36 | MONTH_OPENING_BALANCE | NUMERIC(14,2) | 19 |
| 37 | MONTH_OPENING_UNDRAWN_AMOUNT | NUMERIC(14,2) | 19 |
| 38 | MONTH_OPENING_AVAILABLE_REDRAW_BALANCE | NUMERIC(14,2) | 19 |
| 39 | MONTH_OPENING_OFFSET_FACILITY_BALANCE | NUMERIC(14,2) | 19 |
| 40 | MONTH_OPENING_PRINCIPLE_LIMIT | NUMERIC(15,5) | 19 |
| 41 | BALANCE_SHEET_INDICATOR | CHARACTER VARYING(20) | 20 |
| 42 | WEEK_START_ID | NUMERIC(38,0) | 19 |
| 43 | WEEK_END_ID | NUMERIC(38,0) | 19 |
| 44 | MONTH_START_ID | NUMERIC(38,0) | 19 |
| 45 | MONTH_END_ID | NUMERIC(38,0) | 19 |
| 46 | WEEK_START_DATE | DATE | 4 |
| 47 | WEEK_END_DATE | DATE | 4 |
| 48 | MONTH_START_DATE | DATE | 4 |
| 49 | MONTH_END_DATE | DATE | 4 |
| 50 | MIGRATED_DATE_MINUS_1 | DATE | 4 |
| 51 | MIGRATED_PERIOD_DIM_ID | INTEGER | 4 |
| 52 | MIGRATED_PERIOD_DIM_ID_MINUS_1 | INTEGER | 4 |
| 53 | PRIOR_MONTH_END_ID | INTEGER | 4 |
| 54 | END_OF_PRIOR_WEEK_ID | INTEGER | 4 |
| 55 | END_OF_PRIOR_MONTH_ID | INTEGER | 4 |
| 56 | END_OF_PRIOR_QUARTER_ID | INTEGER | 4 |
| 57 | END_OF_PRIOR_FINANCIAL_YEAR_ID | INTEGER | 4 |
| 58 | PREV_PRINCIPLE_LIMIT | NUMERIC(15,5) | 19 |
| 59 | OFFSET_STATUS | CHARACTER VARYING(24) | 24 |
| 60 | BILL_SRC_STRT_DT | TIMESTAMP | 8 |
| 61 | CURR_DUE_DATE | DATE | 4 |
| 62 | LATEST_SCHDULE_CREATION_DATE | DATE | 4 |