| *CHANGE_KEY |
INTEGER |
Generated unique number based on Person_ID, Section Code, Payroll Entry Group UDDS, Pay Period End Date, Pay Period Chg Date, Leave Type Code, Amount Type Code, and Change Entry Date. This is a surrogate key for unique database identification. |
| PERSON_KEY |
INTEGER |
This is the foreign key to allow joins to the CL_Person view. |
| PAY_PERIOD_ACTIVITY_KEY |
INTEGER |
This is the foreign key to allow joins to the CL_Pay_Period_Activity view. The pay period end date on the CL_Pay_Period_Activity view identifies the pay period that was “current” when the change was entered. For example, if the pay period end date in the CL_Pay_Period_Activity view is “10/09/2010”, then the change was entered after the September B pay period was calc’d but before the October A 2010 pay period was calc’d. The Pay_Period_Chg_Date could be “09/11/2010” indicating that the change entry corrected the September A 2010 pay period. |
| PAY_PERIOD_CHG_DATE |
DATE |
End date of the pay period for which the change was made. |
| BARGAINING_UNIT_CODE |
VARCHAR2(2) |
The bargaining unit associated with this employee or the non-lte classified positions held by the employee. Used by the leave accounting system. Entered directly via transaction ‘ADSV’ or updated when title code entered on classified splits with transactions ‘PMAS’ or ‘PMED’.
Valid values:
| 02 |
Administrative Support |
| 03 |
Blue Collar & Non-Bldg Trades |
| 04 |
Building Trades-Crafts |
| 05 |
Security & Public Safety |
| 06 |
Technical |
| 07 |
Fiscal & Staff Services |
| 08 |
Research Statistics & Analysis |
| 11 |
Patient Care |
| 12 |
Social Services |
| 13 |
Education |
| 14 |
Engineering |
| 15 |
Science |
| 16 |
Non-Professional Supervisory |
| 17 |
Professional Supervisory |
| 18 |
Executive & Management (Staff) |
| 19 |
Executive & Management |
| 36 |
Law Enforcement |
| 98 |
Conf./Supervisory Professional |
| 99 |
Professional Confidential |
|
| BARGAINING_UNIT_DESCR |
VARCHAR2(30) |
Description of Bargaining Unit Code. |
| LEAVE_TYPE_CODE |
VARCHAR2(2) |
Code indicating the type of leave:
| CT |
Comp Time |
| HR |
Hours Paid |
| LH |
Legal Holiday |
| ML |
Military Leave |
| PH |
Personal Holiday |
| SA |
Sabbatical Leave |
| SL |
Sick Leave |
| VN |
Vacation |
|
| LEAVE_TYPE_DESCR |
VARCHAR2(30) |
Description of Leave Type Code |
| AMOUNT_TYPE_CODE |
VARCHAR2(2) |
Code indicating the type of leave amount:
| AD |
Added |
| AJ |
Adjustment |
| AL |
Allocation |
| BA |
Balance |
| CO |
Carryover |
| EA |
Earned |
| EH |
Earned Holiday Time |
| ET |
Earned Time and a Half |
| NE |
Negative Elimination |
| PD |
Paid |
| US |
Used |
|
| AMOUNT_TYPE_DESCR |
VARCHAR2(30) |
Description of Amount Type Code. |
| LEAVE_CHANGE_REASON_CODE |
VARCHAR2(2) |
Code indicating the leave change reason:
| CG |
Change |
| FT |
Change in FTE |
| HR |
Change Hours in Pay |
| LC |
Lost Calendar Year |
| LF |
Lost Fiscal Year |
| SA |
Transfer to Sabbatical |
|
| LEAVE_CHANGE_REASON_DESCR |
VARCHAR2(30) |
Description of Leave Change Reason Code |
| LEAVE_CHANGE_LEVEL_CODE |
VARCHAR2(1) |
Identifies if the change affected the Pay Period Activity or a Balance field (e.g. Carryover, Allocation or Adjustment YTD).
| A |
Pay Period Activity Change (i.e. change made to earnings and/or usage in a particular pay period) |
| B |
Balance Adjustment (i.e. change to a carryover or allocation) |
|
| LEAVE_CHANGE_LEVEL_DESCR |
VARCHAR2(30) |
Description of Leave Change Level Code. |
| ORIGINAL_HOURS |
NUMBER(7,2) |
Original value of amount affected by change. |
| NEW_HOURS |
NUMBER(7,2) |
New value of amount affected by change. |
| LEAVE_CHANGE_OPERATOR_INITIALS |
VARCHAR2(3) |
Initials of Terminal Operator who made change or program that created change record. |
| CHANGE_ENTRY_DATE |
DATE |
The date the change was entered. |
| EXTRACT_DATE_TIME |
DATE |
The date and time these data were extracted.
Format : YYYYMMDD HH24:MI:SS |