SDW_TSDWF_CLMS_LOAN_AR_TXN

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CLMS_LOAN_AR_TXN_ID INTEGER 4
2 PST_DT_TM TIMESTAMP 8
3 SRC_STM_ID INTEGER 4
4 AR_ID INTEGER 4
5 TXN_CODE_ID INTEGER 4
6 LOAD_ST_F CHARACTER VARYING(1) 1
7 ISRT_RUN_AUDT_ID INTEGER 4
8 UDT_RUN_AUDT_ID INTEGER 4
9 SRC_SEQ_MO_NBR INTEGER 4
10 SRC_SEQ_TXN_NBR INTEGER 4
11 SRC_TXN_CODE CHARACTER VARYING(6) 6
12 SRC_TXN_SPLMT_CD CHARACTER VARYING(6) 6
13 SRC_EFF_DT TIMESTAMP 8
14 AMT NUMERIC(14,2) 19
15 CLC_FEE_AMT NUMERIC(14,2) 19
16 TXN_PST_TP_ID INTEGER 4
17 TXN_SPLM_TP_ID INTEGER 4
18 TXN_RSN_TP_ID INTEGER 4
19 TXN_GRP_TP_ID INTEGER 4
20 TXN_FEE_TP_ID INTEGER 4
21 TXN_WV_TP_ID INTEGER 4
22 TXN_DRDWN_TP_ID INTEGER 4
23 TXN_DSCHRG_TP_ID INTEGER 4
24 CLS_F CHARACTER VARYING(1) 1
25 EFF_CPTL_BAL NUMERIC(14,2) 19
26 EFF_CRN_BAL NUMERIC(14,2) 19
27 EFF_DBT_WRTOF_BAL NUMERIC(14,2) 19
28 EFF_INBA_BAL NUMERIC(14,2) 19
29 EFF_IIA_ACR_INT_BAL NUMERIC(14,2) 19
30 EFF_ON_UREC_COST_BAL NUMERIC(14,2) 19
31 EFF_DCN_PREM_BAL NUMERIC(14,2) 19
32 EFF_PNP_LMT NUMERIC(14,2) 19
33 EFF_APRV_GNT_LMT NUMERIC(14,2) 19
34 EFF_DRN_LTD NUMERIC(14,2) 19
35 EFF_MX_INT_TO_BE_CPZ NUMERIC(14,2) 19
36 EFF_AMT_OF_INT_CPZ NUMERIC(14,2) 19
37 EFF_VAL_GNT NUMERIC(14,2) 19
38 EFF_UREC_COST_CGY_1_BAL NUMERIC(14,2) 19
39 EFF_UREC_COST_CGY_2_BAL NUMERIC(14,2) 19
40 EFF_UREC_COST_CGY_3_BAL NUMERIC(14,2) 19
41 EFF_UREC_COST_CGY_4_BAL NUMERIC(14,2) 19
42 EFF_UREC_COST_CGY_5_BAL NUMERIC(14,2) 19
43 EFF_UREC_COST_CGY_6_BAL NUMERIC(14,2) 19
44 EFF_UREC_COST_CGY_7_BAL NUMERIC(14,2) 19
45 EFF_UREC_COST_CGY_8_BAL NUMERIC(14,2) 19
46 EFF_UREC_COST_CGY_9_BAL NUMERIC(14,2) 19
47 EFF_AST_WDV_INL_EXPN NUMERIC(14,2) 19
48 EFF_AST_ORIG_COST NUMERIC(14,2) 19
49 EFF_DPRCN_LMT NUMERIC(14,2) 19
50 EFF_GST_AC_BAL NUMERIC(14,2) 19
51 TXN_DSC_1 CHARACTER VARYING(64) 64
52 TXN_DSC_2 CHARACTER VARYING(64) 64
53 SPLM_WV_DSC CHARACTER VARYING(64) 64
54 BSN_LOAD_DT TIMESTAMP 8
55 ALLFI_TLR_CODE CHARACTER VARYING(8) 8
56 ALLFI_BR_OU_IP_ID INTEGER 4
57 PYMT_MTH_TP_ID INTEGER 4
58 DVC_TP_ID INTEGER 4
59 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
60 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
61 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
62 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8