RD_PLAN_VW (SQL View)	Index Back
Plan and Subplan view Denormalized view of Plans and Subplans for a given Constituent

RD_PLAN_VW

(SQL View)

Plan and Subplan view

Denormalized view of Plans and Subplans for a given Constituent

SELECT P.BO_ID , P.INSTITUTION , P.ACAD_CAREER , P.ACAD_PROG , P.ACAD_PLAN , SP.ACAD_SUB_PLAN , P.ADM_APPL_NBR , P.APPLICATION_STATUS , P.STUDENT_STATUS , P.STATUS_DT FROM PS_RD_PLAN P LEFT OUTER JOIN PS_RD_SUBPLAN SP ON P.BO_ID = SP.BO_ID AND P.ACAD_CAREER = SP.ACAD_CAREER AND P.ACAD_PROG = SP.ACAD_PROG AND P.ACAD_PLAN = SP.ACAD_PLAN

# 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.
Prompt Table: INSTITUTION_TBL

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
Prompt Table: RD_CAREER

4 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic program field coming from campus solution system.
Prompt Table: RD_PROGRAM

5 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan field coming from campus solution system
Prompt Table: RD_USR_PLN_VW

6 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic sub plan, a field together with program, plan, and sub plan to store student program information.
Prompt Table: ACAD_SUBPLN_TBL

7 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application number for recruiting and admissions.

8 APPLICATION_STATUS Character(4) VARCHAR2(4) NOT NULL program action field to store program action value.
ACTV=Activate
ADMT=Admit
ADRV=Admission Revocation
APPL=Application
COMP=Completion of Program
COND=Conditional Admit
DATA=Data Change
DDEF=Defer Decision
DEFR=Defer Enrollment
DEIN=Intention to Matriculate
DENY=Deny
DISC=Discontinuation
DISM=Dismissal
LEAV=Leave of Absence
MATR=Matriculation
PLNC=Plan Change
PRGC=Program Change
RADM=Readmit
RAPP=Readmit Application
RECN=Reconsideration
REVK=Revoke Degree
RLOA=Return from Leave of Absense
SPND=Suspension
TRAN=Transfer to Other Career
VDIS=Voluntarily Discontinued
WADM=Administrative Withdrawal
WAIT=Waitlist
WAOF=Waitlist Offer
WAPP=Applicant Withdrawal

9 STUDENT_STATUS Character(4) VARCHAR2(4) NOT NULL Program status field to store academic program status value.
AC=Active in Program
AD=Admitted
AP=Applicant
CM=Completed Program
CN=Cancelled
DC=Discontinued
DE=Deceased
DM=Dismissed
LA=Leave of Absence
PM=Prematriculant
SP=Suspended
WT=Waitlisted

10 STATUS_DT Date(10) DATE This field is used as edit box to show the Status Date

#	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. Prompt Table: INSTITUTION_TBL
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 Prompt Table: RD_CAREER
4	ACAD_PROG	Character(5)	VARCHAR2(5) NOT NULL	Academic program field coming from campus solution system. Prompt Table: RD_PROGRAM
5	ACAD_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Academic Plan field coming from campus solution system Prompt Table: RD_USR_PLN_VW
6	ACAD_SUB_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Academic sub plan, a field together with program, plan, and sub plan to store student program information. Prompt Table: ACAD_SUBPLN_TBL
7	ADM_APPL_NBR	Character(8)	VARCHAR2(8) NOT NULL	Application number for recruiting and admissions.
8	APPLICATION_STATUS	Character(4)	VARCHAR2(4) NOT NULL	program action field to store program action value. ACTV=Activate ADMT=Admit ADRV=Admission Revocation APPL=Application COMP=Completion of Program COND=Conditional Admit DATA=Data Change DDEF=Defer Decision DEFR=Defer Enrollment DEIN=Intention to Matriculate DENY=Deny DISC=Discontinuation DISM=Dismissal LEAV=Leave of Absence MATR=Matriculation PLNC=Plan Change PRGC=Program Change RADM=Readmit RAPP=Readmit Application RECN=Reconsideration REVK=Revoke Degree RLOA=Return from Leave of Absense SPND=Suspension TRAN=Transfer to Other Career VDIS=Voluntarily Discontinued WADM=Administrative Withdrawal WAIT=Waitlist WAOF=Waitlist Offer WAPP=Applicant Withdrawal
9	STUDENT_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Program status field to store academic program status value. AC=Active in Program AD=Admitted AP=Applicant CM=Completed Program CN=Cancelled DC=Discontinued DE=Deceased DM=Dismissed LA=Leave of Absence PM=Prematriculant SP=Suspended WT=Waitlisted
10	STATUS_DT	Date(10)	DATE	This field is used as edit box to show the Status Date