MILITARY

Military Service History

The Military Service History file contains information on the military history of an employee or applicant.
UPDATED BY
BN305 HAP3.1 HCRE.1 HEP4.1 HPOS.1 HPQC.1
HPRS.1 HR11.1 HR11.2 HR170 HR28.1 HR511
HR54.1 HR70.1 HRS1.1 HRSC.1 LT101 ZH510
PA02.1 PA100 PA102 PA115 PA120 PA13.1
PA13.2 PA14.1 PA214 PA231 PA239 PA311
PA39.1 PA502 PA513 PA52.1 PA52.3 PA52.4
PA52.5 PA54.1 PR110 PR113 PR12.6 PR120
PR13.1 PR13.5 PR13.6 PR13.8 PR13.9 PR30.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MIL-COMPANY
Element: Company Hr		Numeric 4
The company number represents an established company.
PA14.1 PA39.1
MIL-EMP-APP
Element: Emp App		Numeric 1
Employee/applicant flag.
0 = Employee
1 = Applicant
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR28.1
HR511 HR54.1
HRS1.1 HRSC.1
LT101 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA14.1
PA39.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
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.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR28.1
HR511 HR54.1
HRS1.1 HRSC.1
LT101 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA14.1
PA39.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
MIL-BR-SERVICE
Element: Br Service		Alpha 2
This field contains the branch of service.
PA14.1 PA39.1
MIL-SEQ-NBR
Element: Seq Nbr		Numeric 4
Sequence number. Automatically assigned.
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR28.1
HR511 HR54.1
HRS1.1 HRSC.1
LT101 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA14.1
PA39.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA54.1
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
ZH510
MIL-SERV-SPEC
Element: Serv Spec		Alpha 20
This field contains the service specialty.
PA14.1 PA39.1
MIL-YEARS-SERVED
Element: Years Served		Numeric 2
This field contains the years served.
PA14.1 PA39.1
MIL-MNTHS-SERVED
Element: Mnths Served		Numeric 2
This field contains the months served.
PA14.1 PA39.1
MIL-RANK-ATTAINED
Element: Rank Attained		Alpha 3
This field contains the highest rank attained.
PA14.1 PA39.1
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
PA14.1 PA39.1
MIL-DISCHG-DATE
Element: Dischg Date		Numeric 8 (yyyymmdd)
This field contains the discharge date.
PA14.1 PA39.1


MILITARY FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MILSET1 COMPANY
EMP-APP
EMPLOYEE
BR-SERVICE
SEQ-NBR
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR170
HR28.1 HR511
HR54.1 HR70.1
HRS1.1 HRSC.1
LT101 ZH510
PA02.1 PA100
PA102 PA115
PA120 PA13.1
PA13.2 PA14.1
PA214 PA231
PA239 PA311


MILITARY FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED 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

File created: Thu Jun 09 11:22:04 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.