TL_TMPLT_CONDS

#	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_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
5	CONDITION_ID	Character(12)	VARCHAR2(12) NOT NULL	Condition ID Prompt Table: TL_CONDITIONS
6	LEFT_PAREN	Character(1)	VARCHAR2(1) NOT NULL	Left Parenthesis 1=( 2=(( 3=((( 4=(((( 5=((((( 6=(((((( 7=(((((((
7	RIGHT_PAREN	Character(1)	VARCHAR2(1) NOT NULL	Right Parenthesis 1=) 2=)) 3=))) 4=)))) 5=))))) 6=)))))) 7=)))))))
8	BOOLEAN_OPERATOR	Character(1)	VARCHAR2(1) NOT NULL	AND\OR 0=AND 1=OR