PAINCICOST – Employee Incident Costs

System
Personnel (PA)
Prefix
PAI
Primary key
COMPANY, EMPLOYEE, ESTABLISHMENT, INCIDENT-NBR, SEQ-NBR
Fields
22
Updated by
10 programs
Referenced by
0 programs

PAINCICOST is the Employee Incident Costs table in Lawson Personnel (prefix PAI). It is indexed by COMPANY, EMPLOYEE, ESTABLISHMENT, INCIDENT-NBR, SEQ-NBR (PAISET1); alternate indexes: PAISET2. It is related 1:1 to CUCODES, PRSYSTEM, PCODES, EMPLOYEE, OSHESTAB, GLMASTER, OSHA and PAEMPLOYEE. It is updated by HR00.1, HR01.1, HR11.1, PA115, PA290, PA372, PA490, PA590 and 2 more. The table has 22 fields, 2 indexes and 10 documented relations.

About PAINCICOST

No description in the Lawson data dictionary.

Fields (22)

Column = COBOL field name without the PAI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PAI-COMPANY PK
COMPANY		Numeric 4—PA590, PA90.3
#PAI-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.PA590, PA90.3
#PAI-ESTABLISHMENT PK
ESTABLISHMENT		Alpha 10Contains the establishment where the incident occurred.PA590, PA90.3
#PAI-INCIDENT-NBR PK
INCIDENT_NBR		Numeric 4Contains the incident report number.PA590, PA90.3
#PAI-SEQ-NBR PK
SEQ_NBR		Numeric 4An automatically assigned sequence number.PA590, PA90.3
#PAI-EFFECT-DATE SET2
EFFECT_DATE		Numeric 8 (yyyymmdd)Contains the date for the incident cost.PA590, PA90.3
#PAI-COST-CAT
COST_CAT		Alpha 10Contains the user-defined incident cost category.PA590, PA90.3
#PAI-COST-TYPE
COST_TYPE		Alpha 10Contains the user-defined incident cost type.PA590, PA90.3
#PAI-COST
COST		Signed 11.2Contains the incident cost.PA590, PA90.3
#PAI-EXP-COMPANY
EXP_COMPANY		Numeric 4Contains the distribution expense company where the cost should be posted.PA590, PA90.3
#PAI-EXP-ACCT-UNIT
EXP_ACCT_UNIT		Alpha 15Contains the expense accounting unit where the incident cost should be posted.PA590, PA90.3
#PAI-EXP-ACCOUNT
EXP_ACCOUNT		Numeric 6Contains the expense account where the incident cost should be posted.PA590, PA90.3
#PAI-EXP-SUB-ACCT
EXP_SUB_ACCT		Numeric 4Contains the expense sub account where the incident costs should be posted.PA590, PA90.3
#PAI-COMMENT
COMMENT		Alpha 40 (Lower Case)This field contains the comment narrative.PA590, PA90.3
#PAI-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.PA590, PA90.3
#PAI-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.PA590, PA90.3
#PAI-USER-ID
USER_ID		Alpha 10 (Lower Case)—PA590, PA90.3
#PAI-CURRENCY-CODE
CURRENCY_CODE		Alpha 5Contains the currency in which the incident cost is recorded.PA590, PA90.3
#PAI-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.PA590, PA90.3
#PAI-BASE-CURRENCY
BASE_CURRENCY		Alpha 5Contains the company's base currency.PA590, PA90.3
#PAI-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the company base currency.PA590, PA90.3
#PAI-BASE-AMOUNT
BASE_AMOUNT		Signed 15.2Contains the incident cost in the company's base currency.PA590, PA90.3

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PAISET1
  1. COMPANY
  2. EMPLOYEE
  3. ESTABLISHMENT
  4. INCIDENT-NBR
  5. SEQ-NBR
PrimaryHR00.1, HR01.1, HR11.1, PA115, PA290, PA372, PA490, PA590 +2 more
PAISET2
  1. COMPANY
  2. EMPLOYEE
  3. ESTABLISHMENT
  4. INCIDENT-NBR ↓
  5. EFFECT-DATE ↓
  6. SEQ-NBR ↓
KeyChangePA290, PA90.3

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
CUCODESPRSYSTEMPCODESEMPLOYEEOSHESTABGLMASTEROSHAPAEMPLOYEEPAINCICOST

One to one (10) — lookups and parents

RelationTableRulesConditionField map
Base CurrencyCUCODESRequiredWhen (PAI-CURRENCY-CODE != Spaces)
PAI-BASE-CURRENCY→CUC-CURRENCY-CODE
CompanyPRSYSTEMRequired
PAI-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Cost CategoryPCODESRequiredWhen (PAI-COST-CAT != Spaces)
"OC"→PCO-TYPE
PAI-COST-CAT→PCO-CODE
Cost TypePCODESRequiredWhen (PAI-COST-TYPE != Spaces)
"OT"→PCO-TYPE
PAI-COST-TYPE→PCO-CODE
CurrencyCUCODESRequiredWhen (PAI-CURRENCY-CODE != Spaces)
PAI-CURRENCY-CODE→CUC-CURRENCY-CODE
EmployeeEMPLOYEERequired
PAI-COMPANY→EMP-COMPANY
PAI-EMPLOYEE→EMP-EMPLOYEE
EstablishmentOSHESTABRequiredWhen (PAI-ESTABLISHMENT != Spaces)
PAI-COMPANY→OTB-COMPANY
PAI-ESTABLISHMENT→OTB-ESTABLISHMENT
Expense AcctGLMASTERRequiredWhen (PAI-EXP-ACCT-UNIT != Spaces) Or (PAI-EXP-ACCOUNT != Zeroes)
PAI-EXP-COMPANY→GLM-COMPANY
PAI-EXP-ACCT-UNIT→GLM-ACCT-UNIT
PAI-EXP-ACCOUNT→GLM-ACCOUNT
PAI-EXP-SUB-ACCT→GLM-SUB-ACCOUNT
IncidentOSHARequired
PAI-COMPANY→OSH-COMPANY
PAI-EMPLOYEE→OSH-EMPLOYEE
PAI-ESTABLISHMENT→OSH-ESTABLISHMENT
PAI-INCIDENT-NBR→OSH-SEQ-NBR
PaemployeePAEMPLOYEERequired
PAI-COMPANY→PEM-COMPANY
PAI-EMPLOYEE→PEM-EMPLOYEE

Programs

Updated by (10)