SSR_EXM_DET_VW(SQL View) |
Index Back |
|---|---|
My Exams Details View |
| SELECT DISTINCT IAM.EMPLID , MT.INSTITUTION , IAM.SSR_ACT_ID_ROOT , MT.SSR_ACTIVITY_ID , ITEM.SSR_ITEM_ID , HDR.DESCR50 , PERIOD.SSR_PERIOD_ID , XREF.CRSE_ID , XREF.STRM , IAM.SSR_IAM_ACT_STATUS , TBL.DESCR , PERIOD.DESCR , MT.FACILITY_ID , MT.START_DT , MT.MEETING_TIME_START , MT.MEETING_TIME_END , CONT.DESCR50 FROM PS_SSR_PERIOD_TBL PERIOD , PS_SSR_ACMEXAM_EXT EXT , PS_SSR_IAM IAM , PS_SSR_ACM_SCTN_MT MT , PS_SSR_ACTIVITY ACT , PS_SSR_ACT_XREF XREF , PS_INSTITUTION_TBL TBL , PS_SSR_AIR_H_CRSE CRSE , PS_SSR_APT_ITEM ITEM , PS_SSR_AIR_HDR HDR , PS_SSR_ACMCONT_ITM CONT WHERE PERIOD.INSTITUTION = EXT.INSTITUTION AND PERIOD.SSR_PERIOD_ID = EXT.SSR_PERIOD_ID AND PERIOD.SSR_PERIOD_TYPE = 'EXAM' AND IAM.INSTITUTION = EXT.INSTITUTION AND EXT.SSR_ACTIVITY_ID = IAM.SSR_ACTIVTY_ID_PAR AND MT.INSTITUTION = EXT.INSTITUTION AND MT.SSR_ACTIVITY_ID = IAM.SSR_ACTIVITY_ID AND ACT.SSR_ACTIVITY_ID = EXT.SSR_ACTIVITY_ID AND ACT.INSTITUTION = EXT.INSTITUTION AND XREF.SSR_ACTIVITY_ID = ACT.SSR_ACTIVITY_ID AND CRSE.INSTITUTION = IAM.INSTITUTION AND CRSE.CRSE_ID = XREF.CRSE_ID AND %EffdtCheck(SSR_AIR_H_CRSE CRSE_ED, CRSE, %CurrentDateIn) AND ITEM.EMPLID = IAM.EMPLID AND ITEM.INSTITUTION = IAM.INSTITUTION AND ITEM.SSR_ITEM_ID = CRSE.SSR_ITEM_ID AND HDR.INSTITUTION = ITEM.INSTITUTION AND HDR.SSR_ITEM_ID = ITEM.SSR_ITEM_ID AND %EffdtCheck(SSR_AIR_HDR HDR_ED, CRSE, %CurrentDateIn) AND TBL.INSTITUTION = PERIOD.INSTITUTION AND %EffdtCheck(INSTITUTION_TBL TBL_ED, TBL, %CurrentDateIn) AND CONT.INSTITUTION = ACT.INSTITUTION AND CONT.SSR_ACTIVITY_ID = MT.SSR_ACTIVITY_ID AND IAM.SSR_IAM_ACT_STATUS IN ('A', 'ED','EE','S', 'EC') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 3 | SSR_ACT_ID_ROOT |
Character(11) | VARCHAR2(11) NOT NULL | Course Root Activity ID |
| 4 | SSR_ACTIVITY_ID |
Character(11) | VARCHAR2(11) NOT NULL | Academic Activity ID |
| 5 | SSR_ITEM_ID | Character(11) | VARCHAR2(11) NOT NULL | Academic Item ID |
| 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 |
| 8 | CRSE_ID | Character(6) | VARCHAR2(6) NOT NULL | Course ID |
| 9 | STRM | Character(4) | VARCHAR2(4) NOT NULL | Term |
| 10 | SSR_IAM_ACT_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Activity Status
A=Assigned AC=Assigned - confirmed AX=Assigned - requires confirmtn D=Dropped E=Enrolled EC=Enrolled - Confirmed ED=Enrolled by Default EE=Enrolled EX=Enrolled - Confirmation Req'd RA=Resit Allowed RC=Resit Candidate RD=Resit Delete RN=Resit Not Allowed RR=Reassessed RS=Resit Select S=Selected SC=Selected - confirmed SD=Selected by Default SR=Selected as Resit SX=Selected - requires confirmatn WD=Withdrawn WL=Waitlisted X=Inactive |
| 11 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 12 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 13 | FACILITY_ID | Character(10) | VARCHAR2(10) NOT NULL | Facility ID |
| 14 | START_DT | Date(10) | DATE | Start Date |
| 15 | MEETING_TIME_START | Time(15) | TIMESTAMP | Meeting Start Time |
| 16 | MEETING_TIME_END | Time(15) | TIMESTAMP | Meeting End Time |
| 17 | SSR_AM_DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | This field is used to display the requisite enrollment type for the xml file for the post enrollment requisite check report. |