TL_TR_TRC_VW(SQL View) |
Index Back |
---|---|
TRC Prompt ViewThis record is used as a dynamic prompt view for the elapsed time processes. |
SELECT DISTINCT AA.EMPLID ,AA.EMPL_RCD ,A.WORKGROUP ,A.EFFDT ,D.TRC ,B.TRC_PROGRAM ,A.COMP_TIME_PLAN ,D.DESCR ,D.COMP_LEAV_IND ,D.TRC_TYPE 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 (D.COMP_LEAV_IND IN ('NO','LTKN') OR D.COMP_LEAV_IND IN ('CERN','CTKN') AND ( EXISTS ( SELECT 'X' FROM PS_TL_EMPL_COMP S2 , PS_TL_COMP_TRC S3 WHERE S2.EMPLID = AA.EMPLID AND S2.EMPL_RCD = AA.EMPL_RCD AND S2.EFF_STATUS = 'A' AND S3.COMP_TIME_PLAN = S2.COMP_TIME_PLAN AND S3.EFF_STATUS = 'A' AND S3.TRC = C.TRC) OR A.COMP_TIME_PLAN <> ' ' AND EXISTS ( SELECT 'X' FROM PS_TL_COMP_TRC S4 WHERE S4.COMP_TIME_PLAN =A.COMP_TIME_PLAN AND S4.EFF_STATUS = 'A' AND S4.TRC = C.TRC) )) AND A.EFF_STATUS = 'A' AND D.EFF_STATUS = 'A' |
# | 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 | TRC_PROGRAM | Character(5) | VARCHAR2(5) NOT NULL | TRC Program ID |
7 | COMP_TIME_PLAN | Character(10) | VARCHAR2(10) NOT NULL | Compensatory Time Off Plan |
8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
9 | 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 |
10 | TRC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
This defines TRC Type of Hours,Amounts ,Units
A=Amount H=Hours U=Units |