OLM_CONST_VW

(SQL View)
 Index Back

Constituents Profile

View used in Constituents profile record definition.

SELECT A.BO_ID , (%NumToChar(B.SYNCID) %Concat %NumToChar(C.SYNCID) %Concat %NumToChar(D.SYNCID) %Concat %NumToChar(E.SYNCID) ) , A.INSTITUTION , A.ACAD_CAREER , A.ACAD_PROG , A.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 , A.BO_ID_STR , A.LAST_SCH_ATTEND , A.GRADUATION_DT , A.RA_SELF_RPT_GPA , A.RA_CLASS_SIZE , A.RA_CLASS_RANK , A.LIFECYCLE_STATUS , A.LIFECYCLE_STAT_DT , A.RA_CAMPUS , A.ADM_APPL_NBR , A.APPLICATION_STATUS , A.STUDENT_STATUS , A.STATUS_DT , E.RA_MKT_CENTER FROM PS_RA_CNSTTUENT_VW A LEFT OUTER JOIN PS_RA_ACADCAR_VW B ON A.INSTITUTION=B.INSTITUTION AND A.ACAD_CAREER=B.ACAD_CAREER LEFT OUTER JOIN PS_RA_ACADPRG_VW C ON A.INSTITUTION=C.INSTITUTION AND A.ACAD_PROG=C.ACAD_PROG LEFT OUTER JOIN PS_RA_ACADPLN_VW D ON A.INSTITUTION=D.INSTITUTION AND A.ACAD_PLAN=D.ACAD_PLAN LEFT OUTER JOIN PS_RA_MC_PGMLVL_VW E ON A.BO_ID = E.BO_ID AND A.INSTITUTION=E.INSTITUTION AND A.ACAD_CAREER = E.ACAD_CAREER AND A.ACAD_PROG=E.ACAD_PROG UNION SELECT A.BO_ID , (%NumToChar(B.SYNCID) %Concat %NumToChar(C.SYNCID) %Concat %NumToChar(D.SYNCID) %Concat %NumToChar(E.SYNCID) ) , A.INSTITUTION , A.ACAD_CAREER , A.ACAD_PROG , A.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 , A.BO_ID_STR , A.LAST_SCH_ATTEND , A.GRADUATION_DT , A.RA_SELF_RPT_GPA , A.RA_CLASS_SIZE , A.RA_CLASS_RANK , A.LIFECYCLE_STATUS , A.LIFECYCLE_STAT_DT , A.RA_CAMPUS , A.ADM_APPL_NBR , A.APPLICATION_STATUS , A.STUDENT_STATUS , A.STATUS_DT , E.RA_MKT_CENTER FROM PS_RA_CNSTTUENT_VW A LEFT OUTER JOIN PS_RA_ACADCAR_VW B ON A.INSTITUTION=B.INSTITUTION AND A.ACAD_CAREER=B.ACAD_CAREER LEFT OUTER JOIN PS_RA_ACADPRG_VW C ON A.INSTITUTION=C.INSTITUTION AND A.ACAD_PROG=C.ACAD_PROG LEFT OUTER JOIN PS_RA_ACADPLN_VW D ON A.INSTITUTION=D.INSTITUTION AND A.ACAD_PLAN=D.ACAD_PLAN LEFT OUTER JOIN PS_RA_MC_CARLVL_VW E ON A.BO_ID = E.BO_ID AND A.INSTITUTION=E.INSTITUTION AND A.ACAD_CAREER = E.ACAD_CAREER

# 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 RA_ATTRIB_SEQ Number(31,0) DECIMAL(31) NOT NULL Profile / attribute sequence numbers
3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Institution field to store institution information in campus solution system.
4 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
5 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic program field coming from campus solution system.
6 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan field coming from campus solution system
7 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL stores information about term attending.
8 ADMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Admit type stores information about the type of admission.
9 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
10 RECRUITING_STATUS Character(4) VARCHAR2(4) NOT NULL Recruiting Status
APPL=Applicant
INAC=Inactive
INQR=Inquiry
PROS=Prospect
SUSP=Suspect
11 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
12 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
13 HOUSING_INTEREST Character(1) VARCHAR2(1) NOT NULL Housing interest
C=Commuter
F=Off Campus Housing
H=On Campus Housing
14 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.
15 ADM_REFRL_SRCE Character(4) VARCHAR2(4) NOT NULL Referral Source
16 CS_REFERRAL_SRC_DT Date(10) DATE CS_REFERRAL_SRC_DTis used in OLM Profile student admin Dialog for OLM/SA Integration.
17 BO_ID_STR Character(32) VARCHAR2(32) NOT NULL BO ID as a string
18 LAST_SCH_ATTEND Character(11) VARCHAR2(11) NOT NULL Last school attended
19 GRADUATION_DT Date(10) DATE Enter the graduation date information.
20 RA_SELF_RPT_GPA Number(23,4) DECIMAL(22,4) NOT NULL Self Reported GPA
21 RA_CLASS_SIZE Number(18,0) DECIMAL(18) NOT NULL Class Size
22 RA_CLASS_RANK Number(18,0) DECIMAL(18) NOT NULL Class Rank
23 LIFECYCLE_STATUS Character(4) VARCHAR2(4) NOT NULL Recruiting Status
ALUM=Alumnus
APPL=Applicant
INAC=Inactive
PROS=Prospect
STUD=Student
SUSP=Suspect
24 LIFECYCLE_STAT_DT Date(10) DATE Lifecycle status date
25 RA_CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
26 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application number for recruiting and admissions.
27 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
28 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
29 STATUS_DT Date(10) DATE This field is used as edit box to show the Status Date
30 RA_MKT_CENTER Character(10) VARCHAR2(10) NOT NULL Marketing Center code