InfoAccess

  

DATA VIEW NAME

DEPARTMENT_STOUT

OVERVIEW 

This view contains the department number descriptions.  The department number is broken down into to three sub-sets of data.  Each of these sub-sets of the department number also contains a description.

LOAD FREQUENCY

As changes occur.

DATA CUSTODIAN

Director of Accounting Services
Ted Wenum

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 the Infoaccess home page.

SPECIAL CONSIDERATIONS

  

QUESTIONS

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

LAST UPDATED

  

DATA FORMATS

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

CHAR2(N) OR CHAR (N) - Alphanumeric.  (N) is the length of the field.  Field contains letters and/or numbers. 
Example: CHAR (5) could contain 'ABC12' or '12345' or 'ABCDEF' and (N) is the length of the field. 

  NUM (N) - Numeric field. (N) is the length of the field.  Field contains only numbers.  Numbers with decimal points are represented as NUM (X.Y) X=total number of digits Y=the number of decimals after the decimal.
Examples: NUM (6,2) could contain 2500.12, NUM (6) could contain 000005 or 550000
  DATE  (XXXX) - Date field. (XXXX) is the format of the field. Date can be in various formats and date functions available based on your query tool can be used against the field. 
Examples: DATE (YYMMDD); DATE (YYDDD); DATE (DD-MM-YY)

Column Name

Format

Description

DEPARTMENT_NO

CHAR 6

Department number

DEPARTMENT_DESC

CHAR 30

Department number description

DIVISION

CHAR 1

Division

DIVISION_DESC

CHAR 30

Division description

COLLEGE_MAJOR_UNIT

CHAR 2

College major unit

COLLEGE_MAJOR_UNIT_DECSR

CHAR 30

Department group description

DEPARTMENT_GROUP

CHAR 4

Department group

DEPARTMENT_GROUP_DESC

CHAR 30

Department group description

EXTRACT_DATE_TIME

DATE

Date time transaction loaded on data warehouse