UA APPT SENSITV

DATA VIEW NAME

UA_APPT_SENSITV

OVERVIEW

APPT_SENSITV displays general and sensitive appointment information for currently active appointments that fall within your authorization. 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.

This view also contains highly sensitive information that should only be made available to authorized University faculty and staff. The sensitive data includes things such as heritage and gender.

This data view uses UDDS code to limit the records returned based on your authorization.

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/01/94 Project to standardize the data view documentation.
10/97 Div_Affiliation no longer used – will contain blanks
12/98 Added 4 new fields – TOTAL_APPT_PERCENT, TOTAL_PERCENT_LV,
11/01 Added field ‘Marked for Conversion’. C4j
12/01 Removed 2 fields: Fin_aid_status & Student_pay_ctgry. C4j.
09/03 Changed load frequency from weekly to daily. kek.
05/07 – Added ‘Working Title’ and ‘CBC_Completed_Date’ C4J
10/07 – Data Custodian change.
10/07 – Updated Service Status definition c4j
11/09 – Heritage Codes are now expanded to include 1 through 7 as valid values. 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. For 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. For 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.
APPOINTMENT_ID	A8	A unique number assigned to each appointment.
APPT_MONITOR	PS1.1	The projected length used for planning and/or monitoring purposes. Must be used for classified project appointments (that cannot exceed four years), and may be helpful for other types of appointments. Valid values are 0 = no projected length any other value less than 10.
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.
BEGIN_APPT_ACTION	A2	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 the appointment began. Valid values are: 01 return from layoff or other involuntary break in service 02 in lieu of layoff – chosen by employer 03 in lieu of layoff – chosen by employee 04 Voluntary – use with demotion only 05 Involuntary-use with demotion or transfer only 06 Displacement/Bumping – use with transfer or demotion 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) Blank not applicable
CONTINUING_STAFF	A1	The status of the appointment for inclusion in continuing staff. Valid values are: A Appointment is continuing staff B Appointment begins on or after July 1 of the current year C Appointment has a contract anniversary date other than July 1 or the start of the academic year. D Appointment appeared in the prior year budget but will be treated as a new appointment in the current budget as an employee-in-training or graduate assistant E Appointment is on the University payroll and will be in the budget on one of the titles listed in categories I – III Blank not applicable
CONTRACT_EFF_DATE	A8	The date the contract begins – in the format YYYYMMDD.
CONTRACT_END_DATE	A8	The date the contract ends – in the format YYYYMMDD.
CNTRCT_RAISE_DATE	A8	The effective date of the merit and pay plan increase when it is the exception to the normal annual or academic year increase. This does not apply to classified employees. The format is MMDD.
CPP_PERCENT	PS1.6	Used to express the Clinical Practice Plan (CPP) supplement rate as a percentage of full time rate.
CPP_EFF_DATE	A8	The date the CPP supplement came in to being – in the format YYYYMMDD.
DIV_AFFILIATION	A1	For the time being this field is no longer used. It will be spaces.
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 not applicable
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.
FLSA_STATUS	A1	Exemption status from the Wages and Hour provisions of the Fair Labor Standards Act for overtime pay of time and a half or compensatory time. Valid values are: E – Exempt N – Non-exempt Z – Not covered
FEDERAL_APPT_TYPE	A1	Describes the type of federal appointment related to this UW appointment. Valid values are: 1 USDA 2 Cooperative extension 3 Military service 4 Veterans hospital 9 Other
FUNDING_RSPNSBLTY	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.
LIMITED_APPT_PTR	A8	Points to the limited appointment that this backup/concurrent appointment is associated with. If this field contains a value, it will be a valid appointment id, it will indicate that this appointment is a backup appointment and the ID number in this field will point to a limited appointment.
NEXT_APPT_LOC	A1	The location of the next appointment that fringe benefits earned in this appointment can be transferred to. Valid values are: A Within the same university – different employing unit E Within the same university – same employing unit B different university C different university – WARF D different state agency
PERSON_ID	A8	A unique number assigned to a person. It is always the same for the same person.
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.
PRIOR_APPT_TYPE	A2	The type of the prior appointment that qualified the employee for fringe benefits that may be transferred to this appointment. This element is required if the value of prior appointment location is A, B, C, or D. The value in this field should match the values in appointment type or be blank.
PRIOR_APPT_BREAK	A1	Indicates whether there was a break in state service between the employee’s prior appointment and this appointment. This element is required if the value of prior appointment location is A, B, C, or D. Valid values are blank, Y or N.
BIRTHDATE	A8	The year, month and day of a person’s birth, in the format YYYYMMDD
EXT_AGREEMENT	A1	Indicates a formal agreement between a campus and extension for funding. Blank means no extension agreement exists and Y means one does.
GENDER	A1	Indicates gender. Valid values are M, F, and blank.
HERITAGE_CODE	A1	Racial/Ethnic heritage of employee. Valid values are: 1 – Black 2 – Asian 3 – Native American 4 – Hispanic 5 – White 6 – Hawaiian 7 – 2 or More Races Blank – Unknown
I9_CERTIFY_DATE	A8	The date the employment eligibility form is verified in the format YYYYMMDD. It may be blank.
I9_DEPARTMENT	A11	The UDDS of the department that holds the employment verification form. This field may be blank.
I9_ELIGIBILITY	A1	Taken from I9 eligibility form. Valid values are: 1 A citizen or national of the United States 2 An alien lawfully admitted for permanent residence 3 An alien authorized by the immigration and naturalization service to work in the United States.
PERSON_NAME	A30	The name currently used by the person.
PPC_PAYROLL_ID	A9	The ID number assigned to a person in the Peterson Processing Center (PPC) payroll system when the person does not have a social security number or needs to obtain one. The number must start with 980 or 990.
REASON_ID_GRANTED	A1	The reason a person id number was given to a person not employed or appointed by the University. Valid values are: P Parking permit S Staff directory (chaplains, bookstore mgr., etc.) T Telephone microfiche (contractors) V Photo ID
SENIORITY_DATE	A8	The adjusted date of civil service employment with the state of Wisconsin. In the format YYYYMMDD.
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.
SSN_REQUIRED	A1	Indicates if a social security number is required. Valid values are Y or N.
VISA_EXPECTED	A1	Indicates that the person being newly identified is expected to hold a visa. This does not indicate the presence of a valid visa period. There is no relationship of this element with the entry of actual immigration information or employment verification eligibility. Valid values are: Y – expected to hold a visa.
WARF_PAYROLL_ID	A9	The ID number assigned to a person in the WARF payroll system. The number must start with a 900 or 999.
PERSON_ID_CURRENT	A8	ID number currently assigned to a 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_EFF_DATE	A8	The date the approved title became effective. In the format YYYYMMDD.
EXECUTIVE_PLAN	A1	Identifies the executive plan rules that apply to the appointment. Valid values are: C Career executive plan – classified W UW system executive plan Y State of Wisconsin legislative plan
TITLE_CHG_REASON	A2	The reason for the title change. Valid values are: 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 30 Due to appeal 31 Activating a backup appointment
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.
RATE_EFF_DATE	A8	The date the salary base rate is effective. In the format YYYYMMDD
RATE_OVER_MAX	A1	Indicates if the appointment rate is approved to be above the pay range maximum (if one is defined), or the appointment is red circled upon eligible personnel actions. Valid values are: Y Rate is approved to be above max R Red circled S Above max, but in supplemental range
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.)
RATE_UNDER_MIN	A1	Indicates that the appointment is approved to be below the pay range defined. Valid values are: Y – Rate is approved to be below minimum
CONT_EFF_DATE	A8	The date the continuity status is effective. In the format YYYYMMDD.
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 value 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) that 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 that 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
MARKED_FOR_CONVERSION	A1	Indicates whether a particular appointment should be converted from classified to unclassified or from unclassified to classified. Valid values are Blank = appointment is not marked to conversion 1 = to be converted to classified 2 = to be converted to unclassified
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.
EXTRACT_DATE_TIME	Date	The System generated date when the data was last refreshed. Format: mm/dd/ccyy.