SSR_HEIMS_LOCVW

(SQL View)
 Index Back

Location View

Used in HEIMS Course on Campus.

SELECT SETID AS INSTITUTION , LOCATION , DESCR FROM PS_LOCATION_TBL A WHERE %EffdtCheck(LOCATION_TBL B,A, %CurrentDatein) AND EFF_STATUS='A' AND EXISTS( SELECT LOCATION FROM PS_SSR_HM_CAMP_LOC WHERE INSTITUTION=A.SETID AND LOCATION = A.LOCATION)

  • Related Language Record: SSR_HEIMS_LCLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    2 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: LOCATION_TBL

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description