TL_TR_TRCVW_LNG

(SQL View)
Index Back

TRC Prompt View

This record is used as a prompt view for the elapsed time processes.

SELECT DISTINCT AA.EMPLID ,AA.EMPL_RCD ,A.WORKGROUP ,A.EFFDT ,D.TRC ,D.LANGUAGE_CD ,D.DESCR 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_LANG D WHERE AA.TIME_RPTG_STATUS = 'A' AND AA.WORKGROUP = A.WORKGROUP AND A.TRC_PROGRAM = B.TRC_PROGRAM AND B.EFFDT=C.EFFDT AND B.TRC_PROGRAM = C.TRC_PROGRAM AND C.TRC = D.TRC

  • Related Language Record for TL_MBLE_TRC_VW TL_TR_TRC_VW
  • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description