|
InfoAccess |
|
|
DATA VIEW NAME |
FTE_STOUT |
|
OVERVIEW |
This view contains FTE (full time equivalency) information for each funding source and department by fiscal year. |
|
LOAD FREQUENCY |
As changes occur |
|
DATA CUSTODIAN |
Budget, Planning &
Analysis Office |
|
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 |
|
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' (N) is the length of the field. Field contains letters and/or numbers. |
|
| 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 |
|---|---|---|
|
FISCAL_YEAR |
CHAR4 |
Fiscal year Transaction occurred in |
|
SEQUENCE_NO |
CHAR10 |
Sequence number of transaction |
|
GL_ ACCOUNT_NO |
CHAR15 |
General Ledger Account Number of transaction |
|
FUND |
CHAR3 |
Fund number of transaction |
|
ACTIVITY |
CHAR1 |
Activity number of transaction |
|
DEPARTMENT |
CHAR6 |
Department number of transaction |
|
ACCOUNT_NO |
CHAR5 |
Object code of transaction |
|
SFS_ FUND_NO |
CHAR3 |
SFS fund number to UW System |
|
SFS_ ACCOUNT_NO |
CHAR4 |
SFS account number to UW System |
|
REFERENCE_NO |
CHAR10 |
Reference number of transaction |
|
INCREASE_AMT |
NUM 7,3 |
FTE increase amount |
|
DECREASE_AMT |
NUM 7,3 |
FTE decrease amount |
|
DECREASE_AMT |
NUM 7,3 |
FTE increase - FTE decrease |
|
BUDGET_TRANSFER_DESC |
CHAR30 |
Budget transfer description |
|
SALARY_TURNOVER_DESC |
CHAR30 |
Salary turnover description |
|
FTE_TRANSFER_DESC |
CHAR30 |
FTE transfer description |
|
EXTRACT_DATE_TIME |
DATE |
Date time transaction loaded on data warehouse |