CHG_Change - Remedy table - Yaritz Consulting: The Consultation Company  



SQL Table:
chg_change


SQL Fields: ACTUAL_DURATION__IN_HOURS_ ACTUAL_END_DATE ACTUAL_START_DATE ADDITIONAL_APPROVER_ ADDITIONAL_FORM_1 ADDITIONAL_FORM_10 ADDITIONAL_FORM_11 ADDITIONAL_FORM_12 ADDITIONAL_FORM_13 ADDITIONAL_FORM_14 ADDITIONAL_FORM_15 ADDITIONAL_FORM_16 ADDITIONAL_FORM_17 ADDITIONAL_FORM_18 ADDITIONAL_FORM_19 ADDITIONAL_FORM_2 ADDITIONAL_FORM_20 ADDITIONAL_FORM_3 ADDITIONAL_FORM_4 ADDITIONAL_FORM_5 ADDITIONAL_FORM_6 ADDITIONAL_FORM_7 ADDITIONAL_FORM_8 ADDITIONAL_FORM_9 APPROVAL_REQUIRED_ APPROVAL_STATUS ASSETS_AFFECTED ASSIGNEE_LOGIN_NAME ASSIGNEE_MANAGER_FULL_NAME ASSIGNEE_MANAGER_LOGIN ATTACHMENT1 AUDIT_X AUTO_CLOSE_DAYS AUTO_CLOSE_TIME AUTO_END_TIME AUTO_START_TIME BACKOUT_PLAN BUSINESS_PROCESS BUSINESS_RISK CATEGORY CBOENFORCECHGDEPENDENCY CBOENFORCETSKDEPENDENCY CHANGETYPE CHANGE_ID_ CLOSURE_CODE CONFIRM_RESOLUTION CREATE_DATE DATA_ADMINISTRATION DATE_TIME_EXECUTED DBA_X DEPARTMENT DEPENDANT_ISR DESCRIPTION DIVISION_IMPACTED DOWNTIME EDI EMERGENCY EMERGENCYNAME EMERGENCYPHONE EMERGENCYUSERCODE ENVIRONMENT ERROR_IN_APPROVAL_PROCESS ESCALATED_ ESTIMATED_TOTAL_TIME HOTLIST IMAGING IMPACT IMPLEMENTATION_PLAN INSTANCEID ISASSETRELATED ISR ISR_GATED ISR_STATUS ITEM LAN LAST_MODIFIED_BY MODIFIED_DATE MODULE MTG NETWORK_ADMINISTRATIONV NUMBER_OF_TASKS OFFICE ORIG_SUBMITTER PDADEPARTMENT PDAREGION PDASITE PDAWAPCATEGORY PDAWAPITEM PDAWAPTYPE PENDING PHONE_NUMBER PLANNED_DURATION__IN_HOURS_ PLANNED_END_DATE PLANNED_START_DATE PLANS POLICY_VIOLATION PREAPPROVALSUMMARYUSED_ PREV_ASSIGNEE_FULL_NAME PREV_ASSIGNEE_LOGIN PRIORITY PRODUCTION_SUPPORT PVCSQUESTION PVCS_PLANNED_END_DATE QAT_APPLICATION QAT_ASSOCIATEDPROJECTS QAT_AVAILABLETOUSERS QAT_BIQUERYMODELCHANGE QAT_BUSINESSREASON QAT_CRASSESSMENT QAT_DDLREQUIRED QAT_DELIVERABLE QAT_DEVELOPMENTCOMPLETE QAT_DEVELOPMENTSTART QAT_DEVELOPMENTVALIDATION QAT_DEVELOPMENTVALIDATIONBY QAT_INSTALLATIONINSTRUCTIONS QAT_INTEGRATIONSTARTTEST QAT_INTEGRATIONTESTCOMPLETE QAT_INTEGRATIONTESTENVIRONMENT QAT_INTEGRATIONVALIDATION QAT_INTEGRATIONVALIDATIONBY QAT_ISMANAGER QAT_PCRAGENDA QAT_PLANNEDRESOLUTION QAT_PRODUCTIONDEPLOYMENTREV001 QAT_PRODUCTIONDEPLOYMENTREV002 QAT_PRODUCTIONEXECUTION QAT_PRODUCTIONVALIDATEDBY QAT_PRODUCTIONVALIDATION QAT_SUPERVISORNAME QAT_TIDALCHANGEREQUIRED QAT_WEIGHT REASON REGION RELATED_ISR RELEASE RELEASE_VERSION__ REQUESTED_COMPLETION_DATE_ REQUESTER_ID_ REQUESTER_LOGIN_NAME_ REQUESTER_NAME_ REQUEST_MANAGER_TO_REASSIGN REQUEST_TYPE REQUEST_URGENCY RISK RISKS_BENEFITS_COMMENTS SCHEMANAME SCOPE SCREEN SEQUENCE SERVICE SERVICELOCATION SITE SOFTWARE_SUPPORT SOURCE1 STATUS STATUS_UPDATE SUBMITTED_FOR SUMMARY SUPERVISOR_GROUP_ SUPERVISOR_NAME_ SYSTEM_ADMIN SYSTEM_ENVIRONMENT TARGET_LEVEL_MGTCHAIN TECHNICAL_RISK TEST_PLAN TIME_SPENT__MIN_ TOTAL_TIME_SPENT TYPE URL USERSBYASSETF USERSBYLOCF WAP_TYPE WORKCLASS WORKLOG WORK_LOG ZAPPROVALPROCESSNAME ZASSIGNEDGROUPID ZASSIGNEEID ZASSIGNEEMANAGERID ZCHANGERELATIONSHIPKEYCHAR ZDEPENDENCYNOTIFICATION ZOTHERCHANGESSAMEORDER ZPREVASSIGNEEID ZPREVGROUPID ZPREVGROUPLOGIN ZSCHEDULEDTHISTRANSACTION ZSCHEMAPROPERNAME ZSUBMITTINGDEPENDENT ZTEMPNOOFTASKS ZTMPACTIONONSUBMIT ZTMPASNPROCESSSTATUS ZTMPAUDIT ZTMPEXTERNALQUAL ZTMPKEYWORD ZTMPMGRCHECK ZTMPTABLEENTRYID ZTMPUSEESCBUSHRS ZTMPWHEREAMI