Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             EMPCODES FILE

                        Emp/App Personnel Codes

The Emp/App Personnel Codes file is a multi-purpose file containing the
following records.

Employee and applicant certification
Employee company property
Employee and applicant education
Employee benefits
Employee and applicant relocation
Employee and applicant skill

Records in this file are differentiated by the values in the EPC-TYPE and
EPC-EMP-APP fields as described below. Many of the fields in this file have
different meanings depending on the type of record. This file is maintained by
the Personnel system.

REFERENCED BY

HR15.1    HR155     HR170     HR511     HR55.2    HR650
HR70.1    HS11.1    HS12.1    HS13.1    HS14.1    HS50.1
HS50.2    HS50.3    HS50.4    HS51.1    HS51.2    HS52.1
HS52.2    PA216     PA220     PA221     PA222     PA224
PA225     PA231     PA234     PA235     PA236     PA238
PA262     PA263     PA311     PA502     PA513     PA62.1
PA63.1    PA64.1    PA64.2    PA65.1    PA65.2    TR120
TR121     TR20.1    TR20.2    TR20.3    PR13.1    PR13.5
PR13.6    PR13.8    HR04.2    HR04.3    HR04.7    HR04.8
HR80.1    HR80.2    HR80.3    HR80.4    HR80.5    HR80.6
HR80.7    HR80.8    HR80.9    HR81.1    HR81.2    HR81.3
HR81.4    HR81.5    HR81.6    HR81.7    HR81.8    HR81.9
HR82.1    HR82.2    HR82.3    HR82.4    HR82.5    HR82.6
HR82.7    HR82.8    HR82.9    HR83.1    HR83.2    HR83.3
HR83.4    HR83.5    HR83.6    HR83.7    HR83.8    HR83.9
HR84.1    HR84.2    HR84.3    HR84.4    HR84.5    HR84.6
HR84.7    HR84.8    HR84.9    HR85.1    HR85.2    HR85.3
HR85.4    HR85.5    HR85.6    HR85.7    HR85.8    HR86.1
HR86.2    HR86.3    HR86.4    HR86.5    HR86.6    HR86.7
HR86.8    HR86.9    HR87.1    HR87.2    HR87.3    HR87.4
HR87.5    HR87.6    HR87.7    HR87.8    HR87.9    HR88.1
HR88.2    HR88.3    HR88.4    HR88.5    HR88.6    HR88.7
HR89.1    HR89.2    HR89.3    HR89.4    HR89.5    HR89.6
HR89.7

UPDATED BY

HR54.1    HRS1.1    HRSC.1    PA120     PA16.1    PA25.1
PA54.1    TR22.1    TR500

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

EPC-COMPANY          Numeric 4                                   PA16.1  PA25.1
Company              Contains the company number represents      TR22.1  TR500
                     an  established company.

EPC-TYPE             Alpha 2                                     PA16.1  PA25.1
Type                 This field indicates the kind of            TR22.1  TR500
                     information stored in the record.
                     BN = Benefit Codes
                     CE = Certifications
                     CN = Contracts
                     CP = Company Property
                     ED = Education
                     RL = Relocation
                     SK = Skills
                     AB = Ability
                     KN = Knowledge
                     OA = Other Attributes

EPC-EMP-APP          Numeric 1                                   HR54.1  HRS1.1
Type                 This field contains the employee            HRSC.1  HS50.1
                     applicant indicator.                        HS50.2  HS51.1
                     0 = Employee                                HS51.2  HS52.1
                     1 = Applicant                               HS52.2  PA54.1
                                                                 TR120   TR121
                                                                 TR20.1  TR20.2
                                                                 TR20.3  TR22.1
                                                                 TR500

EPC-EMPLOYEE         Numeric 9                                   HR54.1  HRS1.1
Employee             Contains the employee Number                HRSC.1  HS50.1
                                                                 HS50.2  HS51.1
                                                                 HS51.2  HS52.1
                                                                 HS52.2  PA16.1
                                                                 PA25.1  PA54.1
                                                                 TR120   TR121
                                                                 TR20.1  TR20.2
                                                                 TR20.3  TR22.1
                                                                 TR500

EPC-CODE             Alpha 10                                    PA16.1  PA25.1
Code                 This is the name of the code being          TR22.1  TR500
                     described.  All codes must be valid in
                     PCODES.  Valid values are:

                     ED = Education Degree.
                     CP = Property.
                     SK = Skill.
                     CE = Certification.
                     RL = Relocation.
                     BN = Benefit.

EPC-SUBJECT          Alpha 10                                    TR22.1  TR500
Subject              This field is only filled on "ED"
                     (education records) and contains the
                     subject for the degree.  The subject
                     code must be valid in PCODES.


EPC-SEQ-NBR          Numeric 4                                   HR54.1  HRS1.1
Sequence Number      This field is filled for "CP"               HRSC.1  PA16.1
                     (property), "ED" (education Degree), and    PA54.1  TR22.1
                     "SK" (skill) records only and is            TR500
                     automatically assigned.

EPC-DATE-ACQUIRED    Numeric 8  (yyyymmdd)                       PA16.1  TR22.1
Date Acquired        Contains the following:                     TR500

                     - the date the certificate was acquired,
                     - the date skill was acquired, or
                     - the date property was issued.

                     This field is used only for CE
                     (Certifications), CP (Company Property),
                     and SK (Skill).

EPC-RENEW-DATE       Numeric 8  (yyyymmdd)                       PA16.1  TR22.1
License Renewal Date This field contains the following           TR500
                     information:

                     CE = Certificate renewal date.
                     CP = Anticipated return date.
                     ED = Degree completion date.
                     BN = Zeroes.
                     RL = Zeroes.
                     SK = Date skill was last used.

EPC-PER-RATING       Signed 5.2                                  TR22.1  TR500
Performance Rating   This is a user-defined field and is
                     only filled for types "ED" (education
                     degree) and "SK" (skill).

EPC-INSTRUCTOR       Alpha 10                                    TR22.1  TR500
Instructor           This field contains the following
                     information:

                     CE = Spaces.
                     CP = Spaces.
                     ED = Education Institution.
                     BN = Spaces.
                     RL = Spaces.
                     SK = Skill Instructor.

EPC-CO-SPONSORED     Alpha 1                                     TR22.1  TR500
Company Sponsored    This field is filled for types "CE"
                     (certification), "ED" (education
                     degree), and "SK" (skill).
                     Y = Yes
                     N = No

EPC-IN-PRO-FLAG      Alpha 1                                     PA25.1  TR22.1
In Process Flag      This field can contain the following        TR500
                     information:

                     CE = Spaces.
                     CP = Spaces.
                     ED = Education in process.
                     BN = Dependent coverage.
                     RL = Relocation status.
                     SK = Space.
                              (R - Requests transfer
                                     W - Will transfer
                                     N - Will not transfer)
                     Y = Yes
                     N = No

EPC-LIC-NUMBER       Alpha 20                                    TR22.1  TR500
License Number       This field is filled only for "CE"
                     (certification) and contains the
                     certification license number.

EPC-COST             Signed 11.2                                 TR22.1  TR500
Cost                 This field is filled only for "CE"
                     (certification) and contains the cost of
                     obtaining the certification.

EPC-RENEWAL-CODE     Alpha 2
Renewal Cycle        This field is only filled for "CE"
                     (certification).
                     2Y = 2 Years
                     3Y = 3 Years
                     4Y = 4 Years
                     5Y = 5 Years
                     6Y = 6 Years
                     7Y = 7 Years
                     8Y = 8 Years
                     9Y = 9 Years
                     AN = Annual
                     QT = Quarterly
                     SA = Semi-annual

EPC-COMPONENT        Numeric 4                                   PA16.1  TR22.1
Component            This field is only filled for "CP"          TR500
                     (certification) and gives the component
                     number of the property issued.

EPC-PROP-VALUE       Signed 7.2                                  PA16.1  TR22.1
Property Value       This field is only filled for "CP"          TR500
                     (property) and gives the value of the
                     company property.

EPC-PA-ASSET-NBR     Alpha 9  (Lower Case)                       PA16.1  TR22.1
Pa Asset Nbr         Contains the asset number of the            TR500
                     property issued.

EPC-DATE-RETURNED    Numeric 8  (yyyymmdd)                       PA16.1  TR22.1
Date Returned        This field is only filled for "CP"          TR500
                     (property) and is the date the company
                     property was returned.

