Time Entry Approvals Exceptions User Guide

Updated on Jul 18, 2024

Time Entry, Approvals, Exceptions

User Guide

Last Revised: 11/16/22

REVISION CONTROL

Document Title:	Time Entry, Approvals, Exceptions User Guide
Author:	CHRS Project Area
File Reference:	Time Entry, Approvals, Exceptions User Guide

Revision History

Revision Date	Revised By	Summary of Revisions	Section(s) Revised
Click here to enter Revision Date	Click here to enter name of Person Revising.	Click here to enter Summary of Revisions	Click here to enter Sections Revised.

Review / Approval History

Review Date	Reviewed By	Action (Reviewed, Recommended or Approved)
Click here to enter Review Date	Click here to enter Reviewer	Click here to enter Reviewed, Recommended or Approved

Page ii

Table of Contents Page

1.0 Process Overview 4

2.0 Process Prerequisites 4

3.0 Process Steps 4

3.1 Employee Self Service Timesheet Time Entry 4

3.2 Manager Self Service Timesheet Time Entry 4

3.3 Manager Checks Work Study Balances 5

3.4 Employee Self Service Web Clock Time Entry 5

3.5 New Rapid Time Entry by Administrator 6

3.6 Manual Time Administration Execution 6

3.7 Approver approves Payable Time 7

3.8 Administrator Approves Payable Time 7

3.9 Administrator Delegates T&L Roles on Behalf of Approver 8

3.10 Administrator Re-routes T&L approval transaction 9

3.11 Administrator ends a delegation 9

3.12 Administrator Review Exceptions 10

3.13 Administrator Allow Exceptions 10

3.14 Administrator creates new rows in a Calendar Year Balance ID Table 10

3.15 Administrator creates new rows in a non-Calendar Year Balance ID Table 11

3.16 Administrator creates a Pay Run ID 11

3.17 Administrator creates a Pay Calendar 12

3.18 Administrator generates a PIP file for transmission 12

3.19 Administrator Reviews the PIP Generated Data 13

4.0 Process Output 13

5.0 Testing 13

6.0 Appendix 14

6.1 List of Exceptions 14

6.2 List of Validations 14

6.3 List of Timesheet TRCs 14

6.4 List of Rules 16

Page iii

1.0 Process Overview

Please refer to the Guidelines for Creating Accessible Documentation, for standards to follow when using this template to create accessible documentation. Please delete this text before starting your document. <Start text here

2.0 Process Prerequisites

Inputs and outputs, dependencies, security roles, training requirements

3.0 Process Steps

3.1 Employee Self Service Timesheet Time Entry

Employee signs in.
OPTIONAL – If necessary, change the tile set to Employee Self Service
Click on the “Time” tile
OPTIONAL – If necessary, click on the “Timesheet” navigation set, then “Enter Time”.
OPTIONAL – If the employee has multiple jobs, select the job which requires time entry.
OPTIONAL – Navigate to appropriate pay period using the arrows next to the date range. Employees should always be able to enter time for the current period. Employees are only allowed to enter time in the prior period for up to five days after the end of the period.
OPTIONAL – Navigate to the appropriate week in the pay period. The timesheet page will only display one week at a time.
Select the Time Reporting Code from the dropdown. See Appendix 6.3 for list of TRCs and descriptions.
Locate the day the employee needs to report hours.
Enter the number of hours worked. IMPORTANT – If the TRC is ADO, enter a “1” to indicate that a single day of ADO was earned.
Click the “Submit” button. Time Admin will be run against the time entered.
Click “Ok” on the confirmation screen.

3.2 Manager Self Service Timesheet Time Entry

Sign in as an approver.
Select the Manager Self Service option from the home page dropdown
Click on the “Team Time” tile
OPTIONAL – Click the Filter Button and set filter criteria, clicking “Done” when done.
Click the “Get Employees” button.
Select the employee from the returned results.
OPTIONAL – If the employee has multiple jobs, select the job which requires time entry.
OPTIONAL – Navigate to appropriate pay period using the arrows next to the date range. Employees should always be able to enter time for the current period. Employees are only allowed to enter time in the prior period for up to five days after the end of the period.
OPTIONAL – Navigate to the appropriate week in the pay period. The timesheet page will only display one week at a time.
Select the Time Reporting Code from the dropdown. See Appendix 6.3 for list of TRCs and descriptions.
Locate the day the employee needs to report hours.
Enter the number of hours worked. IMPORTANT – If the TRC is ADO, enter a “1” to indicate that a single day of ADO was earned.
Click the “Submit” button. Time Admin will be run against the time entered and the generated payable time automatically approved.
Click “Ok” on the confirmation screen.

