| 1 |
RPT_LEVEL_IND |
CHARACTER VARYING(2) |
2 |
| 2 |
RPT_LEVEL_CODE |
CHARACTER VARYING(150) |
150 |
| 3 |
CAL_YEAR_MONTH |
CHARACTER VARYING(200) |
200 |
| 4 |
CAL_MONTH_LAB |
CHARACTER VARYING(200) |
200 |
| 5 |
REPORTING_DATE |
DATE |
4 |
| 6 |
REPORTING_CYCLE |
CHARACTER VARYING(1) |
1 |
| 7 |
EMPLOYEE_NUMBER |
CHARACTER VARYING(50) |
50 |
| 8 |
EMPLOYEE_NAME |
CHARACTER VARYING(201) |
201 |
| 9 |
LEVEL_02_NAME |
CHARACTER VARYING(240) |
240 |
| 10 |
LEVEL_02_CODE |
CHARACTER VARYING(150) |
150 |
| 11 |
LEVEL_03_NAME |
CHARACTER VARYING(240) |
240 |
| 12 |
LEVEL_03_CODE |
CHARACTER VARYING(150) |
150 |
| 13 |
HR_TEAM_NAME |
CHARACTER VARYING(100) |
100 |
| 14 |
PAYMENTDATEX_PLRX |
CHARACTER VARYING(200) |
200 |
| 15 |
AL_APPROVED_START_DATEX |
CHARACTER VARYING(200) |
200 |
| 16 |
AL_ACCRUED_START_DATEX |
CHARACTER VARYING(200) |
200 |
| 17 |
ANNUAL_LEAVE_BALANCE_DAYS_AT_PAYDATE |
NUMERIC(10,2) |
19 |
| 18 |
ANNUAL_LEAVE_TARGET |
NUMERIC(38,6) |
19 |
| 19 |
AL_TARGET_DATEX_1 |
CHARACTER VARYING(200) |
200 |
| 20 |
ACCRUED_AL_TILL_TARGET_DATE_1 |
NUMERIC(38,6) |
19 |
| 21 |
APP_LEAVE_CNT_TARGET_1 |
NUMERIC(38,6) |
19 |
| 22 |
PREDICTED_AL_TILL_TARGET_DATE_1 |
NUMERIC(38,6) |
19 |
| 23 |
FORECAST_AL_TILL_TARGET_DATE_1 |
NUMERIC(38,6) |
19 |
| 24 |
REQUIRED_AL_TILL_TARGET_DATE_1 |
NUMERIC(38,6) |
19 |
| 25 |
AL_TARGET_DATEX_2 |
CHARACTER VARYING(200) |
200 |
| 26 |
ACCRUED_AL_TILL_TARGET_DATE_2 |
NUMERIC(38,6) |
19 |
| 27 |
APP_LEAVE_CNT_TARGET_2 |
NUMERIC(38,6) |
19 |
| 28 |
PREDICTED_AL_TILL_TARGET_DATE_2 |
NUMERIC(38,6) |
19 |
| 29 |
FORECAST_AL_TILL_TARGET_DATE_2 |
NUMERIC(38,6) |
19 |
| 30 |
REQUIRED_AL_TILL_TARGET_DATE_2 |
NUMERIC(38,6) |
19 |
| 31 |
ANNUAL_LEAVE_CONCAT_T2 |
CHARACTER VARYING(4000) |
4000 |
| 32 |
AL_TARGET_DATEX_3 |
CHARACTER VARYING(200) |
200 |
| 33 |
ACCRUED_AL_TILL_TARGET_DATE_3 |
NUMERIC(38,6) |
19 |
| 34 |
APP_LEAVE_CNT_TARGET_3 |
NUMERIC(38,6) |
19 |
| 35 |
PREDICTED_AL_TILL_TARGET_DATE_3 |
NUMERIC(38,6) |
19 |
| 36 |
FORECAST_AL_TILL_TARGET_DATE_3 |
NUMERIC(38,6) |
19 |
| 37 |
REQUIRED_AL_TILL_TARGET_DATE_3 |
NUMERIC(38,6) |
19 |
| 38 |
AL_TARGET_DATEX_4 |
CHARACTER VARYING(200) |
200 |
| 39 |
ACCRUED_AL_TILL_TARGET_DATE_4 |
NUMERIC(38,6) |
19 |
| 40 |
APP_LEAVE_CNT_TARGET_4 |
NUMERIC(38,6) |
19 |
| 41 |
PREDICTED_AL_TILL_TARGET_DATE_4 |
NUMERIC(38,6) |
19 |
| 42 |
FORECAST_AL_TILL_TARGET_DATE_4 |
NUMERIC(38,6) |
19 |
| 43 |
REQUIRED_AL_TILL_TARGET_DATE_4 |
NUMERIC(38,6) |
19 |
| 44 |
STANDARD_HOURS_PLR |
NUMERIC(6,2) |
19 |
| 45 |
FTE |
NUMERIC(38,6) |
19 |
| 46 |
DEPARTMENT_COST_CENTRE_PLR |
CHARACTER VARYING(100) |
100 |
| 47 |
ANNUAL_LEAVE_BALANCE_HRS_PLR |
NUMERIC(38,6) |
19 |
| 48 |
POSITION_TITLE_PLR |
CHARACTER VARYING(256) |
256 |
| 49 |
EMPLOYEE_CLASS_CODE_CFO |
CHARACTER VARYING(24) |
24 |
| 50 |
EMPLOYEE_CLASS_NAME_PLR |
CHARACTER VARYING(255) |
255 |
| 51 |
BUSINESS_UNIT_NAME_CFO |
CHARACTER VARYING(100) |
100 |
| 52 |
DIVISION_NAME_CFO |
CHARACTER VARYING(100) |
100 |
| 53 |
DEPARTMENT_NAME_CFO |
CHARACTER VARYING(100) |
100 |
| 54 |
SECTION_NAME_CFO |
CHARACTER VARYING(100) |
100 |
| 55 |
TEAM_NAME_PLR |
CHARACTER VARYING(100) |
100 |
| 56 |
EMPLOYEE_NUMBER_LEAVE_MAT |
CHARACTER VARYING(51) |
51 |
| 57 |
FTE_LEAVE_MAT |
NUMERIC(11,6) |
19 |
| 58 |
FUNCTION_LEAVE_MAT |
CHARACTER VARYING(240) |
240 |
| 59 |
LEAVE_START_DATE_MAT |
TIMESTAMP |
8 |
| 60 |
LEAVE_END_DATE_MAT |
TIMESTAMP |
8 |
| 61 |
LEAVE_STATUS_MAT |
CHARACTER VARYING(128) |
128 |
| 62 |
LEAVE_DURATION_MAT |
NUMERIC(8,2) |
19 |
| 63 |
HIRE_DATE_MAT |
TIMESTAMP |
8 |
| 64 |
POSITION_NUMBER_MAT |
CHARACTER VARYING(100) |
100 |
| 65 |
POSITION_TITLE_MAT |
CHARACTER VARYING(256) |
256 |
| 66 |
POSITION_START_DATE_MAT |
TIMESTAMP |
8 |
| 67 |
LEAVE_MAT_FLAG |
INTEGER |
4 |
| 68 |
LEAVE_ANN_FLAG |
INTEGER |
4 |