Data Base Fields

All the available columns of the ixi-UMS Journal Data Base are described in the following. The German description is used for the Export by ODBC in the XML-templates.

For reasons of completeness, all the available columns are described, no matter whether they are needed for an analysis or not.

The order corresponds with the order, which is written into a table with a journal export without query criteria.

For the analysis of the journal data, the field contents marked with "internal use" are irrelevant.

 

Fieldname

Description

 

RECORD_ID

Internal use - primary key

CALL_ID

Internal use

BOUNDTYPE

Information whether this is an incoming or and outgoing message

Values: in, out

SERVICE

Information about the type of the message

Values:

FAXG3, FAXPOLL, VOC,SMS, ALERT = used services, connection OK

FAXG3_CALL,VOC_CALL = not clear because the connection had been interrupted

UNKNOWN = could not be detected

SENDERADDRESS

CallingPartyNumber= (D-channel) sender number

MAILFROM

Information of the "Mail From"-field with outgoing messages. This can be an e-mail address (SMTP) or a call number (e.g. SAP), depending on the connection

RECIPADDRESS

CalledPartyNumber - number to which the message is sent by ixi-UMS Business

ORIGRECIPADDRESS

Recipient number as entered by the user in an outgoing message

CHARGE

Must be transferred by the PSTN to ixi-UMS Business with SMS: number of the single messages

BILLINGCODE

Information of the cost center from the user properties

ASSOCFILENAME

Information for internal processing - Internal use

SUBJECT

Subject of the message

FAXTRANSSPEED

Only with fax messages

FAXNUMOFPAGES

Number of the transmitted fax pages

FAXRESOLUTION

Only with fax messages

FAXREMOTESTATION_ID

Only for outgoing faxes, ID of the remote station

FAXLOCALSTATION_ID

Corresponds with the sender call number, made up of the license and the fax sender number of the user.

This number is sent in the header as sender number

TRANSTIME

Date and time the entry was written into the journal

TRANSDURATION

Transmission time, duration the channel was busy in milliseconds

RESULTCODE

Final result (as code) after the connection was terminated; passed on from CAPI to ixi-UMS

RESULTMESSAGE

Translation of the final result code into text

CONNECTIONCODE

ISDN protocol information that gives a cause for a disconnect

CONNECTIONMESSAGE

Translation of the connection code into text

TRANSMISSIONCODE

ISDN protocol information that provides information about transmission errors

TRANSMISSIONMESSAGE

Translation of the transmission codes into text

CONNECTOR

Information from which ixi-UMS  Connector the outgoing message has been sent

PRIORITY

Priority of the outgoing message

CONNECTOR_ID

Internal description of the ixi-UMS Connector

BCHANNEL

Information via which channel the message had been sent or received

SDNCONTROLLER Controller

Information via which controller the message had been received or sent

CHARGELOCCURRENCY

Must be passed on from the PSTN to the %PRODUKTNAME% Kernel

URL

Information whether and on which script the incoming call had been routed

ROUTEMETHOD

Information whether and how theixi-UMS Business passed on the calls: DDI, REDIRECTING, SUBADDRESS, CALLINGPARTY, DTMF

JOB_ID

Information for internal processing - Internal use

USER_JOB_ID

Currently is not used

MESSAGE_ID

If a message ID is transferred in the outgoing message, it is entered here. If no message ID is entered, theixi-UMS Business generates a new, unambiguous one.

FINALFLAG

With the last connection try of a job, FINALFLAG is set to 1, at all the previous jobs, it is 0. When the value is 1, the job is displayed in the journal. All the other connection tries are displayed in the job details. VALUES:

0 – not final entry for job

1 – final entry for job

RETRYCOUNT

States, which transmission try for outgoing messages the entry represents.

VALUES:

Depend on the configured connection retries in the spooling

 

Version SR1