VIEW: CS.CS_INCIDENT_ACTIONS#

Source

View Text - Preformatted

select INCIDENT_ACTION_ID INCIDENT_ACTION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, INCIDENT_ID INCIDENT_ID, ACTION_CODE ACTION_CODE, ACTION_NUM ACTION_NUM, ACTION_LINE_NUMBER ACTION_LINE_NUMBER, ACTION_TYPE_ID ACTION_TYPE_ID, ACTION_STATUS_ID ACTION_STATUS_ID, RESPONSIBLE_GROUP_ID RESPONSIBLE_GROUP_ID, ACTUAL_TIME ACTUAL_TIME, RESPONSIBLE_PERSON_ID RESPONSIBLE_PERSON_ID, TEXT TEXT, EFFORT_MINUTES EFFORT_MINUTES, COMPLETION_DATE COMPLETION_DATE, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, ACTION_SEVERITY_ID ACTION_SEVERITY_ID, TEXT_DESCRIPTION TEXT_DESCRIPTION, TEXT_RESOLUTION TEXT_RESOLUTION, ACTION_EFFECTIVE_DATE ACTION_EFFECTIVE_DATE, EXPECTED_RESOLUTION_DATE EXPECTED_RESOLUTION_DATE, ACTUAL_RESOLUTION_DATE ACTUAL_RESOLUTION_DATE, SERVICE_INVENTORY_ITEM_ID SERVICE_INVENTORY_ITEM_ID, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, CONTEXT CONTEXT, OPEN_FLAG OPEN_FLAG, WORKFLOW_PROCESS_ID WORKFLOW_PROCESS_ID, DISPATCHER_ORIG_SYST DISPATCHER_ORIG_SYST, DISPATCHER_ORIG_SYST_ID DISPATCHER_ORIG_SYST_ID, DISPATCH_ROLE_NAME DISPATCH_ROLE_NAME from "CS"."CS_INCIDENT_ACTIONS"

View Text - HTML Formatted

SELECT INCIDENT_ACTION_ID INCIDENT_ACTION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, INCIDENT_ID INCIDENT_ID
, ACTION_CODE ACTION_CODE
, ACTION_NUM ACTION_NUM
, ACTION_LINE_NUMBER ACTION_LINE_NUMBER
, ACTION_TYPE_ID ACTION_TYPE_ID
, ACTION_STATUS_ID ACTION_STATUS_ID
, RESPONSIBLE_GROUP_ID RESPONSIBLE_GROUP_ID
, ACTUAL_TIME ACTUAL_TIME
, RESPONSIBLE_PERSON_ID RESPONSIBLE_PERSON_ID
, TEXT TEXT
, EFFORT_MINUTES EFFORT_MINUTES
, COMPLETION_DATE COMPLETION_DATE
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, ACTION_SEVERITY_ID ACTION_SEVERITY_ID
, TEXT_DESCRIPTION TEXT_DESCRIPTION
, TEXT_RESOLUTION TEXT_RESOLUTION
, ACTION_EFFECTIVE_DATE ACTION_EFFECTIVE_DATE
, EXPECTED_RESOLUTION_DATE EXPECTED_RESOLUTION_DATE
, ACTUAL_RESOLUTION_DATE ACTUAL_RESOLUTION_DATE
, SERVICE_INVENTORY_ITEM_ID SERVICE_INVENTORY_ITEM_ID
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, CONTEXT CONTEXT
, OPEN_FLAG OPEN_FLAG
, WORKFLOW_PROCESS_ID WORKFLOW_PROCESS_ID
, DISPATCHER_ORIG_SYST DISPATCHER_ORIG_SYST
, DISPATCHER_ORIG_SYST_ID DISPATCHER_ORIG_SYST_ID
, DISPATCH_ROLE_NAME DISPATCH_ROLE_NAME
FROM "CS"."CS_INCIDENT_ACTIONS"