| id |
integer |
Yes |
Yes |
nextval('payroll_schedules_id_seq'::regclass) |
Unique identifier |
| frequency |
integer |
Yes |
No |
|
Number of pay periods per year |
| dates |
date[] |
Yes |
No |
ARRAY[]::date[] |
End dates for all the pay periods using this frequency |
| descriptions |
character varying[] |
Yes |
No |
ARRAY[]::character varying[] |
Descriptions for all the pay periods for this frequency |
| _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 |
| _created_by |
character varying(3) |
No |
No |
|
User initials that created this record |
| _modified |
timestamp without time zone |
No |
No |
|
UTC Date and time this record was last modified |
| _modified_by |
character varying(3) |
No |
No |
|
User initials that last modified this record |