Audit Table for WFM Schedule Change Data
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| keyid | varchar(150) | false | Primary Key | |||
| modifiedby | varchar(50) | true | Schedule GUID | |||
| scheduleid | varchar(50) | true | ||||
| addorremove | varchar(10) | true | Schedule Change Type | |||
| datemodified | timestamp without time zone | true | Schedule Date Changed (UTC) | |||
| datemodifiedltc | timestamp without time zone | true | Schedule Date Changed (LTC) | |||
| agentid | varchar(50) | true | Schedule Change User GUID | |||
| updated | timestamp without time zone | true | Date Row Updated (UTC) |
| Name | Type | Definition |
|---|---|---|
| wfmauditdata_key | PRIMARY KEY | PRIMARY KEY (keyid) |
| Name | Definition |
|---|---|
| wfmauditdata_key | CREATE UNIQUE INDEX wfmauditdata_key ON public.wfmauditdata USING btree (keyid) |