SQL Table:
hpd_helpdesk
SQL Fields: A1ST_CONTACT A2ND_CONTACT A3RDPARTYCASENBR ACCOUNTING_CODE ACTIVEDIRID ACTUAL_END_DATE ACTUAL_START_DATE ALTCONTACT1 ALTCONTACT2 ALTCONTACT3 ALTNUMBER1 ALTNUMBER2 ALTNUMBER3 ARRIVAL_TIME ASSIGNED_TO_GROUP_ ASSIGNED_TO_INDIVIDUAL_ ASSIGNEE_LOGIN_NAME ASSIGNEE_MANAGER_FULL_NAME ASSIGNEE_MANAGER_LOGIN ASSIGN_TIME ATTACHMENT_1 ATTACHMENT_10 ATTACHMENT_11 ATTACHMENT_12 ATTACHMENT_2 ATTACHMENT_3 ATTACHMENT_4 ATTACHMENT_5 ATTACHMENT_6 ATTACHMENT_7 ATTACHMENT_8 ATTACHMENT_9 AUDIT_TRAIL AUTO_CLOSE_DAYS AUTO_CLOSE_TIME AUTO_END_TIME AUTO_START_TIME A_ZTMPSTATUS BULLETIN_BOARD__ CALLBACKSDONE CASE_CATEGORY___TYPE___ITEM CASE_ID_ CASE_TYPE CATEGORY CHARACTER_FIELD2 CHARACTER_FIELD3 CHARACTER_FIELD4 CLIENT CLIENT_REQUIRED CLOSEDBY CLOSURE_CODE CONFIRM_RESOLVED_CASE CREATE_TIME DATETIMEEXECUTED DEPARTMENT DESCRIPTION DUPLICATE DUP_ID_ EMAIL EMAILADDRESS ENVIRONMENT ESCALATED_ ESCALATED_TO_US ESCALATE_TIME ESTIMATED_TOTAL_TIME ETA EVENT_UEID FEEDBACKCOMMENTS FEEDBACKCONTACTATTEMPTS FEEDBACKCONTACTMADEBY FEEDBACKCONTACTSTATUS FEEDBACKDATEOFCONTACT FEEDBACKRATING FHSCCASEID FHSCCASETYPE FHSCCATEGORY FHSCDEPARTMENT FHSCGROUP FHSCINDIVIDUAL FHSCITEM FHSCREGION FHSCREQUESTERNAME FHSCSITE FHSCTYPE FHSCUPPERINDIVIDUAL FIRST_CALL_RESOLUTION HOTLIST HOURS_TO_RESOLVE IMPACT INCIDENT INCIDENTID INCIDENT_COUNT INCIDENT_REASON_CODE INSTANCEID ITEM KNOWN_ERROR KNOWN_ERROR_STATUS LAST_MODIFIED_BY MODIFIED_TIME NAATTACH1 NAATTACH2 NAATTACH3 NOTIFICATION_METHOD NOVELLID OFFICE OPENVIEWSUMMARY ORIGINALCOMPANY ORIG_SUBMITTER ORIG_TICKET__ PAGER_ PALM_STATUS PDADEPARTMENT PDAREGION PDASITE PDAWAPCATEGORY PDAWAPITEM PDAWAPTYPE PENDING PENDINGRCAPAGESENT PEREGRINECATEGORY PEREGRINEGROUP PEREGRINEINDIVIDUAL PEREGRINEPRIORITY PEREGRINESERVICELOCATION PEREGRINESTATUS PEREGRINESUBCATEGORY PEREGRINESUBSYSTEM PEREGRINETICKETNUMBER PHONE_NUMBER PREV_ASSIGNEE_FULL_NAME PREV_ASSIGNEE_LOGIN PRIORITY QAT_SLAMET REGION RELEASENUMBER REQUESTEDCOMPLETIONDATE REQUESTED_COMPLETION_DATE REQUESTER_ID_ REQUESTER_LOGIN_NAME REQUESTER_NAME_ REQUEST_IMPACT REQUEST_MANAGER_TO_REASSIGN REQUEST_URGENCY RESOLUTION_METHOD RESOLVEDBY RESOLVED_TIME ROOTCAUSECATEGORY ROOTCAUSEITEM ROOTCAUSETYPE ROOT_CAUSE ROOT_CAUSE_NEW SCOPE SEARCH_KEYWORD SENDEMAIL_ SENDPAGE_ SERVER SERVICE SERVICELOCATION SERVICEWARESOLUTIONID SITE SLA_REQUEST_LEVEL SOLUTION_DESCRIPTION SOLUTION_SUMMARY SOURCE STATUS STATUS_UPDATE STATUS_UPDATE_LOG SUBMITTED_FOR SUMMARY SURVEYID TIME_HOLDER TIME_SPENT__MIN_ TMPSOLUTIONSUMMARY TMPWORKLOG TMPWORKLOG2 TOTALCOST TOTAL_TIME_SPENT TYPE UPDATED_STATUS URL VALIDREQLOGIN WAPWORKLOG WAP_TYPE WHERE_AM_I WORKCLASS WORK_LOG X_ZTMPPROBLEMGROUPASSIGNNAME ZASSIGNEDGROUPID ZASSIGNEEID ZASSIGNEEMANAGERGLUE ZDUPORIGINALID ZINCIDENTORIGINALID ZPREVASSIGNEEID ZPREVGROUPID ZPREVGROUPLOGIN ZSCHEMAPROPERNAME ZSERVER ZTMPASNPROCESSSTATUS ZTMPAUDIT ZTMPBUTTONFLAG ZTMPCBS ZTMPCONTACT1 ZTMPCONTACT1NUM ZTMPCONTACT2 ZTMPCONTACT2NUM ZTMPEXTERNALQUAL ZTMPGROUPEMAILPAGERS ZTMPKEYWORD ZTMPMODIFYALL ZTMPPARAMETER ZTMPPREVETA ZTMPRESOLVEDUPS ZTMPRESOLVEGROUP ZTMPSTATUS ZTMPSTATUSTIME ZTMPSTATUSUPDATE ZTMPUSEESCBUSHRS ZTMPWHEREAMI ZTMP_MEMBEROFTELECOM
| hpd_helpdesk - Remedy Table - Yaritz Consulting: The Consultation Company |