PC_LATETIME_LVW

(SQL View)
 Index Back

Timesheet Due Lang Table

Late Timesheets based on My Project Team Members. Includes members with overdue Timesheets(for current period) as well as missing Timesheets (projects with End Date >= current date to eliminate "old" projects).

SELECT A.OPRID , A.BUSINESS_UNIT , A.PROJECT_ID , A.TEAM_MEMBER , LG.LANGUAGE_CD , LG.DESCR FROM PS_PC_PROJ_TEAM_VW A , PS_PC_LATETIME_VW B , PS_PROJECT_LANG LG , PS_PC_EX_TIME_PER D WHERE A.OPRID = D.OPRID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND A.TEAM_MEMBER = B.EMPLID AND B.BUSINESS_UNIT = LG.BUSINESS_UNIT AND B.PROJECT_ID = LG.PROJECT_ID AND B.BUSINESS_UNIT_GL = D.BUSINESS_UNIT_GL AND B.PERIOD_END_DT = D.PERIOD_END_DT UNION SELECT A.OPRID , A.BUSINESS_UNIT , A.PROJECT_ID , A.TEAM_MEMBER , LG.LANGUAGE_CD , LG.DESCR FROM PS_PC_PROJ_TEAM_VW A , PS_PC_EX_TIME_PER B , PS_PROJECT_LANG LG , PS_EX_EE_ORG_DTL D WHERE A.OPRID = B.OPRID AND A.END_DT >= %CurrentDateIn AND B.PERIOD_END_DT BETWEEN A.START_DT AND A.END_DT AND A.BUSINESS_UNIT = LG.BUSINESS_UNIT AND A.PROJECT_ID = LG.PROJECT_ID AND A.TEAM_MEMBER = D.EMPLID AND B.BUSINESS_UNIT_GL = D.BUSINESS_UNIT_GL AND D.DFLT_EE_PROF_FLG = 'Y' AND EXISTS ( SELECT 'X' FROM PS_EX_TIME_HDR HDR , PS_EX_TIME_DTL DTL WHERE HDR.TIME_SHEET_ID = DTL.TIME_SHEET_ID AND HDR.VERSION_NUM = DTL.VERSION_NUM AND B.BUSINESS_UNIT_GL = HDR.BUSINESS_UNIT_GL AND B.PERIOD_END_DT = HDR.PERIOD_END_DT AND DTL.BUSINESS_UNIT_PC = A.BUSINESS_UNIT AND DTL.PROJECT_ID = A.PROJECT_ID AND NOT EXISTS ( SELECT 'X' FROM PS_EX_TIME_HDR E WHERE A.TEAM_MEMBER = E.EMPLID AND B.PERIOD_END_DT = E.PERIOD_END_DT))

  • Related Language Record for PC_LATETIME_VW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_PC_NONVW

    3 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

    Prompt Table: PROJECT_ALL_VW

    4 TEAM_MEMBER Character(30) VARCHAR2(30) NOT NULL Team Member

    Prompt Table: PGM_TEAM_PRM_VW

    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description