CFD_TCFDR_FREQUENCY_ALTERATION

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 FREQ_ALTRN_ID BIGINT 8
2 PRDT_SYS_CODE CHARACTER VARYING(10) 10
3 FREQ_ALTRN_CODE CHARACTER VARYING(10) 10
4 BLLG_FREQ_CODE CHARACTER VARYING(10) 10
5 LDNG_FCTR_VAL NUMERIC(18,6) 19
6 VALID_FLG CHARACTER VARYING(1) 1
7 EFF_STRT_DATE TIMESTAMP 8
8 EFF_END_DATE TIMESTAMP 8
9 DATA_LOAD_DATE TIMESTAMP 8
10 SNPSHT_DATE TIMESTAMP 8
11 SRC_SYS_ID CHARACTER VARYING(5) 5
12 LOAD_ID BIGINT 8
13 BNFT_RISK_COMMNCMNT_DATE DATE 4
14 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
15 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
16 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
17 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8