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
Account Currency
Code

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

EMC-BASE-ND            Numeric 1                                 TR12.1
Account Currency       Indicates the number of decimal
Code                   positions defined for the training
                       system's base currency.

EMC-BASE-AMOUNT        Signed 15.2                               TR12.1
Element: Adj 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

                            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

                            "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

Type           PCODES       Required

                            "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