TL_TMPLT_STEPS (SQL Table)	Index Back
Rule Template Steps This is the building block onto which template built rule entries are applied in order to generate the actual rule steps (TL_RULE_STEPS) when the user saves the template-built rule. 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_STEPS

(SQL Table)

Rule Template Steps

This is the building block onto which template built rule entries are applied in order to generate the actual rule steps (TL_RULE_STEPS) when the user saves the template-built rule. 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 Of TL_TMPLT_PARMS TL_TMPLT_PARMT

# 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 RULE_OPERAND_TYPE Character(4) VARCHAR2(4) NOT NULL Rule Operand Type.
0=Action
1=SQL Object
2=Truncate Work Table
3=Update Statistics
Default Value: 1

5 ACTION_ID Character(12) VARCHAR2(12) NOT NULL Action ID
Prompt Table: TL_ACTIONS

6 SQL_ID Character(30) VARCHAR2(30) NOT NULL TL
Prompt Table: TL_SQL_OBJECT

7 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
Prompt Table: TL_WORK_RT_VW

8 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

#	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	RULE_OPERAND_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Rule Operand Type. 0=Action 1=SQL Object 2=Truncate Work Table 3=Update Statistics Default Value: 1
5	ACTION_ID	Character(12)	VARCHAR2(12) NOT NULL	Action ID Prompt Table: TL_ACTIONS
6	SQL_ID	Character(30)	VARCHAR2(30) NOT NULL	TL Prompt Table: TL_SQL_OBJECT
7	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: TL_WORK_RT_VW
8	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description