Home > AltiGen comm > Server > AltiGen comm MAXCS 87 CDR Manual

AltiGen comm MAXCS 87 CDR Manual

    Download as PDF Print this page Share this page

    Have a look at the manual AltiGen comm MAXCS 87 CDR Manual online for free. It’s possible to download the document as PDF or print. UserManuals.tech offer 29 AltiGen comm manuals and user’s guides for free. Share the user manual or guide on Facebook, Twitter or Google+.

    							Records and Data SchemaCDR Manual  55
    Table: AGENTPERWGSUMMARY3
    Database 
    ElementDefinitionTypeSpecification
    Version Version of the record LONG2 = OE/ACM 5.0A
    NodeID Server ID (System ID) 
    assigned
    
     to a MAXCS system 
    in MaxAdmin LONG
    value: 1–100 
    uid Unique ID to link to 
    AGENTPERWGSUMMARY1 LONG
    DurLogin The total time agent was 
    logged in. LONG
    DurOutWGTalk
    Talk duration of outgoing 
    con
    
    nected calls 
    (NumOutWGConnected) 
    from the time the call 
    enters "Connected" state 
    until disconnected, parked 
    or transferred LONG
    NumOutWGWrapUp Number of wrap-ups for 
    outbound 
    
    WG calls LONG
    DurOutWGWrapUp Wrap-up duration for 
    outbound 
    
    WG calls LONG
    NumOutWGHold Count of outbound WG 
    hold calls by agent 
    
    (One 
    call on hold multiple times 
    will count once only) LONG
    DurOutWGHold Hold duration of outbound 
    workgr
    
    oup calls LONG
    Database ElementDefinitionTypeSpecification 
    						
    							Data Schema
    56 CDR Manual
    Table: AGENTSUMMARY1
    Database 
    ElementDefinitionTypeSpecification
    Version Version of the record LONG2 = OE/ACM 5.0A
    NodeID Server ID (System ID) assigned to 
    a MAXCS system in MaxAdmin LONG
    value: 1–100 
    uid Unique ID to link to 
    AGE
    
    NTSUMMARY2, 
    AGENTSUMMARY3, and 
    AGENTSUMMARY4 LONG
    StartTime GMT start time of record's period. 
    Seconds since 1970/01/01
    
     
    00:00:00. LONG
    EndTime GMT end time of record's period. 
    Seconds since GMT
    
     1970/01/01 
    00:00:00. LONG
    GMTOffset Offset to GMT time, includes 
    daytime
    
     savings, i n seconds; ex: 
    Pacific Summer time 25200 LONG
    LocalDay 8 digit number representing date
    ex: 20040608 = 06/08/2004 LONG
    Format: 
    yy
    
    yymmdd
    DayofWeek Day of the week LONG0 = Sunday 
    1 = Monday
    2 = Tuesday
    3 = Wednesday
    4 = Thursday
    5 = Friday
    6 = Saturday
    AgentNum Agent Extension Number LONG
    Table: AGENTSUMMARY2
    Database ElementDefinitionTypeSpecification
    The following values are significant only when an agent logs in to at least one 
    workgroup. If an agent doesn’t log into any workgroup, all valu es should be zero.
    Version Version of the record LONG2 = OE/ACM 
    5.0A 
    						
    							Records and Data Schema
    CDR Manual 57
    NodeIDServer ID (System ID) 
    assigned to a MAXCS 
    system in MaxAdminLONGvalue: 1–100 
    uidUnique ID to link to 
    AGENTSUMMARY1LONG
    NumInDirCallDirect (non-workgroup) 
    incoming callLONG
    NumInDirAnsweredDirect (non-workgroup) 
    incoming call answeredLONG
    DurInDirTalkTotal talk duration of direct 
    (non-workgroup) incoming 
    callsLONG
    NumInDirVMCount of direct inbound 
    voicemail messageLONG
    DurInDirVMTotal duration of direct 
    inbound voicemail messageLONG
    NumInDirHold
    The number of direct 
    incoming call put on hold 
    (One call on hold multiple 
    times will count once only)
    LONG
    DurInDirHoldTotal hold duration of direct 
    incoming callsLONG
    NumOutDirConnectedNumber of direct outgoing 
    connected callsLONG
    DurOutDirTalkTotal talk duration of direct 
    (non-workgroup) outgoing 
    connected callsLONG
    NumOutDirHold
    Count of direct outbound 
    calls on hold (One call on 
    hold multiple times will 
    count once only)
    LONG
    DurOutDirHoldTotal hold duration of direct 
    outbound callsLONG
    NumAgentBusyNumber of times agent is 
    busyLONG
    DurAgentBusyThe duration of time when 
    agent is busyLONG
    NumInWrapUpNumber of times agent 
    entered Wrap UpLONG
    Database ElementDefinitionTypeSpecification 
    						
    							Data Schema
    58 CDR Manual
    Table: AGENTSUMMARY3
    Database ElementDefinitionTypeSpecification
    Version Version of the record LONG2 = OE/ACM 
    5.0A
    NodeID Server ID (System ID) 
    assigned to
    
     a MAXCS 
    system in MaxAdmin LONG
    value: 1–100 
    uid Unique ID to link 
    AGE
    
    NTSUMMARY1 LONG
    CountLogonWG Count of workgroups that 
    agent 
    
    is logged into LONG
    DurAgentLogon The login duration when 
    agent 
    
    logs into at least one 
    workgroup LONG
    NumAgentAvailable Number of times agent is 
    available LONG
    DurAgentAvailable The duration while agent is 
    in ava
    
    ilable state LONG
    Table: AGENTSUMMARY4
    DurInWrapUp Wrap-up duration of 
    incomin
    g workgroup calls LONG
    NumOutWrapUp Number of wrap-ups for 
    o
    
    utbound workgroup calls LONG
    DurOut WrapUp Wrap-up duration for 
    o
    
    utbound workgroup calls
    Database ElementDefinitionTypeSpecification
    The following values are signifi cant only when an agent logs into at least one 
    workgroup. If an agent doesn’t log  into any workgroup, all values should be zero.
    Version Version of the record LONG2 = OE/ACM 
    5.0A
    NodeID Server ID (System ID) assigned to 
    a
    
     MAXCS system in MaxAdmin LONG
    value: 1–100 
    uid Unique ID link to 
    AGENTS
    
    UMMARY1 LONG
    Database ElementDefinitionTypeSpecification 
    						
    							Records and Data Schema
    CDR Manual 59
    Table: CDRMAIN
    NumAgentDNDNumber of times agent entered 
    DNDLONG
    DurAgentDNDTotal duration of the DNDLONG
    NumAgentFWDNumber of times agent enable 
    extension forward and enter FWD 
    stateLONG
    DurAgentFWDDuration of agent in FWD stateLONG
    NumAgentErrorNumber of times agent enter Error 
    State while loginLONG
    DurAgentErrorDuration of agent in Error State 
    while loginLONG
    NumNotReadyCount of Agent enters Not-Ready 
    stateLONG
    DurNotReadyDuration of Agent Not-ReadyLONG
    Database ElementDefinitionTypeSpecification
    VersionVersion of the recordLONG2 = OE/ACM 5.0A
    NodeIDServer ID (System ID) 
    assigned to a MAXCS 
    system in MaxAdminLONGvalue: 1–100 
    StartTime
    GMT start time of 
    record's period. 
    Seconds since 1970/01/
    01 00:00:00.
    LONG
    EndTime
    GMT end time of 
    record's period. 
    Seconds since 1970/01/
    01 00:00:00.
    LONG
    GMTOffset
    Offset to GMT time, 
    includes daytime 
    savings, in seconds; ex: 
    Pacific Summer time 
    25200
    LONG
    LocalDay
    8 digit number 
    representing date
    ex: 20040608 = 06/08/
    2004LONGFormat: yyyymmdd
    Database ElementDefinitionTypeSpecification 
    						
    							Data Schema
    60 CDR Manual
    DayOfWeekDay of the weekLONG
    0 = Sunday 
    1 = Monday
    2 = Tuesday
    3 = Wednesday
    4 = Thursday
    5 = Friday
    6 = Saturday
    SessionID
    Session ID: a unique 
    number, usually 9 digits 
    or larger, assigned by 
    MAXCS to a call
    LONG
    SequenceID
    A unique number to 
    identify multiple records 
    of same call (same 
    Session ID), beginning 
    with 0
    LONG
    TrunkCallTrunk call or external 
    callLONG1=Internal
    2=Trunk Call
    DirectionDirection of the call 
    (incoming or outgoing)LONG
    1=Outgoing
    2=Incoming
    3=Not applicable (for 
    example, MeetMe 
    conference would be 3)
    OriginalPriorityThe first priority set by 
    the system for this call 
    (1-9)LONG
    StartPriorityCall priority at Start 
    Time (1-9)LONG
    EndPriorityCall priority at End Time 
    (1-9)LONG
    Database ElementDefinitionTypeSpecification 
    						
    							Records and Data Schema
    CDR Manual 61
    CallerTypeType of line for an 
    incoming call LONG
    0 = Unknown line type
    1 = Ext analog
    2 = Ext IP
    3 = Reserved
    4 = Ext virtual
    5 = Workgroup
    6 = Application Extension
    7 = Analog Trunk
    8 = T1 Trunk
    9 = IP Trunk
    10 = PRI Trunk
    11 = not used
    12 = E1 trunk
    CallerPadLine’s physical address 
    for an incoming callCHAR (5)
    E.g. “0004”, where 
    “00”=slot, “04”=channel
    Always “-1-1” for WG or 
    virtual extension
    CallerNum
    Caller phone number of 
    an incoming call 
    (extension number or 
    off-net PSTN)CHAR (41)
    CallerName
    Caller name for an 
    incoming call (provided 
    by CO for trunk calls; as 
    entered in MaxAdmin 
    for extension calls)
    CHAR (65)
    CallerTenantCaller Tenant nameCHAR
    CallerProjectCaller Project IDLONG
    Database ElementDefinitionTypeSpecification 
    						
    							Data Schema
    62 CDR Manual
    TargetTypeCalled target line typeLONG
    0 = Unknown line type
    1 = Ext analog
    2 = Ext IP
    3 = Reserved
    4 = Ext virtual
    5 = Workgroup
    6 = Application Extension
    7 = Analog Trunk
    8 = T1 Trunk
    9 = IP Trunk
    10 = PRI Trunk
    11 = not used
    12 = E1 trunk
    TargetPadPhysical address of line 
    for a called targetUCHAR (5)
    E.g. “0004,” where 
    “00”=slot and 
    “04”=channel
    TargetNumNumber for a called 
    targetCHAR (41)
    TargetNameName for a called targetCHAR (65)
    TargetTenantTenant name for called 
    targetCHAR
    TargentProjectProject ID for called 
    targetLONG
    TargetWGNumTarget workgroup 
    numberCHAR
    WGSessionIDA unique Session ID for 
    workgroup callLONG
    OutGoingWGWorkgroup number for 
    an outgoing call, while 
    agent loginLONG
    ConfSessionIDConference Session IDLONG
    DNISDNIS number for 
    incoming callCHAR (33)
    AccountCodeAccount codeCHAR (11)1—10 digits in length
    Database ElementDefinitionTypeSpecification 
    						
    							Records and Data Schema
    CDR Manual 63
    AADuration
    Duration in seconds an 
    incoming call is 
    connected to the Auto 
    Attendant/IVR; multiple 
    connections to AA/IVR 
    in a single session 
    produces multiple 
    records
    LONG
    RingDurationDuration in seconds a 
    call is ringing and in 
    workgroup queueLONG
    QueueDurationDuration in seconds 
    when a call stays in a 
    queue.LONG
    VMDuration
    Duration in seconds 
    after a call goes into a 
    voicemail box; includes 
    greeting, false attempts 
    at messages, 
    successful message, 
    and review of message
    LONG
    VMRecDuration
    Duration in seconds of 
    recording time for a VM 
    message that was 
    completed
    LONG
    HoldDurationDuration in seconds 
    while a call is on holdLONG
    TalkDurationDuration in seconds of 
    talk timeLONG
    RecordDurationDuration in seconds of 
    recordingLONG
    AnswerWithin SLT
    Call is answered within 
    the Service Level 
    Threshold LONG1=within
    2=not within
    ExitStateState when call is 
    terminatedLONG(see end of this table for 
    specifications for the 34 
    exit states)
    Database ElementDefinitionTypeSpecification 
    						
    							Data Schema
    64 CDR Manual
    AbnTargetTypeType of abandon 
    forward targetLONG
    1=Abandon to AA
    2=Abandon to Operator
    3=Abandon to Extension
    4=Abandon to Outside      Number
    5 =Abandon to VM
    6 = Abandon to        Application
    7 = Abandon to Others
    8 = Call Disconnected
    AdvQAppTypeType of Advanced 
    Queue Management 
    ApplicationLONG
    MMCallTypeMulti-Media call typeLONG
    PriorityQueueDur
    ationThe duration in seconds 
    of a call hold current 
    priority in queueLONG
    IVRExitPointExit Point of IVR/AACHAR 
    (63)
    When a call is transferred 
    from AA menu, the 
    system logs the exit AA 
    point, which is the AA 
    item ID.
    IVRDataData of IVR/AACHAR 
    (255)
    UserDataAgent inputCHAR 
    (255)
    FormDataWeb form dataCHAR
    URLDataLast URLCHAR 
    (255)
    DNISNameDNIS name for 
    incoming callCHAR 
    (64)
    CallbackTypeWorkgroup callback call 
    typeLONG1 - Callback request
    2 - Callback attempt
    Database ElementDefinitionTypeSpecification 
    						
    All AltiGen comm manuals Comments (0)

    Related Manuals for AltiGen comm MAXCS 87 CDR Manual