- DATA VIEW NAME
- CL_PAY_PERIOD_ACTIVITY
- OVERVIEW
- Captures each biweekly pay period and some payroll information at the time, with leave amounts earned or used including any corrections during each calculated biweekly period back to October A 2006 Classified calc. Shows pay period detail for the same population selected for the CL_Person.
- LOAD FREQUENCY
- This data will be refreshed every two weeks, right after the classified leave calculation is run.
- DATA CUSTODIAN
- Office of Human Resources
Catharine Derubeis - AUTHORIZATION
- You must receive approval to access data from the data custodian. For information about how to get authorized for InfoAccess data views, connect to the InfoAccess Home Page
- SPECIAL
CONSIDERATIONS - None.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 08/2010 – New view created.
11/2011 – Custodian change c4j. - DATA FORMATS
- Primary Key Columns are identified with an asterisk(*)
- Alphanumeric Data
- VARCHAR2( N) (N) = maximum length. Field contains letters and/or numbers. Trailing blanks are eliminated.
Example: VARCHAR2 (5) could contain ‘ABC12’ or ‘ABC’ or ‘A’ - Numeric Data
- NUMBER (N) (N) = length. Field contains only numbers.
NUMBER (X,Y) = format for numbers with decimal positions.
X = total number of digits
Y = the number of digits after the decimal
Examples: NUMBER (6) represents 250012 NUMBER (6,2) represents 2500.12 - Date
- DATE – Date can be in various formats. Date functions available with your query tool can be used to format the date.
Examples: DATE (YYYYMMDD), DATE (YYDDD), DATE (DD-MM-YY)
| Column Name | Format | Description | ||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| *PAY_PERIOD_ACTIVITY_KEY | INTEGER | Generated unique number based on Person_ID, Section Code, Payroll Entry Group UDDS, and Pay Period End 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_BEGIN_DATE | DATE | Begin date of pay period for which leave data was entered. | ||||||||||||||||||||||||||||||||||||||
| PAY_PERIOD_BEGIN_DATE_CCYY | VARCHAR2(4) | 4-digit year of begin date of pay period for which leave data was entered. | ||||||||||||||||||||||||||||||||||||||
| PAY_PERIOD_BEGIN_DATE_MM | VARCHAR2(2) | 2-digit month of begin date of pay period for which leave data was entered. | ||||||||||||||||||||||||||||||||||||||
| PAY_PERIOD_BEGIN_DATE_DD | VARCHAR2(2) | 2-digit day of begin date of pay period for which leave data was entered. | ||||||||||||||||||||||||||||||||||||||
| PAY_PERIOD_END_DATE | DATE | End date of pay period for which leave data was entered. | ||||||||||||||||||||||||||||||||||||||
| PAY_PERIOD_END_DATE_CCYY | VARCHAR2(4) | 4-digit year of end date of pay period for which leave data was entered. | ||||||||||||||||||||||||||||||||||||||
| PAY_PERIOD_END_DATE_MM | VARCHAR2(2) | 2-digit month of end date of pay period for which leave data was entered. | ||||||||||||||||||||||||||||||||||||||
| PAY_PERIOD_END_DATE_DD | VARCHAR2(2) | 2-digit day of end date of pay period for which leave data was entered. | ||||||||||||||||||||||||||||||||||||||
| CALC_ID | VARCHAR2(9) | The unique identifier for a calculation processed in the payroll system. Consists of calendar year, payroll paid month, and sequence number. The scheduled calculations will be assigned a calculation number in advance. Special calculations will be given a calculation number in between the sequence numbers of scheduled calculations. | ||||||||||||||||||||||||||||||||||||||
| CALC_DESCR | VARCHAR2(30) | A name associated with the calculation number, such as Aug A Classified. | ||||||||||||||||||||||||||||||||||||||
| 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:
|
||||||||||||||||||||||||||||||||||||||
| BARGAINING_UNIT_DESCR | VARCHAR2(30) | Description of Bargaining Unit Code. | ||||||||||||||||||||||||||||||||||||||
| LEAVE_STATUS_MODIFIER | VARCHAR2(1) | The leave status modifier identifies how the leave hours were processed for the pay period. Valid values are
|
||||||||||||||||||||||||||||||||||||||
| FLSA_STATUS | VARCHAR2(1) | Exemption status from the Wages and Hour provisions of the Fair Labor Standards Act for overtime pay of time and a half or compensatory time. Valid values are: Blank (‘ ‘) E – Exempt N – Non-exempt |
||||||||||||||||||||||||||||||||||||||
| HOURS_PAID | NUMBER(5,1) | Hours reported in payroll system for the pay period. | ||||||||||||||||||||||||||||||||||||||
| NORMAL_HOURS | NUMBER(3,1) | Hours normally worked for pay period. Total of base hours on payroll splits related to this leave detail at time of leave maintenance. | ||||||||||||||||||||||||||||||||||||||
| VN_EARNED | NUMBER(5,2) | Vacation hours earned for this pay period. | ||||||||||||||||||||||||||||||||||||||
| VN_USED | NUMBER(5,2) | Vacation hours used in this pay period. | ||||||||||||||||||||||||||||||||||||||
| VN_ADJUSTMENT | NUMBER(5,2) | Difference in the vacation earned from hours worked compared to vacation that would have been earned if paid the normal hours. | ||||||||||||||||||||||||||||||||||||||
| VN_NEG_ELIMINATION | NUMBER(5,2) | Negative vacation hours balance or carryover that were dropped during pay period. Considered as non-deduct LWOP. | ||||||||||||||||||||||||||||||||||||||
| SL_EARNED | NUMBER(3,1) | Sick leave hours earned for this pay period. | ||||||||||||||||||||||||||||||||||||||
| SL_USED | NUMBER(5,2) | Sick leave hours used for this pay period. | ||||||||||||||||||||||||||||||||||||||
| PH_USED | NUMBER(5,2) | Personal holiday hours used for this pay period. | ||||||||||||||||||||||||||||||||||||||
| LH_EARNED | NUMBER(5,2) | Legal holiday hours earned for this pay period. | ||||||||||||||||||||||||||||||||||||||
| LH_USED | NUMBER(5,2) | Legal holiday hours used for this pay period. | ||||||||||||||||||||||||||||||||||||||
| LH_NEG_ELIMINATION | NUMBER(5,2) | Negative legal holiday hours balance that were dropped during pay period. Considered as non-deduct LWOP. | ||||||||||||||||||||||||||||||||||||||
| CT_EARNED_STRAIGHT | NUMBER(5,2) | Regular comp time hours earned for this pay period. | ||||||||||||||||||||||||||||||||||||||
| CT_EARNED_HOLIDAY | NUMBER(5,2) | Holiday comp time hours earned for this pay period. | ||||||||||||||||||||||||||||||||||||||
| CT_EARNED_TIME_HALF | NUMBER(5,2) | Time and a half comp time hours earned for this pay period. | ||||||||||||||||||||||||||||||||||||||
| CT_USED | NUMBER(5,2) | Comp time hours used for this pay period. | ||||||||||||||||||||||||||||||||||||||
| SA_ADDED | NUMBER(5,2) | Sabbatical hours added for this pay period. | ||||||||||||||||||||||||||||||||||||||
| SA_USED | NUMBER(5,2) | Sabbatical hours used for this pay period. | ||||||||||||||||||||||||||||||||||||||
| MILITARY_LEAVE | NUMBER(5,2) | Military hours used for this pay period. | ||||||||||||||||||||||||||||||||||||||
| CT_WORKED_STRAIGHT | NUMBER(5,2) | Regular comp time hours worked for this pay period. | ||||||||||||||||||||||||||||||||||||||
| CT_WORKED_HOLIDAY | NUMBER(5,2) | Holiday comp time hours worked for this pay period. | ||||||||||||||||||||||||||||||||||||||
| CT_WORKED_TIME_HALF | NUMBER(5,2) | Time and a half comp time hours worked for this pay period. | ||||||||||||||||||||||||||||||||||||||
| OVERTIME | NUMBER(3,1) | Hours of overtime on which additional leave was earned for pay period. | ||||||||||||||||||||||||||||||||||||||
| DEDUCT_LWOP | NUMBER(5,2) | Hours of LWOP for pay period which reduced vacation and/or sick leave balance. | ||||||||||||||||||||||||||||||||||||||
| NON_DEDUCT_LWOP | NUMBER(5,2) | Hours of LWOP for pay period which did not reduce vacation or sick balances. | ||||||||||||||||||||||||||||||||||||||
| EXTRACT_DATE_TIME | DATE | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |