INT_OBP_FLX_PI_COL_FD_EMP_PROF_VW

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 HOST_CUST_NBR CHARACTER VARYING(40) 40
2 EMP_SEQ_ID CHARACTER VARYING(30) 30
3 DETERMINANT_VALUE CHARACTER VARYING(60) 60
4 EMPLOYMENT_STAT_CD CHARACTER VARYING(30) 30
5 EMPLOYMENT_TYPE CHARACTER VARYING(30) 30
6 EMPLOYER_NAME CHARACTER VARYING(120) 120
7 COMPANY_TYPE CHARACTER VARYING(30) 30
8 INDUSTRY_TYPE CHARACTER VARYING(30) 30
9 PROFESSION_TYPE CHARACTER VARYING(30) 30
10 DESIGNATION_TXT CHARACTER VARYING(150) 150
11 GRS_ANNUAL_INCOME DOUBLE PRECISION 8
12 START_DT TIMESTAMP 8
13 END_DT TIMESTAMP 8
14 IS_PRIMARY CHARACTER(1) 1
15 PROFILE_STATUS CHARACTER VARYING(20) 20
16 STATUS CHARACTER(1) 1
17 HOST_SRC_ID CHARACTER VARYING(3) 3