INSTITUTIONACAD_PLANACAD_SUB_PLANEFFDTPrompt Table: SSR_FOS_TBL
SSR_SUBPLAN_AUS(SQL Table) |
Index Back |
|---|---|
Academic Sub Plan AUSAUS fields for Academic Sub Plan Table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | ACAD_PLAN |
Character(10) | VARCHAR2(10) NOT NULL | Academic Plan |
| 3 | ACAD_SUB_PLAN |
Character(10) | VARCHAR2(10) NOT NULL | Academic Sub-Plan |
| 4 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 5 | SSR_SPECIALSATN_CD | Character(8) | VARCHAR2(8) NOT NULL |
Specialisation Code
Prompt Table: SSR_FOS_TBL |