HDDA_FPA

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..EFS_HDDA_FPA

Columns
# Name Data Type Length
1 KEY_COID CHARACTER VARYING(5) 5
2 KEY_PROD CHARACTER VARYING(3) 3
3 KEY_ACCT BIGINT 8
4 FPA_SEQ_NUM INTEGER 4
5 FPA_IB_TYPE INTEGER 4
6 FPA_INT_RATE DOUBLE PRECISION 8
7 FPA_REN_CDE CHARACTER VARYING(1) 1
8 FPA_REN_END_DTE TIMESTAMP 8
9 FPA_START_DTE TIMESTAMP 8
10 FPA_TERM INTEGER 4
11 FPA_TERM_CDE CHARACTER VARYING(1) 1
12 FPA_AMOUNT NUMERIC(16,2) 19
13 FPA_END_DTE TIMESTAMP 8
14 FPA_INT_ACC_CTD DOUBLE PRECISION 8
15 DATA_DATE TIMESTAMP 8
16 LOAD_ID INTEGER 4
17 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
18 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
19 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
20 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8