- DATA VIEW NAME
- STDNT UGRD APPLICANT ACTIONS
- OVERVIEW
-
This data view contains a history of every Program Action and Action Reason taken on an undergraduate application to the University of Wisconsin-Madison.
The view is intended to be joined with the STDT_UGRD_APPLICANT data view to gather year-to-date statistics.
Due to the significant potential for confusion in gathering year-to-date statistics with this data view, it is suggested that individuals limit queries to data relevant to their office.
This data view should not be used to gather day-to-day applicant information; instead, the STDT_UGRD_APPLICANT data view alone should be accessed.
- LOAD FREQUENCY
- Data is refreshed daily Monday – Friday and Sunday
- DATA CUSTODIAN
- Undergraduate Admissions Office
Contact: David Leszczynski - AUTHORIZATION
-
You must receive approval to access data from the data custodian.
Users of this data view will have to acknowledge an understanding of this information prior to being granting access.
For information about how to get authorized for InfoAccess data views, connect to the InfoAccess Home Page
- SPECIAL CONSIDERATIONS
-
- A complete understanding of Program Action and Program Reason combinations is necessary to gather accurate statistics from this data view.
- The data view must be linked with STDT_UGRD_APPLICANT on the ID and Application Number fields (multiple applications may exist for an individual) in order to limit the data by term.
- Each applicant could have multiple rows of data.
- Due to previous term change policy, multiple terms may exist with the same application number creating multiple admit or deny rows.
- Multiple actions may occur on the same date.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-4357 (HELP) - LAST UPDATED
-
- 01/2003 New View
- 06/2003 Data Custodian change
- 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 |
|---|---|---|
| ID | VARCHAR2 (11) | ID number assigned by ISIS to be used internally. This is a unique ID for each student. |
| APPLICATION_NUMBER | VARCHAR2 (8) | ISIS system generated application number. |
| PROGRAM_ACTION | VARCHAR2 (4) | The application decision. Valid values are: ADMT = Admit ADRV = Admission Revocation APPL = Application COND = Conditional Admit DATA = Data Change DDEF = Defer Decision DEFR = Defer Enrollment DEIN = Intention to Matriculate DENY = Deny MATR = Matriculation PLNC = Plan Change PRGC = Program Change RAPP = Readmit Application RECN = Reconsideration WADM = Administrative Withdrawal WAIT = Waitlist WAOF = Waitlist Offer WAPP = Applicant Withdrawal |
| PROGRAM_ACTION_DESCR | VARCHAR2 (30) | Full description of Program Action |
| PROGRAM_ACTION_DATE | DATE | Date the action was taken. |
| PROGRAM_REASON | VARCHAR2 (4) | Supporting reason for action taken. Examples of Valid values are: U10 = Freshman Automated Decision U01 = Complete – 2-4 Weeks U20 = Postpone U40 = Less Than 24 Credits |
| PROGRAM_REASON_DESCR | VARCHAR2 (30) | Full description of Program Reason. |
| EXTRACT_DATE_TIME | DATE | The date and time these data were extracted. |