UA_MILITARY_MILW

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.

The data in this view is refreshed on the first and third Saturday of every month

UWM - Human Resource Office
Contact: Sarine Schmidt

You must receive approval to access data from the data custodian. For information on which forms to fill out or what connections are necessary, check out the Infoaccess home page.

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

08/10/94 The new view was created.

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.

A8

A unique number assigned to each person.  The number is always the same for the same person.

A2

A unique number assigned to a time period of military action.

A35

A name assigned to a time period of military action.

A8

The begin date of a time period of military action.

A8

The end date of a time period of military action.

A1

The type of military action.
     Valid values are:
     C = campaign
     W = war

A8

This is the date that this record was loaded to this table.