|
|
PRRATES FILE
Alternate Pay Rates
The Alternate Pay Rates file contains alternate pay rates for an employee.
These can be defined by job code or pay code for an effective date range. When
you enter time records for an hourly employee and you leave the rate field
blank, the system takes the rate from this file if possible; otherwise, it
defaults to the employee rate. At time record entry you can use the Select key
to select rates in this file.
REFERENCED BY
HR170 HR211 HR511 HR70.1 PA02.1 PA100
PA102 PA13.1 PA13.2 PA311 PA502 PA513
PA52.1 PA52.3 PA52.4 PA52.5 PR110 PR113
PR120 PR13.1 PR13.5 PR13.6 PR13.8 BN150
PR128 PR130 PR131 PR132 PR134 PR136
PR29.1 PR32.2 PR33.2 PR33.3 PR35.1 PR35.2
PR35.3 PR35.4 PR35.5 PR35.6 PR35.8 PR35.9
PR36.1 PR45.1 PR529 PR530 PR560 PR82.1
UK102 TA147 TP135
UPDATED BY
HR14.1 HR514 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRR-COMPANY Numeric 4 HR14.1 HR514
Element: Company Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
PRR-EMPLOYEE Numeric 9 HR14.1 HR514
Element: Employee Employee number is assigned to each
person employed by the firm. It is used
to correlate all of the information
related to that person.
PRR-SEQ-NBR Numeric 4 HR14.1 HR514
Element: Sequence NumbeAn automatically assigned sequence
number.
PRR-JOB-CODE Alpha 9 HR14.1 HR514
Element: Job Code Contains the user-defined job code.
PRR-PAY-CODE Alpha 4 HR14.1 HR514
Element: Payment Code Contains the pay code. A pay code is a
user-defined code that identifies a kind
of pay.
PRR-PAY-RATE Signed 13.4 HR14.1 HR514
Element: Rate of Pay Contains an alternate rate of pay for
the employee.
PRR-EFFECT-DATE Numeric 8 (yyyymmdd) HR14.1 HR514
Element: Effective DateContains the effective date of the
alternate pay rate. The effective date
is compared to the time record date when
defaulting the alternate rate.
PRR-END-DATE Numeric 8 (yyyymmdd) HR14.1 HR514
Element: Ending Date Contains the last date the alternate
rate is effective. The ending date is
compared to the time record date when
defaulting the alternate rate.
PRR-POSITION Alpha 12 HR14.1 HR514
Element: Position Contains the user-defined code that
represents a position in the company.
PRR-PROCESS-LEVEL Alpha 5 HR14.1 HR514
Element: Process Lev HrThis field contains the process level,
which is the reporting hierarchy below
company.
PRR-DEPARTMENT Alpha 5 HR14.1 HR514
Element: Department Contains the department.
PRR-CURRENCY-CODE Alpha 5 HR14.1 HR514
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
PRR-CURR-ND Numeric 1 HR14.1 HR514
Account Currency Represents the number of decimals
Code defined for the currency of the object.
PRRATES FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRRSET1 COMPANY HR11.1 HR11.2
EMPLOYEE HR14.1 HR170
SEQ-NBR HR211 HR511
HR514 HR70.1
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA311 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PRRSET2 COMPANY KeyChange BN150 PR128
EMPLOYEE PR130 PR131
JOB-CODE PR132 PR134
POSITION PR136 PR29.1
PROCESS-LEVEL PR32.2 PR33.2
DEPARTMENT PR33.3 PR35.1
PAY-CODE PR35.2 PR35.3
EFFECT-DATE* PR35.4 PR35.5
SEQ-NBR PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 UK102
TA147 TP135
PRRATES FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PRR-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Department DEPTCODE Required
When (PRR-DEPARTMENT != Spaces )
PRR-COMPANY -> DPT-COMPANY
PRR-PROCESS-LEVEL -> DPT-PROCESS-LEVEL
PRR-DEPARTMENT -> DPT-DEPARTMENT
Employee EMPLOYEE Required
PRR-COMPANY -> EMP-COMPANY
PRR-EMPLOYEE -> EMP-EMPLOYEE
Jobcode JOBCODE Required
When PRR-JOB-CODE != Spaces
PRR-COMPANY -> JBC-COMPANY
PRR-JOB-CODE -> JBC-JOB-CODE
Paycode PRPAYCODE Required
When PRR-PAY-CODE != Spaces
PRR-COMPANY -> PCD-COMPANY
PRR-PAY-CODE -> PCD-PAY-CODE
Spaces -> PCD-PROCESS-LEVEL
Spaces -> PCD-JOB-CODE
Process Level PRSYSTEM Required
When (PRR-PROCESS-LEVEL != Spaces )
PRR-COMPANY -> PRS-COMPANY
PRR-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
PRRATES FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Position PAPOSITION
Valid When (PRR-POSITION != Spaces )
PRR-COMPANY -> POS-COMPANY
PRR-POSITION -> POS-POSITION
POS-EFFECT-DATE
|
