CHG_Task - Remedy Table - Yaritz Consulting: The Consultation Company  



SQL Table:
chg_task


SQL Fields: ACTUAL_DURATION ACTUAL_END_DATE ACTUAL_START_DATE ASSIGNEE_LOGIN_NAME ASSIGNEE_MANAGER_FULL_NAME ASSIGNEE_MANAGER_LOGIN AUDIT_X AUTO_END_TIME AUTO_START_TIME CATEGORY CBOENFORCETSKDEPENDENCY CHANGE_ID_ CLOSURE_CODE CREATE_DATE DATE_INFO_SENT DATE_RESPONSE_EXPECTED DATE_TIME_EXECUTED DELETED DEPARTMENT DESCRIPTION EMERGENCYNAME EMERGENCYPHONE ENVIRONMENT ESCALATED ESTIMATED_TOTAL_TIME FIRST_IN_LINE HOTLIST IMPLEMENTOR_GROUP_ IMPLEMENTOR_NAME_ INSTANCEID ITEM LAST_MODIFIED_BY METHOD METHODKEYWORD MODIFIED_DATE OFFICE ORDERCONFIRMATIONTYPECODE PARENT_ID PARENT_OBJECT_ID PENDING PHONE_NUMBER PLANNED_DURATION PLANNED_END_DATE PLANNED_START_DATE PREV_ASSIGNEE_FULL_NAME PREV_ASSIGNEE_LOGIN PRIORITY REGION REQUESTER_ID REQUESTER_LOGIN_NAME REQUESTER_NAME REQUEST_SUPERVISOR_TO_REASSIGN REQUEST_TYPE REQUEST_URGENCY SCOPE SEQUENCE SITE STATUS SUBMITTER SUMMARY TASK_ID_ TASK_PLANS TIME_SPENT__MIN_ TOTAL_TIME_SPENT TYPE VENDOR VENDOR_NAME WEBSERVICEORDER WORK_CLASS WORK_LOG WORK_ORDER WORK_ORDER_COMMENTS ZASSIGNEDGROUPID ZASSIGNEEID ZASSIGNEEMANAGERID ZCANCELEDTHISTRANSACTION ZCLOSEDTHISTRANSACTION ZDEPENDENCYNOTIFICATION ZPARENTCHANGEINSTANCEID ZPREVASSIGNEEID ZPREVGROUPID ZPREVGROUPLOGIN ZSCHEDULEDTHISTRANSACTION ZSCHEMAPROPERNAME ZTASKTEMPLATEID ZTEMPNOOFTASKS ZTEMPPREVENDDT ZTEMPPREVSEQNUM ZTEMPPREVSTARTDT ZTMPASNPROCESSSTATUS ZTMPAUDIT ZTMPBUSINESSHRSSELECTION ZTMPEXTERNALQUAL ZTMPKEYWORD ZTMPOTHERTASKSSAMEORDE ZTMPPLANNEDEND ZTMPTABLEENTRYID ZTMPWHEREAMI ZWIPTHISTRANSACTION