TL_RUN_RULE_DTL (SQL Table)	Index Back
Time Run Control Participants This record is used to define the employees and groups selected for a given run control within Time & Labor.

TL_RUN_RULE_DTL

(SQL Table)

Time Run Control Participants

This record is used to define the employees and groups selected for a given run control within Time & Labor.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 TL_RULE_ID Character(12) VARCHAR2(12) NOT NULL Rule ID

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

6 PERIOD_ID Character(12) VARCHAR2(12) NOT NULL Time Period ID

7 TL_USER_EXIT Character(1) VARCHAR2(1) NOT NULL User Exit

8 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section

9 AE_SECTION_UD Character(8) VARCHAR2(8) NOT NULL User defined AE Section Name. This is an AE Section that a user has previously written to handle a specific rule that could not be defined using one of the delivered Rule Templates or Rule Components (Actions, Conditions, SQL Objects). The AE Section must be populated on the PS_TL_AE_SECTION table.

10 TEMPLATE_TYPE Character(3) VARCHAR2(3) NOT NULL Template Type
ACC=Accumulator
APP=Approval Required
ATT=Attendance
CON=Consecutive Days
DFL=Default
DTH=Daily Threshold
EXC=Exception
GUA=Guaranteed Hours
HOL=Holiday
LIB=Library
MEA=Meal
MIS=Miscellaneous
MSP=Missing Punch
OPA=OPA Regulatory Rules
PRM=Premium Zone
PTR=Period Threshold
SCH=Schedule Deviation
SHF=Shift Premium
SPC=Specific Day
TSK=Task

11 TEMPLATE_ID Character(15) VARCHAR2(15) NOT NULL Template ID

12 CHANGED Character(1) VARCHAR2(1) NOT NULL Field introduced with Rules to differentiate pure template-based rules from those subsequently customized.

13 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	TL_RULE_ID	Character(12)	VARCHAR2(12) NOT NULL	Rule ID
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
6	PERIOD_ID	Character(12)	VARCHAR2(12) NOT NULL	Time Period ID
7	TL_USER_EXIT	Character(1)	VARCHAR2(1) NOT NULL	User Exit
8	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
9	AE_SECTION_UD	Character(8)	VARCHAR2(8) NOT NULL	User defined AE Section Name. This is an AE Section that a user has previously written to handle a specific rule that could not be defined using one of the delivered Rule Templates or Rule Components (Actions, Conditions, SQL Objects). The AE Section must be populated on the PS_TL_AE_SECTION table.
10	TEMPLATE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Template Type ACC=Accumulator APP=Approval Required ATT=Attendance CON=Consecutive Days DFL=Default DTH=Daily Threshold EXC=Exception GUA=Guaranteed Hours HOL=Holiday LIB=Library MEA=Meal MIS=Miscellaneous MSP=Missing Punch OPA=OPA Regulatory Rules PRM=Premium Zone PTR=Period Threshold SCH=Schedule Deviation SHF=Shift Premium SPC=Specific Day TSK=Task
11	TEMPLATE_ID	Character(15)	VARCHAR2(15) NOT NULL	Template ID
12	CHANGED	Character(1)	VARCHAR2(1) NOT NULL	Field introduced with Rules to differentiate pure template-based rules from those subsequently customized.
13	DESCRLONG	Long Character	CLOB	Long Description