- DATA VIEW NAME
- STDNT_ACADEMIC_PLAN_CODES
- OVERVIEW
- This view contains academic plan codes and code descriptions.
- LOAD FREQUENCY
- The data is refreshed each weekend.
- DATA CUSTODIAN
- Registrar’s Office – Phil Hull
- AUTHORIZATION
- No approval signature is required by the Data Custodian to receive
authorization to access this data view. For information about how to get authorized for InfoAccess data views, connect to the InfoAccess Home Page - SPECIAL
CONSIDERATIONS - None.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 10/01 View Created to use Varchar2 data type and conformed data element names. C4j
2/2012 Custodian Change c4j - DATA FORMATS
- Primary Key Columns are identified with an asterisk(*)
- Alphanumeric Data
- VARCHAR2( N) (N) = maximum length. Field contains letters and/or numbers. Trailing blanks are eliminated.
Example: VARCHAR2 (5) could contain ‘ABC12’ or ‘ABC’ or ‘A’ - Numeric Data
- NUMBER (N) (N) = length. Field contains only numbers.
NUMBER (X,Y) = format for numbers with decimal positions.
X = total number of digits
Y = the number of digits after the decimal
Examples: NUMBER (6) represents 250012 NUMBER (6,2) represents 2500.12 - Date
- DATE – Date can be in various formats. Date functions available with your query tool can be used to format the date.
Examples: DATE (YYYYMMDD), DATE (YYDDD), DATE (DD-MM-YY)
| Column Name | Format | Description |
|---|---|---|
| *ACAD_PLAN_CODE | VARCHAR2 (10) | IThe code for the academic plan. |
| ACAD_PLAN_LONG_DESCR | VARCHAR2 (30) | The long description. |
| ACAD_PLAN_SHORT_DESCR | VARCHAR2 (10) | First 10 characters of the High School name |
| ACAD_PLAN_EFF_DATE | DATE | Date |
| EXTRACT_DATE_TIME | DATE | The System generated date when the data was last refreshed. Format: mm/dd/ccyy. |