ACAD_SUBPLN_TBL(SQL Table) |
Index Back |
---|---|
Academic Sub Plan TableAn 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). |
# | 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 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
6 | 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 |
7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
8 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: ACAD_SUBPLN_TBL.DESCR |
9 | 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 |
10 | DIPLOMA_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Diploma Description |
11 | DIPLOMA_PRINT_FL | Character(1) | VARCHAR2(1) NOT NULL |
Print on Diploma
Y/N Table Edit Default Value: Y |
12 | DIPLOMA_INDENT | Number(2,0) | SMALLINT NOT NULL | Number of Characters to Indent |
13 | TRNSCR_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Transcript Description |
14 | TRNSCR_PRINT_FL | Character(1) | VARCHAR2(1) NOT NULL |
Print on Transcript
Y/N Table Edit Default Value: Y |
15 | TRNSCR_INDENT | Number(2,0) | SMALLINT NOT NULL | Nbr of Chars Indnt on Transcr |
16 | FIRST_TERM_VALID | Character(4) | VARCHAR2(4) NOT NULL |
First Term Valid
Prompt Table: TERM_VAL_TBL |
17 | CIP_CODE | Character(13) | VARCHAR2(13) NOT NULL |
CIP code
Default Value: ACAD_PLAN_TBL.CIP_CODE Prompt Table: CIP_CODE_TBL |
18 | HEGIS_CODE | Character(8) | VARCHAR2(8) NOT NULL |
HEGIS Code
Default Value: ACAD_PLAN_TBL.HEGIS_CODE Prompt Table: HEGIS_CODE_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 | EVALUATE_SUBPLAN | Character(1) | VARCHAR2(1) NOT NULL |
Evaluate SubPlan Before Plan?
Y/N Table Edit |
21 | SSR_LAST_PRS_DT | Date(10) | DATE | Last Prospect Date |
22 | SSR_LAST_ADM_TERM | Character(4) | VARCHAR2(4) NOT NULL |
Last Admit Term
Prompt Table: TERM_VAL_TBL |
23 | SAA_WHIF_DISP_ADVR | Character(1) | VARCHAR2(1) NOT NULL |
Show In What-If Advisor
Y/N Table Edit Default Value: N |
24 | SAA_WHIF_DISP_PREM | Character(1) | VARCHAR2(1) NOT NULL |
Show in What-If Prematric Std
Y/N Table Edit Default Value: N |
25 | SAA_WHIF_DISP_STD | Character(1) | VARCHAR2(1) NOT NULL |
Show in What-If Student
Y/N Table Edit Default Value: N |