|
|
PAINCICOST FILE
Incident Costs
Contains incident cost information. This file is maintained primarily by
PA90.3 (Incident Costs).
REFERENCED BY
PA290
UPDATED BY
HR700 PA372 PA590 PA90.1 PA90.3 HR00.1
HR01.1 HR11.1 PA115 PBIP.1
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 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 HR700 PA590
Currency Code Contains the currency in which the PA90.3
incident cost is recoreded.
PAI-CURR-ND Numeric 1 HR700 PA590
Currency Number of Represents the number of decimals PA90.3
Decimals defined for the currency of the object.
PAI-BASE-CURRENCY Alpha 5 HR700 PA590
Base Currency Contains the company's base currency. PA90.3
PAI-BASE-ND Numeric 1 HR700 PA590
Base Number Of The number of decimal positions defined PA90.3
Decimals for the company base currency.
PAI-BASE-AMOUNT Signed 15.2 HR700 PA590
Base Amount Contains the incident cost in the PA90.3
company's base currency.
PAINCICOST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAISET1 COMPANY HR00.1 HR01.1
EMPLOYEE HR11.1 HR700
ESTABLISHMENT PA115 PA372
INCIDENT-NBR PA590 PA90.1
SEQ-NBR PA90.3 PBIP.1
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
|