PR
PRROEInsurableEarningsByPayPeriod
Stores the insurable earnings for each pay period related to the record of employment.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
InsurableEarnings | decimal | Insurable Earnings | - | |
Description:The amount of earnings which the employee has received. | ||||
InsurableHours | decimal | Insurable Hours | - | |
Description:The amount of hours the employee has worked and for which they were paid. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
PayPeriodID | nvarchar(6) | Pay Period ID | - | |
Description:The pay period. The field is included in FK.RecordOfEmployment. | ||||
RefNbr | nvarchar(15) | Reference Nbr. | PRRecordOfEmployment | |
Description:The user-friendly unique identifier of the record of employment. The field is included in FK.RecordOfEmployment. The value of this field corresponds to the value of the PRRecordOfEmployment.RefNbr field. | ||||
TStamp | timestamp | - | ||
Description:No description available | ||||