Re: [Emerald] Calls table entries

Dale E. Reed Jr. ( (no email) )
Sat, 05 Feb 2000 09:57:26 -0800

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Dan Tang: "Re: [Emerald] SQL QUERY: Extracting Spaces and/or '-' from Phone Numbers"
Next message: iml@interconnect.net: "[Emerald] error in log"
Maybe in reply to: Josh Hillman: "[Emerald] Calls table entries"
Next in thread: Josh Hillman: "Re: [Emerald] Calls table entries"

Josh Hillman wrote:
>
> Why are the following columns in the Calls table always null?:
> AccountID
> ConnectInfo (null because it doesn't relate to Ascend??)
> ServerID
> Status (what is Status for?)

ConnectInfo is populated by the NAS. Ascend uses a proprietary
attribute for this.

AccountID, ServerID, and Status are used for consolidation/usage
billing. AccountID/ServerID are updates either with the two
stored procs (UpdateCalls_ServerID and UpdateCalls_AccountID) or
the updtcall.sql script. Status is changed from NULL after that
record has been processed.

> Also, if the "Time On" tab in Emerald is a stored procedure or view, what is
> its name?

Its not.

Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com

For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart

Previous message: Dan Tang: "Re: [Emerald] SQL QUERY: Extracting Spaces and/or '-' from Phone Numbers"
Next message: iml@interconnect.net: "[Emerald] error in log"
Maybe in reply to: Josh Hillman: "[Emerald] Calls table entries"
Next in thread: Josh Hillman: "Re: [Emerald] Calls table entries"