OBP24_HST_CZ_SC_OR_CTR_PROP_INCOME

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PROP_INCM_ID CHARACTER VARYING(100) 100
2 APPLICATION_ID CHARACTER VARYING(100) 100
3 AUTO_APPLICANT_ID CHARACTER VARYING(40) 40
4 AUTO_ORG_ID CHARACTER VARYING(50) 50
5 PRP_INCM_SOURCE CHARACTER VARYING(50) 50
6 PRP_INCM_OWN_P DOUBLE PRECISION 8
7 PRP_INCM_AMT DOUBLE PRECISION 8
8 PRP_INCM_PERIOD CHARACTER VARYING(50) 50
9 SUM_ACT_AMT DOUBLE PRECISION 8
10 SUM_ACT_PERIOD DOUBLE PRECISION 8
11 SUM_ALL_AMT DOUBLE PRECISION 8
12 ACTUAL_M DOUBLE PRECISION 8
13 ACTUAL_Y DOUBLE PRECISION 8
14 ALLOWABLE_M DOUBLE PRECISION 8
15 ALLOWABLE_Y DOUBLE PRECISION 8
16 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
17 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
18 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
19 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8