3.3 Manager Checks Work Study Balances

Sign in as an Approver
Navigate to Navigator > Manager Self Service > CSU Manager Self Service > CSU Work Study Balance
OPTIONAL – Select the Business Unit
OPTIONAL – Select a different pay period
OPTIONAL – Click on the Job/Time & Labor Data Summary to view additional details.

3.4 Employee Self Service Web Clock Time Entry

Sign as employee
OPTIONAL – If necessary, change the tile set to Employee Self Service
Click on the “Time” tile
Click on the “Report Time” link
OPTIONAL – Select the job to report time for using the drop down menu.
Select the Punch Type from the drop down menu. Use “In” to report an in punch and “Out” to report an out punch.
Select the Time Reporting Code from the drop down menu. See table 6.3 for a list of time reporting codes.
OPTIONAL – Click the “View Legal Statement” link to acknowledge
Click the “Submit” button

3.5 New Rapid Time Entry by Administrator

Sign in as payroll staff
Navigate to Main Menu > Time and Labor > Report Time > Rapid Time
Click on the “Create New Session” tab
Enter a description
Select the template type
Select the Template
Set the processing mode to Addition
Enter an Emplid
OPTIONAL – Enter an Empl Record
Enter a Date
OPTIONAL – enter additional information required by the template. IMPORTANT – Enter accurate time for each day worked. Loading all hours worked in a period on a single day is not allowed.
OPTIONAL – Create new rows using the “Add or Remove Rows” section
1. Enter the number of rows to add
2. OPTIONAL – Check the “Copy Down Values from Last Row” box if copies of the last row entered are required.
3. OPTIONAL – Check the “Increment Date” box to increment the date value for each new row created.
4. Click the “Add Row(s)” button.
OPTIONAL – Create new rows using the “+” button.
OPTIONAL – Enter or update the data for all newly created rows.
Click the “Submit” button.
Click “OK” on both alerts.
Click the “Process Monitor” link
Verify that the job “TL_RAPIDTIME” completes successfully.

3.6 Manual Time Administration Execution

Sign in as a campus Time & Labor administrator
Navigate to Main Menu > Time and Labor > Process Time > Request Time Administration
Enter the Run Control ID. Follow standard campus procedures and conventions for use of Run Controls.
Click Search.
Ensure that “Forecast Payable Time” is unchecked
Ensure that “Use Reported Time for POI” is checked.
Ensure that “Use Current Date” is unchecked.
Set the “Process through Date” to the end of the current SCO pay period.
IMPORTANT – Set either an Emplid or a Group ID with the “include” option. The Time Administration process is shared across all campuses, so it is necessary to only include those affected employees.
Click the “Run” button
Click the “OK” button on the “Process Scheduler Request” screen.
Click the “Process Monitor” link.
Verify that the job “TL_TIMEADMIN” job runs to success.

3.7 Approver approves Payable Time

Sign in as approver
Click the “Approvals” tile
OPTIONAL – Click the “Filter” button and set filtering critera.
Click on the employee from the returned results.
Select all time entries which need approval.
OPTIONAL – Enter any comments
Click the “approve” button
OPTIONAL – Enter any additional comments
Click the “Submit” button

3.8 Administrator Approves Payable Time

Sign in as payroll administrator
Navigate to Main Menu > Time & Labor > Approve Time > Request Batch Approval Process
Enter a run control ID
1. Run control IDs are controlled by the campus. Please follow your campus procedures for creation of a run control, if required.
Enter a “From Date” which describes the beginning of the period which approval is required.
Enter an “End Date” which describes the end of the period which approvals is required.
Enter either an Empl ID & Empl Record or a Group ID
1. When processing approvals, either emplids or group IDs can be used. Only the employees to be approved (included) must be listed.
OPTIONAL – Click the “+” button to add a new row and repeat step 6 for the new row.
Click the “Run” button
Click the “OK” button to execute the TL_APPRV_AE application engine.
Click on the “Process Monitor” link to go to the process monitor page.
Refresh the page until the job completes.

3.9 Administrator Delegates T&L Roles on Behalf of Approver

