SSR_PERIOD_IDSSR_EXAM_PRDVW3(SQL View) |
Index Back |
|---|---|
Campus Period TableThis is a view against the SSR_PERIOD_TBL and holds Period Type of "Exam". |
| SELECT DISTINCT P.SSR_PERIOD_ID ,P.DESCR FROM PS_SSR_PERIOD_TBL P , PS_SSR_PRDATTR_TBL A , PS_SSR_PERIOD_CAF C WHERE P.INSTITUTION = A.INSTITUTION AND P.SSR_PERIOD_ID = A.SSR_PERIOD_ID AND P.INSTITUTION = C.INSTITUTION AND P.SSR_PERIOD_ID = C.SSR_PERIOD_ID AND C.SCC_CAF_ATTRIB_NM = 'SSR_EXAMPRD_TYPE' AND P.SSR_PERIOD_TYPE = 'EXAM' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_PERIOD_ID |
Character(12) | VARCHAR2(12) NOT NULL | Academic Period ID |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |