SSR_ADC_RSLTVVW(SQL View) |
Index Back |
---|---|
Activity Action Date Ctrl VldActivity Action Date Control Valid Structures |
SELECT SSR_AC_CONTX_TYPE , SSR_ADC_RSLTREL_TP , SSR_ADC_RSLT_ID , EFFDT , SSR_SEQ_NBR , INSTITUTION , SSR_EXAM_ONLY_FL , ACAD_ORG , ACAD_CAREER , ACAD_PROG , INSTR_TYPE , SSR_CW_EX_STF_TYPE , SSR_CW_EXAM_TYPE , SSR_RSLT_TYPE , SSR_RSLT_SUB_TYPE , SSR_IAM_RSLT_STAT , SSR_ADC_INC_RSLTST FROM PS_SSR_ADC_RSLT_VL |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SSR_AC_CONTX_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Academic Content Context Type
CRSE=Coursework |
2 | SSR_ADC_RSLTREL_TP | Character(2) | VARCHAR2(2) NOT NULL |
Release Type
FS=Faculty Self Service Update SS=Student Self Service View |
3 | SSR_ADC_RSLT_ID | Character(20) | VARCHAR2(20) NOT NULL | Result Date ID |
4 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
5 | SSR_SEQ_NBR | Number(4,0) | SMALLINT NOT NULL | Sequence Number |
6 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
7 | SSR_EXAM_ONLY_FL | Character(1) | VARCHAR2(1) NOT NULL |
Exam Only Option
E=Exclude in selection I=Included O=Exam Only Course Y/N Table Edit Default Value: N |
8 | ACAD_ORG | Character(10) | VARCHAR2(10) NOT NULL |
Academic Organization
Prompt Table: ACAD_ORG_TBL |
9 | ACAD_CAREER | Character(4) | VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine Prompt Table: ACAD_CAR_TBL |
10 | ACAD_PROG | Character(5) | VARCHAR2(5) NOT NULL |
Academic Program
Prompt Table: ACAD_PROG_TBL |
11 | INSTR_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Instructor Type
ADJ=Adjunct Professor ADV=Advisor Only ASSC=Associate Professor ASST=Assistant Professor EMRT=Emeritus INST=Instructor LECT=Lecturer PROF=Professor TA=Teaching Assistant UNDF=Undefined VLEC=Visiting Lecturer VPRF=Visiting Professor |
12 | SSR_CW_EX_STF_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Staff Type
CEX=Chief Examiner EXA=Examiner INV=Invigilator PRO=Proctor |
13 | SSR_CW_EXAM_TYPE | Character(12) | VARCHAR2(12) NOT NULL |
Exam Type
Prompt Table: SSR_EXAMTYP_TBL |
14 | SSR_RSLT_TYPE | Character(20) | VARCHAR2(20) NOT NULL |
Result Type
Prompt Table: SSR_AM_RSLT_VW |
15 | SSR_RSLT_SUB_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Result Sub-Type
C=Capped F=Mandatory Fail I=Insufficient Mark L=Late Penalty M=Multiple Scales R=Resit Calculation |
16 | SSR_IAM_RSLT_STAT | Character(2) | VARCHAR2(2) NOT NULL |
Result Status
00=00-Undetermined 05=05-Manual 07=07-Imported 10=10-Calculated 20=20-Awaiting Approval 30=30-Approved 40=40-Overridden 50=50-Final |
17 | SSR_ADC_INC_RSLTST | Character(1) | VARCHAR2(1) NOT NULL |
Include Lower Result Status
Y/N Table Edit Default Value: N |