If an approver is no longer willing or able to approve Time & Labor entries, an administrator can delegate their transaction roles to another approver. The proxy approver will need to first accept the delegation request using the “Approvals” tile. Once accepted, any transactions submitted will be routed to the proxy approver. The original approver will not receive a copy of the transaction.

Sign in as an administrator
Navigate to Main Menu > Workforce Administration > Self Service Transactions > Approvals and Delegation > Add Delegation Request.
Enter the search criteria for the approver that is no longer willing or able to approve Time & Labor Entries (i.e. Original Approver).
Click the “Search” button
OPTIONAL – If multiple rows are returned, click the appropriate row.
OPTIONAL – If there is not an available blank row, click the “+” button to add a delegation row.
Enter the date the delegation should start in the “From Date” field.
OPTIONAL – Enter the predefined end date in the “To Date” field. Leaving this field blank will tell the system that there is no expected end date and that the delegation will be ended manually by an administrator.
Select the Transaction Name of the transaction to be delegated:
- ManageReportTimeFluid – Manage Reported Time Fluid – Allows the proxy to enter time on behalf of the original approver’s employees.
- TL_MSS_EE_SRCH_PRD – Manage Approve Payable Time – Allows the proxy to approve payable time for the original approver’s employees.
Enter the employee ID of the proxy approver.
OPTIONAL – If additional transactions are required to be set up, click the “+” button to create a new row, then repeat steps 7-9.
Click the “Save” button. Upon saving the delegation request will be sent to the proxy’s approval tile. This process will not automatically re-route pending approvals to the proxy. Follow process 3.10 to re-route pending approvals if needed.

3.10 Administrator Re-routes T&L approval transaction

If an approver is unable to unwilling to approve a given transaction, it can be re-routed to a different approver using the transaction routing page. It is best practice to inform the approvers ahead of time that the transactions will be re-routed so that they both know to expect the change.

Sign in as an administrator
Navigate to Main Menu > Time and Labor > CSU Time and Labor > CSU Transaction Routing
Enter the search criteria. When searching for Time & Labor transactions, it is recommended that the approver emplid is entered and the Approval Process of TL Payable Time is selected. It is also recommended that the Begin and End dates be reviewed to ensure that they encompass all transactions that need to be re-routed.
Select the transactions that need to be re-routed from the returned list.
Select the OPRID of the approver to re-route the transactions to. Use the lookup function if the OPRID is not known. Be aware that if the approver works at multiple campuses, they will have multiple OPRIDs.
OPTIONAL – Enter a Comment in to the “Reassign Comment” field.
Click the “Reassign Selected” button to reassign the transactions. The transactions will immediately move from the “Approval” tile of the original approver to the “Approval” tile of the new approver.

3.11 Administrator ends a delegation

If an approver no longer requires a transaction to be delegated and the delegation either has no end date or the end date has not arrived, it must be cancelled manually by an administrator.

Sign in as an administrator
Navigate to Main Menu > Workforce Administration > Self Service Transactions > Approvals and Delegation > Administer Delegation.
OPTIONAL – Enter Search criteria. It is recommended that the original approver’s (i.e. not the proxy) emplid is entered in to the “Delegator” field.
Click the “Search” button.
Select the Delegation transaction (or transactions) to be ended.
Click the “Revoke” button. Upon clicking the button, any newly submitted transactions will no longer be routed to the proxy and will instead be routed to the original approver. This process will not automatically re-route already submitted transactions. Follow process 3.10 to re-route pending approvals if needed.

3.12 Administrator Review Exceptions

Sign in as either an administrator or approver
OPTIONAL – Switch the Manager Self Service Homepage
Click on the “Team Time” tile
Click on the “Manage Exceptions” navigation
OPTIONAL – Change the filter settings to view exceptions.

3.13 Administrator Allow Exceptions

Sign in as an administrator
OPTIONAL – Switch the Manager Self Service Homepage
Click on the “Team Time” tile
Click on the “Manage Exceptions” navigation
OPTIONAL – Change the filter settings to view exceptions.
Locate the exception(s) to be allowed.
OPTIONAL – Click the arrow in the exception row to view more information.
Check the box or boxes of the exception to be allowed.
Click the “Allow” button.

3.14 Administrator creates new rows in a Calendar Year Balance ID Table

