ACAD_PROG_RPTVW

(SQL View)
 Index Back

Academic Program Table View

The Academic Program Table View lists all active academic programs that an institution has ever offered regardless of effective date.

SELECT INSTITUTION ,ACAD_CAREER ,ACAD_PROG ,EFFDT ,EFF_STATUS ,REPEAT_ENRL_CTL ,REPEAT_ENRL_SUSP ,REPEAT_GRD_SUSP ,REPEAT_GRD_CK ,REPEAT_CRSE_ERROR FROM PS_ACAD_PROG_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

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 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
4 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
6 REPEAT_ENRL_CTL Character(1) VARCHAR2(1) NOT NULL Process on Enrollment
N=No
Y=Yes
7 REPEAT_ENRL_SUSP Character(1) VARCHAR2(1) NOT NULL Temp Susp Rpt Ck on Enrl
8 REPEAT_GRD_SUSP Character(1) VARCHAR2(1) NOT NULL Temp Susp Rpt Ck on Grading
9 REPEAT_GRD_CK Character(1) VARCHAR2(1) NOT NULL Repeat Grade Check
A=All Courses
N=Never
O=Only Repeat Candidates
10 REPEAT_CRSE_ERROR Character(1) VARCHAR2(1) NOT NULL Course Catalog Repeat Message
E=Error
N=None
W=Warning