CFD_TCFDT_MEMBER_ACCOUNT_TXN

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 MBR_ACCT_TXN_ID BIGINT 8
2 PRDT_ID BIGINT 8
3 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
4 EMPR_CODE CHARACTER VARYING(30) 30
5 TXN_EFF_DATE TIMESTAMP 8
6 TXN_PROCG_DATE TIMESTAMP 8
7 TXN_AMT NUMERIC(18,6) 19
8 TXN_TYP_ID BIGINT 8
9 CONTRBUTN_TYP_CODE CHARACTER VARYING(4) 4
10 CNCSN_CONTRBUTN_FLG CHARACTER VARYING(4) 4
11 SRC_COMPLYING_FUND_ID BIGINT 8
12 EXIT_RSN_CODE CHARACTER VARYING(4) 4
13 DEST_COMPLYING_FUND_ID BIGINT 8
14 DEST_PAYEE_NAM CHARACTER VARYING(100) 100
15 POL_STRT_DATE TIMESTAMP 8
16 POL_END_DATE TIMESTAMP 8
17 ASSC_MBR_TXN_ID BIGINT 8
18 TXN_USER_ID BIGINT 8
19 TXN_USER_NAM CHARACTER VARYING(50) 50
20 SNPSHT_DATE TIMESTAMP 8
21 DATA_LOAD_DATE TIMESTAMP 8
22 SRC_SYS_ID CHARACTER VARYING(5) 5
23 LOAD_ID BIGINT 8
24 PRDT_SYS_CODE CHARACTER VARYING(10) 10
25 TRM_COV_NUM CHARACTER VARYING(20) 20
26 CLM_NUM CHARACTER VARYING(20) 20
27 DISBURSMNT_RULE_NUM DOUBLE PRECISION 8
28 DISBURSMNT_RULE_ID DOUBLE PRECISION 8
29 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
30 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
31 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
32 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8