Sign in as a payroll administrator
Navigate to Main Menu > Set Up HCM > Product Related > Payroll for North America > Payroll Processing Controls > Balance ID Table
OPTIONAL - Enter a Set ID
OPTIONAL – Enter a Balance ID
Click Search
OPTIONAL – Select the Balance ID to be updated
Enter the calendar year to be created and click the “Create” button.
Click the “OK” button on the message indicating that the rows were created successfully.
Locate the first period for the new year created.
Confirm that the Begin and End Dates are set correctly based on the AY or SCO calendar. Update as needed.
Repeat step 10 for periods 2-12.
Click the “Save” button.

3.15 Administrator creates new rows in a non-Calendar Year Balance ID Table

Sign in as a payroll administrator
Navigate to Main Menu > Set Up HCM > Product Related > Payroll for North America > Payroll Processing Controls > Balance ID Table
OPTIONAL - Enter a Set ID
OPTIONAL – Enter a Balance ID
Click Search
OPTIONAL – Select the Balance ID to be updated
Click the “+” button to create a new row.
Enter a Year, the period ID (month number), Begin Date and End Date (as defined by either the SCO or AY calendar as needed), the Period Name (Month name), and Abbreviation (3 character month ID).
Repeat steps 8 & 9 for all rows that need to be created.
Click on the “Balance ID Table 2” tab.
Click on the “+” button to create a new row.
Enter a year, the quarter number, the period name (the word “Quarter” followed by the quarter number –

e.g. “Quarter 1”), the abbreviation (the letter Q followed by the quarter number – e.g. “Q1”), the From Period and To Period as defined by the associated quarter (1-3 for Q1, 4-6 for Q2, 7-9 for Q3, and 10-12 for Q4).

Repeat steps 12 & 13 for all rows that need to be created.
Click “Save”

3.16 Administrator creates a Pay Run ID

Sign in as a payroll administrator
Navigate to Main Menu > Set Up HCM > Product Related > Payroll for North America > Payroll Processing Controls > Pay Run Table
Click on the “Add a New Value” tab
Enter a pay run ID name using the standardized naming convention. As of 8/23/2021, that naming convention is as follows: <2 Character Campus Indicator><4 Character Year><2 Character Month><Remaining 2 characters can be anything except spaces> - Ex. FL202103MS
Enter a Description. Description contents are entirely at campus discretion.
OPTIONAL – Enter a Short Description. Short Description contents are entirely at campus discretion. 7. Click the “Save” button

3.17 Administrator creates a Pay Calendar

Pay Calendars define the begin and end date of a payroll period. They are associated with a pay run ID which is used with LCD and PIP activity. Campuses are responsible for creating and maintaining their own Pay Calendars. There must exist pay calendars to cover the entirety of a given calendar year, especially with ACD calendars.

Sign in as a payroll administrator
Navigate to Main Menu > Set Up HCM > Product Related > Payroll for North America > Payroll Processing Controls > Pay Calendar Table
Click on the “Add a New Value” tab
Enter the Company
Enter the Pay Group
Enter the Pay Period End Date as defined by the associated SCO or ACD payroll period.
Click the “Add” button
OPTIONAL – Enter a Pay Run ID
Enter a Pay Period Begin Date as defined by the associated SCO or ACD payroll period. 10. Click “Save”

3.18 Administrator generates a PIP file for transmission

Sign in as a payroll administrator
Navigate to Main Menu > Time and Labor > CSU Time and Labor > CSU PIP > CSU PIP Process
Enter a run control ID
1. Run control IDs are controlled by the campus. Please follow your campus procedures for creation of a run control, if required.
Enter the appropriate Pay Run ID in the “Run ID” field. IMPORTANT – Never re-run any Pay Run IDs for periods prior to the campus' CHRS conversion date. PIP history for campuses is not converted and the process will try to re-send everything.
OPTIONAL – Enter a Balance ID to bound the returned values by Balance ID
OPTIONAL – Enter a Business Unit
OPTIONAL – Enter a from date to bound the data to be included in the file
OPTIONAL – Enter a thru date to bound the data to be included in the file
OPTIONAL – Check the “Incl Retro:” box if the run requires the gathering of entries from prior periods.

NOTE: this option may not be available on all runs.

