Bucketizer
This table lists the time buckets that are available in bucketizer:
Type | Length | PK | FK | Mode | Mandatory | Remarks | |||||
---|---|---|---|---|---|---|---|---|---|---|---|
Table | Field | Read | Write | Delete | Create | Update | |||||
bucket begin | DATE | 3 | X | ||||||||
bucket end | DATE | X | |||||||||
bucket identifier (inactive) | DATE | X | |||||||||
description | STRING | 80 | X | ||||||||
end item | STRING | 80 | 2 | product | code | X | |||||
filler1 | STRING | 1 | X | ||||||||
filler2 | STRING | 1 | X | ||||||||
filler3 | STRING | 1 | X | ||||||||
filler4 | STRING | 1 | X | ||||||||
filler5 | STRING | 1 | X | ||||||||
filler6 | STRING | 1 | X | ||||||||
identifier | DATE | X | |||||||||
model name | STRING | 80 | X | X | |||||||
quantity | REAL | X | |||||||||
resource group | STRING | 80 | 1 | resource group | code | X | |||||
site identifier | STRING | 80 | X | ||||||||
unique key | STRING | 248 | X | [resource group]code (padded with spaces to 80 characters) + end item product (padded with spaces to 80 characters) + bucket begin (internal time format, 8 characters) + version (padded with spaces to 80 characters) | |||||||
unit | STRING | 20 | X | ||||||||
version | NUM | 4 | process step | version | X | ||||||