ACAD_PROG_A_VW(SQL View) |
Index Back |
---|---|
Primary Student Acad ProgThis view is used as a prompt table for Student Academic Career Term Student Career Number. |
select a.emplid, a.acad_career, b.strm, a.institution, a.stdnt_car_nbr, a.effdt, a.effseq, a.stdnt_car_nbr, a.acad_prog, a.prog_status, a.acad_load_appr from PS_ACAD_PROG a, ps_term_tbl b where a.institution = b.institution and a.acad_career = b.acad_career and a.admit_term <= b.strm |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
2 | 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 |
3 | STRM | Character(4) | VARCHAR2(4) NOT NULL |
Term
Prompt Table: TERM_TBL |
4 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INST_CAR_SRCH |
5 | STDNT_CAR_NBR1 | Number(3,0) | SMALLINT NOT NULL | Student Career Number |
6 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
7 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
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 | PROG_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Academic Program Status
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 |
11 | ACAD_LOAD_APPR | Character(1) | VARCHAR2(1) NOT NULL |
Approved Academic Load
B=Vocational Coaching (NLD) D=Dual (NLD) E=Part-time Vocational Tr (NLD) F=Full-Time O=Vocational Training (NLD) P=Part-Time |