Definition of table call-browse

Table Description

Denormalized Call Log Browsing table

Table Dump Name: call-brw

Alphabetical Field Summary

assigned-staff-id: (INTG) Insternal Staff ID this call is assigned to (if any)
assigned-staff-nickname: (CHAR) Nickname for staff member (for browsers/listers)
billable: (LOGC) Yes if this call is billable
billable-po-num: (CHAR) PO Number, if any, for this billable call
browse-field-list: (CHAR) Browser packaged field list
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)
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-description: (CHAR) Descrption of this component
component-id: (INTG) Internally assigned component ID
contact-id: (INTG) Site person contacted regarding this event
contact-nickname: (CHAR) Nickname for contact (for Browsers/Listers)
event-date: (DATE) Date of this event occured
event-time: (INTG) Time event took place
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
product-shortname: (CHAR) Shorthand Name for product (for browsers/listers)
request-id: (INTG) Request ID/Order #
site-id: (INTG) Sites interally assigned ID
site-shortname: (CHAR) Shorthand name for site (for browsers/listers)

Alphabetical Index Summary

call-log-id: (UNIQUE, PRIMARY) call-log-id
closed-calls: call-closed, call-log-id

Other tables who reference call-browse

call-event - One entry per event for a call
call-log - Log of customer calls
dev-request-call - List of call logs associated with this request

Tables call-browse references

call-log - Log of customer calls
component - Product Components
contact - Site Contacts
dev-request - A request of development for resources to fix a bug and/or e
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)

assigned-staff-nickname Data type: CHARACTER
Format: X(8)
Help: Nickname for staff member (for browsers/listers)

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

browse-field-list Data type: CHARACTER
Format: x(32)
Description: Browser packaged field list

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)

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)

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-description Data type: CHARACTER
Format: x(32)
Help: Descrption of this component

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

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

contact-nickname Data type: CHARACTER
Format: X(8)
Help: Nickname for contact (for Browsers/Listers)

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

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

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

product-shortname Data type: CHARACTER
Format: x(8)
Help: Shorthand Name for product (for browsers/listers)

request-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Request ID/Order #

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

site-shortname Data type: CHARACTER
Format: x(10)
Help: Shorthand name for site (for browsers/listers)