Set the process statuses to be executed in this run using the drop downs for each.
1. Draft Run generates a draft file that is intended to be reviewed for accuracy.
2. Final Run generates a file that is intended to be transmitted and sets the “TR” status on payable time.
OPTIONAL – Enter departments in the “Include Departments” section to bound the data to be included in the file.
OPTIONAL – Enter job codes in the “Include Job Codes” section to bound the data to be included in the fi1l1e.
OPTIONAL – Enter emplids & empl records in the “Include/Exclude EmplIDs” section to bound the data to be included in the file.
Click the “Run” button to execute the PIP File generation process(es).

3.19 Administrator Reviews the PIP Generated Data

Sign in as a payroll administrator
Navigate to Main Menu > Time and Labor > CSU Time and Labor > CSU PIP > PIP Review Page
Enter search criteria into the Search Criteria fields
Click Search
Click on the desired entry from the search results.
Review the returned results
OPTIONAL – If the result should be excluded from the final file, select the appropriate option from the “Exclude from PIP” dropdown.
1. Excld Perm – This will set the exclusion flag on the data preventing it from being transmitted in this, or any subsequent run.
2. Excld Temp – This will set a temporary exclusion flag on the data preventing it from being transmitted in this run, but will be picked up in subsequent runs.
Click “Save” to save any changes.

4.0 Process Output

Where does the data go, what are the next steps?

Reporting info – Data validation steps?

5.0 Testing

Where to find the test scripts for this (UFT)

6.0 Appendix

Useful tables, glossaries, translations

6.1 List of Exceptions

6.2 List of Validations

6.3 List of Timesheet TRCs

TRC	TRC DESCRIPTION	RATE MULTIPLIER	EARNINGS CODE	OVERRIDE RATE
OF6	Planned Holiday Pay @ 1.5 (OT)	1.5	OF6	0
OTPR	Overtime Paid @ 1.5	1.5	OTP	0
REG	Regular Hours Worked	1	REG	0
CTST	Comp Time Earned @ 1.0	1	HRS	0
CTPR	Comp Time Earned @ 1.5	1	HRS	0
CTO	Comp Time Taken	1	REG	0
CTOPD	CTO Paydown	1	OTS	0
HG5	Planned Holiday Pay @ 1.0	1	HG5	0
HG6	Planned Holiday Pay @ 1.5	1.5	HG6	0
OTST	Overtime Paid @ 1.0	1	OTS	0
OF5	Planned Holiday Pay @ 1.0 (OT)	1	OF5	0
ASBES	Asbestos HazMat Handling Diff	1	AS3	3
ADO	Additional Day Off Earned	1	HRS	0
AEADJ	ADO Earned Adjustment	1	HRS	0
ATADJ	ADO Negative Adjustment	1	HRS	0
ADOT	Additional Day Off Taken	1	REG	0
SHE08	Shift - Evening R08 (.23)	1	E08	0.23
SHE1	Shift - Evening R10 (1.50)	1	S10	1.5
SHG06	Shift - Graveyard R06 (2.30)	1	G06	2.3
SHG99	Shift - Graveyard Cadet (.28)	1	G99	0.28
SHGRV	Shift - Graveyard CSUEU (2.30)	1	GCS	2.3
SHN08	Shift - Night R08 (2.20)	1	N08	2.2
SHN10	Shift - Graveyard R10 (2.50)	1	G10	2.5
SHS06	Shift -Swing R06 Diff (1.30)	1	S06	1.3
SHS99	Shift - Swing Cadet Diff (.23)	1	S99	0.23
SHSWG	Shift - Swing CSUEU (1.35)	1	SCS	1.35
SHSUN	Shift - Sunday R10 (2.50)	1	U10	2.5
SHU06	Shift - Sunday R06 Diff (1.30)	1	S06	1.3
CBWK	Callback Worked 2.5 Unit 10	2.5	CBW	0

SELECT T.TRC, T.DESCR AS "TRC DESCRIPTION", T.FACTOR_MULT AS "RATE MULTIPLIER", TL_ERNCD AS "EARNINGS CODE", PERUNIT_OVR_RT AS "OVERRIDE RATE"

FROM PS_TL_TRC_TBL T, PS_TL_ERNCD_TBL E, PS_EARNINGS_TBL EC

WHERE T.EFFDT = (SELECT MAX (T1.EFFDT) FROM PS_TL_TRC_TBL T1

WHERE T.TRC = T1.TRC

AND T1.EFFDT <= SYSDATE)

AND T.EFF_STATUS = 'A'

AND T.TRC_FILTER <> 'Y'

