INSTITUTIONSSR_ACTIVITY_IDPrompt Table: SSR_EXAM_PRD_VW
Prompt Table: SSR_EXAMTYP_TBL
SSR_IAM_EXMSCVW(SQL View) |
Index Back |
|---|
| SELECT A.INSTITUTION , A.SSR_ACTIVITY_ID , A.SSR_PERIOD_ID , A.SSR_CW_EXAM_TYPE , B.DESCR50 FROM PS_SSR_ACMEXAM_EXT A , PS_SSR_ACMCONT_ITM B WHERE B.INSTITUTION = A.INSTITUTION AND B.SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | SSR_ACTIVITY_ID |
Character(11) | VARCHAR2(11) NOT NULL | Academic Activity ID |
| 3 | SSR_PERIOD_ID | Character(12) | VARCHAR2(12) NOT NULL |
Academic Period ID
Prompt Table: SSR_EXAM_PRD_VW |
| 4 | SSR_CW_EXAM_TYPE | Character(12) | VARCHAR2(12) NOT NULL |
Exam Type
Prompt Table: SSR_EXAMTYP_TBL |
| 5 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |