Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAEMPCOSTS


                            PAEMPCOSTS FILE

                             Employee Costs

Contains employee cost and account reference information. TR12.1 (Employee
Costs) is the primary program that updates this file.

REFERENCED BY

TR210

UPDATED BY

TR12.1    HR11.1    PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

EMC-COMPANY            Numeric 4                                 TR12.1
Element: Company       Contains the company number.

EMC-EMPLOYEE           Numeric 9                                 TR12.1
Element: Employee      Contains the employee number.

EMC-COURSE             Alpha 10                                  TR12.1
Element: Course Code   Contains the course code.

EMC-COST-TYPE          Alpha 10                                  TR12.1
Element: Cost Type     Contains the specific cost
                       classification.

EMC-DATE               Numeric 8  (yyyymmdd)                     TR12.1
Element: Date          Contains the date of the cost.

EMC-COST-CAT           Alpha 10                                  TR12.1
Element: Cost Category Contains the general cost
                       classification.

EMC-COST               Signed 11.2                               TR12.1
Element: Cost          Contains the amount of the cost.

EMC-DIST-COMPANY       Numeric 4                                 TR12.1
Element: Distribution CContains the distribution company to
                       which a cost could be posted.

EMC-DST-ACCT-UNIT      Alpha 15                                  TR12.1
Distribution           Contains the general ledger accounting
Account Unit           unit to which the amount could be
                       posted.

EMC-DST-ACCOUNT        Numeric 6                                 TR12.1
Element: Distribution AContains the general ledger account to
                       which the amount could be posted.

EMC-DST-SUB-ACCT       Numeric 4                                 TR12.1
Distribution           Contains the general ledger subaccount
Subaccount             to which the amount could be posted.

EMC-COST-DESIGNATR     Alpha 1                                   TR12.1
Element: Actual or BudgIndicates whether the cost is actual or
                       budgeted.
                       A = Actual
                       B = Budget

EMC-CURRENCY-CODE      Alpha 5                                   TR12.1
Element: Currency Code Contains the currency in which the cost
                       is recorded.

EMC-CURR-ND            Numeric 1                                 TR12.1
Element: Acct Nd       The number of decimals assigned to a
                       particular account as determined by the
                       account currency.


EMC-BASE-CURRENCY      Alpha 5                                   TR12.1
Element: Base Currency Contains the training system's base
                       currency.

EMC-BASE-ND            Numeric 1                                 TR12.1
Element: Base Nd       Indicates the number of decimal
                       positions defined for the training
                       system's base currency.

EMC-BASE-AMOUNT        Signed 15.2                               TR12.1
Element: Base Amt      Contains the cost in the training
                       system's base  currency.

                         PAEMPCOSTS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

EMCSET1   COMPANY                                                HR11.1  PA115
          EMPLOYEE                                               TR12.1  TR210
          COURSE
          DATE
          COST-TYPE
          COST-CAT

EMCSET2   COURSE                                                 TR210
          COMPANY
          EMPLOYEE
          COST-TYPE
          COST-CAT
          DATE

                         PAEMPCOSTS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accounts       GLMASTER     Not Required
                            Valid When (EMC-DIST-COMPANY  != Zeroes )
                                  And  (EMC-DST-ACCT-UNIT != Spaces )
                                  And  (EMC-DST-ACCOUNT   != Zeroes )

                            EMC-DIST-COMPANY     -> GLM-COMPANY
                            EMC-DST-ACCT-UNIT    -> GLM-ACCT-UNIT
                            EMC-DST-ACCOUNT      -> GLM-ACCOUNT
                            EMC-DST-SUB-ACCT     -> GLM-SUB-ACCOUNT

Base Currency  CUCODES      Required
                            When EMC-CURRENCY-CODE != Spaces

                            EMC-BASE-CURRENCY    -> CUC-CURRENCY-CODE

Category       PCODES       Not Required
                            Valid When EMC-COST-CAT != Spaces

                            "MC"                 -> PCO-TYPE
                            EMC-COST-CAT         -> PCO-CODE

Company        PRSYSTEM     Required

                            EMC-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Currency       CUCODES      Required
                            When EMC-CURRENCY-CODE != Spaces

                            EMC-CURRENCY-CODE    -> CUC-CURRENCY-CODE

Employee       EMPLOYEE     Required

                            EMC-COMPANY          -> EMP-COMPANY
                            EMC-EMPLOYEE         -> EMP-EMPLOYEE

Paemployee     PAEMPLOYEE   Required

                            EMC-COMPANY          -> PEM-COMPANY
                            EMC-EMPLOYEE         -> PEM-EMPLOYEE

Type           PCODES       Required
                            When EMC-COST-TYPE != Spaces

                            "MT"                 -> PCO-TYPE
                            EMC-COST-TYPE        -> PCO-CODE

                         PAEMPCOSTS FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Course         PACOURSE     Required

                            EMC-COURSE           -> CRS-COURSE
                                                    CRS-EFFECTIVE-DATE