AND EXISTS (SELECT 'X' FROM PS_TL_TRCPGELE_TBL P

WHERE P.EFFDT = (SELECT MAX (P1.EFFDT) FROM PS_TL_TRCPGELE_TBL P1

WHERE P.TRC_PROGRAM = P1.TRC_PROGRAM

AND P1.EFFDT <= SYSDATE)

AND T.TRC = P.TRC)

AND E.EFFDT = (SELECT MAX (E1.EFFDT) FROM PS_TL_ERNCD_TBL E1

WHERE E.TRC = E1.TRC

AND E1.EFFDT <= SYSDATE)

AND T.TRC = E.TRC

AND E.EFF_STATUS = 'A'

AND EC.EFFDT = (SELECT MAX (EC1.EFFDT) FROM PS_EARNINGS_TBL EC1

WHERE EC.ERNCD = EC1.ERNCD

AND EC1.EFFDT <= SYSDATE)

AND EC.EFF_STATUS = 'A'

AND E.TL_ERNCD = EC.ERNCD;

6.4 List of Rules

RULE_PGM_ID	TL_RULE_ID	SHORT DESCR	Long Descr
CSU BRIDGE	CSUT008	Default REG for blank TRC	Defaulting TRC Rule. This rule will assign any hours without a Time Reporting Code (TRC) to the REG TRC.
CSU BRIDGE	CSUC112	Delete Meal
CSU BRIDGE	CSUC111	Round Payable Time to 1/10th	TRC Removal Rule. Remove entries for the FL TRC from Rules working table (TL_IPT1). This will ensure the TRC is not included in Payable Time. Warning: Any TRC used in this template will not be included in Payable Time and will not be sent to a payroll system. A common use of this rule template would be to clean up Accumulators that are loaded into TL_IPT1.
CSU BRIDGE	CSUC100	No MEAL after 6 hours	Exception Rule: No Break. When the sum of hours worked from Punch Types (In), is more than 6 hours without a break, create Exception CSUX103. This template can be used to inform managers if Time Reporters are working too many hours without a break

CSU BRIDGE	CSUT102	Long MEAL > 1.25 hours	Exception Rule: Missing Punch Monitoring. When a Time Reporter reports more than 1.25 hours for the following punch types (Meal), create exception CSUX102.
CSU BRIDGE	CSUT101	Student > 40 hours for week	Exception Rule: Excessive (over)time. Create exception CSUX101 when a Time Reporter reports more than 40 total hours of (OTPR, REG) during the rule period . This template could be used as a rule to warn that a time reporter is approaching Overtime for the specified period.
CSU BRIDGE	CSUT100	Long IN punch > 12 hours	Exception Rule: Missing Punch Monitoring. When a Time Reporter reports more than 12 hours for the following punch types (In), create exception CSUX100.
CSU BRIDGE	CSUT001	Exception Over 40 Hours	Exception Rule: Excessive (over)time. Create exception TLX90001 when a Time Reporter reports more than 40 total hours of (ADOT, CIT, CTO, CTST, DOCK, FL, HOL, HT, JD, ML, MPA, ODL, OTST, PDL, PH, PL, REG, SL, SLD, SLF, UTN, UTR, VA) during the rule period . This template could be used as a rule to warn that a time reporter is approaching Overtime for the specified period.
CSU HRLY	CSUT008	Default REG for blank TRC	Defaulting TRC Rule. This rule will assign any hours without a Time Reporting Code (TRC) to the REG TRC.

CSU HRLY	CSUC112	Delete Meal	TRC Removal Rule. Remove entries for the FL TRC from Rules working table (TL_IPT1). This will ensure the TRC is not included in Payable Time. Warning: Any TRC used in this template will not be included in Payable Time and will not be sent to a payroll system. A common use of this rule template would be to clean up Accumulators that are loaded into TL_IPT1.
CSU HRLY	CSUC111	Round Payable Time to 1/10th
CSU HRLY	CSUC100	No MEAL after 6 hours	Exception Rule: No Break. When the sum of hours worked from Punch Types (In), is more than 6 hours without a break, create Exception CSUX103. This template can be used to inform managers if Time Reporters are working too many hours without a break
CSU HRLY	CSUT102	Long MEAL > 1.25 hours	Exception Rule: Missing Punch Monitoring. When a Time Reporter reports more than 1.25 hours for the following punch types (Meal), create exception CSUX102.
CSU HRLY	CSUT100	Long IN punch > 12 hours	Exception Rule: Missing Punch Monitoring. When a Time Reporter reports more than 12 hours for the following punch types (In), create exception CSUX100.

