TL_TMPLT_PARMS (SQL Table)	Index Back
Rule Template Parameters This is the building block onto which template built rule entries are applied in order to generate the rule parameter table (TL_TMPLT_RULE2). If the content of this table is modified, all rules created from said template must be compiled for the update to take effect.

TL_TMPLT_PARMS

(SQL Table)

Rule Template Parameters

This is the building block onto which template built rule entries are applied in order to generate the rule parameter table (TL_TMPLT_RULE2). If the content of this table is modified, all rules created from said template must be compiled for the update to take effect.

Parent record: TL_TMPLT_STEPS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 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

4 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number

5 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
Default Value: DERIVED_TL_TMPL

6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
Prompt Table: PSRECFIELDALL

7 TL_FIELDFORMAT Character(1) VARCHAR2(1) NOT NULL Field Format. Introduced to hold the numeric FIELDTYPE values in a xlat set for user friendly selection. It is not a true representation as it also supports the need to indicate a character value as something not to be surrounded by '' when formatted into a SQL statement in the TL AE rules building.
0=Character
2=Numeric
3=Signed Numeric
4=Date
5=Time
6=Date and Time
9=Character Without Quotes
Default Value: 0

8 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

9 REQUIRED_FIELD Character(1) VARCHAR2(1) NOT NULL * Required Field
Y/N Table Edit
Default Value: Y

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEMPLATE_ID	Character(15)	VARCHAR2(15) NOT NULL	Template ID
2	TL_RULE_STEP	Number(2,0)	SMALLINT NOT NULL	Rule Step
3	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
4	SEQ_NO	Number(2,0)	SMALLINT NOT NULL	Sequence Number
5	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Default Value: DERIVED_TL_TMPL
6	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: PSRECFIELDALL
7	TL_FIELDFORMAT	Character(1)	VARCHAR2(1) NOT NULL	Field Format. Introduced to hold the numeric FIELDTYPE values in a xlat set for user friendly selection. It is not a true representation as it also supports the need to indicate a character value as something not to be surrounded by '' when formatted into a SQL statement in the TL AE rules building. 0=Character 2=Numeric 3=Signed Numeric 4=Date 5=Time 6=Date and Time 9=Character Without Quotes Default Value: 0
8	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
9	REQUIRED_FIELD	Character(1)	VARCHAR2(1) NOT NULL	* Required Field Y/N Table Edit Default Value: Y