PC_CUR_ACTST_VW

(SQL View)
 Index Back

Current Proj Activity Status

View that selects the current effective-dated Activity Status.

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , A.EFFDT , A.EFFSEQ , A.ACTIVITY_STATUS , A.ACTIVITY_PRIORITY , A.ACTIVITY_MANAGER , A.DESCRLONG FROM PS_PROJ_ACT_STATUS A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_PROJ_ACT_STATUS B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND A.ACTIVITY_ID = B.ACTIVITY_ID AND B.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(C.EFFSEQ) FROM PS_PROJ_ACT_STATUS C WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.PROJECT_ID = C.PROJECT_ID AND A.ACTIVITY_ID = C.ACTIVITY_ID AND A.EFFDT = C.EFFDT)

  • Parent record: PROJ_ACTIVITY

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: PROJ_ACTIVITY.BUSINESS_UNIT

    Prompt Table: SP_BU_PC_NONVW

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

    Prompt Table: PROJECT

    3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    6 ACTIVITY_STATUS Character(1) VARCHAR2(1) NOT NULL Activity Status

    Prompt Table: %EDITTABLE3

    7 ACTIVITY_PRIORITY Number(3,0) SMALLINT NOT NULL Activity Priority
    8 ACTIVITY_MANAGER Character(11) VARCHAR2(11) NOT NULL Activity Manager

    Prompt Table: PROJ_MGR_VW

    9 DESCRLONG Long Character CLOB Long Description