TL_TMPLT_RULE2

(SQL Table)
Index Back

TL Rule Template Definitions

# 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 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
2=TRC
3=WorkGroup
4=Union Code
5=Jobcode
6=Deptid
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