- DATA VIEW NAME
- MILITARY_MSN
- 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 Madison campus. After 11/20/2009 the data in this view will no longer be refreshed due to federal changes in reporting for veterans.
- LOAD FREQUENCY
- The data in this view was being refreshed on the first and third Saturday of every month, with the last update being 11/20/2009.
- DATA CUSTODIAN
- Equity and Diversity Resource Center
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 - QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 08/10/94 The new view was created.
- 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. |
| 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: |
| LOADDATE | A8 | This is the date that this record was loaded to the table. |