Military Service History
The Military Service History file contains information on the military history of an employee or applicant.
REFERENCED BY
HR170 | HR70.1 | PA214 | PA231 | PA239 | PA311 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
MIL-COMPANY Element: Company Hr | Numeric 4 The company number represents an established company. |
|
||
MIL-EMP-APP Element: Emp App | Numeric 1 Employee/applicant flag. 0 = Employee 1 = Applicant |
|||
MIL-EMPLOYEE Element: Employee | Numeric 9 An employee number is assigned to each person employed by the company. It is use to correlate all information related to the employee. |
|||
MIL-BR-SERVICE Element: Br Service | Alpha 2 This field contains the branch of service. |
|
||
MIL-SEQ-NBR Element: Seq Nbr | Numeric 4 Sequence number. Automatically assigned. |
|||
MIL-SERV-SPEC Element: Serv Spec | Alpha 20 This field contains the service specialty. |
|
||
MIL-YEARS-SERVED Element: Years Served | Numeric 2 This field contains the years served. |
|
||
MIL-MNTHS-SERVED Element: Mnths Served | Numeric 2 This field contains the months served. |
|
||
MIL-RANK-ATTAINED Element: Rank Attained | Alpha 3 This field contains the highest rank attained. |
|
||
MIL-DISCHG-TYPE Element: Dischg Type | Alpha 1 This field contains the discharge type. D = Dishonorable H = Honorable L = Less Honorable M = Medical O = Other |
|
||
MIL-DISCHG-DATE Element: Dischg Date | Numeric 8 (yyyymmdd) This field contains the discharge date. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||
---|---|---|---|---|---|---|---|---|---|
MILSET1 |
COMPANY EMP-APP EMPLOYEE BR-SERVICE SEQ-NBR |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Applicant | APPLICANT |
Required
| ||||||||||||
Company | PRSYSTEM |
Required
| ||||||||||||
Employee | EMPLOYEE |
Required
| ||||||||||||
Pa Employee | PAEMPLOYEE |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
App Comments | PACOMMENTS |
Delete Cascades
| |||||||||||||||||||||||||||||||||
Emp Comments | PACOMMENTS |
Delete Cascades
|
All trademarks and registered trademarks are the property of their
respective owners.