SSR_PERIOD_IDPrompt Table: SSR_AC_EXPRDEVW
CRSE_IDCRSE_OFFER_NBRSSR_ACTIVITY_IDINSTITUTIONPrompt Table: SSR_EXAMTYP_TBL
SSR_ACMEXCO_VW(SQL View) |
Index Back |
|---|---|
Activity Exam Extension ViewExtension Record for the Exam content item (Activity Manager). |
| SELECT A.SSR_PERIOD_ID ,X.CRSE_ID ,X.CRSE_OFFER_NBR ,A.SSR_ACTIVITY_ID ,A.INSTITUTION ,A.SSR_CW_EXAM_TYPE ,A.SSR_CW_EXAM_DUR_H ,A.SSR_CW_EXAM_DUR_M ,A1.SSR_AC_CONTENT_ID ,A1.SSR_AC_ITEM_ID ,P.SSR_ACTIVTY_ID_PAR ,C.DESCR50 FROM PS_SSR_ACMEXAM_EXT A , PS_SSR_ACTIVITY A1 , PS_SSR_ACMCONT_ITM C , PS_SSR_ACT_XREF X , PS_SSR_ACTIVITY P WHERE A1.SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID AND C.SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID AND X.SSR_ACTIVITY_ID = A.SSR_ACTIVITY_ID AND P.INSTITUTION = A1.INSTITUTION AND P.SSR_ACTIVTY_ID_LNK = A1.SSR_ACTIVITY_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_PERIOD_ID |
Character(12) | VARCHAR2(12) NOT NULL |
Academic Period ID
Prompt Table: SSR_AC_EXPRDEVW |
| 2 | CRSE_ID |
Character(6) | VARCHAR2(6) NOT NULL | Course ID |
| 3 | CRSE_OFFER_NBR |
Number(2,0) | SMALLINT NOT NULL | Course Offering Nbr |
| 4 | SSR_ACTIVITY_ID |
Character(11) | VARCHAR2(11) NOT NULL | Academic Activity ID |
| 5 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 6 | SSR_CW_EXAM_TYPE | Character(12) | VARCHAR2(12) NOT NULL |
Exam Type
Prompt Table: SSR_EXAMTYP_TBL |
| 7 | SSR_CW_EXAM_DUR_H | Number(3,0) | SMALLINT NOT NULL | Exam Duration (hours : mins) |
| 8 | SSR_CW_EXAM_DUR_M | Number(2,0) | SMALLINT NOT NULL | Exam Duration (mins) |
| 9 | SSR_AC_CONTENT_ID | Character(13) | VARCHAR2(13) NOT NULL | Activity Registry ID |
| 10 | SSR_AC_ITEM_ID | Character(10) | VARCHAR2(10) NOT NULL | Content Item ID |
| 11 | SSR_ACTIVTY_ID_PAR | Character(11) | VARCHAR2(11) NOT NULL | Parent Activity ID |
| 12 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |