SDW_TSDMD_AR_DIM

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 AR_DIM_ID BIGINT 8
2 ISRT_RUN_AUDT_ID BIGINT 8
3 UDT_RUN_AUDT_ID BIGINT 8
4 AR_ID BIGINT 8
5 EFF_DT TIMESTAMP 8
6 END_DT TIMESTAMP 8
7 CURR_RECORD_FL CHARACTER VARYING(1) 1
8 SRC_SYS_CD CHARACTER VARYING(12) 12
9 SRC_COMPANY_CD CHARACTER VARYING(6) 6
10 SRC_PROD_TP_CD CHARACTER VARYING(6) 6
11 SRC_ACCT_NBR_CD CHARACTER VARYING(20) 20
12 UNIQUE_ID_SRC_SYS CHARACTER VARYING(256) 256
13 OPN_DT TIMESTAMP 8
14 CLS_DT TIMESTAMP 8
15 CRT_DT TIMESTAMP 8
16 AR_LIFE_CYCLE_ST_TP_CD CHARACTER VARYING(24) 24
17 AR_LIFE_CYCLE_ST_TP_NM CHARACTER VARYING(256) 256
18 AR_LIFE_CYCLE_ST_TP_STD_CD CHARACTER VARYING(24) 24
19 AR_STATUS_TP_CD CHARACTER VARYING(24) 24
20 AR_STATUS_TP_NM CHARACTER VARYING(256) 256
21 AR_BLOCK_TP_CD CHARACTER VARYING(24) 24
22 AR_BLOCK_TP_NM CHARACTER VARYING(256) 256
23 AR_RECLASS_TP_CD CHARACTER VARYING(24) 24
24 AR_RECLASS_TP_NM CHARACTER VARYING(256) 256
25 BSC_RESTRAINT_GRP_CD CHARACTER VARYING(256) 256
26 BSC_RESTRAINT_GRP_NBR BIGINT 8
27 AR_CLS_REASON_TP_CD CHARACTER VARYING(24) 24
28 AR_CLS_REASON_TP_STD_CD CHARACTER VARYING(24) 24
29 AR_CLS_REASON_TP_NM CHARACTER VARYING(256) 256
30 AR_CLS_REASON_TP_STD_NM CHARACTER VARYING(256) 256
31 AR_WRITEOFF_REASON_TP_CD CHARACTER VARYING(24) 24
32 AR_WRITEOFF_REASON_TP_STD_CD CHARACTER VARYING(24) 24
33 AR_WRITEOFF_REASON_TP_NM CHARACTER VARYING(256) 256
34 AR_WRITEOFF_REASON_TP_STD_NM CHARACTER VARYING(256) 256
35 DT_LAST_WRITEOFF TIMESTAMP 8
36 WRITEOFF_FL CHARACTER VARYING(1) 1
37 INDUSTRY_CL_CD CHARACTER VARYING(24) 24
38 INDUSTRY_CL_STD_CD CHARACTER VARYING(24) 24
39 INDUSTRY_CL_NM CHARACTER VARYING(256) 256
40 INDUSTRY_CL_STD_NM CHARACTER VARYING(256) 256
41 AR_SECURITY_TP_CD CHARACTER VARYING(24) 24
42 COLLATERAL_TP_CD CHARACTER VARYING(24) 24
43 COLLATERAL_TP_STD_CD CHARACTER VARYING(24) 24
44 COLL_TP_SECURED_UNSECURED_FL CHARACTER VARYING(1) 1
45 INSURANCE_COMPANY_CD CHARACTER VARYING(24) 24
46 INSURANCE_PROD_TP_CD CHARACTER VARYING(24) 24
47 INSURANCE_PROD_TP_NM CHARACTER VARYING(256) 256
48 INSURANCE_TP_CD CHARACTER VARYING(24) 24
49 MTGE_INS_FL CHARACTER VARYING(1) 1
50 MTGE_INS_100PCT_COVER_HELD_FL CHARACTER VARYING(1) 1
51 DT_LAST_REVIEW TIMESTAMP 8
52 LVR NUMERIC(5,2) 19
53 MANAGING_OU_IP_CD CHARACTER VARYING(24) 24
54 REPAYMENT_FREQ_TP_CD CHARACTER VARYING(24) 24
55 TFR_FROM_ACCT_NBR_CD CHARACTER VARYING(20) 20
56 TFR_TO_ACCT_NBR_CD CHARACTER VARYING(20) 20
57 NBR_CUST BIGINT 8
58 NBR_TIMES_CARD_LOST_STOLEN BIGINT 8
59 COLLECTION_CLASS_CD CHARACTER VARYING(24) 24
60 NBR_AUTO_REAGE BIGINT 8
61 DT_LAST_MNUL_REAGE TIMESTAMP 8
62 AUTO_REAGE_FL CHARACTER VARYING(1) 1
63 AFFILIATION_TP_CD CHARACTER VARYING(24) 24
64 AFFILIATION_TP_NM CHARACTER VARYING(256) 256
65 AFFILIATION_TP_STD_CD CHARACTER VARYING(24) 24
66 AFFILIATION_TP_STD_NM CHARACTER VARYING(256) 256
67 AR_PURPOSE_TP_NM CHARACTER VARYING(256) 256
68 AR_PURPOSE_TP_STD_CD CHARACTER VARYING(24) 24
69 AR_PURPOSE_TP_STD_NM CHARACTER VARYING(256) 256
70 AR_SUB_PURPOSE_TP_CD CHARACTER VARYING(24) 24
71 AR_SUB_PURPOSE_TP_NM CHARACTER VARYING(256) 256
72 AR_SUB_PURPOSE_TP_STD_CD CHARACTER VARYING(24) 24
73 AR_SUB_PURPOSE_TP_STD_NM CHARACTER VARYING(256) 256
74 AR_CASHBACK_AVAIL_TP_CD CHARACTER VARYING(24) 24
75 AR_CASHBACK_AVAIL_TP_NM CHARACTER VARYING(256) 256
76 AR_CASHBACK_AVAIL_TP_STD_CD CHARACTER VARYING(24) 24
77 AR_CASHBACK_AVAIL_TP_STD_NM CHARACTER VARYING(256) 256
78 COLL_TP_SECURED_UNSECURED_CD CHARACTER VARYING(64) 64
79 AR_SECURITISATION_STATUS_TP_CD CHARACTER VARYING(24) 24
80 AR_SECURITISATION_STATUS_TP_NM CHARACTER VARYING(256) 256
81 AR_SECURITISATION_STATUS_FL CHARACTER VARYING(1) 1
82 INSURANCE_TP_NM CHARACTER VARYING(256) 256
83 INSURANCE_TP_STD_CODE CHARACTER VARYING(24) 24
84 INSURANCE_TP_STD_NM CHARACTER VARYING(256) 256
85 INSURANCE_TP_PARENT_NM CHARACTER VARYING(64) 64
86 INSURANCE_TP_CR_INSURANCE_FL CHARACTER VARYING(1) 1
87 ORIG_LVR NUMERIC(5,2) 19
88 INT_ACCRUAL_STATUS_TP_CD CHARACTER VARYING(24) 24
89 INT_ACCRUAL_STATUS_TP_NM CHARACTER VARYING(256) 256
90 INT_ACCRUAL_STATUS_TP_STD_CD CHARACTER VARYING(24) 24
91 INT_ACCRUAL_STATUS_TP_STD_NM CHARACTER VARYING(256) 256
92 INT_ACCRUAL_STATUS_FL CHARACTER VARYING(1) 1
93 INSURANCE_COMPANY_WAIVE_CD CHARACTER VARYING(64) 64
94 INSURANCE_COMPANY_STD_CD CHARACTER VARYING(24) 24
95 INSURANCE_PROD_100PCT_COVER_CD CHARACTER VARYING(64) 64
96 NOVATED_LEASE_F CHARACTER VARYING(1) 1
97 LEASE_OPN_FOR_REWRITE_FL CHARACTER VARYING(1) 1
98 LEASE_CLS_FOR_REWRITE_FL CHARACTER VARYING(1) 1
99 DT_PDL_CONVERT_TO_LEASE TIMESTAMP 8
100 AR_LIFE_CYCLE_ST_TP_PARENT_NM CHARACTER VARYING(256) 256
101 SECURED_BY_MTGE_FL CHARACTER VARYING(1) 1
102 AR_CASHBACK_AVAIL_ALLOWED_FL CHARACTER VARYING(1) 1
103 AR_PURPOSE_TP_CD CHARACTER VARYING(24) 24
104 STAFF_FL CHARACTER VARYING(1) 1
105 LOW_DOC_FL CHARACTER VARYING(1) 1
106 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
107 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
108 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
109 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8