EXT_ORG_SCHL_VW

(SQL View)
 Index Back

External Organization Schl VW

This view shows all the external organizations with school types specified in the 'SCHOOL_TYPE_TBL' record.

SELECT A.EXT_ORG_ID , A.EFFDT , A.EFF_STATUS , B.EXT_ORG_TYPE , A.LS_SCHOOL_TYPE , B.DESCR , B.CITY , B.STATE , B.COUNTRY FROM PS_EXT_ORG_TBL_ADM A , PS_EXT_ORG_PRI_VW B , PS_LS_SCHL_TYP_TBL C WHERE A.EXT_ORG_ID = B.EXT_ORG_ID AND %EffdtCheck(EXT_ORG_TBL B1, B, %CurrentDateIn) AND B.EFF_STATUS = 'A' AND A.LS_SCHOOL_TYPE = C.LS_SCHOOL_TYPE AND C.STDNT_RESP_SCHOOL = 'Y' AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_LS_SCHL_TYP_TBL C1 WHERE C1.LS_SCHOOL_TYPE = C.LS_SCHOOL_TYPE)

  • Related Language Record: EXTORGSCHLVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Default Value: 0

    Prompt Table: EXT_ORG_TBL

    2 EFFDT Date(10) DATE Effective Date
    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    4 EXT_ORG_TYPE Character(4) VARCHAR2(4) NOT NULL Organization Type

    Prompt Table: SCC_ORG_TYP_TBL

    5 LS_SCHOOL_TYPE Character(3) VARCHAR2(3) NOT NULL School Type

    Prompt Table: LS_SCHL_TYP_TBL

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 CITY Character(30) VARCHAR2(30) NOT NULL City
    8 STATE Character(6) VARCHAR2(6) NOT NULL State
    9 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country