Definition of table call-log

Table Description

Log of customer calls

Table Dump Name: call-log

Alphabetical Field Summary

assigned-staff-id: (INTG) Insternal Staff ID this call is assigned to (if any)
assigned-staff-order: (INTG) Order of this call for the assigned person
billable: (LOGC) Yes if this call is billable
billable-po-num: (CHAR) PO Number, if any, for this billable call
billing-summary: (CHAR) Notes about the billable parts of this call
call-catagory: (CHAR) Catagory of the call
call-closed: (LOGC) Set if the call is closed or dropped
call-duration: (INTG) Duration of this call (as a whole)
call-log-id: (INTG) Call Log ID
call-status: (CHAR) Call Status (Open, Done, Unresolved)
call-summary: (CHAR) Summary of this call
call-urgency: (CHAR) Call Urgency (Immediate, High, Average, Low, FYI)
call-urgency-order: (INTG) Used for ordering the record, regardless of the textual orde
closed-by-staff-id: (INTG) Staff member who closed the call
closed-date: (DATE) Date call was closed
closed-time: (CHAR) Time call was closed at
component-id: (INTG) Internally assigned component ID
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
expected-by: (DATE) Date request is expected to be done
expires-on: (DATE) Date call log will 'expire'
invoice-id: (CHAR) Invoice # this call was invoiced on
invoiced: (LOGC) Has this call log been invoiced (if billable)
invoiced-by-staff-id: (INTG) Staff Member who invoiced this call log
invoiced-date: (DATE) Date call log was invoiced
invoiced-time: (CHAR) Time call log was invoiced
needed-by: (DATE) Date request is needed by (if any)
product-id: (INTG) Internally assigned Product ID code
site-id: (INTG) Sites interally assigned ID
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-assignment: assigned-staff-id, assigned-staff-order, call-log-id
call-by-product: product-id, component-id, call-log-id
call-by-site: site-id, call-urgency-order, call-log-id
call-by-site-product: site-id, product-id, call-log-id
call-by-staff: assigned-staff-id, call-urgency, call-log-id
call-dispatch: call-status, call-urgency-order, -call-log-id
call-log: (UNIQUE, PRIMARY) call-log-id
call-status: call-status, call-log-id
closed-calls: call-closed, call-log-id

Alphabetical Trigger Summary

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

Other tables who reference call-log

call-browse - Denormalized Call Log Browsing table
call-event - One entry per event for a call
dev-request-call - List of call logs associated with this request

Tables call-log references

call-browse - Denormalized Call Log Browsing table
component - Product Components
dev-request-call - List of call logs associated with this request
product - (no description available)
site - Installed Sites
site-product - Products Installed at a site

Detailed Alphabetical Field Listing

assigned-staff-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Insternal Staff ID this call is assigned to (if any)
Attributes: Index Component

assigned-staff-order Data type: INTEGER
Format: zz9 (Initial Value: 0)
Help: Order of this call for the assigned person
Attributes: Index Component

billable Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes if this call is billable

billable-po-num Data type: CHARACTER
Format: x(10)
Help: PO Number, if any, for this billable call

billing-summary Data type: CHARACTER
Format: x(60)
Help: Notes about the billable parts of this call

call-catagory Data type: CHARACTER
Format: X(12) (Initial Value: Bug)
Description: Catagory of the call
Help: Calls Catagorization (Bug, Enhancement, Service or Help)

call-closed Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Set if the call is closed or dropped
Attributes: Index Component

call-duration Data type: INTEGER
Format: zzzz9 (Initial Value: 0)
Help: Duration of this call (as a whole)

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

call-status Data type: CHARACTER
Format: X(10) (Initial Value: Open)
Help: Call Status (Open, Done, Unresolved)
Attributes: Index Component

call-summary Data type: CHARACTER
Format: x(40)
Help: Summary of this call

call-urgency Data type: CHARACTER
Format: X(10) (Initial Value: Average)
Help: Call Urgency (Immediate, High, Average, Low, FYI)
Attributes: Index Component

call-urgency-order Data type: INTEGER
Format: zz9 (Initial Value: 30)
Description: Used for ordering the record, regardless of the textual orde
Attributes: Index Component

closed-by-staff-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Staff member who closed the call

closed-date Data type: DATE
Format: 99/99/9999
Help: Date call was closed

closed-time Data type: CHARACTER
Format: X(8)
Help: Time call was closed at

component-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally assigned component ID
Help: Component of product (if any) for the call
Attributes: Index Component

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

expected-by Data type: DATE
Format: 99/99/9999
Help: Date request is expected to be done

expires-on Data type: DATE
Format: 99/99/9999
Help: Date call log will 'expire'

invoice-id Data type: CHARACTER
Format: x(10)
Help: Invoice # this call was invoiced on

invoiced Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Has this call log been invoiced (if billable)

invoiced-by-staff-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Staff Member who invoiced this call log

invoiced-date Data type: DATE
Format: 99/99/9999
Help: Date call log was invoiced

invoiced-time Data type: CHARACTER
Format: X(8)
Help: Time call log was invoiced

needed-by Data type: DATE
Format: 99/99/9999
Help: Date request is needed by (if any)

product-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally assigned Product ID code
Help: Product that call is about
Attributes: Index Component

site-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Sites interally assigned ID
Help: Site this call/request was made by
Attributes: Index Component

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

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

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