|
InfoAccess |
|
|---|---|
|
DATA VIEW NAME |
HR_STOUT |
|
OVERVIEW |
This view contains position/wage information on each employee's position/wage record. |
|
LOAD FREQUENCY |
The data is refreshed every night |
|
DATA CUSTODIAN |
Human Resources 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 |
09/00 Data view
created |
|
DATA FORMATS |
Key fields are identified
with an asterisk(*) |
| CHAR
(N) - Alphanumeric field. (N) is the length of the field. Field contains
letters and/or numbers. Example: CHAR (5) could contain ‘ABC12’ or ‘12345’ or ‘ABCDEF’ |
|
| 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 digits after the decimal Examples: NUMBER (6,2) could contain 2500.12 NUMBER (6) could contain 000005 or 550000 |
|
| DATE
-. 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 |
|---|---|---|
|
PERSON_ID |
CHAR 7 |
ID number assigned by Datatel to be used internally. This is a unique ID for each employee. Not the same as Campus ID. |
|
SSN |
CHAR 9 |
Employee's nine-digit social security number. |
|
DISABILITIES |
CHAR 1 |
Self-identification
of disability: |
|
PAYCLASS |
DATE 2 |
A field that contains a
code, which identifies the type of employment for the person's position. |
|
CONTRACT_LENGTH |
NUMBER 5,2 |
Length of contract
for employee in position. |
|
EMPLOYMENT_STATUS |
CHAR 3 |
Code indicating status
of position: |
|
EMPLOYMENT_STATUS_DESC |
CHAR 20 |
Description of employment statu |
|
TITLE_MODIFIER |
CHAR 2 |
A code identifying the
type of appointment: |
|
MADISON_APPT_NO |
NUMB 8 |
A unique eight-digit code assigned to each appointment |
|
PAY_CLASS_CODE |
NUMB 4 |
Identifies the expenditure
category to be charged with a payroll expense. |
|
GL_ACCT_CODE |
CHAR 20 |
GL account number assigned to position wage record; includes appropriation, activity code and UDDS |
|
DISTRIBUTION_PERCENT |
NUMB 5 |
Percent of payroll charged to a particular GL account code (carried three decimal points |
|
FTE |
CHAR 4 |
Position FTE for Classified and PIT FTE for Unclassified. |
|
NON_UWSTOUT_EDUC |
CHAR 2 |
Number of years of experiences in educational institutions other than UW-Stout (used by Unclassified only). |
|
NON_UWSTOUT-REL |
CHAR 2 |
Number of years of related non-educational experience awarded entering UW-Stout (used by Unclassified only). |
|
YRS_AT_STOUT |
CHAR 2 |
Number of years at UW-Stout regardless of FTE (used by Unclassified only). |
|
ED_PREP_CODE |
CHAR 1 |
A code used to identify
highest level of education (used by Unclassified only): |
|
ED_PREP_CODE_DESC |
CHAR 15 |
Description of Ed Prep Code |
|
CUPA_CODE |
CHAR 4 |
Discipline in which the
staff member is teach (used by Unclassified only): |
|
CUPA_CODE_DESC |
CHAR 15 |
Description of CUPA code |
|
CLASSIFICATIONS |
CHAR 5 |
Codes for titles assigned to Unclassified and Classified |
|
CLASSIFICATION_DESC |
CHAR 30 |
Description of classifications |
|
DEPARTMENT |
CHAR 4 |
Code for department where employee works |
|
DEPARTMENT_DESC |
CHAR 30 |
Description of department |
|
EXTRACT_DATE_TIME |
CHAR 19 |
|
|
POSITION.RANK |
CHAR 2 |
Code for rank given
to a classification: |