SSR_APT_RQRC_VW

(SQL View)
 Index Back

Req Run Ctrl History Details

Shows a list of students, their APT Instance and Program/Plan, and the outcomes and message log entries of their APT requests

SELECT A.OPRID , A.RUN_CNTL_ID , A.PROCESS_INSTANCE , B.EMPLID , B.INSTITUTION , B.SSR_APT_INSTANCE , C.ACAD_CAREER , C.STDNT_CAR_NBR , D.ACAD_PROG , E.DESCR , D.ACAD_PLAN , F.DESCR , B.SSR_PRCS_STATUS , B.SSR_APT_REQUEST_ID FROM %Table(SSR_APT_ADMRQRC) A , %Table(SSR_APT_ADM_RC2) B , %Table(SSR_APT_HDR) C , %Table(SSR_STU_ACAD_VW) D , %Table(ACAD_PROG_TBL) E , %Table(ACAD_PLAN_TBL) F WHERE A.RUN_CNTL_ID = B.RUN_CNTL_ID AND B.EMPLID = C.EMPLID AND B.INSTITUTION = C.INSTITUTION AND B.SSR_APT_INSTANCE = C.SSR_APT_INSTANCE AND C.EMPLID = D.EMPLID AND C.INSTITUTION = D.INSTITUTION AND C.ACAD_CAREER = D.ACAD_CAREER AND C.STDNT_CAR_NBR = D.STDNT_CAR_NBR AND %EffdtCheck(SSR_STU_ACAD_VW D1, D, %CurrentDateIn) AND D.INSTITUTION = E.INSTITUTION AND D.ACAD_PROG = E.ACAD_PROG AND %EffdtCheck(ACAD_PROG_TBL E1, E, %CurrentDateIn) AND E.EFF_STATUS = 'A' AND D.INSTITUTION = F.INSTITUTION AND D.ACAD_PLAN = F.ACAD_PLAN AND %EffdtCheck(ACAD_PLAN_TBL F1, F, %CurrentDateIn) AND F.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
6 SSR_APT_INSTANCE Number(3,0) SMALLINT NOT NULL Academic Progress Tracker Instance Number
7 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
8 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
9 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
11 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
12 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
13 SSR_PRCS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
E=Error
S=Success
W=Warning
14 SSR_APT_REQUEST_ID Character(12) VARCHAR2(12) NOT NULL APT Request ID