UDDS_NAME

This is a view built off of a table used for the Financial Management Reporting system (UW.FMR_CT03).  It contains any UDDS code active within a three year period (past year, current year and future year). In addition, it contains 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.

This data is refreshed weekly.

No custodian signature is required.

You must receive approval to access data from the data custodian. For information about how to get authorized for InfoAccess data views, connect to the InfoAccess home page.

Contact: Division of Information Technology Help Desk
Phone: 264-4357 (HELP)

04/01/94 Project to standardize the data view documentation.
07/16/96 Added - Combined UDDS name field to view.
07/31/06 Added information to the overview about the population included in this view.

The codes following the field names in this document define the field.  The different types are:

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'.

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.

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.

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.

A16

This is the short description of the UDDS.

A39

This is the long description of the UDDS.

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

A43

This is the combined long name:
Example: MSN\L&S\ADMINISTRATION\GENERAL