PR
PRRecordOfEmployment
PX.Objects.PR27 of 27 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
RefNbr | nvarchar(15) | Reference Nbr. (Block 1) | - | |
Description:No description available | ||||
AddressID | int | Address ID | Address | |
Description:No description available | ||||
AmendedRefNbr | nvarchar(15) | Amended ROE Ref. Nbr. (Block 2) | - | |
Description:No description available | ||||
Amendment | bit | Amendment | - | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
Comments | nvarchar(128) | Comments (Block 18) | - | |
Description:No description available | ||||
CRAPayrollAccountNumber | varchar(15) | CRA Payroll Account Number (Block 5) | - | |
Description:No description available | ||||
CreatedByID | 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:No description available | ||||
EmployeeID | int | Employee | Vendor | |
Description:No description available | ||||
FinalPayPeriodEndingDate | datetime2 | Final Pay Period Ending Date (Block 12) | - | |
Description:No description available | ||||
FirstDayWorked | datetime2 | First Day Worked (Block 10) | - | |
Description:No description available | ||||
LastDayForWhichPaid | datetime2 | Last Day for Which Paid (Block 11) | - | |
Description:No description available | ||||
LastModifiedByID | 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 | - | |
Description:No description available | ||||
OrigRefNbr | nvarchar(15) | Original Document | PRPayment | |
Description:No description available | ||||
PeriodType | char(2) | Period Type (Block 6) | - | |
Description:No description available | ||||
ReasonForROE | char(3) | Reason for ROE (Block 16) | - | |
Description:No description available | ||||
Status | char(3) | Status | - | |
Description:No description available | ||||
TotalInsurableEarnings | decimal(19, 6) | Total Insurable Earnings (Block 15B) | - | |
Description:No description available | ||||
TotalInsurableHours | decimal(19, 6) | Total Insurable Hours (Block 15A) | - | |
Description:No description available | ||||
VacationPay | decimal(19, 6) | Vacation Pay (Block 17A) | - | |
Description:No description available | ||||