INSTITUTIONLOCATIONEFFDT_FROMSSR_PROVIDER_TYPEHEP=Higher Education Provider
NA=Not Applicable
TAC=Tertiary Admission Centre
VET=Vocational Education&Training
SSR_HM_CMP_VW(SQL View) |
Index Back |
|---|---|
HEIMS Campus ViewCampuses eligible to be posted to HEIMS. |
| SELECT LOC.SETID , LOC.LOCATION , LOC.EFFDT , HMLOC.SSR_PROVIDER_TYPE , LOC.ADDRESS1 , LOC.CITY , LOC.STATE , LOC.COUNTRY , DEST.SSR_COUNTRY_DEST , LOC.POSTAL FROM PS_LOCATION_TBL LOC , PS_SSR_HM_CAMP_LOC HMLOC , PS_SSR_COUNTRY_AUS DEST WHERE LOC.SETID = HMLOC.INSTITUTION AND LOC.LOCATION = HMLOC.LOCATION AND %EffdtCheck(LOCATION_TBL LOC2, LOC, %CurrentDateIn) AND LOC.EFF_STATUS = 'A' AND HMLOC.EFF_STATUS = 'A' AND DEST.COUNTRY = LOC.COUNTRY AND %EffdtCheck(SSR_COUNTRY_AUS A, DEST, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | LOCATION |
Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 3 | EFFDT_FROM |
Date(10) | DATE | Effective Date From |
| 4 | SSR_PROVIDER_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Provider Type
HEP=Higher Education Provider NA=Not Applicable TAC=Tertiary Admission Centre VET=Vocational Education&Training |
| 5 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 6 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 7 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 8 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 9 | SSR_COUNTRY_DEST | Character(4) | VARCHAR2(4) NOT NULL | DEST Country Code |
| 10 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |