ACAD_SUBPLNTBVW

(SQL View)
 Index Back

Academic Sub Plan Table View

An Academic Sub Plan is a focus within an academic plan. An example of a subplan might be an American history concentration within the history major (plan).

SELECT A.INSTITUTION ,A.ACAD_PLAN ,A.ACAD_SUB_PLAN ,A.ACAD_SUBPLAN_TYPE ,A.DESCR ,A.DESCRSHORT ,A.SUBPLN_REQTRM_DFLT ,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.TRANSCRIPT_LEVEL ,A.EVALUATE_SUBPLAN FROM PS_ACAD_SUBPLN_TBL A WHERE A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(A2.EFFDT) FROM PS_ACAD_SUBPLN_TBL A2 WHERE A2.INSTITUTION = A.INSTITUTION AND A2.ACAD_PLAN = A.ACAD_PLAN AND A2.ACAD_SUB_PLAN = A.ACAD_SUB_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

Default Value: OPR_DEF_TBL_CS.ACAD_PLAN

Prompt Table: ACAD_PLAN_T2_VW

3 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Sub-Plan
4 ACAD_SUBPLAN_TYPE Character(3) VARCHAR2(3) NOT NULL Academic Sub-Plan Type
CON=Concentration
EMP=Emphasis
MIN=Minor
OPT=Option
SPC=Specialization
TRK=Track
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

Default Value: ACAD_SUBPLN_TBL.DESCR

7 SUBPLN_REQTRM_DFLT Character(1) VARCHAR2(1) NOT NULL Sub-Plan Req Term Default
A=Program's Admit Term
D=SubPlan's Declare Date
L=Plan's Requirement Term
P=Program's Requirement Term

Default Value: ACAD_PLAN_TBL.PLN_REQTRM_DFLT

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

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: Y

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

Prompt Table: TERM_VAL_TBL

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

Default Value: ACAD_PLAN_TBL.CIP_CODE

Prompt Table: CIP_CODE_TBL

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

Default Value: ACAD_PLAN_TBL.HEGIS_CODE

Prompt Table: HEGIS_CODE_TBL

17 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

18 EVALUATE_SUBPLAN Character(1) VARCHAR2(1) NOT NULL Evaluate SubPlan Before Plan?

Y/N Table Edit