PRRecordOfEmployment

PX.Objects.PRScreenPR303000Release 2025.2

Stores the record of employment information that was generated from the final paycheck or created manually.

Select a row for its description 27 of 27 fields

	Field Name	Type	Display Name	Foreign Key
	`AddressID`Default Navigation	`int`	Address ID	Address
Description:The unique identifier of the address where the employee resided at the time of the record of employment's creation. The field is included in FK.Address. The value of this field corresponds to the value of the Address.AddressID field.
	`AmendedRefNbr`	`nvarchar(15)`	Amended ROE Ref. Nbr. (Block 2)	-
Description:The user-friendly unique identifier of the amendment to which the current record of employment refers, if any.
	`Amendment`	`bit`	Amendment	-
Description:A boolean value that specifies (if set to true) that the payment associated with the record of employment is of the amendment type.
	`BranchID`Default Navigation	`int`	Branch	Branch
Description:The unique identifier of the branch to which the employee belonged. The field is included in FK.Branch. The value of this field corresponds to the value of the Branch.BranchID field.
	`CRAPayrollAccountNumber`	`nvarchar(15)`	CRA Payroll Account Number (Block 5)	-
Description:The unique identifier of the payroll account number for the employee which is provided by the Canadian Revenue Agency.
	`Comments`	`nvarchar(128)`	Comments (Block 18)	-
Description:A field to hold optional comments.
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`		-
Description:No description available
	`DocDesc`	`nvarchar(128)`	Description	-
Description:The description of the payment referenced by the record of employment.
	`EmployeeID`Default Navigation	`int`	Terminated Employee (Block 9)	PREmployee
Description:The unique identifier of the employee for which the record of employment was generated. The field is included in FK.PREmployee. The value of this field corresponds to the value of the BAccount.BAccountID field.
	`FinalPayPeriodEndingDate`	`datetime`	Final Pay Period Ending Date (Block 12)	-
Description:The last of the working pay period during which the employee received their last paycheck.
	`FirstDayWorked`	`datetime`	First Day Worked (Block 10)	-
Description:The date of the employee's first day of employment.
	`LastDayForWhichPaid`	`datetime`	Last Day for Which Paid (Block 11)	-
Description:The date upon which the employee received their last paycheck.
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime`	`datetime`		-
Description:No description available
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`OrigDocType`	`char(3)`	Original Doc. Type	PRPayment
Description:The type of the payment for which the record of employment was originally generated. The field is included in FK.PRPayment. The value of this field corresponds to the value of the PRPayment.DocType field. The field can have one of the values described in PayrollType.ListAttribute.
	`OrigRefNbr`	`nvarchar(15)`	Original Document	PRPayment
Description:The user-friendly unique identifier of the payment for which the record of employment was originally generated. The field is included in FK.PRPayment. The value of this field corresponds to the value of the PRPayment.RefNbr field.
	`PeriodType`	`char(2)`	Period Type (Block 6)	-
Description:The frequency at which the employee was being paid. The field can have one of the values described in PayPeriodType.ROEListAttribute.
	`ReasonForROE`	`char(3)`	Reason for ROE (Block 16)	-
Description:The reason why the employee was terminated. The field can have one of the values described in ROEReason.ListAttribute.
	`RefNbr`Default Navigation	`nvarchar(15)`	Reference Nbr. (Block 1)	-
Description:The user-friendly unique identifier of the record of employment.
	`Status`	`char(3)`	Status	-
Description:The status of the record of employment. The field can have one of the values described in ROEStatus.ListAttribute.
	`TotalInsurableEarnings`	`decimal`	Total Insurable Earnings (Block 15B)	-
Description:The total amount of earnings which the employee has received.
	`TotalInsurableHours`	`decimal`	Total Insurable Hours (Block 15A)	-
Description:The total amount of hours the employee has worked and for which they were paid.
	`VacationPay`	`decimal`	Vacation Pay (Block 17A)	-
Description:The amount disbursed as unclaimed vacation time remaining at the moment of termination, if any.