TL_TMPLT_CONDS

#	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 MEA=Meal MIS=Miscellaneous MSP=Missing Punch 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	Template ID
3	TL_RULE_STEP	Number(2,0)	SMALLINT NOT NULL	Rule Step Prompt Table: TL_RULE_STEPS
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