public.activitycodedetails
Description
Activity Code Lookup Data
Columns
| keyid |
varchar(100) |
|
false |
|
|
|
| id |
varchar(50) |
|
true |
|
|
|
| businessunitid |
varchar(50) |
|
true |
|
|
|
| name |
varchar(50) |
|
true |
|
|
|
| active |
bit(1) |
|
true |
|
|
|
| defaultcode |
bit(1) |
|
true |
|
|
|
| category |
varchar(50) |
|
true |
|
|
|
| lengthinminutes |
integer |
|
true |
|
|
|
| countsaspaidwork |
bit(1) |
|
true |
|
|
|
| countsasworktime |
bit(1) |
|
true |
|
|
|
| updated |
timestamp without time zone |
|
true |
|
|
|
Constraints
| activitycodedetails_pkey |
PRIMARY KEY |
PRIMARY KEY (keyid) |
Indexes
| activitycodedetails_pkey |
CREATE UNIQUE INDEX activitycodedetails_pkey ON
public.activitycodedetails USING btree (keyid) |
Related Articles
public.vwactivitycodedetails
Description See activitycodes table Table Definition CREATE VIEW vwactivitycodedetails AS ( SELECT activitycodedetails.keyid, activitycodedetails.id, activitycodedetails.businessunitid, activitycodedetails.name, activitycodedetails.active, ...
public.vwtimeoffdata
Description See TimeOffData - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwtimeoffdata AS ( SELECT td.userid, td.buid, td.scheduleid, td.businessunitdate, td.length, td.description, td.activitycode, td.paid, ...
public.vwscheduledatacomplete
Description Combined view of schedule data and full-day time-off data - Use this view to see complete schedule including users on time-off Table Definition CREATE VIEW vwscheduledatacomplete AS ( SELECT sc.scheduleid, sc.userid, sc.shiftid, ...
public.vwscheduledata
Description See ScheduleData - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwscheduledata AS ( SELECT sc.scheduleid, sc.userid, sc.shiftid, sc.shiftstartdate, sc.shiftstartdateltc, sc.shiftlengthtime, sc.activitystartdate, ...
public.z_wfmscheduledata
Description See WFMScheduleData: Data combining schedule and time off information Table Definition CREATE VIEW z_wfmscheduledata AS ( SELECT sc.userid, sc.shiftstartdate, sc.shiftlengthtime, sc.activitystartdate, sc.activitystartdateltc, ...