MILITARY – Military Service History

System
Personnel (PA)
Prefix
MIL
Primary key
COMPANY, EMP-APP, EMPLOYEE, BR-SERVICE, SEQ-NBR
Fields
11
Updated by
45 programs
Referenced by
6 programs

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.

Fields (11)

Column = COBOL field name without the MIL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#MIL-COMPANY PK
COMPANY		Numeric 4The company number represents an established company.PA14.1, PA39.1
#MIL-EMP-APP PK
EMP_APP		Numeric 1Employee/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 9An 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 2This field contains the branch of service.PA14.1, PA39.1
#MIL-SEQ-NBR PK
SEQ_NBR		Numeric 4Sequence 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 20This field contains the service specialty.PA14.1, PA39.1
#MIL-YEARS-SERVED
YEARS_SERVED		Numeric 2This field contains the years served.PA14.1, PA39.1
#MIL-MNTHS-SERVED
MNTHS_SERVED		Numeric 2This field contains the months served.PA14.1, PA39.1
#MIL-RANK-ATTAINED
RANK_ATTAINED		Alpha 3This field contains the highest rank attained.PA14.1, PA39.1
#MIL-DISCHG-TYPE
DISCHG_TYPE		Alpha 1This 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

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MILSET1
  1. COMPANY
  2. EMP-APP
  3. EMPLOYEE
  4. BR-SERVICE
  5. SEQ-NBR
PrimaryBN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
APPLICANTPRSYSTEMEMPLOYEEPAEMPLOYEEPACOMMENTSMILITARY

One to one (4) — lookups and parents

RelationTableRulesConditionField map
ApplicantAPPLICANTRequiredWhen MIL-EMP-APP = 1
MIL-COMPANY→APL-COMPANY
MIL-EMPLOYEE→APL-APPLICANT
CompanyPRSYSTEMRequired
MIL-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequiredWhen MIL-EMP-APP = Zeroes
MIL-COMPANY→EMP-COMPANY
MIL-EMPLOYEE→EMP-EMPLOYEE
Pa EmployeePAEMPLOYEERequiredWhen MIL-EMP-APP = Zeroes
MIL-COMPANY→PEM-COMPANY
MIL-EMPLOYEE→PEM-EMPLOYEE

One to many (2) — child tables

RelationTableRulesConditionField map
App CommentsPACOMMENTSDelete CascadesValid 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 CommentsPACOMMENTSDelete CascadesValid 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

Programs

Updated by (45)

Referenced by (6)