One record exists for each employee containing Year-to-Date totals on vacation, sick
leave, compensatory time and hours worked as well as last check stub information and
payment indicators. The data originates from the Employee Data Base (EDB).
| Field Name | Business Name | Data Type | Description |
|---|---|---|---|
| APR_PAY_IND | PAY INDICATOR - APRIL | VARCHAR2(1) | The code indicating whether an individual had pay computation activity during the month of April. (values are Y=Yes or BLANK) |
| AUG_PAY_IND | PAY INDICATOR - AUGUST | VARCHAR2(1) | The code indicating whether an individual had pay computation activity during the month of August. (values are Y=Yes or BLANK) |
| COMP_TIME_BAL | COMPENSATORY TIME BALANCE | NUMBER(9,2) | The number of hours that an individual has available for use as compensatory time off. |
| CURR_PAY_IND | CURRENT MONTH PAY INDICATOR | VARCHAR2(1) | The code indicating whether an individuals payroll compute record (PAR) had gross earnings activity for the current month. |
| DEC_PAY_IND | PAY INDICATOR - DECEMBER | VARCHAR2(1) | The code indicating whether an individual had pay computation activity during the month December. (values are Y=Yes or BLANK) |
| EMPLOYEE_ID | EMPLOYEE ID NUMBER | VARCHAR2(9) | The unique employee identification number. (key) |
| FEB_PAY_IND | PAY INDICATOR - FEBRUARY | VARCHAR2(1) | The code indicating whether an individual had pay computation activity during the month of February. (values are Y=Yes or BLANK) |
| JAN_PAY_IND | PAY INDICATOR - JANUARY | VARCHAR2(1) | The code indicating whether an individual had pay computation activity during the month of January. (values are Y=Yes or BLANK) |
| JUL_PAY_IND | PAY INDICATOR - JULY | VARCHAR2(1) | The code indicating whether an individual had pay computation activity during the month of July. (values are Y=yes or BLANK) |
| JUN_PAY_IND | PAY INDICATOR - JUNE | VARCHAR2(1) | The code indicating whether an individual had pay computation activity during the month of June. (values are Y=yes or BLANK) |
| LAST_STUB_PTO_BAL | LAST PAY STUB PAID-TIME-OFF BALANCE | NUMBER(9,2) | The paid time off hours balance displayed on the most recently issued paycheck stub or surepay earnings statement. |
| LAST_STUB_PTO_IND | LAST PAY STUB PAID-TIME-OFF INDICATOR | VARCHAR2(1) | The code indicating whether the paid time off hours balance-last stub should be reset. (values are R=yes-reset, or N=no-do not reset) |
| LAST_STUB_SICK_BAL | LAST PAY STUB SICK LEAVE BALANCE | NUMBER(9,2) | The sick leave hours balance displayed on the most recently issued paycheck stub or surepay earnings statement |
| LAST_STUB_SICK_IND | LAST PAY STUB SICK LEAVE INDICATOR | VARCHAR2(1) | The code indicating whether the sick leave hours balance-last stub (EDB 5140) should be reset (R=Yes-reset, or N=No-do not reset) |
| LAST_STUB_VAC_BAL | LAST PAY STUB VACATION BALANCE | NUMBER(9,2) | The vacation leave hours balance printed on the most recently issued paycheck stub or surepay earnings statement |
| LAST_STUB_VAC_IND | LAST PAY STUB VACATION INDICATOR | VARCHAR2(1) | The code indicating whether the vacation leave hours balance-last stub (EDB 5139) should be reset (R=Yes-reset, or N=No-do not reset) |
| MAR_PAY_IND | PAY INDICATOR - MARCH | VARCHAR2(1) | The code indicating whether an individual had pay computation activity during the month of March (values are y=yes or BLANK) |
| MAY_PAY_IND | PAY INDICATOR - MAY | VARCHAR2(1) | The code indicating whether an individual had pay computation activity during the month of May (values are y=yes or BLANK) |
| MTH_PAY_IND | MONTHLY PAY INDICATOR | VARCHAR2(1) | The code indicating whether an individual had pay computation activity during the month (values are y=yes or N=No) |
| NORM_PTO_MAX | NORMAL PAID-TIME-OFF MAXIMUM | NUMBER(9,2) | The maximum number of hours available to an individual as paid time off under normal personnel policy |
| NORM_SICKLV_MAX | NORMAL SICK LEAVE MAXIMUM | NUMBER(9,2) | The maximum number of hours available to an individual as sick leave under normal personnel policy |
| NORM_VAC_MAX | NORMAL VACATION HOURS MAXIMUM | NUMBER(9,2) | The maximum number of hours available to an individual as vacation leave under normal personnel policy |
| NOV_PAY_IND | PAY INDICATOR - NOVEMBER | VARCHAR2(1) | The code indicating whether an individual had pay computation activity during the month of November (values are y=yes or BLANK) |
| OCT_PAY_IND | PAY INDICATOR - OCTOBER | VARCHAR2(1) | The code indicating whether an individual had pay computation activity during the month of October (values are y=yes or BLANK) |
| PRIOR_PAY_MTH1 | PRIOR PAY - MONTH 1 FLAG | VARCHAR2(1) | The code indicating whether an individuals payroll compute record (PAR) had gross earnings activity 1 month ago (values are y=yes or BLANK) |
| PRIOR_PAY_MTH2 | PRIOR PAY - MONTH 2 FLAG | VARCHAR2(1) | The code indicating whether an individuals payroll compute record (PAR) had gross earnings activity 2 months ago (values are y=yes or BLANK) |
| PRIOR_PAY_MTH3 | PRIOR PAY - MONTH 3 FLAG | VARCHAR2(1) | The code indicating whether an individuals payroll compute record (PAR) had gross earnings activity 3 months ago. (values are Y=yes or BLANK) |
| PTO_HRS_BAL | PAID-TIME-OFF BALANCE | NUMBER(11,6) | The number of hours that an individual has available for use as paid time off. |
| SEP_PAY_IND | PAY INDICATOR - SEPTEMBER | VARCHAR2(1) | The code indicating whether an individual had pay computation activity during the month of September. (values are y=yes or BLANK) |
| SICK_LV_HRS_BAL | SICK LEAVE HOURS BALANCE | NUMBER(11,6) | The number of hours available to an employee for use as sick leave. |
| SPEC_PTO_MAX | SPECIAL PAID-TIME-OFF MAXIMUM | NUMBER(9,2) | The maximum number of hours available to an individual as paid time off when the normal maximum has been pre-empted by another personnel policy. |
| SPEC_SICKLV_MAX | SPECIAL SICK LEAVE MAXIMUM | NUMBER(9,2) | The maximum number of hours available to an individual as sick leave when the normal maximum has been pre-empted by another personnel policy. |
| SPEC_VAC_MAXHRS | SPECIAL VACATION HOURS MAXIMUM | NUMBER(9,2) | The maximum number of hours available to an individual as vacation leave when the normal maximum has been pre-empted by another personnel policy. |
| VAC_HRS_BALANCE | VACATION HOURS BALANCE | NUMBER(11,6) | The number of hours available to an employee for use as vacation leave. |
| YTD_NON_WORKED | YEAR-TO-DATE NON-WORKED HOURS | NUMBER(9,2) | The number of paid time hours which are considered non-worked for the calendar year-to-date. Includes all hours defined by the type of hours attribute on the description of services table as non-worked, e.g. paid leave time. |
| YTD_OVERTIME | YEAR-TO-DATE OVERTIME HOURS | NUMBER(9,2) | The number of hours worked for the calendar year-to-date which are reported as overtime. |
| YTD_REG_HRS_WORK | YEAR-TO-DATE REGULAR HOURS WORKED | NUMBER(9,2) | The number of regular hours worked for the calendar year-to-date. Includes all hours defined by the type of hours attribute on the description of service table as regular time. Does not include overtime, differential, or leave time hours. |
| YTD_TOTAL_HOURS | YEAR-TO-DATE TOTAL HOURS | NUMBER(9,2) | The total number of hours reported on pay status for the calendar year. This excludes overtime, differential, etc. Includes all hours defined by the description of service table as counting towards hours on pay status. |
| Top of this page | Data Dictionary | PPS Main Menu |
Sent Comment to: PPS Data
Warehouse Support
Last Updated: August 3, 2000