Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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

HGLM.1    HPOS.1    HPQC.1    HPRS.1    HR54.1    HRS1.1
HRSC.1    PA100     PA102     PA120     PA14.1    PA39.1
PA52.1    PA52.3    PA52.4    PA52.5    PA54.1    PRSC.1
HR11.1    PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MIL-COMPANY            Numeric 4                                 PA14.1  PA39.1
Element: Company       The company number represents an
                       established company.

MIL-EMP-APP            Numeric 1                                 HGLM.1  HPOS.1
Element: Type          Employee/applicant flag.                  HPQC.1  HPRS.1
                       0 = Employee                              HR54.1  HRS1.1
                       1 = Applicant                             HRSC.1  PA100
                                                                 PA102   PA14.1
                                                                 PA39.1  PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PRSC.1

MIL-EMPLOYEE           Numeric 9                                 HGLM.1  HPOS.1
Element: Employee      An employee number is assigned to each    HPQC.1  HPRS.1
                       person employed by the company.  It is    HR54.1  HRS1.1
                       use to correlate all information related  HRSC.1  PA100
                       to the employee.                          PA102   PA14.1
                                                                 PA39.1  PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PRSC.1

MIL-BR-SERVICE         Alpha 2                                   PA14.1  PA39.1
Element: Branch of ServThis field contains the branch of
                       service.

MIL-SEQ-NBR            Numeric 4                                 HGLM.1  HPOS.1
Element: Sequence NumbeSequence number. Automatically assigned.  HPQC.1  HPRS.1
                                                                 HR54.1  HRS1.1
                                                                 HRSC.1  PA100
                                                                 PA102   PA14.1
                                                                 PA39.1  PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PA54.1
                                                                 PRSC.1

MIL-SERV-SPEC          Alpha 20                                  PA14.1  PA39.1
Military Service       This field contains the service
Specialty              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: Months 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: Discharge TypeThis 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: Discharge DateThis field contains the discharge date.

                         MILITARY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MILSET1   COMPANY                                                HGLM.1  HPOS.1
          EMP-APP                                                HPQC.1  HPRS.1
          EMPLOYEE                                               HR11.1  HR170
          BR-SERVICE                                             HR54.1  HR70.1
          SEQ-NBR                                                HRS1.1  HRSC.1
                                                                 PA100   PA102
                                                                 PA115   PA120
                                                                 PA14.1  PA214
                                                                 PA231   PA239
                                                                 PA311   PA39.1
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA54.1  PRSC.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