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 HR511 HR54.1 HRS1.1
HRSC.1 PA02.1 PA100 PA102 PA115 PA120
PA13.1 PA13.2 PA14.1 PA39.1 PA502 PA513
PA52.1 PA52.3 PA52.4 PA52.5 PA54.1 PR110
PR113 PR120 PR13.1 PR13.5 PR13.6 PR13.8
PR13.9 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.
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 HR511
HR54.1 HRS1.1
HRSC.1 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
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
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 HR511
HR54.1 HRS1.1
HRSC.1 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
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
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 HR511
HR54.1 HRS1.1
HRSC.1 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
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
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
HR511 HR54.1
HR70.1 HRS1.1
HRSC.1 PA02.1
PA100 PA102
PA115 PA120
PA13.1 PA13.2
PA14.1 PA214
PA231 PA239
PA311 PA39.1
PA502 PA513


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: Wed Jun 08 20:50:21 2016

Home
Contact Us



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