- DATA VIEW NAME
- UA_APT_TITLHIST
- OVERVIEW
- APT_TITLHIST contains historical title information. It shows all of the title changes for a given appointment. There are multiple records per appointment so care must be taken to ask for the correct time periods when using this view. This data view uses UDDS code to limit the records returned based on your authorization.
- LOAD FREQUENCY
- The data in this view is refreshed every weekend.
- DATA CUSTODIAN
- Data Custodian: Human Resources Office
Contact:Catharine Derubeis - 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 InfoAccess Home Page
- SPECIAL
CONSIDERATIONS - The APPT_EFF_DATE and APPT_END_DATE must be used together to select the correct appointments depending on what you are looking for. If you want to see the title history of a specific appointment, just use appointment_id in the selection criteria. If you want to see all title changes for a specific time period use BT or GE and a rate_eff_date in the selection criteria.
The fields UNIT, DIVISION, DEPARTMENT and SUBDEPT contain the same information as APPT_MAJOR_DEPT except they just contain the values for the specific sub field. For example someone with APPT_MAJOR_DEPT = A060520: UNIT = A, DIVISION = 06, DEPARTMENT = 05 and SUBDEPT = 20. The field is broken apart for ease of writing selection criteria.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 09/27/95 – View’s base tables changed – rzs
10/12/07 – Data Custodian change.
11/11 – Data Custodian Change c4j . - DATA FORMATS
- 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’.PS – Packed-Signed field. 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 that is defined as PS4.2 would be in the format 9999.99 whereas PS6 would be in the format 999999.
| Column Name | Format | Description |
|---|---|---|
| PERSON_NAME | A30 | The name currently used by a person. The name must begin with a letter. The format will be last name, followed by a comma and a space, then first name or initial, middle initial or name, followed by a space plus Jr. or Sr. or III if appropriate. The only special character required is the comma to end the last name. A hyphen is allowed. |
| PERSON_ID | A8 | ID number currently assigned to person. |
| APPT_ID | A8 | The assignment of an appointment ID number means a person has been selected but the appointment is not valid until the effective date is reached. An appointment must exist for each person who is to be paid salary or stipend, and each person without pay who has a university affiliation. The APPOINTMENT_ID is automatically generated by a subroutine that obtains the next available number and an appointment record is created. |
| APPOINTMENT_TYPE | A2 | This identifies the major personnel category for this appointment. Each type is governed by specific statutes and/or personnel regulations, policies, or procedures. Appointment type can change from classified permanent to academic staff and vice versa. This is called a conversion. Valid values are: ‘FA’ = faculty ‘LI’ = limited appointee ‘AS’ = academic staff ‘ET’ = employees-in-training ‘SA’ = student assistants ‘CP’ = classified permanent ‘CL’ = classified LTE ‘CJ’ = classified project ‘SH’ = student help ‘OT’ = other |
| APPT_DEPT | A11 | This is the basic unit of personnel administration. Each employee belongs to one or more appointment departments. |
| APPT_MAJOR_DEPT | A11 | This department is the one that coordinates the appointment. It is used for unclassified and classified appointments to identify this department as the one that will assume responsibility for coordinating the personnel decisions. |
| APPT_MAJOR_UNIT | A1 | This is first character of APPT_MAJOR_DEPT. |
| APPT_MAJOR_DIV | A2 | This is second and third characters of APPT_MAJOR_DEPT. |
| APPT_MAJOR_DEP | A2 | This is fourth and fifth characters of APPT_MAJOR_DEPT. |
| APPT_MAJOR_SUBDEPT | A2 | This is sixth and seventh characters of APPT_MAJOR_DEPT. |
| APPT_MONITOR | PS1.1 | This is the projected length used for planning and/or monitoring purposes. This must be used for classified project appointments (which cannot exceed 4 years), and may be helpful for other types of appointments, (e.g. clinical), regular TAs. Valid values include: ‘0’ = no projected length any other value less than 10 years. |
| DEPT_PERCENT | PS1.6 | The percentage of full-time for an appointment within an appointment department. This represents the proportion of full-time appointment for which this department is responsible on an on-going basis. It provides the payroll/accounting edit for ensuring that all funding amounts have been entered. Supports budget calculations, and may be used to determine eligibility for fringe benefits. This percentage remains constant through temporary changes in funding sources or temporary leaves without pay. Departments that provide short-term funding but assume no personnel responsibility (e.g., graduate school research committee) need not be linked to an appointment as an appointment department with a percent appointment department. If hours authorized entered, percent appointment department is computed:
percent = hours authorized / 80.0 (biweekly) |
| INIT_APPT_PERCENT | PS1.6 | The percentage of full-time for an appointment at the time of the appointment add. Do not use this element for reporting appointment FTE. Use summary or appointment department percent at a point in time. |
| APPT_HOURS | PS3.2 | This is the number of hours authorized per pay period at the time of the appointment add. It is used only when the appointment salary basis is “hourly”. For classified employees, it can’t exceed 80 hours, and for unclassified employees, it can’t exceed 176 hours. Do not use this element for reporting appointment FTE. Use summary of appointment department hours at a point in time. |
| BEGIN_APPT_ACTION | A2 | This is the official action that took place to begin this appointment. Valid values are: ’01’ = new appointment ’02’ = original appointment ’03’ = promotion ’04’ = transfer ’05’ = reinstatement ’06’ = restoration ’07’ = demotion ’08’ = rehire |
| BEGIN_APPT_REASON | A2 | The reason why the appointment began. For classified permanent, use only reasons 1 – 10. For limited term teaching assistants, use only reasons 11 – 15, for other appointment types, no reason code is needed. Valid values are: ’01’ = return from layoff or other involuntary break in service ’02’ = in lieu of layoff – beginning appt as chosen by employer ’03’ = in lieu of layoff – beginning appt as chosen by employee ’04’ = voluntary – use with demotion only ’05’ = involuntary – use with demotion or transfer only ’06’ = displacement/bumping – use with demotion or transfer only ’07’ = permissive – use with transfer only ’08’ = contractual – use with transfer only ’09’ = disciplinary – use with transfer or demotion only ’10’ = due to appeal – use with restoration or reinstatement only ’11’ = due to enrollment and/or staff fluctuations ’12’ = due to unexpected resignation ’13’ = due to changes or reduction in course offerings ’14’ = to replace TAs on leave of absence ’15’ = to fill a position left vacant by reassignment of TAs ’16’ = non-completion of probationary period (restoration only) |
| APPT_EFF_DATE | A8 | This is the start date of the appointment. Format: YYYYMMDD |
| END_APPT_CODE | A2 | The official action that took place upon the ending of this appointment. Valid values are: ’01’ = resignation ’02’ = retirement ’03’ = non-renewal ’04’ = layoff ’05’ = death ’06’ = fixed term termination, limited term project appointment ended ’07’ = dismissal ’99’ = cancelled |
| END_APPT_REASON | A2 | The reason why the appointment ended. Note that some reasons are specific to certain official actions. Valid values are: ’01’ = voluntary – use with classified l ayoff only ’02’ = involuntary – use with classified layoff only ’03’ = probationary or evaluation period failure ’04’ = program redirection/reorganization (for unclassified only) ’05’ = funding reduction ( for unclassified only) ’06’ = in lieu of dismissal for cause ’07’ = abandonment ’08’ = no reason supplied by employee ’09’ = health Blank – does not apply |
| APPT_END_DATE | A8 | This is the date that the appointment ends. This is the last date the appointment is in active pay status. Format: YYYYMMDD and it must be the same or later than the begin date for this appointment. |
| SOC_SEC_NUMBER | A9 | The social security number is a nine-digit identifier number assigned by the social security administration. It is required for all paid individuals with the exception of foreign employees working overseas. |
| EXECUTIVE_PLAN | A1 | This identifies which, if any, executive plan rules apply to the appointment. Valid values are: ‘C’ = career executive plan ‘W’ = UW system executive plan ‘Y’ = State of Wisconsin Legislative executive plan. |
| TITLE_CODE | A5 | Used to identify the official University System title, or Wisconsin Civil Service title for the appointment. |
| TITLE_NAME | A21 | This is the name of the title for an appointment. |
| TITLE_CHG_REASON | A2 | The reason for a change in title. Valid values: 01 = Reclassification 02 = Reallocation/Reorganization 03 = Promotion/Progression 04 = Error Correction. 21 = Appointment Type Conversion 24 = Educational Attainment 25 = Temporary change in duties. 28 = Historical Entry 29 = Restructuring coding scheme by system administration. 30 = Due to appeal. 31 = Activating a backup appointment. 36 = Contractual Training. 37 = Frankel Order |
| TITLE_TYPE | A1 | Titles may be classified into subtypes as follows: Valid values: C = Classified Title U = Unclassified Title S = Student Hourly title (technically this is also an “unclassified title.”) (currently there is only one Student Hourly title in use) Note that “Student Hourly” and ” Student Assistant” titles are completely different; they are sometimes confused due to similar names. |
| TITLE_EFF_DATE | A8 | The date the approved title is effective. Format: YYYYMMDD |
| APPT_BASE_RATE | PS8.3 | For each appointment, the salary base rate is the amount of money the University agrees to pay the employee for the work done in the appointment expressed in a standardized form. |
| RATE_EFF_DATE | A8 | The date the salary base rate is effective. Format: YYYYMMDD |
| SALARY_BASIS | A1 | Contains the pay basis for this appointment. It is determined by the following: “C” (academic year) – Directly tied to the academic year calendar. “A” (annual year) – continue regardless of whether classroom instruction is taking place. “B” (ten month) – a ten-month appointment used only with intercollegiate athletics. “H” (hourly) – All classified employees are normally paid using this basis. “L” (lump) – For “piece work”, paid as one amount. |
| RATE_OVER_MAX | A1 | This indicates if the appointment rate is approved to be above the pay range or span maximum defined (if one is defined), or the appointment is red circled upon eligible personnel actions. Valid values are: ‘Y’ = rate is approved to be above the maximum. ‘R’ = red circled (currently for classified only) ‘S’ = rate above UW’s maximum but within supplemental range. |
| RATE_UNDER_MIN | A1 | This indicates that the appointment rate is approved to be below the pay range or span minimum defined (if one is defined). The rate can be below the minimum for special employee circumstances or training periods in classified service. |
| LOADDATE | A8 | This is the date the data was last refreshed. Format: YYYYMMDD |