SSR_REQS_RQL_VW

(SQL View)
 Index Back

Requisite Check Results View

Thisview contains the results from processing requisite checking.

SELECT EMPLID , ACAD_CAREER , INSTITUTION , STRM , CLASS_NBR , SSR_REQS_TYPE , SSR_REQS_SEQ_NO , SSR_ENTRY_SEQ , ENTRY_R_TYPE , RQ_DATE , RQRMNT_GROUP , RQ_GRP_LINE_NBR , REQUIREMENT , RQ_LINE_NBR , RQ_GRP_LINE_TYPE , REQ_LINE_TYPE , ITEM_R_STATUS FROM PS_SSR_REQS_RSLTS WHERE ENTRY_R_TYPE = 'KEYRQL'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

2 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

3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

4 STRM Character(4) VARCHAR2(4) NOT NULL Term

Prompt Table: TERM_VAL_TBL

5 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr

Prompt Table: CLASS_TBL_VW

6 SSR_REQS_TYPE Character(1) VARCHAR2(1) NOT NULL Requisite Record Type
E=Enrollment
P=Post Enrollment
7 SSR_REQS_SEQ_NO Number(6,0) INTEGER NOT NULL Sequence Number
8 SSR_ENTRY_SEQ Number(4,0) SMALLINT NOT NULL This field is used in requisite checking to track the position of the results in the processing.
9 ENTRY_R_TYPE Character(6) VARCHAR2(6) NOT NULL Entry Type
10 RQ_DATE Date(10) DATE Requirement Date
11 RQRMNT_GROUP Character(6) VARCHAR2(6) NOT NULL Requirement Group

Prompt Table: RQ_GRP_TBL

12 RQ_GRP_LINE_NBR Character(4) VARCHAR2(4) NOT NULL Group Line Nbr
13 REQUIREMENT Character(9) VARCHAR2(9) NOT NULL Academic Requirement

Prompt Table: RQ_MAIN_TBL

14 RQ_LINE_NBR Character(4) VARCHAR2(4) NOT NULL Line Nbr
15 RQ_GRP_LINE_TYPE Character(4) VARCHAR2(4) NOT NULL Group Line Type
COND=Condition
CRSE=Course
CRSW=Wild Card Course
RQ=Requirement
16 REQ_LINE_TYPE Character(3) VARCHAR2(3) NOT NULL Line Type
CND=Condition Requirement
GLM=Global Limit
GSQ=Global Sequential Restriction
LIM=Unit, Course or GPA Limit
MT=Course Requirement
SC=Specified Courses
SEQ=Sequential Restriction
17 ITEM_R_STATUS Character(4) VARCHAR2(4) NOT NULL Item Status
COMP=Complete
EXMP=Exempted
FAIL=Fail