| id |
integer |
Yes |
Yes |
nextval('employee_roe_details_id_seq'::regclass) |
|
| employee_roes_id |
integer |
Yes |
No |
|
Link to employee_roes.id |
| sequence |
integer |
Yes |
No |
|
Sequence number for display order |
| type |
character varying(1) |
No |
No |
|
Pay type for this record as per CRA specs; I = Insurable earnings H = Statutory holiday pay O = Other monies S = Special payments |
| code |
character varying(5) |
No |
No |
|
ROE pay code as per CRA specs |
| start_date |
date |
No |
No |
|
Start date for pay record |
| end_date |
date |
No |
No |
|
End date for pay record |
| amount |
numeric(8,2) |
No |
No |
|
Amount for pay record |
| hours |
numeric(6,2) |
No |
No |
|
Number of hours for pay record |
| period |
character varying(1) |
No |
No |
|
Period code for record; "" = Not applicable D = Per Day W = Per Week |
| _modified_by |
character varying(3) |
No |
No |
|
User initials that modified this record |
| _created_by |
character varying(3) |
No |
No |
|
User initials that created this record |
| _modified |
timestamp without time zone |
No |
No |
|
UTC Date and time record was last modified |
| _dbversion |
integer |
No |
No |
|
Program version that last modified this record |
| _created |
timestamp without time zone |
No |
No |
|
UTC Date and time record was created |