OBP24_HST_CZ_SC_OR_CTR_APPLICANT_BACKUP

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 AUTO_APPLICANT_ID CHARACTER VARYING(50) 50
2 APPLICATION_ID CHARACTER VARYING(100) 100
3 APPLICANT_ID CHARACTER VARYING(40) 40
4 CALL_TYPE CHARACTER VARYING(50) 50
5 NAME CHARACTER VARYING(100) 100
6 MAR_STATUS CHARACTER VARYING(50) 50
7 N_OF_DEPNDS DOUBLE PRECISION 8
8 APP_TYPE CHARACTER VARYING(50) 50
9 GEN_LIVING_COST DOUBLE PRECISION 8
10 PRP_INCM_SOURCE CHARACTER VARYING(50) 50
11 PRP_INCM_OWN_P DOUBLE PRECISION 8
12 PRP_INCM_AMT DOUBLE PRECISION 8
13 PRP_INCM_PERIOD CHARACTER VARYING(50) 50
14 O_CONT_COMM_PER_MON_AMT DOUBLE PRECISION 8
15 O_CONT_COMM_PER_MON_PERIOD CHARACTER VARYING(50) 50
16 TAXABLE_INVEST_INCM_M DOUBLE PRECISION 8
17 TAXABLE_INVEST_INCM_Y DOUBLE PRECISION 8
18 TAXABLE_INCOME_M DOUBLE PRECISION 8
19 TAXABLE_INCOME_Y DOUBLE PRECISION 8
20 TAXTN_EXPENSE_M DOUBLE PRECISION 8
21 TAXTN_EXPENSE_Y DOUBLE PRECISION 8
22 TTL_TAX_FREE_INCM_M DOUBLE PRECISION 8
23 TTL_TAX_FREE_INCM_Y DOUBLE PRECISION 8
24 TTL_OTHER_CON_COM_M DOUBLE PRECISION 8
25 TTL_OTHER_CON_COM_Y DOUBLE PRECISION 8
26 NET_INCM_M DOUBLE PRECISION 8
27 NET_INCM_Y DOUBLE PRECISION 8
28 NET_INCM_INC_PI_M DOUBLE PRECISION 8
29 NET_INCM_INC_PI_Y DOUBLE PRECISION 8
30 APP_SPOUSE_ID CHARACTER VARYING(50) 50
31 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
32 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
33 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
34 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8