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
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 PA372 PA590
ESTABLISHMENT PA90.1 PA90.3
INCIDENT-NBR PR197
SEQ-NBR
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
|
