SSR_HM_CPRE_LTQ

(SQL View)
Index Back

Course Application Preference

Course Application preference last successful transaction

SELECT CPRE.INSTITUTION , CPRE.EMPLID , CPRE.ACAD_CAREER , CPRE.STDNT_CAR_NBR , CPRE.ADM_APPL_NBR , CPRE.APPL_PROG_NBR , CPRE.SSR_TRANS_ID , CPRE.SSR_SEQ_NBR , CPRE.SSR_SEQ_NBR2 , CPRE.SSR_MAP_ID FROM PS_SSR_HM_PREFER CPRE , PS_SSR_HM_CPRE_LTX LTX WHERE CPRE.EMPLID= LTX.EMPLID AND CPRE.INSTITUTION= LTX.INSTITUTION AND CPRE.ADM_APPL_NBR = LTX.ADM_APPL_NBR AND CPRE.APPL_PROG_NBR = LTX.APPL_PROG_NBR AND CPRE.ACAD_CAREER = LTX.ACAD_CAREER AND CPRE.STDNT_CAR_NBR = LTX.STDNT_CAR_NBR AND CPRE.SSR_TRANS_ID = LTX.SSR_TRANS_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 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
4 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
5 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr
6 APPL_PROG_NBR Number(3,0) SMALLINT NOT NULL Application Program Nbr
7 SSR_TRANS_ID Number(31,0) DECIMAL(31) NOT NULL HEIMS Transaction ID
8 SSR_SEQ_NBR Number(4,0) SMALLINT NOT NULL Sequence Number
9 SSR_SEQ_NBR2 Number(4,0) SMALLINT NOT NULL Sequence Number 2
10 SSR_MAP_ID Number(31,0) DECIMAL(31) NOT NULL HEIMS Map ID