PAINCICOST

Employee Incident Costs

Contains incident cost information. This file is maintained primarily by PA90.3 (Incident Costs).
UPDATED BY
PA290 PA372 PA490 PA590 PA90.1 PA90.3
HR00.1 HR01.1 HR11.1 PA115

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAI-COMPANY
Element: Company Hr
Numeric 4
PA590 PA90.3
PAI-EMPLOYEE
Element: Employee
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
Element: Establishment
Alpha 10
Contains the establishment where the incident occurred.
PA590 PA90.3
PAI-INCIDENT-NBR
Element: Incident Nbr
Numeric 4
Contains the incident report number.
PA590 PA90.3
PAI-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
PA590 PA90.3
PAI-EFFECT-DATE
Element: Effect Date
Numeric 8 (yyyymmdd)
Contains the date for the incident cost.
PA590 PA90.3
PAI-COST-CAT
Element: Cost Cat
Alpha 10
Contains the user-defined incident cost category.
PA590 PA90.3
PAI-COST-TYPE
Element: Cost Type
Alpha 10
Contains the user-defined incident cost type.
PA590 PA90.3
PAI-COST
Element: Cost
Signed 11.2
Contains the incident cost.
PA590 PA90.3
PAI-EXP-COMPANY
Element: Company
Numeric 4
Contains the distribution expense company where the cost should be posted.
PA590 PA90.3
PAI-EXP-ACCT-UNIT
Element: Acct Unit
Alpha 15
Contains the expense accounting unit where the incident cost should be posted.
PA590 PA90.3
PAI-EXP-ACCOUNT
Element: Account
Numeric 6
Contains the expense account where the incident cost should be posted.
PA590 PA90.3
PAI-EXP-SUB-ACCT
Element: Sub Acct
Numeric 4
Contains the expense sub account where the incident costs should be posted.
PA590 PA90.3
PAI-COMMENT
Element: Comment
Alpha 40 (Lower Case)
This field contains the comment narrative.
PA590 PA90.3
PAI-DATE-STAMP
Element: 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
Element: 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
Element: User
Alpha 10 (Lower Case)
PA590 PA90.3
PAI-CURRENCY-CODE
Element: Currency Code
Alpha 5
Contains the currency in which the incident cost is recorded.
PA590 PA90.3
PAI-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
PA590 PA90.3
PAI-BASE-CURRENCY
Element: Base Currency
Alpha 5
Contains the company's base currency.
PA590 PA90.3
PAI-BASE-ND
Element: Base Nd
Numeric 1
The number of decimal positions defined for the company base currency.
PA590 PA90.3
PAI-BASE-AMOUNT
Element: Base Amt
Signed 15.2
Contains the incident cost in the company's base currency.
PA590 PA90.3


PAINCICOST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAISET1 COMPANY
EMPLOYEE
ESTABLISHMENT
INCIDENT-NBR
SEQ-NBR
HR00.1 HR01.1
HR11.1 PA115
PA290 PA372
PA490 PA590
PA90.1 PA90.3
PAISET2 COMPANY
EMPLOYEE
ESTABLISHMENT
INCIDENT-NBR*
EFFECT-DATE*
SEQ-NBR*
KeyChange
PA290 PA90.3


PAINCICOST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


File created: Thu Jun 09 02:24:58 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.