INT_ASIC516_OBP_HEM_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..INT_ASIC516_OBP_HEM

Columns
# Name Data Type Length
1 SUBMISSION_ID CHARACTER VARYING(100) 100
2 APPLICATION_ID CHARACTER VARYING(100) 100
3 TOT_NET_INCOME DOUBLE PRECISION 8
4 TOT_NO_OF_ADULT INTEGER 4
5 TOT_NO_OF_DEPENDENTS INTEGER 4
6 HH1_NO_OF_ADULT INTEGER 4
7 HH1_NO_OF_DEPENDENTS INTEGER 4
8 HH1_CTR_CALCULATED_EXPENSE DOUBLE PRECISION 8
9 HH1_CUST_ENTERED_EXPENSE DOUBLE PRECISION 8
10 HH1_NET_INCOME DOUBLE PRECISION 8
11 HH1_GROSS_INCOME DOUBLE PRECISION 8
12 HH2_NO_OF_ADULT INTEGER 4
13 HH2_NO_OF_DEPENDENTS INTEGER 4
14 HH2_CTR_CALCULATED_EXPENSE DOUBLE PRECISION 8
15 HH2_CUST_ENTERED_EXPENSE DOUBLE PRECISION 8
16 HH2_NET_INCOME DOUBLE PRECISION 8
17 HH2_GROSS_INCOME DOUBLE PRECISION 8
18 HH1_CDLE_VS_HEM CHARACTER VARYING(4) 4
19 HH2_CDLE_VS_HEM CHARACTER VARYING(20) 20