|
|
PAINCICOST FILE
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 PBIP.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAI-COMPANY Numeric 4 PA590 PA90.3
Element: Company The company number represents an
established company and is entered on
all function codes.
PAI-EMPLOYEE Numeric 9 PA590 PA90.3
Element: 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
Element: Establishment Contains the establishment where the
incident occurred.
PAI-INCIDENT-NBR Numeric 4 PA590 PA90.3
Element: Incident Nbr Contains the incident report number.
PAI-SEQ-NBR Numeric 4 PA590 PA90.3
Element: Sequence NumbeAn automatically assigned sequence
number.
PAI-EFFECT-DATE Numeric 8 (yyyymmdd) PA590 PA90.3
Element: Date Contains the date for the incident cost.
PAI-COST-CAT Alpha 10 PA590 PA90.3
Element: Cost Cat Contains the user-defined incident cost
category.
PAI-COST-TYPE Alpha 10 PA590 PA90.3
Element: Cost Type Contains the user-defined incident cost
type.
PAI-COST Signed 11.2 PA590 PA90.3
Element: Cost Contains the incident cost.
PAI-EXP-COMPANY Numeric 4 PA590 PA90.3
Element: Exp Company Contains the distribution expense
company where the cost should be posted.
PAI-EXP-ACCT-UNIT Alpha 15 PA590 PA90.3
Element: Accounting UniContains the expense accounting unit
where the incident cost should be
posted.
PAI-EXP-ACCOUNT Numeric 6 PA590 PA90.3
Element: Account Contains the expense account where the
incident cost should be posted.
PAI-EXP-SUB-ACCT Numeric 4 PA590 PA90.3
Element: Subaccount Contains the expense sub account where
the incident costs should be posted.
PAI-COMMENT Alpha 40 (Lower Case) PA590 PA90.3
Element: Comment Line This field contains the comment
narrative.
PAI-DATE-STAMP Numeric 8 (yyyymmdd) PA590 PA90.3
Element: 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
Element: 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
Element: User
PAI-CURRENCY-CODE Alpha 5 PA590 PA90.3
Element: Currency Code Contains the currency in which the
incident cost is recorded.
PAI-CURR-ND Numeric 1 PA590 PA90.3
Account Currency
Code
PAI-BASE-CURRENCY Alpha 5 PA590 PA90.3
To Company Base Contains the company's base currency.
Currency
PAI-BASE-ND Numeric 1 PA590 PA90.3
Account Currency
Code
PAI-BASE-AMOUNT Signed 15.2 PA590 PA90.3
Element: Adj Amt 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 PA290 PA372
INCIDENT-NBR PA490 PA590
SEQ-NBR PA90.1 PA90.3
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
|
