| # |
Name |
Data Type |
Length |
| 1 |
PER_ID |
CHARACTER(10) |
10 |
| 2 |
DETERMINANT_VALUE |
CHARACTER VARYING(60) |
60 |
| 3 |
EMPLOYMENT_STAT_CD |
CHARACTER VARYING(4) |
4 |
| 4 |
EMPLOYMENT_TYPE |
CHARACTER VARYING(30) |
30 |
| 5 |
EMPLOYER_NAME |
CHARACTER VARYING(120) |
120 |
| 6 |
INDUSTRY_TYPE |
CHARACTER VARYING(30) |
30 |
| 7 |
COMPANY_TYPE |
CHARACTER VARYING(30) |
30 |
| 8 |
PROFESSION_TYPE |
CHARACTER VARYING(30) |
30 |
| 9 |
DESIGNATION_TXT |
CHARACTER VARYING(120) |
120 |
| 10 |
GRS_ANNUAL_INCOME |
NUMERIC(36,18) |
19 |
| 11 |
START_DT |
TIMESTAMP |
8 |
| 12 |
END_DT |
TIMESTAMP |
8 |
| 13 |
VERSION |
INTEGER |
4 |
| 14 |
BUS_OBJ_CD |
CHARACTER(30) |
30 |
| 15 |
BO_STATUS_CD |
CHARACTER(12) |
12 |
| 16 |
BO_DATA_AREA |
CHARACTER VARYING(2000) |
2000 |
| 17 |
STATUS_UPD_DTTM |
TIMESTAMP |
8 |
| 18 |
EMP_SEQ_ID |
CHARACTER VARYING(40) |
40 |
| 19 |
EMPL_RCD_STATUS |
CHARACTER VARYING(10) |
10 |
| 20 |
CDC_SOURCE_SYSTEM_CODE |
CHARACTER VARYING(4) |
4 |
| 21 |
CDC_RECORD_TYPE |
CHARACTER VARYING(16) |
16 |
| 22 |
CDC_COMMIT_TIMESTAMP |
TIMESTAMP |
8 |
| 23 |
CDC_EXTRACT_TIMESTAMP |
TIMESTAMP |
8 |