TL_TM_DEF_V_LNG (SQL View)	Index Back
TL Rule Template Definitions

TL_TM_DEF_V_LNG

(SQL View)

TL Rule Template Definitions

SELECT TEMPLATE_TYPE , TEMPLATE_ID ,LANGUAGE_CD , DESCR FROM PS_TL_TMPL_DFN_LNG WHERE TEMPLATE_ID NOT LIKE 'TEMPLATE999%'

Related Language Record for TL_TMPLT_DEF_VW

# 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

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description