One Layoff Seniority Credit record exists for each employee's unique combination of Appointment Title Code, Title Bargaining Unit Code and Representation Code. The regular hours total is automatically updated after the monthly PAR processing. Data was first loaded into this table as of mm/dd/yyyy. The data originates from the Employee Data Base (EDB).
| Field Name |
Business Name |
Data Type |
Description |
| EMPLOYEE_ID |
EMPLOYEE ID NUMBER |
VARCHAR2(9)
|
The unique employee identification number.
|
| LSC_ADC_CODE |
LAYOFF SENIORITY CREDIT A/D/C CODEL |
VARCHAR2(1) |
A code indicating whether the most recent layoff senirority credit transations was an add, change or delete transaction.
|
| LSC_APPT_REP_CODE |
LAYOFF SENIORITY CREDIT APPOINTMENT REPRESENTATION CODE |
VARCHAR2(1) |
The Appointment Representation Code related to the Layoff Seniority Credit hours. (C=Covered, S=Supervisor_uncovered, U=Uncovered)
|
| LSC_PRIOR_BAL_DATE |
LAYOFF SENIORITY CREDIT PRIOR BALANCE HOURS AS OF DATE |
DATE |
The ending date for the Prior Balance hours.
|
| LSC_PRIOR_BAL_HRS |
LAYOFF SENIORITY CREDIT PRIOR BALANCE HOURS |
NUMBER(9,2) |
The hours of service within Title Code, TUC and Appointment Representation Code beginning with the last break in service and ending prior to the start of Layoff Service Credit accumulation.
|
| LSC_REGULAR_HOURS |
LAYOFF SENIORITY CREDIT REGULAR HOURS |
NUMBER(9,2) |
The hours of service within Title Code, TUC and Appointment Representation Code since the start of accumulation or the last break in service.
|
| LSC_REG_HRS_UPDATE |
LAYOFF SENIROITY CREDIT REGULAR HOURS LAST UPDATE |
DATE |
The last PAR Record Generation Pay Cycle End Date from which regular hours are accumulated.
|
| LSC_TITLE_CODE |
LAYOFF SENIORITY CREDIT TITLE CODE |
VARCHAR2(4) |
The Appointment Title Code related to the Layoff Seniority Credit hours.
|
| LSC_TUC |
LAYOFF SENIORITY TITLE UNIT CODE |
VARCHAR2(2) |
The Appointment Title Unit Code related to the Layoff Seniority Credit hours.
|
