a_hrs_ind | LONG | tinyint | | | 0 | DIRECT | Customer OK to repair the service outside of normal business hours; i.e., 0=no, 1=yes, default=0 | |
ack_action | LONG | tinyint | | | | DIRECT | Describes the acknowledgment action; i.e., 0=reject, 1=accept | |
ack_ind | LONG | tinyint | | | 0 | DIRECT | Indicates acknowledgment of the problem submission; i.e., 0=no acknowledgement 1=acknowleged, default=0 | |
ack_reason | LONG | tinyint | | | 0 | DIRECT | Describes the acknowledgment sub status; i.e., 0=OK, 1=no contract, 2=contract expired, 3=product not covered; 4=site not covered, 5=product not found, default=0 | |
ack_state | LONG | tinyint | | | 0 | DIRECT | Describes the acknowledgment status; i.e., 0=no acknowledgement required, 1=service requested, 2=problem submitted, 3=closure submitted, default=0 | |
auth_act_type | LONG | int | | | 0 | DIRECT | Currently authorized activities, which is a bitstring with positions:0=after hrs repair; 1=standby; 2=after hrs standby; 3=test; 4=manager initiated; 5=distatched; 6=no-access; 7=delayed maintenance; 8=release | |
cancel_req_ind | LONG | tinyint | | | 0 | DIRECT | Indicates whether the manager has initiated the process to cancel a trouble report; i.e, 0=no, 1=yes, default=0 | |
close_out_verif | LONG | tinyint | | | 0 | DIRECT | Whether the manager has verified repair completion, denied repair completion or take no action; i.e., 0=no action, 1=denied repair, 2=verified repair, default=0 | |
cmt_date_type | LONG | tinyint | | | 0 | DIRECT | Code giving the type of time committed by the Provider; i.e., 0=unspecified; 1=cleared time, 2=onsite_time, default=0 | |
commit_date | CLK_TIME | datetime | | | | | Provider's committed completion date and time | |
confirm_ind | LONG | tinyint | | | 0 | DIRECT | Indicates confirmation of close for the problem submission; i.e., 0=not confirmed 1=confimed, default=0 | |
contract_id | CHAR | varchar | | 40 | | | Contract ID number from display/edit field. Does not supersede relation to contract object | |
create_date | CLK_TIME | datetime | | | | | The date and time the object was created | |
current_state | LONG | smallint | | | | DIRECT | Reflects the current state of the distributed object in my virtual machine. Map data exchange protocol state values to codes | Search (1) |
dev | LONG | int | 151 | | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | |
dist_mode | LONG | tinyint | | | | DIRECT | The distribution mode; i.e., 0=unknown, 1=transfer, 2=collaborative | |
dist_role | LONG | tinyint | | | | DIRECT | Indicates role in the distribution of the object; i.e., 0=initiator, 1=recipient | Search (1) |
entitle_ind | LONG | tinyint | | | 0 | DIRECT | Indicates entitlement for service of the problem submission; i.e., 0=no entitlement 1=entitled, default=0. This is the internal entitlement state | |
exchange_id | CHAR | varchar | | 255 | | | System-generated unique identifier of the exchange | |
init_mode | LONG | smallint | | | 0 | DIRECT | Mode of initiation of the trouble report; i.e., 0=managerDirect, 1=managerIndirect, 2=agentOriginated, 4=managerIndirectEMail, 5=managerIndirectFax, 6=managerIndirectPersonal, 7=managerIndirectPhone, default=0 | |
lack_ind | LONG | tinyint | | | 0 | DIRECT | Indicates whether information from requestor is lacking; i.e., 0=not lacking 1=is lacking, default=0 | |
m_org_ct_time | CLK_TIME | datetime | | | | | The date and time at which the maintenance organization was contacted by the agent and requested to repair the trouble | |
m_svc_chg_ind | LONG | tinyint | | | 0 | DIRECT | Indicates, once determined, whether the customer will be charged for the maintence; i.e., 0=no or not yet determined, 1=yes, default=0 | |
modify_stmp | CLK_TIME | datetime | | | | | The date and time the object was last modified | |
objid | LONG | int | 3 | | | DIRECT | Internal record number | Search (2) |
onsite_date | CLK_TIME | datetime | | | | | Used for requesting onsite time | |
onsite_req_date | CLK_TIME | datetime | | | | | Used for requesting onsite time | |
outage_dur | LONG | int | | | 0 | DIRECT | Derived. The amount of time between when the trouble was cleared when it was received excluding any times for delayed maintenance. Stored in seconds | |
prfd_priority | LONG | smallint | | | 0 | DIRECT | X790--manager's prefered priority for the trouble; i.e., 0=undefined, 1=minor, 2=major, 3=serious, default=0 | |
priority | LONG | tinyint | | | 1 | DIRECT | Local priority of the exchanged incident. Default=1 | |
prob_ind | LONG | tinyint | | | 0 | DIRECT | Indicates if a problem has been submitted; 0=no, 1=yes, default=0 | |
product | CHAR | varchar | | 255 | | | Customer-defined popup with default name Exchange Product supplies the exchanged product | |
received_time | CLK_TIME | datetime | | | | | The date and time when a trouble report was entered | |
ref_id | CHAR | varchar | | 255 | | | Identifier of the exchange partner's corresponding object | Search (1) |
ref_ind | LONG | tinyint | | | 0 | DIRECT | Indicates that the this is the reference exchange for defining default contacts/person reaches for any future exchange on the case; i.e., 0=no, 1=yes, default=0 | |
repeat_report | LONG | tinyint | | | 0 | DIRECT | Code giving previous actions/history on the service; i.e.,0=unspecified, 1=recent installation, 2=repeat, 3=both installation and repeat, 4=chronic, 5=both instalation and chronic | |
req_act_type | LONG | int | | | 0 | DIRECT | Currently requested authorized activities, which is a bitstring with positions:0=after hrs repair; 1=standby; 2=after hrs standby; 3=test; 4=manager initiated; 5=distatched; 6=no-access; 7=delayed maintenance; 8=release | |
req_date_type | LONG | tinyint | | | 0 | DIRECT | The type of time the request_date/commit_date field is representing; i.e., 0=unspecified; 1=cleared time, 2=onsite_time, default=0 | |
request_date | CLK_TIME | datetime | | | | | Requestor's desired completion date and time | |
requestor_severity | LONG | tinyint | | | 1 | DIRECT | The severity of the problem as defined by the requester; Values must be in the range 1-5 with 1 being most sever. Default=1 | |
response_time | CHAR | varchar | | 30 | | | Promised/desired response time to the customer | |
restore_time | CLK_TIME | datetime | | | | | The date and time that the trouble was cleared. This may be different than the time that the clear event is exchanged | |
rpt_email | CHAR | varchar | | 80 | | | Original e-mail address | |
rpt_fax | CHAR | varchar | | 20 | | | Original reporting site fax number which includes area code, number and extension | |
rpt_first | CHAR | varchar | | 30 | | | Original reporting site contact. Contact's first name | |
rpt_last | CHAR | varchar | | 30 | | | Original reporting site contact. Contact's last name | |
rpt_phone | CHAR | varchar | | 20 | | | Original reporting site phone which includes area code, number and extension | |
status_window | LONG | int | | | 0 | DIRECT | States the maximum interval allowed (in seconds) between the Agent's notifications of progress | |
trouble_found | LONG | smallint | | | 0 | DIRECT | X790--the actual cause of the trouble found; i.e., 0=pending, 1=cameClear, 2=centralOffice, 3=serious, default=0 | |
trouble_type | LONG | smallint | | | 0 | DIRECT | X790--the category of trouble that is being reported on a CNM Service or managed object; e.g., 100=noDialToneGroup, 101=noDialTone, etc., default=0 | |
tsp_priority | LONG | smallint | | | 0 | DIRECT | Government defined Telecommunication Service Priority codes | |
wait_ind | LONG | tinyint | | | 0 | DIRECT | Indicates waiting for confirmation of close for the problem submission; i.e., 0=not waiting 1=waiting, default=0 | |
workflow_status | CHAR | varchar | | 30 | | | What the status of this incident is according to the workflow | |
xref_email | CHAR | varchar | | 80 | | | Email address of the current user/owner working on the exchange case in the partner's system | Search (1) |
xref_fax | CHAR | varchar | | 20 | | | Fax number of the current user/owner working on the exchange case in the partner's system which includes area code, number and extension | |
xref_first | CHAR | varchar | | 30 | | | First name of the current owner working on the exchange case in the partner's system | Search (1) |
xref_last | CHAR | varchar | | 30 | | | Last name of the current owner working on the exchange case in the partner's system | Search (1) |
xref_phone | CHAR | varchar | | 20 | | | Phone number of the current user/owner working on the exchange case in the partner's system which includes area code, number and extension | Search (1) |