PC_ANTYP_VER

(SQL View)
 Index Back

Analysis Type Versioning View

Returns the analysis types that are not part of one of the configured PC budgeting analysis groups. Used as a prompt in the versioning configuration page.

SELECT B.BUSINESS_UNIT , A.ANALYSIS_TYPE , A.DESCR FROM PS_PROJ_ANTYPE_TBL A , PS_BUS_UNIT_OPT_PC B WHERE NOT EXISTS ( SELECT 'X' FROM PS_PROJ_AN_GRP_MAP C , PS_INSTALLATION_PC E WHERE C.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = B.BUSINESS_UNIT AND RECNAME = 'PROJ_AN_GRP_MAP') AND C.ANALYSIS_TYPE = A.ANALYSIS_TYPE AND C.ANALYSIS_GROUP IN (E.AN_GRP_ACTV_BUD,E.PC_REV_BUD_AN_GRP,E.AN_GRP_TOT_COSTS,E.AN_GRP_TOT_REV) ) AND A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_PROJ_ANTYPE_TBL A_ED WHERE A.SETID = A_ED.SETID AND A.ANALYSIS_TYPE = A_ED.ANALYSIS_TYPE AND A_ED.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

  • Related Language Record: PC_ANTP_VER_LVW

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

    Default Value: PROJECT.BUSINESS_UNIT

    2 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description