PC_LATETIME_VW3

(SQL View)
 Index Back

Project Late Timesheets

Consolidated In Progress and Missing Timesheets overdue based on My Project Team Members.

SELECT A.OPRID , A.BUSINESS_UNIT , A.PROJECT_ID , A.TEAM_MEMBER , A.PROJECT_MANAGER , A.PROJ_MGR_NAME , A.EMAILID2 , A.DESCR , A.PERSON_NAME , A.EMAILID , A.PROJ_ROLE , A.START_DT , A.END_DT , CASE WHEN A.TIME_SHEET_ID <> ' ' THEN COUNT(*) ELSE 0 END , CASE WHEN A.TIME_SHEET_ID = ' ' THEN COUNT(*) ELSE 0 END , COUNT(*) FROM PS_PC_LATETIME_VW2 A GROUP BY A.OPRID , A.BUSINESS_UNIT , A.PROJECT_ID , A.TEAM_MEMBER , A.PROJECT_MANAGER , A.PROJ_MGR_NAME , A.EMAILID2 , A.DESCR , A.PERSON_NAME , A.EMAILID , A.PROJ_ROLE , A.START_DT , A.END_DT , A.TIME_SHEET_ID

  • Related Language Record: PC_LATETIME_LW3

    • # 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

    Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT

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

    Default Value: OPR_DEF_TBL_PC.PROJECT_ID

    4 TEAM_MEMBER Character(30) VARCHAR2(30) NOT NULL Team Member
    5 PROJECT_MANAGER Character(11) VARCHAR2(11) NOT NULL Project Manager
    6 PROJ_MGR_NAME Character(50) VARCHAR2(50) NOT NULL Project Manager Name
    7 EMAILID2 Character(70) VARCHAR2(70) NOT NULL Email ID
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 PERSON_NAME Character(100) VARCHAR2(100) NOT NULL Name
    10 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    11 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
    12 START_DT Date(10) DATE Start Date
    13 END_DT Date(10) DATE End Date
    14 TIMESHEET_COUNT1 Number(10,0) DECIMAL(10) NOT NULL Timesheet count
    15 TIMESHEET_COUNT2 Number(10,0) DECIMAL(10) NOT NULL Timesheet count
    16 TIMESHEET_COUNT3 Number(10,0) DECIMAL(10) NOT NULL Timesheet count