EPC-VERIFIED-FLAG    Alpha 1                                     TR22.1  TR500
Verified Flag        This field is only filled for "ED"
                     (education degree) for an applicant's
                     record.  It indicates if an applicant's
                     education degree has been verified.
                     N = No
                     Y = Yes

EPC-PRIORITY-CODE    Numeric 1                                   TR22.1  TR500
Priority Code        This field is only filled for "RL"
                     (relocation) and with the statuses of
                     "R" (requests transfer) or "W" (will
                     transfer).

EPC-SKILL-SOURCE     Alpha 10                                    TR22.1  TR500
Skill Source         This field is only filled for "SK"
                     (Skill).  The skill source must be valid
                     in PCODES.

EPC-PROFIC-LEVEL     Alpha 10                                    TR22.1  TR500
Profic Level         Contains the proficiency level of the
                     skill.

EPC-OBJ-ID           Numeric 12                                  TR22.1  TR500
Object               This is the object identifier. It is
Identification       used to relate commitments or posted
                     transactions back to the originating
                     subsystems. Each subsystem record that
                     is updated as a commitment or posted
                     transaction is assigned an object
                     identifier. The object identifier is
                     maintained in the subsystem files and in
                     the Activity Commitments Detail and
                     Activity Transaction files. The object
                     identifier is a unique key used to drill
                     back from Activity Management to the
                     subsystems.

EPC-CURRENCY-CODE    Alpha 5                                     PA16.1  TR22.1
Currency Code        Contains the currency in which the cost     TR500
                     is recorded.

EPC-CURR-ND          Numeric 1                                   PA16.1  TR22.1
Currency Number of   Represents the number of decimals           TR500
Decimals             defined for the currency of the object.

EPC-BASE-AMOUNT      Signed 15.2                                 PA16.1  TR22.1
Base Amount          Contains the amount in the company's        TR500
                     base currency.

EPC-BASE-CURRENCY    Alpha 5                                     PA16.1  TR22.1
Base Currency        The company base currency.                  TR500

EPC-BASE-ND          Numeric 1                                   PA16.1  TR22.1
Base Number Of       The number of decimal positions defined     TR500
Decimals             for the company base currency.

EPC-DATE-STAMP       Numeric 8  (yyyymmdd)                       PA16.1  PA25.1
Date Stamp           This field contains the server date         TR22.1  TR500
                     (month, date, and year) of the last
                     change to this record.

EPC-TIME-STAMP       Numeric 6  (hhmmss)                         PA16.1  PA25.1
Time Stamp           Contains the server time (hour, minute,     TR22.1  TR500
                     and second) when the record was last
                     changed.

EPC-USER-ID          Alpha 10  (Lower Case)                      PA16.1  PA25.1
User ID Name         Contains the user ID of the person who      TR22.1  TR500
                     last changed this record.

EPC-STATE            Alpha 2                                     TR22.1  TR500
State or Province    This field contains the two-character
                     state code of the address.


EPC-DESCRIPTION      Alpha 30  (Lower Case)                      TR22.1  TR500
Description          This field displays the description.

EPC-WF-VERIFY        Derived
Wf Verify            This is a derived field.

                         EMPCODES FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

EPCSET1   COMPANY                                                HR15.1  HR155
          TYPE                                                   HR170   HR511
          EMP-APP                                                HR54.1  HR55.2
          EMPLOYEE                                               HR650   HR70.1
          CODE                                                   HRS1.1  HRSC.1
          SUBJECT                                                HS11.1  HS12.1
          SEQ-NBR                                                HS13.1  HS14.1
                                                                 HS50.1  HS50.2
                                                                 HS50.3  HS50.4
                                                                 HS51.1  HS51.2
                                                                 HS52.1  HS52.2
                                                                 PA120   PA16.1
                                                                 PA216   PA220
                                                                 PA221   PA222
                                                                 PA224   PA225
                                                                 ...

EPCSET2   COMPANY                                                HR04.2  HR04.3
          TYPE                                                   HR04.7  HR04.8
          EMP-APP                                                HR80.1  HR80.2
          CODE                                                   HR80.3  HR80.4
          EMPLOYEE                                               HR80.5  HR80.6
          SUBJECT                                                HR80.7  HR80.8
          SEQ-NBR                                                HR80.9  HR81.1
                                                                 HR81.2  HR81.3
                                                                 HR81.4  HR81.5
                                                                 HR81.6  HR81.7
                                                                 HR81.8  HR81.9
                                                                 HR82.1  HR82.2
                                                                 HR82.3  HR82.4
                                                                 HR82.5  HR82.6
                                                                 HR82.7  HR82.8
                                                                 ...

