TL_MBLE_TRC_VW (SQL View)	Index Back
TRCs for Mobile TRCs used for prompt table lookup on the Elapsed Time Mobile Page.

TL_MBLE_TRC_VW

(SQL View)

TRCs for Mobile

TRCs used for prompt table lookup on the Elapsed Time Mobile Page.

SELECT DISTINCT AA.EMPLID ,AA.EMPL_RCD ,A.WORKGROUP ,A.EFFDT ,D.TRC ,D.EFFDT ,B.TRC_PROGRAM ,A.COMP_TIME_PLAN ,D.DESCR ,D.DESCRSHORT ,D.COMP_LEAV_IND ,D.TRC_TYPE ,D.EFF_STATUS ,D.SYNCID ,D.LASTUPDDTTM FROM PS_TL_EMPL_DATA AA ,PS_TL_WRKGRP_TBL A ,PS_TL_TRC_PGM_TBL B ,PS_TL_TRCPGELE_TBL C ,PS_TL_TRC_TBL D WHERE AA.TIME_RPTG_STATUS = 'A' AND AA.WORKGROUP = A.WORKGROUP AND A.TRC_PROGRAM = B.TRC_PROGRAM AND A.TRC_PROGRAM = C.TRC_PROGRAM AND C.TRC = D.TRC AND B.EFFDT=C.EFFDT AND A.EFF_STATUS = 'A' AND D.COMP_LEAV_IND = 'NO' AND D.TRC_FILTER = 'N' AND D.GP_ABSENCE_FLG = 'N'

Related Language Record: TL_TR_TRCVW_LNG

# 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 Rcd Nbr

3 WORKGROUP Character(10) VARCHAR2(10) NOT NULL Workgroup

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

5 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code used to report time in Time and Labor

6 DATE2 Date(10) DATE Date 2

7 TRC_PROGRAM Character(5) VARCHAR2(5) NOT NULL TRC Program ID

8 COMP_TIME_PLAN Character(10) VARCHAR2(10) NOT NULL Compensatory Time Off Plan

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

10 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

11 COMP_LEAV_IND Character(4) VARCHAR2(4) NOT NULL Comp Leave Indiactor indicates whether a TRC has any effect on Leave and Compensatory time Off
CERN=Comp Time Earned
CTKN=Comp Time Taken
LTKN=Leave Taken
NO=No Comp Time Effect
RULE=Avoid Replacing by Rules

12 TRC_TYPE Character(1) VARCHAR2(1) NOT NULL This defines TRC Type of Hours,Amounts ,Units
A=Amount
H=Hours
U=Units

13 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

14 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

15 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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 Rcd Nbr
3	WORKGROUP	Character(10)	VARCHAR2(10) NOT NULL	Workgroup
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	TRC	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code used to report time in Time and Labor
6	DATE2	Date(10)	DATE	Date 2
7	TRC_PROGRAM	Character(5)	VARCHAR2(5) NOT NULL	TRC Program ID
8	COMP_TIME_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Compensatory Time Off Plan
9	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
10	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
11	COMP_LEAV_IND	Character(4)	VARCHAR2(4) NOT NULL	Comp Leave Indiactor indicates whether a TRC has any effect on Leave and Compensatory time Off CERN=Comp Time Earned CTKN=Comp Time Taken LTKN=Leave Taken NO=No Comp Time Effect RULE=Avoid Replacing by Rules
12	TRC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	This defines TRC Type of Hours,Amounts ,Units A=Amount H=Hours U=Units
13	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
14	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
15	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.