SFA_ACADPLTBLVW

(SQL View)
 Index Back

Academic Plan Table View

An Academic Plan is a focus within an Academic Program. Academic Plans are typically majors, minors or specializations.

SELECT A.INSTITUTION ,A.ACAD_PLAN ,A.DESCR ,A.DESCRSHORT ,A.ACAD_PLAN_TYPE ,A.ACAD_PROG ,A.PLN_REQTRM_DFLT ,A.DEGREE ,A.DIPLOMA_DESCR ,A.DIPLOMA_PRINT_FL ,A.DIPLOMA_INDENT ,A.TRNSCR_DESCR ,A.TRNSCR_PRINT_FL ,A.TRNSCR_INDENT ,A.FIRST_TERM_VALID ,A.CIP_CODE ,A.HEGIS_CODE ,A.ACAD_CAREER ,A.TRANSCRIPT_LEVEL ,A.STUDY_FIELD ,A.EVALUATE_PLAN ,A.SSR_NSC_CRD_LVL ,A.SSR_PROG_LEN_TYPE ,A.SSR_PROG_LENGTH ,A.SFA_SPEC_PROG_FLG FROM PS_ACAD_PLAN_TBL A WHERE A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(A2.EFFDT) FROM PS_ACAD_PLAN_TBL A2 WHERE A2.INSTITUTION = A.INSTITUTION AND A2.ACAD_PLAN = A.ACAD_PLAN AND A2.EFFDT <= %CurrentDateIn )

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

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

2 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

Default Value: ACAD_PLAN_TBL.DESCR

5 ACAD_PLAN_TYPE Character(3) VARCHAR2(3) NOT NULL Academic Plan Type
CON=Concentration
COS=Course of Study
HON=Honors
MAJ=Major
MIN=Minor
PRP=Preparation
RTC=ROTC
SP=Specialization
6 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

Prompt Table: ACAD_PROG_TBL

7 PLN_REQTRM_DFLT Character(1) VARCHAR2(1) NOT NULL Requirement Term Default
A=Program's Admit Term
D=Plan's Declare Date
P=Program's Requirement Term

Default Value: A

8 DEGREE Character(8) VARCHAR2(8) NOT NULL Degree

Prompt Table: DEGREE_INTRN_VW

9 DIPLOMA_DESCR Character(100) VARCHAR2(100) NOT NULL Diploma Description
10 DIPLOMA_PRINT_FL Character(1) VARCHAR2(1) NOT NULL Print on Diploma

Y/N Table Edit

Default Value: Y

11 DIPLOMA_INDENT Number(2,0) SMALLINT NOT NULL Number of Characters to Indent
12 TRNSCR_DESCR Character(100) VARCHAR2(100) NOT NULL Transcript Description
13 TRNSCR_PRINT_FL Character(1) VARCHAR2(1) NOT NULL Print on Transcript

Y/N Table Edit

Default Value: Y

14 TRNSCR_INDENT Number(2,0) SMALLINT NOT NULL Nbr of Chars Indnt on Transcr
15 FIRST_TERM_VALID Character(4) VARCHAR2(4) NOT NULL First Term Valid

Prompt Table: TERM_VAL_TBL

16 CIP_CODE Character(13) VARCHAR2(13) NOT NULL CIP code

Default Value: ACAD_PROG_TBL.CIP_CODE

Prompt Table: CIP_CODE_TBL

17 HEGIS_CODE Character(8) VARCHAR2(8) NOT NULL HEGIS Code

Default Value: ACAD_PROG_TBL.HEGIS_CODE

Prompt Table: HEGIS_CODE_TBL

18 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

Prompt Table: ACAD_CAR_TBL

19 TRANSCRIPT_LEVEL Character(2) VARCHAR2(2) NOT NULL Transcript level
00=Never Print
20=Print on Official
40=Print on Unofficial
60=Print on Student Life
80=Print on Degree Progress

Default Value: 20

20 STUDY_FIELD Character(10) VARCHAR2(10) NOT NULL Field of Study

Prompt Table: STUDY_FIELD_TBL

21 EVALUATE_PLAN Character(1) VARCHAR2(1) NOT NULL Evaluate Plan Before Program?

Y/N Table Edit

22 SSR_NSC_CRD_LVL Character(1) VARCHAR2(1) NOT NULL This field is used to identify the NSC Class Credential Level for the NSC report.
A=Associate's Degree
B=Bachelor's Degree
C=Certificate - Undergraduate
D=Doctoral Degree
F=Freshman
G=Unspecified-Grad/Professional
J=Junior
L=Professional
M=Master's Degree
N=Unspecified-Undergraduate
P=Postdoctorate
R=Senior
S=Sophomore
T=Post baccalaureate certificate
23 SSR_PROG_LEN_TYPE Character(1) VARCHAR2(1) NOT NULL Program Length Type
M=Months
W=Weeks
Y=Years
24 SSR_PROG_LENGTH Number(7,3) DECIMAL(6,3) NOT NULL Program Length Value
25 SFA_SPEC_PROG_FLG Character(1) VARCHAR2(1) NOT NULL SULA Special Programs Flag
A=Selective Admission Assoc Deg
B=2-year Bachelor's Degree
N=Not Applicable
P=Prep Crsewk Grad Prof Pgm
T=Non-Cred Teacher Cert Pgm
U=Prep Crsewk Ugrad Program