EPCSET3   COMPANY       Subset                                   HR170   HR70.1
          EMP-APP       Where (TYPE = "AB" )
          EMPLOYEE      Or    (TYPE = "KN" )
          TYPE          Or    (TYPE = "OA" )
          CODE          Or    (TYPE = "SK" )
          SUBJECT
          SEQ-NBR*

EPCSET4   COMPANY       Subset                                   HR15.1  HR155
          TYPE          Where TYPE = "ED"                        HR511   HR54.1
          EMP-APP                                                HR55.2  HR650
          EMPLOYEE                                               HRS1.1  HRSC.1
          SUBJECT                                                PA16.1  PA262
          CODE                                                   PA263   PA502
          SEQ-NBR                                                PA513   PA54.1
                                                                 PA62.1  PA63.1
                                                                 TR22.1  TR500
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

EPCSET5   COMPANY       KeyChange, Subset
          TYPE          Where TYPE = "ED"
          EMP-APP
          EMPLOYEE
          RENEW-DATE
          CODE
          SUBJECT
          SEQ-NBR

EPCSET6   OBJ-ID        Subset
          COMPANY       Where (OBJ-ID != Zeroes )
          EMP-APP
          EMPLOYEE
          TYPE
          CODE

EPCSET7   COMPANY       KeyChange, Subset                        HS50.1  HS50.2
          EMP-APP       Where((TYPE != "BN" )                    HS51.1  HS51.2
          EMPLOYEE      And   (TYPE != "RL" ))                   HS52.1  HS52.2
          TYPE                                                   TR120   TR121
          CODE                                                   TR20.1  TR20.2
          DATE-ACQUIRED*                                         TR20.3  TR22.1
          SUBJECT                                                TR500
          SEQ-NBR

                         EMPCODES FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Applicant      APPLICANT    Required
                            When EPC-EMP-APP = 1

                            EPC-COMPANY          -> APL-COMPANY
                            EPC-EMPLOYEE         -> APL-APPLICANT

Base Currency  CUCODES      Required
                            When (EPC-CURRENCY-CODE != Spaces )

                            EPC-BASE-CURRENCY    -> CUC-CURRENCY-CODE

Company        PRSYSTEM     Required

                            EPC-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Contract       PCODES       Required
                            When (EPC-TYPE = "CN" )

                            "C"                  -> PCO-TYPE
                            EPC-CODE             -> PCO-CODE

Currency       CUCODES      Required
                            When (EPC-CURRENCY-CODE != Spaces )

                            EPC-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Employee       EMPLOYEE     Required
                            When EPC-EMP-APP = Zeroes

                            EPC-COMPANY          -> EMP-COMPANY
                            EPC-EMPLOYEE         -> EMP-EMPLOYEE

Hr Code        PCODES       Required

                            EPC-TYPE             -> PCO-TYPE
                            EPC-CODE             -> PCO-CODE

Institution    PCODES       Required
                            When EPC-TYPE       =  "ED"
                            And  EPC-INSTRUCTOR != Spaces

                            "EI"                 -> PCO-TYPE
                            EPC-INSTRUCTOR       -> PCO-CODE

Skill Source   PCODES       Required
                            When EPC-SKILL-SOURCE != Spaces

                            "SS"                 -> PCO-TYPE
                            EPC-SKILL-SOURCE     -> PCO-CODE

Subject        PCODES       Required
                            When EPC-SUBJECT != Spaces

                            "ES"                 -> PCO-TYPE
                            EPC-SUBJECT          -> PCO-CODE

                         EMPCODES FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Course Skills  PAATTRIB
                            Valid When EPC-TYPE = "SK"

                            EPC-TYPE             -> TRB-TYPE
                            EPC-CODE             -> TRB-CODE
                                                    TRB-COURSE

Track Cert     PATRACK
                            Valid When EPC-TYPE = "CE"

                            EPC-CODE             -> TRA-CERT-ACHIEVED
                                                    TRA-TRACK
                                                    TRA-EFFECTIVE-DATE