Definition of table call-event

Table Description

One entry per event for a call

Table Dump Name: call-evt

Alphabetical Field Summary

call-event-id: (INTG) Internally assigned call event #
call-log-id: (INTG) Call Log ID
contact-date: (DATE) Date Site was contacted regarding this event
contact-id: (INTG) Site person contacted regarding this event
contact-time: (INTG) Time person was contacted
cre-date: (DATE) Date of record creation
cre-time: (CHAR) Time of record creation
cre-user-name: (CHAR) Login name of user who created the record
event-date: (DATE) Date of this event occured
event-description: (CHAR) Description of this event
event-duration: (INTG) Duration of the event
event-printed: (LOGC) Set when the even is printed and/or reported
event-time: (INTG) Time event took place
private-event: (LOGC) Yes if this event is 'private' (vs public)
site-contacted: (LOGC) Was the site notified as part of this event?
staff-id: (INTG) Staff member who produced the event
upd-date: (DATE) Date of records last modification
upd-time: (CHAR) Time of records last modification
upd-user-name: (CHAR) Login name of user who last modified the record

Alphabetical Index Summary

call-by-contact: contact-id, call-log-id, call-event-id
call-by-date: event-date, event-time, call-event-id
call-event: (PRIMARY) call-log-id, event-date, event-time, call-event-id
event-description: event-description
unprinted-event: event-printed, private-event, upd-date, upd-time, call-log-id, call-event-id

Alphabetical Trigger Summary

CREATE: Overridable, Procedure is tr-c-cev.p
DELETE: Overridable, Procedure is tr-d-cev.p
WRITE: Overridable, Procedure is tr-u-cev.p

Tables call-event references

call-browse - Denormalized Call Log Browsing table
call-log - Log of customer calls
contact - Site Contacts
dev-request-call - List of call logs associated with this request
staff - Support Staff

Detailed Alphabetical Field Listing

call-event-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Internally assigned call event #
Attributes: Index Component

call-log-id Data type: INTEGER
Format: zzzzzzzz9
Help: Call Log ID
Attributes: Index Component

contact-date Data type: DATE
Format: 99/99/9999
Help: Date Site was contacted regarding this event

contact-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Site person contacted regarding this event
Attributes: Index Component

contact-time Data type: INTEGER
Format: zzzzz9
Help: Time person was contacted

cre-date Data type: DATE
Format: 99/99/9999 (Initial Value: TODAY)
Description: Date of record creation

cre-time Data type: CHARACTER
Format: X(8)
Description: Time of record creation

cre-user-name Data type: CHARACTER
Format: x(16)
Description: Login name of user who created the record

event-date Data type: DATE
Format: 99/99/9999
Help: Date of this event occured
Attributes: Index Component

event-description Data type: CHARACTER
Format: x(60)
Help: Description of this event
Attributes: Index Component

event-duration Data type: INTEGER
Format: zzzzzz9 (Initial Value: 0)
Help: Duration of the event

event-printed Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Description: Set when the even is printed and/or reported
Attributes: Index Component

event-time Data type: INTEGER
Format: zzzzz9
Help: Time event took place
Attributes: Index Component

private-event Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes if this event is 'private' (vs public)
Attributes: Index Component

site-contacted Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Was the site notified as part of this event?

staff-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Staff member who produced the event

upd-date Data type: DATE
Format: 99/99/9999 (Initial Value: TODAY)
Description: Date of records last modification
Attributes: Index Component

upd-time Data type: CHARACTER
Format: X(8)
Description: Time of records last modification
Attributes: Index Component

upd-user-name Data type: CHARACTER
Format: x(16)
Description: Login name of user who last modified the record