- DATA VIEW NAME
- UA_VET_DIS_MILW
- OVERVIEW
- This view contains information about the veteran and disabled status of a person. It has one record for each person that has a currently active appointment on the UW Milwaukee campus.
- LOAD FREQUENCY
- The data in this view is refreshed on the first and third Saturday of every month.
- DATA CUSTODIAN
- UWM – Human Resources Office
Contact: Suzanne Weslow - 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 - QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 08/10/94 The new view was created.
12/05/12 Data contact changed from Sarine Schmidt to Suzanne Weslow. - 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_ID | A8 | A unique number assigned to each person. The number is always the same for the same person |
| PERSON_NAME | A30 | The name currently used by a person. |
| BIRTHDATE | A8 | The day, month and year of the person’s birth. Format: YYYYMMDD |
| GENDER | A1 | The person’s gender: M = male F = female Blank = unreported |
| HERITAGE_CODE | A1 | This is the Racial/Ethnic heritage of an employee. Valid values are: 1 = Black 2 = Asian 3 = Native American 4 = Hispanic 5 = Other Blank = unknown |
| VIETNAM_VETERAN | A1 | This is the Federal definition. “Veteran of the Vietnam-era” means a veteran, any part of whose active military, naval, or air service was during the period August 5, 1964, through May 7, 1975, and who (I) was on duty for more than 180 days and was discharged or released there from with other than a dishonorable discharge, or (II) was discharged or released from active duty because of a service-connected disability. No veteran may be considered to be a veteran of the Vietnam era under this paragraph after December 31, 1991. Valid values are: Y = is a Vietnam veteran according to the above paragraph N = is not a Vietnam veteran Blank = Vietnam veteran status unknown |
| DISABLED_VETERAN | A1 | This is the Federal definition. “Special disabled veteran” means (A) a veteran who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Veterans Administration for a disability (I) rated at 30 percent or more, or (II) rated at 10 or 20 percent in the case of a veteran who has been determined under section 1506 of title 38, U.S.C., to have a serious employment handicap; or (B) a person who was discharged or released from active duty because of a service-connected disability. Valid values are: Y = is a disabled veteran N = is not a disabled veteran Blank = disabled veteran status unknown |
| HANDICAPPED | A1 | This is the Federal definition. A handicapped” individual is a person who has or is regarded as having a physical or mental impairment which substantially limits one or more major life activities. A physical or mental impairment is any physiological disorder or condition, cosmetic disfigurement, or anatomical loss which affects one or more of the following body systems: neurological; musculoskeletal; sense organs; speech organs; cardiovascular; reproductive; digestive; genitourinary; lymphatic; skin; endocrine.Also included are: mental retardation, organic brain syndrome; emotional or mental illness; learning disabilities; orthopedic impairments; cerebral palsy; epilepsy; muscular dystrophy; multiple sclerosis; cancer; heart disease; diabetes; emotional illness; drug addiction and alcoholism. Major life activities means functions such as caring for one’s self performing manual tasks, walking, seeing, hearing, speaking, breathing, learning, working and receiving educational or vocational instruction. Valid values are: Y = is handicapped N = is not handicapped Blank = handicapped status unknown |
| VETERAN | A1 | This is the State definition. This indicates whether the person has identified him or herself as a veteran. Valid values are: Y = is a veteran N = not a veteran Blank = veteran status unknown |
| DISABLED_WAR_VET | A1 | This is the State definition. This indicates whether the person is a disabled wartime veteran whose disability is directly traceable to war service. Valid values are: Y = is a disabled war veteran N = is not a disabled war veteran Blank = disabled war veteran status unknown |
| PCT_WAR_DISABLED | PS1.2 | This is the State definition. It is a number indicating the percent of this person’s wartime disability. |
| SPOUSE_70_PCT_DIS | A1 | This is the State definition. It indicates whether the person is the spouse of a disabled wartime veteran whose disability is at least 70% and is directly traceable to war service. Valid values are: Y = is a spouse N = is not a spouse Blank = spouse status is unknown |
| WIDOWED_SPOUSE_VET | A1 | This is the State definition. It indicates whether the person is an unremarried spouse of a veteran killed in action or a veteran who died of a service-connected disability. Valid values are: Y = is a spouse N = is not a spouse Blank = spouse status is unknown |
| DISCHARGED_VETERAN | A1 | This is the State definition. It indicates whether the person is a veteran, honorably discharged from the U.S. Armed Forces (not including training) OR was discharged for a service-connected disability with less than 180 days active service. Valid values are: Y = is a discharged veteran N = is not a discharged veteran Blank = discharged veteran status is unknow |
| DISABLED | A1 | |
| LOADDATE | A8 |