|
|
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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAI-COMPANY Numeric 4 PA590 PA90.3
Element: Company Hr
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: Seq Nbr An automatically assigned sequence
number.
PAI-EFFECT-DATE Numeric 8 (yyyymmdd) PA590 PA90.3
Element: Effect 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: Company Contains the distribution expense
company where the cost should be posted.
PAI-EXP-ACCT-UNIT Alpha 15 PA590 PA90.3
Element: Acct Unit Contains 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: Sub Acct Contains the expense sub account where
the incident costs should be posted.
PAI-COMMENT Alpha 40 (Lower Case) PA590 PA90.3
Element: Comment 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
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
PAI-BASE-CURRENCY Alpha 5 PA590 PA90.3
Element: Base Currency Contains the company's base currency.
PAI-BASE-ND Numeric 1 PA590 PA90.3
Element: Base Nd The number of decimal positions defined
for the company base currency.
PAI-BASE-AMOUNT Signed 15.2 PA590 PA90.3
Element: Base 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
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 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
|
