- DATA VIEW NAME
- UA_MILITARY_MILW
- OVERVIEW
- This view contains one record for each period of military service a person has served. In addition to being associated with a military period, the person has to have a current 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 Resource 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. 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 |
|---|---|---|
| PERSON_ID | A8 | A unique number assigned to each person. The number is always the same for the same person. |
| MILITARY_PERIOD | A2 | A unique number assigned to a time period of military action. |
| PERIOD_NAME | A35 | A name assigned to a time period of military action. |
| PERIOD_BEGIN_DATE | A8 | The begin date of a time period of military action. |
| PERIOD_END_DATE | A8 | The end date of a time period of military action. |
| CONFLICT_TYPE | A1 | The type of military action. Valid values are: C = campaign W = war |
| LOADDATE | A8 | This is the date that this record was loaded to this table. |