MILITARY – Military Service History

MILITARY is the Military Service History table in Lawson Personnel (prefix MIL). It is indexed by COMPANY, EMP-APP, EMPLOYEE, BR-SERVICE, SEQ-NBR (MILSET1). It is related 1:1 to APPLICANT, PRSYSTEM, EMPLOYEE and PAEMPLOYEE and 1:M to PACOMMENTS. It is updated by BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 and 37 more and referenced by HR170, HR70.1, PA214, PA231, PA239 and PA311. The table has 11 fields, 1 index and 6 documented relations.

About MILITARY

The Military Service History file contains information on the military history of an employee or applicant.

Column = COBOL field name without the MIL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`MIL-COMPANY` PK COMPANY	Numeric 4	The company number represents an established company.	PA14.1, PA39.1
`MIL-EMP-APP` PK 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 +36 more
`MIL-EMPLOYEE` PK 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 +36 more
`MIL-BR-SERVICE` PK BR_SERVICE	Alpha 2	This field contains the branch of service.	PA14.1, PA39.1
`MIL-SEQ-NBR` PK SEQ_NBR	Numeric 4	Sequence number. Automatically assigned.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +36 more
`MIL-SERV-SPEC` SERV_SPEC	Alpha 20	This field contains the service specialty.	PA14.1, PA39.1
`MIL-YEARS-SERVED` YEARS_SERVED	Numeric 2	This field contains the years served.	PA14.1, PA39.1
`MIL-MNTHS-SERVED` MNTHS_SERVED	Numeric 2	This field contains the months served.	PA14.1, PA39.1
`MIL-RANK-ATTAINED` RANK_ATTAINED	Alpha 3	This field contains the highest rank attained.	PA14.1, PA39.1
`MIL-DISCHG-TYPE` 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` DISCHG_DATE	Numeric 8 (yyyymmdd)	This field contains the discharge date.	PA14.1, PA39.1

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`MILSET1`	`COMPANY`, `EMP-APP`, `EMPLOYEE`, `BR-SERVICE`, `SEQ-NBR`	Primary		BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)

Relation	Table	Rules	Condition	Field map
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`

Relation	Table	Rules	Condition	Field map
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`, → `PAC-DATE`
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`, → `PAC-DATE`