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

SSR_REQS_TRK_VW

(SQL View)

Student Requisite Tracking

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_DROP , A.SSR_REQS_DRP_OPRID , A.SSR_REQS_DROP_DTTM , A.OPRID , A.DTTM_STAMP_SEC , ' ' , ' ' , A.DESCRLONG FROM PS_SSR_REQCK_ACTN 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_DROP Character(1) VARCHAR2(1) NOT NULL Issue Drop

7 SSR_REQS_DRP_OPRID Character(30) VARCHAR2(30) NOT NULL User ID

8 SSR_REQS_DROP_DTTM DateTime(26) TIMESTAMP Drop Request Datetime

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

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

11 SSR_OPRID_NAME Character(50) VARCHAR2(50) NOT NULL This field is used to display the oprid name for the xml file for the post enrollment requisite check report.

12 SSR_OPRID2_NAME Character(50) VARCHAR2(50) NOT NULL This field is used to display the oprid name for the xml file for the post enrollment requisite check report.

13 DESCRLONG Long Character CLOB Long Description

#	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_DROP	Character(1)	VARCHAR2(1) NOT NULL	Issue Drop
7	SSR_REQS_DRP_OPRID	Character(30)	VARCHAR2(30) NOT NULL	User ID
8	SSR_REQS_DROP_DTTM	DateTime(26)	TIMESTAMP	Drop Request Datetime
9	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
10	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.
11	SSR_OPRID_NAME	Character(50)	VARCHAR2(50) NOT NULL	This field is used to display the oprid name for the xml file for the post enrollment requisite check report.
12	SSR_OPRID2_NAME	Character(50)	VARCHAR2(50) NOT NULL	This field is used to display the oprid name for the xml file for the post enrollment requisite check report.
13	DESCRLONG	Long Character	CLOB	Long Description