UA APPT GENERAL

DATA VIEW NAME

UA_APPT_GENERAL

OVERVIEW

APPT_GENERAL displays general appointment information for all currently active appointments. This view does not show a history of rate and title changes, only the most current data will be displayed. Only the appointment major department will be shown. This means even if there is more than one department associated with the appointment only one record will display.

LOAD FREQUENCY

The data in this view is refreshed daily.

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

None.

QUESTIONS

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

LAST UPDATED

04/94 Project to standardize the data view documentation
12/98 Added 4 new fields – TOTAL_APPT_PERCENT, TOTAL_PERCENT_LV, NET_PERCENT and SERVICE_STATUS. 04/01 Added 1 new field at the end – Seniority Date
11/01 Added field ‘Marked_for_Conversion’ (C4J)
09/03 Changed load frequency from weekly to daily. (KEK)
11/06 Added field ‘Funding_Responsibility’ to view. (GZT)
05/07 – Added ‘Working Title’ and ‘CBC_Completed_Date’ C4J
10/07 – Data Custodian change.
10/07 – Updated Service Status definition c4j
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 defined as PS4.2 would be in the format 9999.99 whereas PS6 would be in the format 999999.

Column Name	Format	Description
UNIT	A1	The first character of the UDDS code.
DIVISION	A2	The second and third characters of the UDDS code.
DEPT	A2	The fourth and fifth characters of the UDDS code.
SUBDEPT	A2	The sixth and seventh characters of the UDDS code.
APPT_MAJOR_DEPT	A11	The department that coordinates the appointment. This department has responsibility for coordinating personnel decisions.
INIT_APPT_HOURS	PS3.2	The number of hours authorized per pay period. Used only when the salary basis is hourly. CAUTION: This field reflects only initial appointment hours. It may be different from the current appointment hours.
APPOINTMENT_ID	A8	A unique number assigned to each appointment.
INIT_APPT_PERCENT	PS1.6	The percentage of full time for an appointment at the time the appointment is added. CAUTION: This field should not be used for FTE counting. It reflects only the initial appointment hours.
APPT_EFF_DATE	A8	The start date of the appointment, in the format CCYYMMDD.
END_APPT_CODE	A2	The official action that took place upon the ending of this appointment. Valid codes are: 01 resignation 02 retirement 03 non-renewal 04 layoff 05 death 06 fixed-term terminal 07 dismissal 99 cancelled
END_APPT_REASON	A2	The reason the appointment ended. Some reasons are specific to certain actions. Valid codes are: 01 voluntary; used with classified layoff 02 involuntary; used with classified layoff 03 probationary or evaluation period failure 04 program redirection/reorganization use with unclassified only 05 funding reduction; use with 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	The date the appointment ends. This is the last day the appointment is in an active pay status. Format is CCYYMMDD.
FUNDING_RESPONSIBILITY	A1	Describes the level of funding responsibility of the university system that may be related to salary or stipend payments made to the appointment. It does not indicate whether the University is reimbursed for the payments made. Valid values are: 0 = University holds no funding responsibility 1 = University holds sole funding responsibility 2 = University shares funding responsibility
GUARANTEED_LENGTH	PS1.1	The specific period of time stated for the length of the appointment.
PERSON_ID	A8	A unique number assigned to a person. It is always the same for the same person.
CBC_COMPLETED_DATE	A8	Last date a Criminal Background Check (CBC) was completed for this appointment. A history of CBC completed dates is not retained. Various policies dictate when a CBC must be done, however the IADS programs do not enforce any of these rules. The only edit is to verify the entered value is a valid date format. This field is entered/changed via IADS transactions APPT and APCHGA. It is viewed on APPI (pg 2.)
SOC_SEC_NUMBER	A9	Social security number assigned by the social security administration.
PRIOR_APPT_LOC	A1	The location of the prior appointment that qualified the employee for fringe benefits that may be transferred to this appointment.
RECRUITMENT_NMBR	A7	The number that has been assigned to the vacancy listing or recruitment record that was used when this appointment was established.
REC_PRSNL_OFFICE	A3	The personnel office that was responsible for approving or establishing the recruitment for the appointment.
RECRUITMENT_SYSTEM	A4	The personnel system that connects the vacancy listing or recruitment information that was used as a record of approval or a source of data when this appointment was established.
PERSON_NAME	A30	The name currently used by the person.
APPOINTMENT_TYPE	A2	Identifies the major personnel category for this appointment. Valid codes are: AS academic staff CJ classified project CL classified LTE CP classified permanent ET employees in training FA faculty LI limited appointee OT other SA student assistants SH student help
TITLE_CODE	A5	Used to identify the official University System title or Wisconsin civil service title for the appointment.
TITLE_NAME	A21	Current title name.
WORKING_TITLE	A30	Optional. This is the title description/name for the appointment. When entered, it is expected this field will provide a better, or more descriptive, name than the official title name associated with the appointment’s 5-byte title code. This field is entered/changed via IADS transactions APPT and APCHGA. It is viewed on APPI (pg 2).
APPT_BASE_RATE	PS8.3	For each appointment, this is the amount, expressed in a standardized form, the University agrees to pay the employee for the work done in the appointment. It should be noted that the amount in this field is not necessarily the amount actually paid to the employee.
SALARY_BASIS	A1	Contains the pay basis for this appointment. Valid codes are: A annual year B ten month C academic year H hourly L lump. (The display of the salary base rate will differ depending on the salary basis.)
CONTINUITY_STATUS	A2	Describes the continuity of the appointment. Valid codes are: 01 on-going 02 fixed terminal 03 fixed renewable 04 limited 05 acting/provisional 06 rolling horizon 07 interim
LOAD_DATE	A8	The date the data was extracted from the live files. In the format YYYYMMDD.
EXT_AFFILIATION	A2	Identifies the type of affiliation that is associated with this appointment. The affiliation source may be related to funding responsibility for the appointment. Valid values: 01 = Campus related agency 02 = External agency (Government or non-profit) 03 = Clinical/Hospital Affiliation 04 = Inter-institutional contractual agreement (interchange) 05 = Inter-governmental personnel temporary interchange 06 = UW Medical Foundation 09 = Other
C_BARGAIN_UNIT	A2	Code for the “bargaining unit” to which the title has been assigned.
C_SALARY_SCHEDULE	A2	A numeric code used by DER to identify the schedule for a classified title.
C_SALARY_RANGE	A2	A code used by DER to identify the range. (classified)
U_SALARY_GRADE	A2	The salary grade (if any) which characterizes the title code. A salary grade identifies the minimum and maximum salary for any title in that salary grade. The higher the grade, the higher the min and max. Note: If the Title Group begins with ‘A’, Then the Salary Grade must be non-blank and it must exist on edit table UW.SALGRADE Else the Salary Grade must be blank End-If.
U_TITLE_GROUP	A2	A code which groups together similar unclassified titles.
U_FUNCTIONAL_AREA	A2	Another scheme for grouping unclassified titles. Used only at the Madison campus. Five titles have more than 1 functional area. However, it was determined that one appropriate functional area could be chosen for each title, thus eliminating the need for multiple function areas per title. There is no need for a historical record of functional area changes. Valid Values = 1 to 13
U_SALARY_MINIMUM	PS8.3	Salary minimum for the salary grade. For Madison Campus – this is the institution rate selected in this order based on existence – extraordinary first, institution second system third. For system all rate are the system wide minimums.
U_SALARY_MIDPOINT	PS8.3	Salary midpoint for the salary grade. For Madison Campus – this is the institution rate selected in this order based on existence – extraordinary first, institution second system third. For system all rate are the system wide midpoints.
U_SALARY_MAXIMUM	PS8.3	Salary maximum for the salary grade. For Madison Campus – this is the institution rate selected in this order based on existence – extraordinary first, institution second system third. For system all rate are the system wide maximums.
TOTAL_APPT_PERCENT	PS3.4	This is the total percentage of an appointment. The value of this field will be repeated on each appointment/department record listed.
TOTAL_PERCENT_LV	PS3.4	This field is the sum of the department leave percents.
NET_PERCENT	PS3.4	This field is computed by subtracting leave percent from appointment percent. Net percent is never less than zero, even if a leave percent exists in a period of time without an appointment percent.
SERVICE_STATUS	A1	DESCRIBES THE SERVICE STATUS OF THE APPOINTMENT 1 – Emeritus. Indicates that emeritus (honorary) status was granted upon retirement from a faculty, academic staff or permanent classified appointment. The status carries into any subsequent appointment with the same set of duties. 2 – Distinguished Service.(No longer available) Indicates that distinguished service status was granted upon retirement from a non-instructional academic staff appointment. The status carries into any subsequent appointment with the same set of duties after a qualifying number of years of service. 3 – Certificate of appreciation.(No longer available) Indicates that this status was granted upon retirement from a classified appointment after a qualifying number of years of service. 4 – Rehired Annuitant. Indicates that an employee is hired into a new appointment after s/he retired from a previous appointment.
SENIORITY_DATE	A8	The adjusted date of civil service employment within the State of WI. in the format CCYYMMDD.
EXTRACT_DATE_TIME	Date	The System generated date when the data was last refreshed. Format: mm/dd/ccyy.