- DATA VIEW NAME
- UA_UDDS_NAME
- OVERVIEW
- This is a view built from data in the Shared Financial System (SFS). It contains any UW-Madison active UDDS code, future UDDS codes, and all the expired UDDS codes. This allows you to join this view with others data views in order to include a UDDS name in your report even if the report includes a future year UDDS or expired UDDS.
- LOAD FREQUENCY
- This data is refreshed nightly.
- DATA CUSTODIAN
- UW Madison Budget Office
- Contact: Simi Ragha
- AUTHORIZATION
- Data Custodian signature is not required. For information about how to get authorized for InfoAccess data views, connect to InfoAccess Home Page
- SPECIAL
CONSIDERATIONS - QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 06/2019 Project to reconstruct this data from SFS (originally sourced from Mainframe sources) and limit the extraction to only UW Madison. The goal was to keep the data structure and content for UW Madison codes the same so as to not impact existing queries and reports.
- DATA FORMATS
- The codes following the field names in this document define the field. The different types are:
- Alphanumeric Data
- A – Alphanumeric field. This indicates the field may contain Letters and/or numbers. The number following is the field length.
Example: a field defined as A5 could contain ‘E10LN’. - Numeric Data
- N – Numeric data. This indicates the field may contain only numbers. The number following is the field length. If two digits with a decimal point in between are present the first indicates the number of positions before the decimal point and the second the number of digits after the decimal point.
Example: a field defined as N4.2 would be in the format 9999.99 whereas N6 would be in the format 999999. - Date
- D – Date field — this means the field is stored a date. The format is described in the text description. The way this type of field will display in the result section of a query will be dependent upon what default the query tool you are using is set to. Some query tools default to a date/time mode which would show the data 1998-9-03 8:00 or some have a format DD-MMM-(YY)YY. Most query tools allow you to change this to a format you want but you must be aware of what the default is.
| Column Name | Format | Description |
|---|---|---|
| UDDS_LOOKUP_KEY | A11 | A code identifying the combined codes for Unit, Division, Department, and Subdepartment. This is the eleven character financial representation and must be used as the key for look-ups on the IADS views. |
| UDDS_EFF_YEAR | A4 | This is the effective year of the UDDS. |
| UDDS_EXP_YEAR | A4 | This is the expiration year of the UDDS. |
| UDDS_SHORT_NAME | A16 | This is the short description of the UDDS. |
| UDDS_LONG_NAME | A39 | This is the long description of the UDDS. |
| UDDS_FINANCIAL | A7 | A code identifying the combined codes for Unit, Division, Department, and Subdepartment. This is the seven character financial representation and cannot be used as the key for look-ups on the IADS views |
| UDDS_COMB_NAME | A43 | This is the combined long name: Example: MSNL&SADMINISTRATIONGENERAL |
| PRIMARY_CIP | A6 | The primary CIP code.
About CIP Codes: The purpose of the Classification of Instructional Programs (CIP) is to provide a taxonomic scheme that supports the accurate tracking, assessment and reporting of fields of study and program completion activity. CIP was originally developed by the U.S. Department of Education’s National Center for Education Statistics (NCES). The CIP is the accepted federal government statistical standard on instructional program classifications and is used in a variety of educational information surveys and databases. The CIP taxonomy is organized on three levels: To browse through a list of CIP codes including the definition of each code, visit this webpage: |
| SECONDARY_CIP | A6 | The secondary CIP code. |
| TERTIARY_CIP | A6 | The tertiary CIP code. |
| EXTRACT_DATE_TIME | A17 | This is the system generated date of when the data was last refreshed. Format: mm/dd/ccyy. |