MILITARY FILE
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
UPDATED BY
HR54.1 HR700 HRS1.1 HRSC.1 PA100 PA102
PA115 PA120 PA14.1 PA39.1 PA52.1 PA52.3
PA52.4 PA52.5 PA54.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MIL-COMPANY Numeric 4 PA14.1 PA39.1
Company CThe company number represents an
established company.
MIL-EMP-APP Numeric 1 HR54.1 HR700
Type Employee/applicant flag. HRS1.1 HRSC.1
0 = Employee PA100 PA102
1 = Applicant PA14.1 PA39.1
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1
MIL-EMPLOYEE Numeric 9 HR54.1 HR700
Employee An employee number is assigned to each HRS1.1 HRSC.1
person employed by the company. It is PA100 PA102
use to correlate all information related PA14.1 PA39.1
to the employee. PA52.1 PA52.3
PA52.4 PA52.5
PA54.1
MIL-BR-SERVICE Alpha 2 PA14.1 PA39.1
Branch of Service This field contains the branch of
service.
MIL-SEQ-NBR Numeric 4 HR54.1 HR700
Sequence Number Sequence number. Automatically assigned. HRS1.1 HRSC.1
PA100 PA102
PA14.1 PA39.1
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1
MIL-SERV-SPEC Alpha 20 PA14.1 PA39.1
Military Service This field contains the service
Specialty specialty.
MIL-YEARS-SERVED Numeric 2 PA14.1 PA39.1
Years Served This field contains the years served.
MIL-MNTHS-SERVED Numeric 2 PA14.1 PA39.1
Months Served This field contains the months served.
MIL-RANK-ATTAINED Alpha 3 PA14.1 PA39.1
Rank Attained This field contains the highest rank
attained.
MIL-DISCHG-TYPE Alpha 1 PA14.1 PA39.1
Discharge Type This field contains the discharge type.
D = Dishonorable
H = Honorable
L = Less Honorable
M = Medical
O = Other
MIL-DISCHG-DATE Numeric 8 (yyyymmdd) PA14.1 PA39.1
Discharge Date This field contains the discharge date.
MILITARY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MILSET1 COMPANY HR170 HR54.1
EMP-APP HR70.1 HR700
EMPLOYEE HRS1.1 HRSC.1
BR-SERVICE PA100 PA102
SEQ-NBR PA115 PA120
PA14.1 PA214
PA231 PA239
PA311 PA39.1
PA52.1 PA52.3
PA52.4 PA52.5
PA54.1
MILITARY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Applicant APPLICANT Required
When MIL-EMP-APP = 1
MIL-COMPANY -> APL-COMPANY
MIL-EMPLOYEE -> APL-APPLICANT
Company PRSYSTEM Required
MIL-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
When MIL-EMP-APP = Zeroes
MIL-COMPANY -> EMP-COMPANY
MIL-EMPLOYEE -> EMP-EMPLOYEE
Pa Employee PAEMPLOYEE Required
When MIL-EMP-APP = Zeroes
MIL-COMPANY -> PEM-COMPANY
MIL-EMPLOYEE -> PEM-EMPLOYEE
MILITARY FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
App Comments PACOMMENTS Delete Cascades
Valid When MIL-EMP-APP = 1
MIL-COMPANY -> PAC-COMPANY
MIL-EMP-APP -> PAC-EMP-APP
"MI" -> PAC-CMT-TYPE
MIL-EMPLOYEE -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
PAC-LN-NBR
PAC-SEQ-NBR
Emp Comments PACOMMENTS Delete Cascades
Valid When MIL-EMP-APP = Zeroes
MIL-COMPANY -> PAC-COMPANY
MIL-EMP-APP -> PAC-EMP-APP
"MI" -> PAC-CMT-TYPE
MIL-EMPLOYEE -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
PAC-LN-NBR
PAC-SEQ-NBR
|