FCT_QRM_ACCOUNT_TO_COLLATERAL_MR

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..FCT_QRM_ACCOUNT_TO_COLLATERAL_MR_V

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