TL_TMPLT_R2_TAO

#	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	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
6	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
7	LIST_ID	Character(12)	VARCHAR2(12) NOT NULL	List ID
8	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
9	FIELDTYPE	Number(2,0)	SMALLINT NOT NULL	Field Type (from PSST0101 Ref.)
10	FIELD_VALUE	Character(30)	VARCHAR2(30) NOT NULL	Field Value