Previous Topic: Task_Type TableNext Topic: Timezone Table


Timespan Table

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