List of defined time-span elements used by applications to calculate hours-of-operation time calculations.
|
Field |
Data Type |
Reference |
Remarks |
|---|---|---|---|
|
code |
STRING 10 UNIQUE NOT_NULL |
|
|
|
end_day |
STRING 5 |
|
|
|
end_hour |
STRING 5 |
|
|
|
end_minute |
STRING 5 |
|
|
|
end_month |
STRING 5 |
|
|
|
end_year |
STRING 5 |
|
|
|
id |
INTEGER UNIQUE KEY |
|
Unique (to the table) Numeric ID |
|
last_mod_by |
UUID |
ca_contact::uuid |
Specifies the UUID of the contact who last modified this record. |
|
last_mod_dt |
LOCAL_TIME |
|
Indicates the timestamp of when this record was last modified. |
|
nx_desc |
STRING 240 |
|
|
|
start_day |
STRING 5 |
|
|
|
start_hour |
STRING 5 |
|
|
|
start_minute |
STRING 5 |
|
|
|
start_month |
STRING 5 |
|
|
|
start_year |
STRING 5 |
|
|
|
sym |
STRING 30 UNIQUE NOT_NULL |
|
|
|
trigger_day |
STRING 5 |
|
|
|
trigger_hour |
STRING 5 |
|
|
|
trigger_minute |
STRING 5 |
|
|
|
trigger_month |
STRING 5 |
|
|
|
trigger_year |
STRING 5 |
|
|
|
Copyright © 2013 CA.
All rights reserved.
|
|