OBP24_FLX_OR_CD_INC_DTLS

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 DECISION_ID CHARACTER VARYING(50) 50
2 SUBMISSION_ID CHARACTER VARYING(50) 50
3 PARTY_ID CHARACTER VARYING(50) 50
4 INCOME_TYPE_ID CHARACTER VARYING(50) 50
5 ADJ_GROSS_MONTHLY_AMT DOUBLE PRECISION 8
6 ADJ_GROSS_MONTHLY_CCY CHARACTER VARYING(3) 3
7 ADJ_NET_MONTHLY_AMT DOUBLE PRECISION 8
8 ADJ_NET_MONTHLY_CCY CHARACTER VARYING(3) 3
9 ALLOC_NET_MONTHLY_AMT DOUBLE PRECISION 8
10 ALLOC_NET_MONTHLY_CCY CHARACTER VARYING(3) 3
11 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
12 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
13 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
14 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8