DEPT_PROFILE_UDDS

List of UDDS codes included in the Department Profile.  This view can be used in conjunction with UW.DEPT_PROFILE_CREDIT_GEN and UW.DEPT_PROFILE_NON_CREDIT_GEN to decode the UDDS codes in the Department Profile.

This view is replaced 4/30, 8/1, and 11/30.

Anne Gunther – L&S Dean’s Office

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-HELP (4357)

12/2001 – New view created.

Primary Key Columns are identified with an asterisk(*)

VARCHAR2( N)  (N) = maximum length. Field contains letters and/or numbers. Trailing blanks are eliminated.
E xample: VARCHAR2 (5) could contain ‘ABC12’ or  ‘ABC’ or ‘A’

NUM (N) (N) = length. Field contains only numbers.
NUM (X,Y) =  format for numbers with decimal positions
X = total number of digits Y = the number of digits after the decimal
Examples: NUM (6) represents 250012 NUM (6,2) represents 2500.12 

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)

A code for the combined codes for Unit, Division, Department, and Subdepartment.

Long version of UDDS descriptor 

Abbreviated version of UDDS descriptor

The date and time these data were extracted.