PAINCICOST FILE
Contains incident cost information. This file is maintained primarily by
PA90.3 (Incident Costs).
REFERENCED BY
PA290
UPDATED BY
PA372 PA590 PA90.1 PA90.3 HR00.1 HR01.1
HR11.1 PA115 PBIP.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAI-COMPANY Numeric 4 PA590 PA90.3
Company The company number represents an
established company and is entered on
all function codes.
PAI-EMPLOYEE Numeric 9 PA590 PA90.3
Employee 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.
PAI-ESTABLISHMENT Alpha 10 PA590 PA90.3
Establishment Contains the establishment where the
incident occurred.
PAI-INCIDENT-NBR Numeric 4 PA590 PA90.3
Incident Nbr Contains the incident report number.
PAI-SEQ-NBR Numeric 4 PA590 PA90.3
Sequence Number An automatically assigned sequence
number.
PAI-EFFECT-DATE Numeric 8 (yyyymmdd) PA590 PA90.3
Effective Date Contains the date for the incident cost.
PAI-COST-CAT Alpha 10 PA590 PA90.3
Cost Cat Contains the user-defined incident cost
category.
PAI-COST-TYPE Alpha 10 PA590 PA90.3
Cost Type Contains the user-defined incident cost
type.
PAI-COST Signed 11.2 PA590 PA90.3
Cost Contains the incident cost.
PAI-EXP-COMPANY Numeric 4 PA590 PA90.3
Exp Company Contains the distribution expense
company where the cost should be posted.
PAI-EXP-ACCT-UNIT Alpha 15 PA590 PA90.3
Expense Accounting Contains the expense accounting unit
Unit where the incident cost should be
posted.
PAI-EXP-ACCOUNT Numeric 6 PA590 PA90.3
Expense Account Contains the expense account where the
incident cost should be posted.
PAI-EXP-SUB-ACCT Numeric 4 PA590 PA90.3
Depr Expense Contains the expense sub account where
Subaccount the incident costs should be posted.
PAI-COMMENT Alpha 40 (Lower Case) PA590 PA90.3
Comment Line This field contains the comment
narrative.
PAI-DATE-STAMP Numeric 8 (yyyymmdd) PA590 PA90.3
Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
PAI-TIME-STAMP Numeric 6 (hhmmss) PA590 PA90.3
Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
PAI-USER-ID Alpha 10 (Lower Case) PA590 PA90.3
User ID Name Contains the user ID of the person who
last changed this record.
PAI-CURRENCY-CODE Alpha 5 PA590 PA90.3
Currency Code Contains the currency in which the
incident cost is recorded.
PAI-CURR-ND Numeric 1 PA590 PA90.3
Currency Number of Represents the number of decimals
Decimals defined for the currency of the object.
PAI-BASE-CURRENCY Alpha 5 PA590 PA90.3
Base Currency Contains the company's base currency.
PAI-BASE-ND Numeric 1 PA590 PA90.3
Base Number Of The number of decimal positions defined
Decimals for the company base currency.
PAI-BASE-AMOUNT Signed 15.2 PA590 PA90.3
Base Amount Contains the incident cost in the
company's base currency.
PAINCICOST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAISET1 COMPANY HR00.1 HR01.1
EMPLOYEE HR11.1 PA115
ESTABLISHMENT PA372 PA590
INCIDENT-NBR PA90.1 PA90.3
SEQ-NBR PBIP.1 PR197
PAISET2 COMPANY KeyChange PA290 PA90.3
EMPLOYEE
ESTABLISHMENT
INCIDENT-NBR*
EFFECT-DATE*
SEQ-NBR*
PAINCICOST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 PCODES Required
When (PAI-ESTABLISHMENT != Spaces )
"ET" -> PCO-TYPE
PAI-ESTABLISHMENT -> PCO-CODE
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
|
