SSR_REQS_TYP_VW (SQL View)	Index Back
Student Requisite Check Types This view is used for writing XML data for students for the Post Enrollment Requistie Checking report.

SSR_REQS_TYP_VW

(SQL View)

Student Requisite Check Types

This view is used for writing XML data for students for the Post Enrollment Requistie Checking report.

SELECT A.INSTITUTION , A.STRM , A.CLASS_NBR , A.ACAD_CAREER , A.EMPLID , A.SSR_REQS_TYPE , A.SSR_REQS_STATUS , ' ' , ' ' , A.OPRID , ' ' , A.DTTM_STAMP_SEC , ' ' FROM PS_SSR_REQS_HEADR 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 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

5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSONAL_DATA

6 SSR_REQS_TYPE Character(1) VARCHAR2(1) NOT NULL Requisite Record Type
E=Enrollment
P=Post Enrollment

7 SSR_REQS_STATUS Character(1) VARCHAR2(1) NOT NULL Post Enroll Reqs Status
C=Conditional
E=Enrollment Component
N=Not Satisfied
O=Overriden
P=Permitted
S=Satisfied
X=Unknown

8 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.

9 SSR_DESCR_TYPE 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.

10 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

11 DISPLAY_NAME Character(50) VARCHAR2(50) NOT NULL Used to display the person's name in the PERS_SRCH_SBP, EMPL_SRCH_SBP and the components that allow a person to be created

12 DTTM_STAMP_SEC DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

13 STRING_DTTM Character(100) VARCHAR2(100) NOT NULL This Field is used in TL_RI_RESOLV Process

#	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	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
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSONAL_DATA
6	SSR_REQS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Requisite Record Type E=Enrollment P=Post Enrollment
7	SSR_REQS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Post Enroll Reqs Status C=Conditional E=Enrollment Component N=Not Satisfied O=Overriden P=Permitted S=Satisfied X=Unknown
8	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.
9	SSR_DESCR_TYPE	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.
10	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
11	DISPLAY_NAME	Character(50)	VARCHAR2(50) NOT NULL	Used to display the person's name in the PERS_SRCH_SBP, EMPL_SRCH_SBP and the components that allow a person to be created
12	DTTM_STAMP_SEC	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
13	STRING_DTTM	Character(100)	VARCHAR2(100) NOT NULL	This Field is used in TL_RI_RESOLV Process