INSTITUTIONACAD_PLANACAD_SUB_PLANSSR_HE_ACCIDSSR_HE_SPLAC_VW(SQL View) |
Index Back |
|---|---|
HESA SubPlan AccreditationHESA SubPlan Accreditation |
| SELECT DISTINCT INSTITUTION , ACAD_PLAN , ACAD_SUB_PLAN , SSR_HE_ACCID FROM PS_SSR_HE_SPLN_ACC A WHERE %EffdtCheck(SSR_HE_SUBPLAN 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 | ACAD_SUB_PLAN |
Character(10) | VARCHAR2(10) NOT NULL | Academic Sub-Plan |
| 4 | SSR_HE_ACCID |
Character(5) | VARCHAR2(5) NOT NULL | Accreditation ID |