TL_TMPLT_RULE2 (SQL Table)	Index Back
(Custom) Rule Parameters This table holds the pointers and parameter value for every instance within a rule where a parameter placeholder (%RuleTemplate()) is to be replaced by a value from the template rule. For pure template-based rules we store each parameter once (in TL_TMPLT_RULE and TL_TMPLT_RULEP) and use the TL_TMPLT_PARMS table to map the values out into the right SQL steps. Once a rule is modified and may deviate from the template, the TL_TMPLT_RULE2 repository becomes the sole parameter source.

TL_TMPLT_RULE2

(SQL Table)

(Custom) Rule Parameters

This table holds the pointers and parameter value for every instance within a rule where a parameter placeholder (%RuleTemplate()) is to be replaced by a value from the template rule. For pure template-based rules we store each parameter once (in TL_TMPLT_RULE and TL_TMPLT_RULEP) and use the TL_TMPLT_PARMS table to map the values out into the right SQL steps. Once a rule is modified and may deviate from the template, the TL_TMPLT_RULE2 repository becomes the sole parameter source.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

2 TEMPLATE_ID Character(15) VARCHAR2(15) NOT NULL Rule Template
Prompt Table: TL_TMPLT_DEFN

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

4 TL_RULE_STEP Number(2,0) SMALLINT NOT NULL Rule Step

5 TL_AESTMTTYPE Character(2) VARCHAR2(2) NOT NULL This is a psedo-representation of AE Statement Type that helps drive the generation of AE library sections for template-based TL rules. The code-selection is designed to ensure the actions within a step is inserted in order according to AESTMTTYPE code when there are multiple actions under a single step (like DoWhen + SQL).
D=Do Select
H=Do When
W=Do While
Z0=SQL - Standard
Z1=SQL - Quit If No Rows
Default Value: Z0

6 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

7 LIST_TYPE Character(4) VARCHAR2(4) NOT NULL List type for Values
0=TCD Group
1=TaskGroup
10=Company
11=Paygroup
12=Grade
13=Step
14=Punch Type
15=Employee Status
16=Employee Type
17=Attendance Violations
18=Absence Take
19=Compensatory Time Off Plan
2=Time Reporting Codes
20=Plan Type
21=Payable Status
22=Reported Status
23=Absence Status
24=Exception
25=Severity
26=Benefit Plan
27=Absence Entitlement
3=WorkGroup
4=Union Code
5=Jobcode
6=Department
7=Position number
8=Location
9=Shift

8 LIST_ID Character(12) VARCHAR2(12) NOT NULL List ID

9 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

10 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)

11 FIELD_VALUE Character(30) VARCHAR2(30) NOT NULL Field Value

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
2	TEMPLATE_ID	Character(15)	VARCHAR2(15) NOT NULL	Rule Template Prompt Table: TL_TMPLT_DEFN
3	TL_RULE_ID	Character(12)	VARCHAR2(12) NOT NULL	Rule ID
4	TL_RULE_STEP	Number(2,0)	SMALLINT NOT NULL	Rule Step
5	TL_AESTMTTYPE	Character(2)	VARCHAR2(2) NOT NULL	This is a psedo-representation of AE Statement Type that helps drive the generation of AE library sections for template-based TL rules. The code-selection is designed to ensure the actions within a step is inserted in order according to AESTMTTYPE code when there are multiple actions under a single step (like DoWhen + SQL). D=Do Select H=Do When W=Do While Z0=SQL - Standard Z1=SQL - Quit If No Rows Default Value: Z0
6	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
7	LIST_TYPE	Character(4)	VARCHAR2(4) NOT NULL	List type for Values 0=TCD Group 1=TaskGroup 10=Company 11=Paygroup 12=Grade 13=Step 14=Punch Type 15=Employee Status 16=Employee Type 17=Attendance Violations 18=Absence Take 19=Compensatory Time Off Plan 2=Time Reporting Codes 20=Plan Type 21=Payable Status 22=Reported Status 23=Absence Status 24=Exception 25=Severity 26=Benefit Plan 27=Absence Entitlement 3=WorkGroup 4=Union Code 5=Jobcode 6=Department 7=Position number 8=Location 9=Shift
8	LIST_ID	Character(12)	VARCHAR2(12) NOT NULL	List ID
9	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
10	FIELDTYPE	Number(2,0)	SMALLINT NOT NULL	Field Type (from PSST0101 Ref.)
11	FIELD_VALUE	Character(30)	VARCHAR2(30) NOT NULL	Field Value