- DATA VIEW NAME
- STDNT_ACTIONS_MULTITERM
- OVERVIEW
- Contains academic standing information. This includes information about things like probation, academic dismissal (drop), and the clearing of any such actions on the student record.
- LOAD FREQUENCY
- Data will be refreshed nightly (Monday through Friday).
- DATA CUSTODIAN
- Phil Hull – Registrar Office
- AUTHORIZATION
- You must receive approval to access data from the data custodian. For information about how to get authorized for InfoAccess data views, connect to InfoAccess Home Page
- SPECIAL
CONSIDERATIONS - Use last action taken to determine the most recent status of the student relevant to that term. Each of the other categories only summarizes actions of that particular type and won’t tell you most recent status. Each term in this multiterm view may include actions that were not taken in that term, most recent actions are always included. Therefore, we have included an action term for each type to indicate the term in which the action was actually taken.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 05/2002 – New view created.
02/2012 – c4j Custodian Change
11/2014 – s8w Preferred name policy
03/2024 – Added CAREER - DATA FORMAT
- 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 |
|---|---|---|
| Term | varchar2(4) | The code for the academic year and semester. |
| Career | varchar2(4) | The type of academic career in which the student is currently enrolled. Values are: UGRD = Undergraduate GRAD = Graduate VMED = Veterinary Medicine Professional LAW = Law Professional MEDS = Medical Professional PHAR = Pharmacy Professional USPC = University Special Students UGST = University Guest Students (discontinued all 1999) |
| ID | varchar2(11) | A personal Identifier. The ID will never be changed throughout the individual’s relationship with the University. Not the same as Campus_ID. Only 10 characters are in use. |
| Campus_Id | varchar2(16) | A unique student identifier (10 digits). Changes occasionally at the student’s request. |
| Name | varchar2(50) | The student’s preferred name. Format is Last, First Middle. |
| Drop_Action_Term | varchar2(4) | The term the drop action was issued. |
| Drop_Action_Academic_Group | varchar2(5) | Academic group (e.g., College or School) associated to the student’s Academic Program for the given term. Each Program is associated to a unique Academic Group.
Values are: |
| Drop_Action_Code | varchar2(4) | A code for the most recent “Drop” standing action against a student. Students who receive a drop action must obtain permission to enroll in subsequent terms. |
| Drop_Action_Descr | varchar2(30) | A description of the drop code. |
| Drop_Action_Date | Date | The date the Drop action was issued. |
| Probation_Action_Term | varchar2(4) | The term the probation action was issued. |
| Probation_Action_Acad_Group | varchar2(5) | Academic group (e.g, College or School) associated to the student’s Academic Program for the given term. Each Program is associated to a unique Academic Group.
Values are: |
| Probation_Action_Code | varchar2(4) | A code for the most recent “Probation” action against a student. |
| Probation_Action_Descr | varchar2(30) | A description of the probation code. |
| Probation_Action_Date | Date | The date the Probation action was issued. |
| Permission_Action_Term | varchar2(4) | The term the Permission action was issued. |
| Permission_Action_Acad_Group | varchar2(5) | Academic group (e.g, College or School) associated to the student’s Academic Program for the given term. Each Program is associated to a unique Academic Group.
Values are: |
| Permission_Action_Code | varchar2(4) | A code for the most recent “Must obtain permission to continue” action against a student. |
| Permission_Action_Descr | varchar2(30) | A description of the permission action code. |
| Permission_Action_Date | Date | The date the Permission action was issued. |
| Clearing_Action_Term | varchar2(4) | The term the Clearing action was issued. |
| Clearing_Action_Acad_Group | varchar2(5) | Academic group (e.g, College or School) associated to the student’s Academic Program for the given term. Each Program is associated to a unique Academic Group.
Values are: |
| Clearing_Action_Code | varchar2(4) | A code for the most recent “Clearing” of a prior action against a student. Clearing actions are listed same term as the action that was cleared, even though the clearing action usually occurs at a later date. Includes all actions that are not of a punitive nature, even though they may not actually “clear” the student’s probation. For example, Action Pending removal of Incomplete (API) is included in this category since the student is still in “good” standing with this action on their record. |
| Clearing_Action_Descr | varchar2(30) | A description of the clearing action code. |
| Clearing_Action_Date | date | The date the Clearing action was issued. Note; this date will often be later than the given term, which is the term pertaining to the action that was cleared. Format YYYYMMDD. |
| Last_Action_Taken_Term | varchar2(4) | The term of the action that is the most recent action (drop, probation, permission, or clearing) against the student. The most recent action in the term supercedes all previous actions. |
| Last_Action_Taken_Acad_Group | varchar2(5) | The Academic group (e.g, College or School) associated to the student’s Academic Program when thee last action against the student was issued. Each Program is associated to a unique Academic Group.
Values are: |
| Last_Action_Taken_Action_Code | varchar2(4) | The code for the last action taken against the student for the term. |
| Last_Action_Taken__Descr | varchar2(30) | A description of the last action taken against the student for the term. |
| Last_Action_Taken_Date | Date | The date the last action was issued against the student for the term. |
| Extract_Date_Time | Date | The date and time these data were extracted from the source system(s). |