SAE_DEPT_VW

(SQL View)
 Index Back

SELECT ACAD.ACAD_ORG , ACAD.EFFDT , ACAD.INSTITUTION , ACAD.DESCR , 'D' SAE_UNITIND , INST.DESCR , ACAD.EFF_STATUS , ACAD.DESCRSHORT , DEPTSCOPE.SAE_MODE , DEPTSCOPE.SAE_EVENT_DT FROM %Table(INSTITUTION_TBL) INST , %Table(ACAD_ORG_TBL) ACAD , %Table(SAE_INST_SCO_VW) INSTSCOPE , %Table(SAE_ACADORG_EXT) DEPTSCOPE WHERE INST.INSTITUTION = ACAD.INSTITUTION AND INST.EFF_STATUS = 'A' AND %EffdtCheck(INSTITUTION_TBL INST1, INST, %CurrentDateIn) AND ACAD.EFF_STATUS = 'A' AND %EffdtCheck(ACAD_ORG_TBL ACAD1, ACAD, %CurrentDateIn) AND INSTSCOPE.INSTITUTION = ACAD.INSTITUTION AND DEPTSCOPE.INSTITUTION = ACAD.INSTITUTION AND DEPTSCOPE.ACAD_ORG = ACAD.ACAD_ORG AND DEPTSCOPE.SAE_MODE <> 'D' UNION ALL SELECT DEPTSCOPE.ACAD_ORG , %DateNull , DEPTSCOPE.INSTITUTION , '' , 'D' SAE_UNITIND , '' , '' , '' , DEPTSCOPE.SAE_MODE , DEPTSCOPE.SAE_EVENT_DT FROM %Table(INSTITUTION_TBL) INST , %Table(SAE_INST_SCO_VW) INSTSCOPE ,%Table(SAE_ACADORG_EXT) DEPTSCOPE WHERE INST.INSTITUTION = DEPTSCOPE.INSTITUTION AND INST.EFF_STATUS = 'A' AND %EffdtCheck(INSTITUTION_TBL INST1, INST, %CurrentDateIn) AND INSTSCOPE.INSTITUTION = DEPTSCOPE.INSTITUTION AND DEPTSCOPE.SAE_MODE = 'D'

  • Related Language Record: SAE_DEPT_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 SAE_UNITIND Character(1) VARCHAR2(1) NOT NULL Unit Indicator
    6 SAE_INST_DESC Character(30) VARCHAR2(30) NOT NULL Institution Description
    7 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    8 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: ACAD_ORG_TBL.DESCR

    9 SAE_MODE Character(1) VARCHAR2(1) NOT NULL Operation Mode
    A=Add
    C=Change
    D=Delete
    10 SAE_EVENT_DT DateTime(26) TIMESTAMP Event Driven Timestamp