SDW_TSDMQ_PORTFOLIO_PIT

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BUSINESS_LOAD_DATE TIMESTAMP 8
2 DQ_ISSUE_NUMBER NUMERIC(38,0) 19
3 COLUMN_NAME CHARACTER VARYING(500) 500
4 DQ_REASON_DESC CHARACTER VARYING(500) 500
5 DQ_ACTION CHARACTER VARYING(50) 50
6 DQ_INFO CHARACTER VARYING(500) 500
7 SRC_TYPE CHARACTER VARYING(100) 100
8 TGT_TYPE CHARACTER VARYING(100) 100
9 SRC_NAME CHARACTER VARYING(500) 500
10 TGT_NAME CHARACTER VARYING(500) 500
11 SRC_SYS_NAME CHARACTER VARYING(100) 100
12 SRC_ROW CHARACTER VARYING(4000) 4000
13 JOB_NAME CHARACTER VARYING(100) 100
14 JOB_SEQ CHARACTER VARYING(100) 100
15 JOB_INVOCATION CHARACTER VARYING(100) 100
16 DS_PROJECT CHARACTER VARYING(100) 100
17 JOB_START_TIME TIMESTAMP 8
18 PERIOD_DIM_ID BIGINT 8
19 ACCOUNT_DIM_ID BIGINT 8
20 CQR_DIM_ID BIGINT 8
21 SR_DIM_ID BIGINT 8
22 CRC_DIM_ID BIGINT 8
23 SOURCE_PRODUCT_DIM_ID BIGINT 8
24 CLMS_DIVISION_DIM_ID BIGINT 8
25 BDM_DIM_ID BIGINT 8
26 GL_BUSINESS_UNIT_DIM_ID BIGINT 8
27 GL_PRODUCT_DIM_ID BIGINT 8
28 GL_ACCOUNT_DIM_ID BIGINT 8
29 COST_CENTRE_DIM_ID BIGINT 8
30 BRANCH_DIM_ID BIGINT 8
31 CLMS_GROUP_DIM_ID BIGINT 8
32 BORROWER_DIM_ID BIGINT 8
33 ACCOUNT_STATUS_DIM_ID BIGINT 8
34 INSERT_RUN_AUDIT_ID NUMERIC(38,0) 19
35 UPDATE_RUN_AUDIT_ID NUMERIC(38,0) 19
36 CURRENT_BALANCE NUMERIC(14,2) 19
37 CAPTIAL_BALANCE NUMERIC(14,2) 19
38 BALANCE NUMERIC(14,2) 19
39 TOTAL_GUARANTEE_VALUE NUMERIC(14,2) 19
40 AVERAGE_MONTHLY_BALANCE NUMERIC(14,2) 19
41 TOTAL_UNRECOVERED_COSTS NUMERIC(14,2) 19
42 ARREARS_0_1_MONTH_AMOUNT NUMERIC(14,2) 19
43 ARREARS_1_2_MONTH_AMOUNT NUMERIC(14,2) 19
44 ARREARS_2_3_MONTH_AMOUNT NUMERIC(14,2) 19
45 ARREARS_3_4_MONTH_AMOUNT NUMERIC(14,2) 19
46 ARREARS_4_5_MONTH_AMOUNT NUMERIC(14,2) 19
47 ARREARS_5_6_MONTH_AMOUNT NUMERIC(14,2) 19
48 ARREARS_6_PLUS_MONTH_AMOUNT NUMERIC(14,2) 19
49 TOTAL_ARREARS_AMOUNT NUMERIC(14,2) 19
50 OLDEST_ARREARS_GRADING_CODE NUMERIC(38,0) 19
51 PRINCIPLE_LIMIT NUMERIC(15,5) 19
52 SOURCE_PRODUCT_CODE CHARACTER VARYING(24) 24
53 BALANCE_SHEET_INDICATOR CHARACTER VARYING(20) 20
54 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
55 OF_COST_CENTRE_SID BIGINT 8
56 OF_ENTITY_SID BIGINT 8
57 OF_ACCOUNT_SID BIGINT 8
58 OF_CATEGORY_SID BIGINT 8
59 OF_PRODUCT_SID BIGINT 8
60 OF_INTERCOMPANY_SID BIGINT 8
61 GL_ACCOUNT_CODE CHARACTER VARYING(6) 6
62 COST_CENTRE_CODE CHARACTER VARYING(24) 24
63 GL_PRODUCT_CODE CHARACTER VARYING(24) 24
64 GL_BUSINESS_UNIT_CODE CHARACTER VARYING(4) 4
65 GL_ACCOUNT_DESC CHARACTER VARYING(64) 64
66 COST_CENTRE_DESC CHARACTER VARYING(30) 30
67 GL_BUSINESS_UNIT_DESC CHARACTER VARYING(100) 100
68 SRC_SYS_CODE CHARACTER VARYING(12) 12
69 OF_ACCOUNT_CODE CHARACTER VARYING(150) 150
70 OF_CATEGORY_CODE CHARACTER VARYING(150) 150
71 OF_COST_CENTRE_CODE CHARACTER VARYING(150) 150
72 OF_PRODUCT_CODE CHARACTER VARYING(150) 150
73 OF_ENTITY_CODE CHARACTER VARYING(150) 150
74 OF_ACCOUNT_DESC CHARACTER VARYING(255) 255
75 OF_CATEGORY_DESC CHARACTER VARYING(255) 255
76 OF_COST_CENTRE_DESC CHARACTER VARYING(255) 255
77 OF_PRODUCT_DESC CHARACTER VARYING(255) 255
78 OF_ENTITY_DESC CHARACTER VARYING(255) 255
79 MSA_COSTCNTR_CODE CHARACTER VARYING(12) 12
80 MSA_HOGAN_ACCT CHARACTER VARYING(20) 20
81 MSA_HOGAN_COMPANY CHARACTER VARYING(6) 6
82 MSA_MAP_HOGAN_COMPANY CHARACTER VARYING(6) 6
83 MSA_MAP_HOGAN_GL_ACCOUNT CHARACTER VARYING(20) 20
84 MSA_MAP_ENTITY_CODE CHARACTER VARYING(10) 10
85 MSA_MAP_ACCOUNT_CODE CHARACTER VARYING(10) 10
86 MSA_MAP_CATEGORY_CODE CHARACTER VARYING(10) 10
87 MSA_MAP_PRODUCT_CODE CHARACTER VARYING(10) 10
88 MSA_MAP_INTERCOMPANY_CODE CHARACTER VARYING(10) 10
89 MSA_MAP_HOGAN_DEPARTMENT_ID CHARACTER VARYING(12) 12
90 MSA_MAP_COST_CENTRE_ID CHARACTER VARYING(10) 10
91 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
92 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
93 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
94 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8