CUST_REF - Customer Supplied Reference or if no Cust_ref supplied then CONTACT_NAME - The name of the contact within the Customer Organisation or 'BT Originated' if Trouble ticket was raised by BT on behalf of teh Customer QUE_DATE REPORT_DATE - The date the Trouble Ticket was reported WEB_DESCRIPTION - the fault description supplied by the customer CCT_ID - the reference of the circuit in trouble STATUS - the current state of the Trouble Ticket The date and time that the current State was entered CUST_REF - Customer Supplied Reference or if no Cust_ref supplied then CONTACT_NAME - The name of the contact within the Customer Organisation or 'BT Originated' if Trouble ticket was raised by BT on behalf of teh Customer QUE_DATE REPORT_DATE - The date the Trouble Ticket was reported WEB_DESCRIPTION - the fault description supplied by the customer CCT_ID - the reference of the circuit in trouble STATUS - the current state of the Trouble Ticket The date and time that the current State was entered CAMSS Trouble Ticket ID Used to put the lines: FAULT_DESCRIPTION, LOG_LINE1 thru LOG_LINE4, CUST_REF - Customer Supplied Reference or if no Cust_ref supplied then CONTACT_NAME - The name of the contact within the Customer Organisation or 'BT Originated' if Trouble ticket was raised by BT on behalf of teh Customer QUE_DATE REPORT_DATE - The date the Trouble Ticket was reported WEB_DESCRIPTION - the fault description supplied by the customer CCT_ID - the reference of the circuit in trouble Used to hold the C_NAME_A, C_NAME_B, C_ADDRESS_A and C_ADDRESS_B. The LOcation TYpe flag would be either 'A' or 'B'. REF_NO : CAMSS Trouble Ticket ID