TL_RSLV_TMPL_VW (SQL View)	Index Back
Resolve template from Tskgroup Resolve template for the employee (based on the template defined in the taskgroup that has been defined for the employee)

TL_RSLV_TMPL_VW

(SQL View)

Resolve template from Tskgroup

Resolve template for the employee (based on the template defined in the taskgroup that has been defined for the employee)

SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , C.SEQNUM , B.TASKGROUP , B.EFFDT , C.PUNCH_TYPE , C.PUNCH_LABEL FROM PS_TL_EMPL_DATA A , PS_TL_TR_PUNCH C , PS_TL_TASKGRP_TBL B WHERE A.TASKGROUP = B.TASKGROUP AND B.PCH_TR_TMPLT_ID = C.TIME_RPTG_TMPLT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

5 TASKGROUP Character(10) VARCHAR2(10) NOT NULL Taskgroup

6 EFFDT_NEW Date(10) DATE New Effective Date

7 PUNCH_TYPE Character(2) VARCHAR2(2) NOT NULL Global Punch Types
0=Elapsed
1=In
2=Out
3=Meal
4=Break
5=Transfer

8 PUNCH_LABEL Character(10) VARCHAR2(10) NOT NULL Column Heading

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
5	TASKGROUP	Character(10)	VARCHAR2(10) NOT NULL	Taskgroup
6	EFFDT_NEW	Date(10)	DATE	New Effective Date
7	PUNCH_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Global Punch Types 0=Elapsed 1=In 2=Out 3=Meal 4=Break 5=Transfer
8	PUNCH_LABEL	Character(10)	VARCHAR2(10) NOT NULL	Column Heading