Activity code lookup data
CREATE VIEW vwactivitycodedetails AS (
SELECT activitycodedetails.keyid,
activitycodedetails.id,
activitycodedetails.businessunitid,
activitycodedetails.name,
activitycodedetails.active,
activitycodedetails.defaultcode,
activitycodedetails.category,
activitycodedetails.lengthinminutes,
activitycodedetails.countsaspaidwork,
activitycodedetails.countsasworktime,
activitycodedetails.updated
FROM activitycodedetails
)| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| keyid | varchar(100) | true | Key ID | |||
| id | varchar(50) | true | Primary Key | |||
| businessunitid | varchar(50) | true | Business Unit ID | |||
| name | varchar(50) | true | Name | |||
| active | bit(1) | true | Active | |||
| defaultcode | bit(1) | true | Default Code | |||
| category | varchar(50) | true | Category | |||
| lengthinminutes | integer | true | Length in Minutes | |||
| countsaspaidwork | bit(1) | true | Counts as Paid Work | |||
| countsasworktime | bit(1) | true | Counts as Work Time | |||
| updated | timestamp without time zone | true | Last Updated |
| Name | Columns | Comment | Type |
|---|---|---|---|
| public.activitycodedetails | 11 | Activity Code Lookup Data | BASE TABLE |