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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
PAI-COMPANY PKCOMPANY | Numeric 4 | — | PA590, PA90.3 |
PAI-EMPLOYEE PKEMPLOYEE | Numeric 9 | Contains 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 PKESTABLISHMENT | Alpha 10 | Contains the establishment where the incident occurred. | PA590, PA90.3 |
PAI-INCIDENT-NBR PKINCIDENT_NBR | Numeric 4 | Contains the incident report number. | PA590, PA90.3 |
PAI-SEQ-NBR PKSEQ_NBR | Numeric 4 | An automatically assigned sequence number. | PA590, PA90.3 |
PAI-EFFECT-DATEEFFECT_DATE | Numeric 8 (yyyymmdd) | Contains the date for the incident cost. | PA590, PA90.3 |
PAI-COST-CATCOST_CAT | Alpha 10 | Contains the user-defined incident cost category. | PA590, PA90.3 |
PAI-COST-TYPECOST_TYPE | Alpha 10 | Contains the user-defined incident cost type. | PA590, PA90.3 |
PAI-COSTCOST | Signed 11.2 | Contains the incident cost. | PA590, PA90.3 |
PAI-EXP-COMPANYEXP_COMPANY | Numeric 4 | Contains the distribution expense company where the cost should be posted. | PA590, PA90.3 |
PAI-EXP-ACCT-UNITEXP_ACCT_UNIT | Alpha 15 | Contains the expense accounting unit where the incident cost should be posted. | PA590, PA90.3 |
PAI-EXP-ACCOUNTEXP_ACCOUNT | Numeric 6 | Contains the expense account where the incident cost should be posted. | PA590, PA90.3 |
PAI-EXP-SUB-ACCTEXP_SUB_ACCT | Numeric 4 | Contains the expense sub account where the incident costs should be posted. | PA590, PA90.3 |
PAI-COMMENTCOMMENT | Alpha 40 (Lower Case) | This field contains the comment narrative. | PA590, PA90.3 |
PAI-DATE-STAMPDATE_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-STAMPTIME_STAMP | Numeric 6 (hhmmss) | Contains the server time (hour, minute, and second) when the record was last changed. | PA590, PA90.3 |
PAI-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | PA590, PA90.3 |
PAI-CURRENCY-CODECURRENCY_CODE | Alpha 5 | Contains the currency in which the incident cost is recorded. | PA590, PA90.3 |
PAI-CURR-NDCURR_ND | Numeric 1 | The number of decimals assigned to a particular account as determined by the account currency. | PA590, PA90.3 |
PAI-BASE-CURRENCYBASE_CURRENCY | Alpha 5 | Contains the company's base currency. | PA590, PA90.3 |
PAI-BASE-NDBASE_ND | Numeric 1 | The number of decimal positions defined for the company base currency. | PA590, PA90.3 |
PAI-BASE-AMOUNTBASE_AMOUNT | Signed 15.2 | Contains the incident cost in the company's base currency. | PA590, PA90.3 |
Indexes (2)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PAISET1 | COMPANY, EMPLOYEE, ESTABLISHMENT, INCIDENT-NBR, SEQ-NBR | Primary | HR00.1, HR01.1, HR11.1, PA115, PA290, PA372, PA490, PA590 +2 more | |
PAISET2 | COMPANY, EMPLOYEE, ESTABLISHMENT, INCIDENT-NBR*, EFFECT-DATE*, SEQ-NBR* | KeyChange | PA290, PA90.3 |
Relations
One to one (10) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Base Currency | CUCODES | Required | When (PAI-CURRENCY-CODE != Spaces) | PAI-BASE-CURRENCY → CUC-CURRENCY-CODE |
| Company | PRSYSTEM | Required | PAI-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL | |
| Cost Category | PCODES | Required | When (PAI-COST-CAT != Spaces) | "OC" → PCO-TYPE, PAI-COST-CAT → PCO-CODE |
| Cost Type | PCODES | Required | When (PAI-COST-TYPE != Spaces) | "OT" → PCO-TYPE, PAI-COST-TYPE → PCO-CODE |
| Currency | CUCODES | Required | When (PAI-CURRENCY-CODE != Spaces) | PAI-CURRENCY-CODE → CUC-CURRENCY-CODE |
| Employee | EMPLOYEE | Required | PAI-COMPANY → EMP-COMPANY, PAI-EMPLOYEE → EMP-EMPLOYEE | |
| Establishment | OSHESTAB | Required | When (PAI-ESTABLISHMENT != Spaces) | PAI-COMPANY → OTB-COMPANY, PAI-ESTABLISHMENT → OTB-ESTABLISHMENT |
| Expense Acct | GLMASTER | Required | When (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 |
| Incident | OSHA | Required | PAI-COMPANY → OSH-COMPANY, PAI-EMPLOYEE → OSH-EMPLOYEE, PAI-ESTABLISHMENT → OSH-ESTABLISHMENT, PAI-INCIDENT-NBR → OSH-SEQ-NBR | |
| Paemployee | PAEMPLOYEE | Required | PAI-COMPANY → PEM-COMPANY, PAI-EMPLOYEE → PEM-EMPLOYEE |