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 | Character(5) | VARCHAR2(5) NOT NULL | Institution field to store institution information in campus solution system. | |
2 | Character(10) | VARCHAR2(10) NOT NULL | Academic Plan field coming from campus solution system | |
3 | Character(10) | VARCHAR2(10) NOT NULL | Academic sub plan, a field together with program, plan, and sub plan to store student program information. | |
4 | 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 Subplan Type |
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 |
Subplan Required Term Default
Default Value: ACAD_PLAN_TBL.PLN_REQTRM_DFLT |
10 | DIPLOMA_DESCR | Character(100) | VARCHAR2(100) NOT NULL | This field stores the 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 | This field is used to indicate number of characters to indent |
13 | TRNSCR_DESCR | Character(100) | VARCHAR2(100) NOT NULL | This field is used to store the Transcript Description. |
14 | TRNSCR_PRINT_FL | Character(1) | VARCHAR2(1) NOT NULL |
Print on Transcipt value.
Y/N Table Edit Default Value: Y |
15 | TRNSCR_INDENT | Number(2,0) | SMALLINT NOT NULL | Number of Characters Indent on Transcription |
16 | FIRST_TERM_VALID | Character(4) | VARCHAR2(4) NOT NULL | This field is used to indicate first valid term. |
17 | CIP_CODE | Character(13) | VARCHAR2(13) NOT NULL | CIP code |
18 | HEGIS_CODE | Character(8) | VARCHAR2(8) NOT NULL | This field is used for mentioning HEGIS code |
19 | TRANSCRIPT_LEVEL | Character(2) | VARCHAR2(2) NOT NULL |
Transcript level
Default Value: 20 |
20 | EVALUATE_SUBPLAN | Character(1) | VARCHAR2(1) NOT NULL |
Evalute Subplan Before Plan?
Y/N Table Edit |
21 | SSR_LAST_PRS_DT | Date(10) | DATE | Field used to store the Last Prospect Date values. |
22 | SSR_LAST_ADM_TERM | Character(4) | VARCHAR2(4) NOT NULL | This field stores the Last Admitted Term. |
23 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
24 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
25 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
26 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
27 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
28 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |