RD_ACAD_SRCH_VW (SQL View)	Index Back
Academics search view Search view for Academics Configurable Search page

RD_ACAD_SRCH_VW

(SQL View)

Academics search view

Search view for Academics Configurable Search page

SELECT CO.BO_ID , CA.INSTITUTION , CA.ACAD_CAREER , BN.FIRST_NAME , BN.LAST_NAME , CA.ADMIT_TYPE , CA.ADMIT_TERM , CA.RECRUITING_STATUS , CO.CAMPUS_ID , P.SYNCID , ' ' FROM PS_BO_NAME BN , PS_RD_CAREER CA , PS_RD_CONSTITUENT CO , PS_RD_PERSON P WHERE CA.BO_ID = CO.BO_ID AND BN.BO_ID = CO.BO_ID AND CO.BO_ID = P.BO_ID AND BN.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Institution field to store institution information in campus solution system.

3 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic career field coming from campus solution system.
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

4 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

5 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

6 ADMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Admit type stores information about the type of admission.
Prompt Table: ADMIT_TYPE_TBL

7 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL stores information about term attending.
Prompt Table: TERM_TBL

8 RECRUITING_STATUS Character(4) VARCHAR2(4) NOT NULL Recruiting Status
APPL=Applicant
INAC=Inactive
INQR=Inquiry
PROS=Prospect
SUSP=Suspect

9 CAMPUS_ID Character(16) VARCHAR2(16) NOT NULL Campus ID in the Student Administration database.

10 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
2	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Institution field to store institution information in campus solution system.
3	ACAD_CAREER	Character(4)	VARCHAR2(4) NOT NULL	Academic career field coming from campus solution system. 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
4	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
5	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
6	ADMIT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Admit type stores information about the type of admission. Prompt Table: ADMIT_TYPE_TBL
7	ADMIT_TERM	Character(4)	VARCHAR2(4) NOT NULL	stores information about term attending. Prompt Table: TERM_TBL
8	RECRUITING_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Recruiting Status APPL=Applicant INAC=Inactive INQR=Inquiry PROS=Prospect SUSP=Suspect
9	CAMPUS_ID	Character(16)	VARCHAR2(16) NOT NULL	Campus ID in the Student Administration database.
10	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
11	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).