SSR_ACTIVITY_IDPrompt Table: SSR_EXAM_PRD_VW
SSR_IAM_EXMS1VW(SQL View) |
Index Back |
|---|
| SELECT A.SSR_ACTIVITY_ID , A.INSTITUTION , E.SUBJECT , E.CATALOG_NBR , A.SSR_CW_EXAM_TYPE , B.DESCR50 , A.SSR_PERIOD_ID , C.SSR_PRD_START_DT , C.SSR_PRD_END_DT FROM PS_SSR_ACMEXAM_EXT A , PS_SSR_ACMCONT_ITM B , PS_SSR_PERIOD_TBL C , PS_SSR_ACT_XREF D , PS_CRSE_OFFER E , PS_SSR_EXAM_PRD_VW F WHERE B.INSTITUTION = A.INSTITUTION AND B.SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID AND C.INSTITUTION = A.INSTITUTION AND C.SSR_PERIOD_ID = A.SSR_PERIOD_ID AND D.SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID AND E.CRSE_ID = D.CRSE_ID AND E.CRSE_OFFER_NBR = D.CRSE_OFFER_NBR AND E.EFFDT = ( SELECT MAX(E2.EFFDT) FROM PS_CRSE_OFFER E2 WHERE E2.CRSE_ID = E.CRSE_ID AND E2.CRSE_OFFER_NBR = E.CRSE_OFFER_NBR AND E2.EFFDT <= C.SSR_PRD_START_DT) AND A.INSTITUTION = F.INSTITUTION AND A.SSR_PERIOD_ID = F.SSR_PERIOD_ID AND F.SSR_EXAMPRD_TYPE = 'RES' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_ACTIVITY_ID |
Character(11) | VARCHAR2(11) NOT NULL | Academic Activity ID |
| 2 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 3 | SUBJECT | Character(8) | VARCHAR2(8) NOT NULL | Subject Area |
| 4 | CATALOG_NBR | Character(10) | VARCHAR2(10) NOT NULL | Catalog Nbr |
| 5 | SSR_CW_EXAM_TYPE | Character(12) | VARCHAR2(12) NOT NULL | Exam Type |
| 6 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 7 | SSR_PERIOD_ID | Character(12) | VARCHAR2(12) NOT NULL |
Academic Period ID
Prompt Table: SSR_EXAM_PRD_VW |
| 8 | SSR_PRD_START_DT | Date(10) | DATE | Campus Period Start Date |
| 9 | SSR_PRD_END_DT | Date(10) | DATE | Campus Period End Date |