EX_TIME_QUIK_VW

(SQL View)
 Index Back

Time Entry Quick Fill view

Time Entry Quick Fill view

SELECT DISTINCT H.SETID , H.EMPLID ,CASE WHEN 'Y' IN ( SELECT 'Y' FROM PS_EX_EE_USER_PREF WHERE EMPLID = H.EMPLID AND SHOW_DESCR_OPT IN ('Y')) THEN PROJ.DESCR %Concat ' - ' %Concat %Sql(EX_LTRIM_ZEROS, ACT.DESCR) WHEN 'Y' IN ( SELECT 'Y' FROM PS_BUS_UNIT_TBL_EX WHERE BUSINESS_UNIT_GL = H.BUSINESS_UNIT_GL AND SHOW_DESCR_OPT = 'Y' AND EXISTS ( SELECT 'Y' FROM PS_EX_EE_USER_PREF WHERE EMPLID = H.EMPLID AND SHOW_DESCR_OPT IN ('D'))) THEN PROJ.DESCR %Concat ' - ' %Concat %Sql(EX_LTRIM_ZEROS, ACT.DESCR) ELSE D.PROJECT_ID %Concat ' - ' %Concat %Sql(EX_LTRIM_ZEROS,D.ACTIVITY_ID) END , ' ' , ' ' , D.BUSINESS_UNIT_PC , D.PROJECT_ID , D.ACTIVITY_ID FROM PS_EX_TIME_DTL D , PS_EX_TIME_HDR H , PS_EX_ACTEAM_TE_VW ACT , PS_EX_BUGL_TEAM_VW PROJ WHERE D.TIME_SHEET_ID = H.TIME_SHEET_ID AND D.PROJECT_ID <> ' ' AND ACT.EMPLID = H.EMPLID AND ACT.BUSINESS_UNIT_PC = D.BUSINESS_UNIT_PC AND ACT.PROJECT_ID = D.PROJECT_ID AND ACT.ACTIVITY_ID = D.ACTIVITY_ID AND PROJ.EMPLID = H.EMPLID AND PROJ.BUSINESS_UNIT_PC = D.BUSINESS_UNIT_PC AND PROJ.PROJECT_ID = D.PROJECT_ID AND %DateDiff(H.PERIOD_END_DT, %CurrentDateIn) <= 30 UNION SELECT T.SETID , O.EMPLID , T.DESCR , T.TRC , '0' , ' ' , ' ' , ' ' FROM PS_EX_TRC_MAP_VW T , PSOPRDEFNVW O WHERE O.OPRID = %OperatorId

  • Parent record: EX_TIME_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 QUICK_FILL_TRC Character(50) VARCHAR2(50) NOT NULL Quick Fill / Time Reporting Code combo selection dropdown field

    Prompt Table: EX_TIME_QUIK_VW

    4 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code

    Prompt Table: TL_TRC_TBL

    5 TIME_SHEET_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)
    6 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
    7 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    8 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID