SSR_REQS_DTL_VW

(SQL View)
 Index Back

PERC View of RSLTS table


SELECT A.INSTITUTION , A.STRM , A.CLASS_NBR , A.EMPLID , A.ACAD_CAREER , A.SSR_REQS_TYPE , A.SSR_ENTRY_SEQ , A.ENTRY_R_TYPE , A.RQ_DATE , A.RQRMNT_GROUP , A.RQ_GRP_LINE_NBR , A.REQUIREMENT , A.RQ_LINE_NBR , A.RQ_GRP_LINE_TYPE , A.REQ_LINE_TYPE , A.ITEM_R_STATUS , ' ' , ' ' , 0 , ' ' , ' ' , ' ' , %TextIn(' ') FROM PS_SSR_REQS_RSLTS A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

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

Default Value: OPR_DEF_TBL_CS.STRM

Prompt Table: TERM_VAL_TBL

3 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 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
6 SSR_REQS_TYPE Character(1) VARCHAR2(1) NOT NULL Requisite Record Type
E=Enrollment
P=Post Enrollment
7 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.
8 ENTRY_R_TYPE Character(6) VARCHAR2(6) NOT NULL Entry Type
9 RQ_DATE Date(10) DATE Requirement Date
10 RQRMNT_GROUP Character(6) VARCHAR2(6) NOT NULL Requirement Group

Prompt Table: RQ_GRP_TBL

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

Prompt Table: RQ_MAIN_TBL

13 RQ_LINE_NBR Character(4) VARCHAR2(4) NOT NULL Line Nbr
14 RQ_GRP_LINE_TYPE Character(4) VARCHAR2(4) NOT NULL Group Line Type
COND=Condition
CRSE=Course
CRSW=Wild Card Course
RQ=Requirement
15 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
16 ITEM_R_STATUS Character(4) VARCHAR2(4) NOT NULL Item Status
COMP=Complete
EXMP=Exempted
FAIL=Fail
17 SESSION_CODE Character(3) VARCHAR2(3) NOT NULL Session
1=Regular Academic Session
10W=10 Week
12W=Twelve Week
4W1=Four Week - First
4W2=Four Week - Second
4W3=Four Week - Third
4W4=Four Week - Fourth
6W1=Six Week - First
6W2=Six Week - Second
8W1=Eight Week - First
8W2=Eight Week - Second
A11=Medical Period 1, 4 Weeks
A12=Medical Period 1, 8 Weeks
A13=Medical Pd 1, 12 Weeks
A21=Medical Period 2, 4 Weeks
A22=Medical Period 2, 8 Weeks
A23=Medical Period 2, 12 Week
FYR=Full Year
MIN=Mini Session
OEE=Open Entry/Open Exit
SM1=Semester 1
SM2=Semester 2
18 SSR_DESCR_STATUS Character(30) VARCHAR2(30) NOT NULL This field is used to display the requisite enrollment status for the xml file for the post enrollment requisite check report.
19 SSR_CRSE_CNT Number(3,0) SMALLINT NOT NULL This field is used in the post enrollment requisite check process to keep a count of the courses attached to a specific reporting level.
20 DESCR Character(30) VARCHAR2(30) NOT NULL Description
21 SSR_DESCR80 Character(80) VARCHAR2(80) NOT NULL This field is used for holding the 80 character description used in the xml file for post enrollment requisite check reports.
22 DESCR254A Character(254) VARCHAR2(254) NOT NULL Long Description
23 SSR_DESCRLONG_01 Long Character CLOB SR Descrlong 1