CFD_TCFDT_SUPER_INVSTMT_MVT

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
2 PRDT_SYS_CODE CHARACTER VARYING(10) 10
3 FND_TYP_ID BIGINT 8
4 COBE_PRDT_CODE CHARACTER VARYING(10) 10
5 CMPY_PRDT_CODE BIGINT 8
6 BUS_CLASS_CODE CHARACTER VARYING(6) 6
7 DATE_ID BIGINT 8
8 SEQ_NUM BIGINT 8
9 MBR_ACCT_VAL NUMERIC(18,6) 19
10 CASUAL_ACCT_VAL NUMERIC(18,6) 19
11 MBR_ACCT_INTERIM_INT_AMT NUMERIC(18,6) 19
12 CASUAL_ACCT_INTERIM_INT_AMT NUMERIC(18,6) 19
13 SURRENDER_VAL NUMERIC(18,6) 19
14 ACTL_REGULAR_PREM_RECEIVED_AMT NUMERIC(18,6) 19
15 LST_YR_ACTL_CASUAL_PREM_RECEIV NUMERIC(18,6) 19
16 TOT_EMPR_REGULAR_CNT BIGINT 8
17 FINANCIAL_YTD_TFR_RECEIVED NUMERIC(18,6) 19
18 EXIT_CAUSE_CODE BIGINT 8
19 EXIT_AMT NUMERIC(18,6) 19
20 EXIT_DATE TIMESTAMP 8
21 DATA_LOAD_DATE TIMESTAMP 8
22 SNPSHT_DATE TIMESTAMP 8
23 SRC_SYS_ID CHARACTER VARYING(5) 5
24 AGGRESSIVE_LOAD_IND CHARACTER VARYING(1) 1
25 LOAD_ID BIGINT 8
26 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
27 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
28 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
29 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8