PRRATES

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
BN305 HR170 HR211 HR28.1 HR511 HR70.1
LT101 LT111 ZH510 PA02.1 PA100 PA102
PA13.1 PA13.2 PA311 PA502 PA513 PA52.1
PA52.3 PA52.4 PA52.5 PR110 PR113 PR12.6
PR120 PR13.1 PR13.5 PR13.6 PR13.8 PR13.9
PR30.2 PR512 BN150 PR521 EXI2.1 EXI4.1
LP130 PR128 PR131 PR132 PR134 PR135
PR136 PR137 PR189 PR29.1 PR32.1 PR32.2
PR33.1 PR33.2 PR33.3 PR35.1 PR35.2 PR35.3
PR35.4 PR35.5 PR35.6 PR35.8 PR35.9 PR36.1
PR36.4 PR37.1 PR45.1 PR529 PR530 PR560
PR582 PR80.1 PR80.4 PR82.1 UK102 TA147


UPDATED BY
HR14.1 HR514 HR11.1 PA115

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRR-COMPANY
Element: Company Hr		Numeric 4
HR14.1 HR514
PRR-EMPLOYEE
Element: Employee		Numeric 9
Employee number is assigned to each person employed by the firm. It is used to correlate all of the information related to that person.
HR14.1 HR514
PRR-SEQ-NBR
Element: Seq Nbr		Numeric 4
An automatically assigned sequence number.
HR14.1 HR514
PRR-JOB-CODE
Element: Job Code		Alpha 9
Contains the user-defined job code.
HR14.1 HR514
PRR-PAY-CODE
Element: Pay Code		Alpha 4
Contains the pay code. A pay code is a user-defined code that identifies a kind of pay.
HR14.1 HR514
PRR-PAY-RATE
Element: Pay Rate		Signed 13.4
Contains an alternate rate of pay for the employee.
HR14.1 HR514
PRR-EFFECT-DATE
Element: Effect Date		Numeric 8 (yyyymmdd)
Contains the effective date of the alternate pay rate. The effective date is compared to the time record date when defaulting the alternate rate.
HR14.1 HR514
PRR-END-DATE
Element: End Date		Numeric 8 (yyyymmdd)
Contains the last date the alternate rate is effective. The ending date is compared to the time record date when defaulting the alternate rate.
HR14.1 HR514
PRR-POSITION
Element: Position		Alpha 12
Contains the user-defined code that represents a position in the company.
HR14.1 HR514
PRR-PROCESS-LEVEL
Element: Process Lev Hr		Alpha 5
HR14.1 HR514
PRR-DEPARTMENT
Element: Department		Alpha 5
Contains the department.
HR14.1 HR514
PRR-CURRENCY-CODE
Element: Currency Code		Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
HR14.1 HR514
PRR-CURR-ND
Element: Acct Nd		Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
HR14.1 HR514
PRR-CREATE-DATE
Element: Date Stamp		Numeric 8 (yyyymmdd)
HR14.1 HR514
PRR-CREATE-TIME
Element: Time Stamp		Numeric 6 (hhmmss)
Time of Creation
HR14.1 HR514
PRR-CREATE-USER-ID
Element: User Id		Alpha 10 (Lower Case)
User Id of record creator.
HR14.1 HR514
PRR-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
HR14.1 HR514
PRR-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
HR14.1 HR514
PRR-USER-ID
Element: User Id		Alpha 10 (Lower Case)
HR14.1 HR514


PRRATES FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRRSET1 COMPANY
EMPLOYEE
SEQ-NBR
...
BN305 HR11.1
HR11.2 HR11.4
HR14.1 HR170
HR211 HR28.1
HR511 HR514
HR70.1 LT101
LT111 ZH510
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA311 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PRRSET2 COMPANY
EMPLOYEE
JOB-CODE
POSITION
PROCESS-LEVEL
DEPARTMENT
PAY-CODE
EFFECT-DATE*
SEQ-NBR
KeyChange
...
BN150 PR521
EXI2.1 EXI4.1
LP130 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 PR29.1
PR32.1 PR32.2
PR33.1 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR36.4 PR37.1


PRRATES FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Position PAPOSITION
Valid When (PRR-POSITION !=Spaces )
PRR-COMPANY->POS-COMPANY
PRR-POSITION->POS-POSITION
  POS-EFFECT-DATE

File created: Thu Jun 09 02:30:41 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.