CSU HRLY	CSUC109	CTO with Shift	Exception Rule: Excessive (over)time. Create exception CSUX105 when a Time Reporter reports more than 0 total hours of (S$E08, S$E1, S$E2, S$G06, S$G99, S$GRV, S$N08, S$N10, S$S06, S$S99, S$SUN, S$SWG, S$U06, SHE08, SHE1, SHE2, SHG06, SHG99, SHGRV, SHN08, SHN10, SHS06, SHS99, SHSUN, SHSWG, SHU06) during the rule period . This template could be used as a rule to warn that a time reporter is approaching Overtime for the specified period.
CSU HRLY	CSUC108	All Day Shift	Exception Rule: Excessive (over)time. Create exception CSUX104 when a Time Reporter reports more than 4 total hours of (S$E08, S$E1, S$E2, S$G06, S$G99, S$GRV, S$N08, S$N10, S$S06, S$S99, S$SUN, S$SWG, S$U06, SHE08, SHE1, SHE2, SHG06, SHG99, SHGRV, SHN08, SHN10, SHS06, SHS99, SHSUN, SHSWG, SHU06) during the rule period . This template could be used as a rule to warn that a time reporter is approaching Overtime for the specified period.
CSU HRLY	CSUT003	Daily Hours Exceed 16	Exception Rule: Excessive (over)time. Create exception TLX90003 when a Time Reporter reports more than 16 total hours of TRC(s) (ADOT, CIT, CTO, CTST, DOCK, FL, HOL, HT, JD, ML, MPA, ODL, OTST, PDL, PH, PL, REG, SL, SLD, SLF, UTN, UTR, VA) for a day. This template can be used to warn a manager as to when Time Reporters are reporting an excessive amount of hours.

CSU HRLY	CSUT001	Exception Over 40 Hours	Exception Rule: Excessive (over)time. Create exception TLX90001 when a Time Reporter reports more than 40 total hours of (ADOT, CIT, CTO, CTST, DOCK, FL, HOL, HT, JD, ML, MPA, ODL, OTST, PDL, PH, PL, REG, SL, SLD, SLF, UTN, UTR, VA) during the rule period . This template could be used as a rule to warn that a time reporter is approaching Overtime for the specified period.
CSU SALARIED	CSUC001	Sal < 1.0 FTE using OTST, OTPR	If a salaried employee with an FTE < 1.00 uses TRC's OTST or OTPR, an exception will be created. Note: For employees with multiple jobs, this rule takes into account the employee's combined total FTE.
CSU SALARIED	CSUC109	CTO with Shift	Exception Rule: Excessive (over)time. Create exception CSUX105 when a Time Reporter reports more than 0 total hours of (S$E08, S$E1, S$E2, S$G06, S$G99, S$GRV, S$N08, S$N10, S$S06, S$S99, S$SUN, S$SWG, S$U06, SHE08, SHE1, SHE2, SHG06, SHG99, SHGRV, SHN08, SHN10, SHS06, SHS99, SHSUN, SHSWG, SHU06) during the rule period . This template could be used as a rule to warn that a time reporter is approaching Overtime for the specified period.
CSU SALARIED	CSUC108	All Day Shift	Exception Rule: Excessive (over)time. Create exception CSUX104 when a Time Reporter reports more than 4 total hours of (S$E08, S$E1, S$E2, S$G06, S$G99, S$GRV, S$N08, S$N10, S$S06, S$S99, S$SUN, S$SWG, S$U06, SHE08, SHE1, SHE2, SHG06, SHG99, SHGRV, SHN08, SHN10, SHS06, SHS99, SHSUN, SHSWG, SHU06) during the rule period . This template could be used as a rule to warn that a time reporter is approaching Overtime for the specified period.

