INSTITUTIONACAD_PROGSSR_HE_ACCIDSSR_HE_PRACC_VW(SQL View) |
Index Back |
|---|---|
HESA Program AccreditationHESA Program Accreditation |
| SELECT DISTINCT INSTITUTION , ACAD_PROG , SSR_HE_ACCID FROM PS_SSR_HE_PROG_ACC A WHERE %EffdtCheck(SSR_HE_PROG 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_PROG |
Character(5) | VARCHAR2(5) NOT NULL | Academic Program |
| 3 | SSR_HE_ACCID |
Character(5) | VARCHAR2(5) NOT NULL | Accreditation ID |