QRM_ACCOUNT_TO_COLLATERAL_MR

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..BNKNIC_QRM_ACCOUNT_TO_COLLATERAL_MR

SDSNZP02_BANK..EFS_QRM_ACCOUNT_TO_COLLATERAL_MR

SDSNZP02_BANK..UBAR_QRM_ACCOUNT_TO_COLLATERAL_MR

SDSNZP05_BANK..CBP_QRM_ACCOUNT_TO_COLLATERAL_MR

Columns
# Name Data Type Length
1 REC_ID INTEGER 4
2 ACCOUNT_NUMBER NUMERIC(28,0) 19
3 ACCOUNT_STATUS CHARACTER VARYING(50) 50
4 ADDRESS_CITY CHARACTER VARYING(50) 50
5 ADDRESS_LINE1 CHARACTER VARYING(35) 35
6 ADDRESS_LINE2 CHARACTER VARYING(35) 35
7 ADDRESS_LINE3 CHARACTER VARYING(35) 35
8 ADDRESS_STATE CHARACTER VARYING(30) 30
9 ADDRESS_ZIP CHARACTER VARYING(30) 30
10 APRA_ASSET_CLASS CHARACTER VARYING(100) 100
11 APRA_ASSET_CLASS_IRB CHARACTER VARYING(100) 100
12 APRA_CATEGORY INTEGER 4
13 APRA_CLASS INTEGER 4
14 APRA_SUB_CATEGORY INTEGER 4
15 BANK_HAIRCUT_VALUE NUMERIC(22,3) 19
16 BANK_VALUE NUMERIC(22,0) 19
17 BASEL_USE_TYPE CHARACTER VARYING(50) 50
18 BROKER_ORIGINATED_FLAG CHARACTER VARYING(1) 1
19 CHARGE_ID CHARACTER VARYING(20) 20
20 CHARGE_REG_NUMBER CHARACTER VARYING(20) 20
21 CHARGE_STATUS CHARACTER VARYING(2) 2
22 CHARGE_TYPE CHARACTER VARYING(20) 20
23 CLMS_GROUP_NAME CHARACTER VARYING(255) 255
24 CLMS_GROUP_NUMBER INTEGER 4
25 COLL_GROUP_ID_ALL_ASSETS INTEGER 4
26 COLLATERAL_CATEGORY CHARACTER VARYING(50) 50
27 COLLATERAL_DESCRIPTION CHARACTER VARYING(255) 255
28 COLLATERAL_ID NUMERIC(16,0) 19
29 COLLATERAL_SUB_CATEGORY CHARACTER VARYING(50) 50
30 COLLATERAL_TYPE CHARACTER VARYING(50) 50
31 COMMENTS CHARACTER VARYING(1000) 1000
32 CONTRACT_OF_SALE_VALUE NUMERIC(22,0) 19
33 COUNTERPARTY_NAME CHARACTER VARYING(255) 255
34 COUNTERPARTY_TYPE CHARACTER VARYING(50) 50
35 COUNTY CHARACTER VARYING(40) 40
36 CREATION_DATE TIMESTAMP 8
37 CUR_NET_RATE NUMERIC(8,2) 19
38 EXECUTION_DATE TIMESTAMP 8
39 EXPOSURE NUMERIC(15,2) 19
40 FACE_AMT NUMERIC(15,2) 19
41 FOLIO_NUMBER CHARACTER VARYING(40) 40
42 GROUP_LVR_BV NUMERIC(22,12) 19
43 GROUP_LVR_MV NUMERIC(22,12) 19
44 GUARANTOR_NAME CHARACTER VARYING(250) 250
45 ID_NUMBER CHARACTER VARYING(50) 50
46 IDENTIFIER_NUMBER CHARACTER VARYING(40) 40
47 IMPDPASTDUE_FLAG CHARACTER VARYING(1) 1
48 LIMIT_CALCULATED NUMERIC(15,2) 19
49 LOAN_TO_VALUE_RATIO_BV NUMERIC(22,12) 19
50 LOAN_TO_VALUE_RATIO_MV NUMERIC(22,12) 19
51 LOT_DESCRIPTION CHARACTER VARYING(255) 255
52 LOW_DOC_FLAG CHARACTER VARYING(1) 1
53 LVR_ERM NUMERIC(14,4) 19
54 LVR_EST_GROUP NUMERIC(15,4) 19
55 MARKET_VALUE NUMERIC(15,2) 19
56 MATURITY_DATE TIMESTAMP 8
57 MORTGAGE_INSURANCE_COMPANY CHARACTER VARYING(50) 50
58 MORTGAGE_INSURANCE_INDICATOR CHARACTER VARYING(1) 1
59 NATURE_TYPE CHARACTER VARYING(10) 10
60 OBJECT_STATUS_FLAG CHARACTER VARYING(1) 1
61 OCCUPANCY_TYPE CHARACTER VARYING(20) 20
62 OD_SECURED_FLAG CHARACTER VARYING(1) 1
63 ORACLE_GL_COST_CENTRE INTEGER 4
64 PARISH CHARACTER VARYING(50) 50
65 PAST_DUE_DAYS INTEGER 4
66 PLAN_DESC CHARACTER VARYING(2000) 2000
67 PLAN_NUMBER CHARACTER VARYING(40) 40
68 PORTFOLIO_DATE TIMESTAMP 8
69 PRODUCT_CODE_1 CHARACTER VARYING(16) 16
70 PRODUCT_CODE_2 CHARACTER VARYING(15) 15
71 PRODUCT_DESCRIPTION CHARACTER VARYING(100) 100
72 QRM_ACCOUNT CHARACTER VARYING(75) 75
73 REG_AUTHORITY CHARACTER VARYING(120) 120
74 REGISTRATION_DATE TIMESTAMP 8
75 REGISTRATION_END_DATE TIMESTAMP 8
76 REGISTRATION_STATUS CHARACTER VARYING(2) 2
77 REVALUATION_DATE TIMESTAMP 8
78 REVALUATION_PERIOD CHARACTER VARYING(40) 40
79 SECURITISATION_POOL_ID CHARACTER VARYING(8) 8
80 SECURITISATION_REPORTABLE CHARACTER VARYING(3) 3
81 SECURITISATION_STATUS CHARACTER VARYING(1) 1
82 SETTLEMENT_DATE TIMESTAMP 8
83 SOURCE_SYSTEM CHARACTER VARYING(4) 4
84 TCE_GROUP_ID INTEGER 4
85 TITLE_REFERENCE CHARACTER VARYING(40) 40
86 TITLES_SERIAL_ID NUMERIC(9,0) 19
87 UNDERCONSTRUCTION_FLAG CHARACTER VARYING(1) 1
88 VACANT_LAND_FLAG CHARACTER VARYING(1) 1
89 VALUATION_DATE TIMESTAMP 8
90 VALUATION_ID CHARACTER VARYING(16) 16
91 VALUATION_MODE CHARACTER VARYING(3) 3
92 VALUATION_TYPE CHARACTER VARYING(3) 3
93 VOLUME_NUMBER CHARACTER VARYING(40) 40
94 ASSET_MANAGER_ID CHARACTER VARYING(100) 100
95 ASSET_MANAGER_NAME CHARACTER VARYING(100) 100
96 ASSET_MANAGER_USERID CHARACTER VARYING(100) 100
97 BRANCH_NAME CHARACTER VARYING(30) 30
98 CLMS_PRODUCT_DIVISION INTEGER 4
99 COMPOSITE_CDR CHARACTER VARYING(2) 2
100 COMPOSITE_COUNTERPARTY_BDM CHARACTER VARYING(6) 6
101 COMPOSITE_CR CHARACTER VARYING(2) 2
102 DEPOSIT_ACCOUNT_BALANCE NUMERIC(15,2) 19
103 DEPOSIT_ACCOUNT_NUMBER NUMERIC(20,0) 19
104 DEPOSIT_ACCOUNT_SYSTEM CHARACTER VARYING(10) 10
105 INSURANCE_CURRENT_FLAG CHARACTER VARYING(1) 1
106 INSURANCE_MAX_EXPIRY_DATE TIMESTAMP 8
107 LIEN_AMOUNT NUMERIC(15,2) 19
108 LOAN_PURPOSE_CODE CHARACTER VARYING(6) 6
109 LOAN_SUB_PURPOSE_CODE CHARACTER VARYING(15) 15
110 SECONDARY_OFFICER_CODE CHARACTER VARYING(10) 10
111 TBE NUMERIC(15,2) 19
112 TCE NUMERIC(15,2) 19
113 WATCHLIST_CREDITREC_INDICATOR CHARACTER VARYING(2) 2
114 DATA_DATE TIMESTAMP 8
115 LOAD_ID INTEGER 4
116 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
117 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
118 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
119 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8