CSU SALARIED	CSUC106	No Holiday - Rehired Annuitant	Holiday Rule. Pay the following Time Reporters (Salaried) 8 hours of TRC NOHOL for holiday pay. Payable time will be generated for the target TRC in addition to the incoming TRC for quantities that exceed the defined limit. Positive Time Reporters are paid for all holidays, even if there is no reported time in the Period.
CSU SALARIED	CSUC105	Holiday Credit - E99	Holiday Rule. Pay the following Time Reporters (Hourly, Salaried) 8 hours of TRC HCRE for holiday pay. Payable time will be generated for the target TRC in addition to the incoming TRC for quantities that exceed the defined limit. Positive Time Reporters are paid for all holidays, even if there is no reported time in the Period.
CSU SALARIED	CSUC102	Create ADO - ADO_C99	Holiday Rule. Pay the following Time Reporters (Salaried) 1 hours of TRC ADO for holiday pay. Payable time will be generated for the target TRC in addition to the incoming TRC for quantities that exceed the defined limit. Positive Time Reporters are paid for all holidays, even if there is no reported time in the Period.
CSU SALARIED	CSUC101	Create ADO - ADO_CSUEU	Holiday Rule. Pay the following Time Reporters (Salaried) 1 hours of TRC ADO for holiday pay. Payable time will be generated for the target TRC in addition to the incoming TRC for quantities that exceed the defined limit. Positive Time Reporters are paid for all holidays, even if there is no reported time in the Period.

CSU SALARIED	CSUT003	Daily Hours Exceed 16	Exception Rule: Excessive (over)time. Create exception TLX90003 when a Time Reporter reports more than 16 total hours of TRC(s) (ADOT, CIT, CTO, CTST, DOCK, FL, HOL, HT, JD, ML, MPA, ODL, OTST, PDL, PH, PL, REG, SL, SLD, SLF, UTN, UTR, VA) for a day. This template can be used to warn a manager as to when Time Reporters are reporting an excessive amount of hours.
CSU SALARIED	CSUT001	Exception Over 40 Hours	Exception Rule: Excessive (over)time. Create exception TLX90001 when a Time Reporter reports more than 40 total hours of (ADOT, CIT, CTO, CTST, DOCK, FL, HOL, HT, JD, ML, MPA, ODL, OTST, PDL, PH, PL, REG, SL, SLD, SLF, UTN, UTR, VA) during the rule period . This template could be used as a rule to warn that a time reporter is approaching Overtime for the specified period.
CSU_STUDENT	CSUT008	Default REG for blank TRC	Defaulting TRC Rule. This rule will assign any hours without a Time Reporting Code (TRC) to the REG TRC.
CSU_STUDENT	CSUT002	Students > 20 Hrs per week	Exception Rule: Excessive (over)time. Create exception TLX90002 when a Time Reporter reports more than 20 total hours of REG during the rule period . This template could be used as a rule to warn that a time reporter is approaching Overtime for the specified period.
CSU_STUDENT	CSUT100	Long IN punch > 12 hours	Exception Rule: Missing Punch Monitoring. When a Time Reporter reports more than 12 hours for the following punch types (In), create exception CSUX100.
CSU_STUDENT	CSUT101	Student > 40 hours for week	Exception Rule: Excessive (over)time. Create exception CSUX101 when a Time Reporter reports more than 40 total hours of (OTPR, REG) during the rule period . This template could be used as a rule to warn that a time reporter is approaching Overtime for the specified period.
CSU_STUDENT	CSUT102	Long MEAL > 1.25 hours	Exception Rule: Missing Punch Monitoring. When a Time Reporter reports more than 1.25 hours for the following punch types (Meal), create exception CSUX102.
CSU_STUDENT	CSUC100	No MEAL after 6 hours	Exception Rule: No Break. When the sum of hours worked from Punch Types (In), is more than 6 hours without a break, create Exception CSUX103. This template can be used to inform managers if Time Reporters are working too many hours without a break
CSU_STUDENT	CSUC111	Round Payable Time to 1/10th
CSU_STUDENT	CSUC112	Delete Meal	TRC Removal Rule. Remove entries for the FL TRC from Rules working table (TL_IPT1). This will ensure the TRC is not included in Payable Time. Warning: Any TRC used in this template will not be included in Payable Time and will not be sent to a payroll system. A common use of this rule template would be to clean up Accumulators that are loaded into TL_IPT1.

SELECT P.RULE_PGM_ID, R.TL_RULE_ID, R.DESCR AS "SHORT DESCRIPTION", R.DESCRLONG AS "LONG DESCRIPTION"

FROM PS_TL_RULE_DEFN R, PS_TL_RULE_PGM_DTL P

WHERE P.EFFDT = (SELECT MAX (P1.EFFDT) FROM PS_TL_RULE_PGM_DTL P1

WHERE P.RULE_PGM_ID = P1.RULE_PGM_ID