ARF_223_DETAIL_EXISTING
Description
Synonyms
SDSNZP02_BANK..QRMCGN_ARF_223_DETAIL_EXISTING
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ID | BIGINT | 8 |
| 2 | MONTH_KEY | CHARACTER VARYING(30) | 30 |
| 3 | ACCOUNT_NO | CHARACTER VARYING(50) | 50 |
| 4 | QTR_KEY | CHARACTER VARYING(10) | 10 |
| 5 | SOURCE_SYSTEM | CHARACTER VARYING(20) | 20 |
| 6 | APRA_CLASS | CHARACTER VARYING(20) | 20 |
| 7 | APRA_CATEGORY | CHARACTER VARYING(20) | 20 |
| 8 | APRA_SUB_CATEGORY | CHARACTER VARYING(20) | 20 |
| 9 | APRA_ASSET_CLASS_IRB | CHARACTER VARYING(100) | 100 |
| 10 | COUNTERPARTY_TYPE | CHARACTER VARYING(100) | 100 |
| 11 | QRM_ACCOUNT | CHARACTER VARYING(100) | 100 |
| 12 | PRODUCT_CODE_1 | CHARACTER VARYING(50) | 50 |
| 13 | PRODUCT_CODE_2 | CHARACTER VARYING(50) | 50 |
| 14 | LIMIT_CALCULATED | NUMERIC(15,2) | 19 |
| 15 | BALANCE | NUMERIC(15,2) | 19 |
| 16 | OO_INV_FLAG | CHARACTER VARYING(20) | 20 |
| 17 | REVOLVING_CREDIT_FLAG | CHARACTER VARYING(1) | 1 |
| 18 | NON_HOUSING_PURPOSE_FLAG | CHARACTER VARYING(1) | 1 |
| 19 | IO_FLAG | CHARACTER VARYING(1) | 1 |
| 20 | THIRD_PARTY_ORIGINATED | CHARACTER VARYING(1) | 1 |
| 21 | LMI_FLAG | CHARACTER VARYING(1) | 1 |
| 22 | SETTLE_DATE | CHARACTER VARYING(30) | 30 |
| 23 | DEPOSIT_OFFSET_ACCOUNT | NUMERIC(25,0) | 19 |
| 24 | DEPOSIT_OFFSET_BALANCE | NUMERIC(15,2) | 19 |
| 25 | LOW_DOC_FLAG | CHARACTER VARYING(1) | 1 |
| 26 | IMPDPASTDUE_FLAG | CHARACTER VARYING(1) | 1 |
| 27 | PAST_DUE_DAYS | INTEGER | 4 |
| 28 | UNIT_APARTMENT_FLAG | CHARACTER VARYING(1) | 1 |
| 29 | REPO_FLAG | CHARACTER VARYING(1) | 1 |
| 30 | SMSFS_FLAG | CHARACTER VARYING(1) | 1 |
| 31 | LVR_ERM | NUMERIC(18,6) | 19 |
| 32 | NON_RESIDENT_FLAG | CHARACTER VARYING(1) | 1 |
| 33 | EXPOSURE | NUMERIC(15,2) | 19 |
| 34 | PAST3M_IMPDPASTDUE_FLAG | CHARACTER VARYING(1) | 1 |
| 35 | NEW_IMPDPASTDUE_QTR_FLAG | CHARACTER VARYING(1) | 1 |
| 36 | HARDSHIP_FLAG | CHARACTER VARYING(1) | 1 |
| 37 | EAD_ON_BAL | NUMERIC(15,2) | 19 |
| 38 | UNINCORPORATED_BUS_FLAG | CHARACTER VARYING(1) | 1 |
| 39 | DATA_DATE | TIMESTAMP | 8 |
| 40 | LOAD_ID | INTEGER | 4 |
| 41 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(6) | 6 |
| 42 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 43 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 44 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |