RA_CNSTTUENT_VW

(SQL View)
 Index Back

Constituent View

Constituent view is used in profile record definition.

SELECT A.BO_ID , A.INSTITUTION , A.ACAD_CAREER , B.ACAD_PROG , C.ACAD_PLAN , A.ADMIT_TERM , A.ADMIT_TYPE , A.CAMPUS , A.RECRUITING_STATUS , A.ACADEMIC_LOAD , A.ACADEMIC_LEVEL , A.HOUSING_INTEREST , A.CS_FIN_AID_INT , A.ADM_REFRL_SRCE , A.CS_REFERRAL_SRC_DT , %NumToChar(A.BO_ID_SPONSOR) , A.LAST_SCH_ATTEND , A.GRADUATION_DT , A.SELF_RPT_GPA , A.CLASS_SIZE , A.CLASS_RANK , B.LIFECYCLE_STATUS , B.LIFECYCLE_STAT_DT , B.CAMPUS , C.ADM_APPL_NBR , C.APPLICATION_STATUS , C.STUDENT_STATUS , C.STATUS_DT FROM PS_RD_CAREER A LEFT OUTER JOIN PS_RD_PROGRAM B ON A.BO_ID= B.BO_ID AND A.INSTITUTION=B.INSTITUTION AND A.ACAD_CAREER= B.ACAD_CAREER LEFT OUTER JOIN PS_RD_PLAN C ON A.BO_ID= C.BO_ID AND A.INSTITUTION=C.INSTITUTION AND A.ACAD_CAREER= C.ACAD_CAREER AND B.ACAD_PROG= C.ACAD_PROG WHERE A.BO_ID>0

# 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 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic program field coming from campus solution system.
5 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan field coming from campus solution system
6 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL stores information about term attending.
7 ADMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Admit type stores information about the type of admission.
8 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
9 RECRUITING_STATUS Character(4) VARCHAR2(4) NOT NULL Recruiting Status
APPL=Applicant
INAC=Inactive
INQR=Inquiry
PROS=Prospect
SUSP=Suspect
10 ACADEMIC_LOAD Character(1) VARCHAR2(1) NOT NULL Academic load
B=Vocational Coaching (NLD)
D=Dual (NLD)
E=Part-time Vocational Tr (NLD)
F=Full-Time
H=Enrolled Half-Time
L=Less than Half-Time
N=No Unit Load
O=Vocational Training (NLD)
P=Part-Time
T=Three Quarter Time
11 ACADEMIC_LEVEL Character(3) VARCHAR2(3) NOT NULL Academic level
00=Not Set
01=First Year
02=Second Year
03=Third Year
04=Fourth Year
05=Fifth Year
06=Sixth Year
10=Freshman
20=Sophomore
30=Junior
40=Senior
50=Post-Bacc Undergraduate
GR=Graduate
GRA=Graduate AUS
HON=Honours
IE=Industrial Experience
MAS=Masters
P1=Professional Year 1
P2=Professional Year 2
P3=Professional Year 3
P4=Professional Year 4
PHD=PhD
12 HOUSING_INTEREST Character(1) VARCHAR2(1) NOT NULL Housing interest
C=Commuter
F=Off Campus Housing
H=On Campus Housing
13 CS_FIN_AID_INT Character(1) VARCHAR2(1) NOT NULL CS_FIN_AID_INT is used in OLM Profile student admin Dialog for OLM/SA Integration.
14 ADM_REFRL_SRCE Character(4) VARCHAR2(4) NOT NULL Referral Source
15 CS_REFERRAL_SRC_DT Date(10) DATE CS_REFERRAL_SRC_DTis used in OLM Profile student admin Dialog for OLM/SA Integration.
16 BO_ID_STR Character(32) VARCHAR2(32) NOT NULL BO ID as a string
17 LAST_SCH_ATTEND Character(11) VARCHAR2(11) NOT NULL Last school attended
18 GRADUATION_DT Date(10) DATE Enter the graduation date information.
19 RA_SELF_RPT_GPA Number(23,4) DECIMAL(22,4) NOT NULL Self Reported GPA
20 RA_CLASS_SIZE Number(18,0) DECIMAL(18) NOT NULL Class Size
21 RA_CLASS_RANK Number(18,0) DECIMAL(18) NOT NULL Class Rank
22 LIFECYCLE_STATUS Character(4) VARCHAR2(4) NOT NULL Recruiting Status
ALUM=Alumnus
APPL=Applicant
INAC=Inactive
PROS=Prospect
STUD=Student
SUSP=Suspect
23 LIFECYCLE_STAT_DT Date(10) DATE Lifecycle status date
24 RA_CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
25 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application number for recruiting and admissions.
26 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
27 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
28 STATUS_DT Date(10) DATE This field is used as edit box to show the Status Date