Lawson Insight Technical Documentation |
|
MILITARY
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
BN305 HAP3.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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MIL-COMPANY Numeric 4 PA14.1 PA39.1
Element: Company Hr The company number represents an
established company.
MIL-EMP-APP Numeric 1 BN305 HAP3.1
Element: Emp App Employee/applicant flag. HEP4.1 HPOS.1
0 = Employee HPQC.1 HPRS.1
1 = Applicant 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
MIL-EMPLOYEE Numeric 9 BN305 HAP3.1
Element: Employee An employee number is assigned to each HEP4.1 HPOS.1
person employed by the company. It is HPQC.1 HPRS.1
use to correlate all information related HR11.1 HR11.2
to the employee. 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
MIL-BR-SERVICE Alpha 2 PA14.1 PA39.1
Element: Br Service This field contains the branch of
service.
MIL-SEQ-NBR Numeric 4 BN305 HAP3.1
Element: Seq Nbr Sequence number. Automatically assigned. 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
MIL-SERV-SPEC Alpha 20 PA14.1 PA39.1
Element: Serv Spec This field contains the service
specialty.
MIL-YEARS-SERVED Numeric 2 PA14.1 PA39.1
Element: Years Served This field contains the years served.
MIL-MNTHS-SERVED Numeric 2 PA14.1 PA39.1
Element: Mnths Served This field contains the months served.
MIL-RANK-ATTAINED Alpha 3 PA14.1 PA39.1
Element: Rank Attained This field contains the highest rank
attained.
MIL-DISCHG-TYPE Alpha 1 PA14.1 PA39.1
Element: Dischg 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
Element: Dischg Date This field contains the discharge date.
MILITARY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MILSET1 COMPANY BN305 HAP3.1
EMP-APP HEP4.1 HPOS.1
EMPLOYEE HPQC.1 HPRS.1
BR-SERVICE HR11.1 HR11.2
SEQ-NBR 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 PA52.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
|