INSTITUTIONACAD_PLANSSR_HE_ACCIDSSR_HE_PLACC_VW(SQL View) |
Index Back |
|---|---|
HESA Plan AccreditationHESA Plan Accreditation |
| SELECT DISTINCT INSTITUTION, ACAD_PLAN, SSR_HE_ACCID FROM PS_SSR_HE_PLAN_ACC A WHERE %EffdtCheck(SSR_HE_PLAN A1, A, %CurrentDateIn) AND ( SSR_HE_VALID_TO IS NULL OR SSR_HE_VALID_TO > %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | ACAD_PLAN |
Character(10) | VARCHAR2(10) NOT NULL | Academic Plan |
| 3 | SSR_HE_ACCID |
Character(5) | VARCHAR2(5) NOT NULL | Accreditation ID |