[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CS_INCIDENTS_AUDIT_B |
|---|---|
| Object Type: | TABLE |
| Owner: | CS |
| FND Design Data: |  CS.CS_INCIDENTS_AUDIT_B
|
| Subobject Name: | |
| Status: | VALID |
CS_INCIDENTS_AUDIT_B stores audit information for service requests. It is a detail table for CS_INCIDENTS_ALL_B and tracks changes to the service request attributes. This is the multi-language support base table and contains all of the fields from this table that are not translatable.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| CS_INCIDENTS_AUDIT_B_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 INCIDENT_AUDIT_ID
|
| CS_INCIDENTS_AUDIT_B_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INCIDENT_ID
|
| CS_INCIDENTS_AUDIT_B_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CREATION_DATE
|
| CS_INCIDENTS_AUDIT_B_UPG_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INCIDENT_OWNER_ID
|
| CS_INCIDENTS_AUDIT_B_UPG_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
OLD_INCIDENT_OWNER_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INCIDENT_ID | NUMBER | (15) | Yes | Service request identifier |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column - with the user id from FND_USER |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column - with the user id from FND_USER |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| CREATION_TIME | VARCHAR2 | (30) | Time the audit record is created | |
| INCIDENT_STATUS_ID | NUMBER | (15) | New service request status identifier | |
| OLD_INCIDENT_STATUS_ID | NUMBER | (15) | Old service request status identifier | |
| CHANGE_INCIDENT_STATUS_FLAG | VARCHAR2 | (1) | Flag indicating whether request status is changed | |
| INCIDENT_TYPE_ID | NUMBER | (15) | New service request type identifier | |
| OLD_INCIDENT_TYPE_ID | NUMBER | (15) | Old service request type identifier | |
| CHANGE_INCIDENT_TYPE_FLAG | VARCHAR2 | (1) | Flag indicating whether request type is changed | |
| INCIDENT_URGENCY_ID | NUMBER | (15) | New service request urgency identifier | |
| OLD_INCIDENT_URGENCY_ID | NUMBER | (15) | Old service request urgency identifier | |
| CHANGE_INCIDENT_URGENCY_FLAG | VARCHAR2 | (1) | Flag indicating whether request urgency is changed | |
| INCIDENT_SEVERITY_ID | NUMBER | (15) | New service request severity identifier | |
| OLD_INCIDENT_SEVERITY_ID | NUMBER | (15) | Old service request severity identifier | |
| CHANGE_INCIDENT_SEVERITY_FLAG | VARCHAR2 | (1) | Flag indicating whether request severity is changed | |
| RESPONSIBLE_GROUP_ID | NUMBER | (15) | Not currently used | |
| OLD_RESPONSIBLE_GROUP_ID | NUMBER | (15) | Not currently used | |
| CHANGE_RESPONSIBLE_GROUP_FLAG | VARCHAR2 | (1) | Not currently used | |
| INCIDENT_OWNER_ID | NUMBER | (15) | New service request owner identifier | |
| OLD_INCIDENT_OWNER_ID | NUMBER | (15) | Old service request owner identifier | |
| CHANGE_INCIDENT_OWNER_FLAG | VARCHAR2 | (1) | Flag indicating whether request owner is changed | |
| CREATE_MANUAL_ACTION | VARCHAR2 | (1) | Flag identifying that this audit record is for insert of action change | |
| ACTION_ID | NUMBER | (15) | Service request action identifier | |
| EXPECTED_RESOLUTION_DATE | DATE | New expected resolution date | ||
| OLD_EXPECTED_RESOLUTION_DATE | DATE | Old expected resolution date | ||
| CHANGE_RESOLUTION_FLAG | VARCHAR2 | (1) | Flag indicating whether expected resolution date is changed | |
| INCIDENT_AUDIT_ID | NUMBER | (15) | Yes | System-generated ID |
| CHANGE_DESCRIPTION | VARCHAR2 | (2000) | ||
| NEW_WORKFLOW_FLAG | VARCHAR2 | (1) | Flag indicating whether a new workflow process is launched | |
| WORKFLOW_PROCESS_NAME | VARCHAR2 | (30) | Name of the launched workflow process | |
| WORKFLOW_PROCESS_ITEMKEY | VARCHAR2 | (240) | Item key that identifies the launched workflow process | |
| GROUP_ID | NUMBER | New Group ID. See the CS_INCIDENTS_ALL_B table for more information. | ||
| OLD_GROUP_ID | NUMBER | Old Group ID. See the CS_INCIDENTS_ALL_B table for more information. | ||
| CHANGE_GROUP_FLAG | VARCHAR2 | (1) | Flag to indicate that the Group ID column has changed. | |
| OBLIGATION_DATE | DATE | New OBLIGATION_DATE. See the CS_INCIDENTS_ALL_B table for more information. | ||
| OLD_OBLIGATION_DATE | DATE | Old OBLIGATION_DATE. See the CS_INCIDENTS_ALL_B table for more information. | ||
| CHANGE_OBLIGATION_FLAG | VARCHAR2 | (1) | Flag to indicate that the Obligation Date column has changed. | |
| SITE_ID | NUMBER | New SITE_ID. See the CS_INCIDENTS_ALL_B table for more information. | ||
| OLD_SITE_ID | NUMBER | Old SITE_ID. See the CS_INCIDENTS_ALL_B table for more information. | ||
| CHANGE_SITE_FLAG | VARCHAR2 | (1) | Flag to indicate that the SITE_ID column has changed. | |
| BILL_TO_CONTACT_ID | NUMBER | (15) | New BILL_TO_CONTACT_ID. See the CS_INCIDENTS_ALL_B table for more information. | |
| OLD_BILL_TO_CONTACT_ID | NUMBER | (15) | Old BILL_TO_CONTACT_ID. See the CS_INCIDENTS_ALL_B table for more information. | |
| CHANGE_BILL_TO_FLAG | VARCHAR2 | (1) | Flag to indicate that the BILL_TO_CONTACT_ID column has changed. | |
| SHIP_TO_CONTACT_ID | NUMBER | (15) | New SHIP_TO_CONTACT_ID. See the CS_INCIDENTS_ALL_B table for more information. | |
| OLD_SHIP_TO_CONTACT_ID | NUMBER | (15) | Old SHIP_TO_CONTACT_ID. See the CS_INCIDENTS_ALL_B table for more information. | |
| CHANGE_SHIP_TO_FLAG | VARCHAR2 | (1) | Flag to indicate that the SHIP_TO_CONTACT_ID column has changed. | |
| INCIDENT_DATE | DATE | New INCIDENT_DATE. See the CS_INCIDENTS_ALL_B table for more information. | ||
| OLD_INCIDENT_DATE | DATE | Old INCIDENT_DATE. See the CS_INCIDENTS_ALL_B table for more information. | ||
| CHANGE_INCIDENT_DATE_FLAG | VARCHAR2 | (1) | Flag to indicate that the INCIDENT_DATE column has changed. | |
| CLOSE_DATE | DATE | New CLOSE_DATE. See the CS_INCIDENTS_ALL_B table for more information. | ||
| OLD_CLOSE_DATE | DATE | Old CLOSE_DATE. See the CS_INCIDENTS_ALL_B table for more information. | ||
| CHANGE_CLOSE_DATE_FLAG | VARCHAR2 | (1) | Flag to indicate that the CLOSE_DATE column has changed. | |
| CUSTOMER_PRODUCT_ID | NUMBER | (15) | New CUSTOMER_PRODUCT_ID. See the CS_INCIDENTS_ALL_B table for more information. | |
| OLD_CUSTOMER_PRODUCT_ID | NUMBER | (15) | Old CUSTOMER_PRODUCT_ID. See the CS_INCIDENTS_ALL_B table for more information. | |
| CHANGE_CUSTOMER_PRODUCT_FLAG | VARCHAR2 | (1) | Flag to indicate that the CUSTOMER_PRODUCT_ID column has changed. | |
| AUDIT_FIELD | VARCHAR2 | (30) | API stores null in this field for all records inserted. | |
| OBJECT_VERSION_NUMBER | NUMBER | (9) | Stamdard OBJECT_VERSION_NUMBER used for maintaining data integrity in environments whre record locking cannot be implemented. | |
| PLATFORM_ID | NUMBER | New PLATFORM_ID. See the CS_INCIDENTS_ALL_B table for more information. | ||
| OLD_PLATFORM_ID | NUMBER | Old PLATFORM_ID. See the CS_INCIDENTS_ALL_B table for more information. | ||
| CHANGE_PLATFORM_ID_FLAG | VARCHAR2 | (1) | Flag to indicate that the PLATFORM_ID column has changed. | |
| PLATFORM_VERSION_ID | NUMBER | New PLATFORM_VERSION_ID. See the CS_INCIDENTS_ALL_B table for more information. | ||
| OLD_PLATFORM_VERSION_ID | NUMBER | Old PLATFORM_VERSION_ID. See the CS_INCIDENTS_ALL_B table for more information. | ||
| CHANGE_PLAT_VER_ID_FLAG | VARCHAR2 | (1) | Flag to indicate that the PLATFORM_VERSION_ID column has changed. | |
| CP_COMPONENT_ID | NUMBER | New CP_COMPONENT_ID. See the CS_INCIDENTS_ALL_B table for more information. | ||
| OLD_CP_COMPONENT_ID | NUMBER | Old CP_COMPONENT_ID. See the CS_INCIDENTS_ALL_B table for more information. | ||
| CHANGE_CP_COMPONENT_ID_FLAG | VARCHAR2 | (1) | Flag to indicate that the CP_COMPONENT_ID column has changed. | |
| CP_COMPONENT_VERSION_ID | NUMBER | New CP_COMPONENT_VERSION_ID. See the CS_INCIDENTS_ALL_B table for more information. | ||
| OLD_CP_COMPONENT_VERSION_ID | NUMBER | Old CP_COMPONENT_VERSION_ID. See the CS_INCIDENTS_ALL_B table for more information. | ||
| CHANGE_CP_COMP_VER_ID_FLAG | VARCHAR2 | (1) | Flag to indicate that the CP_COMPONENT_VERSION_ID column has changed. | |
| CP_SUBCOMPONENT_ID | NUMBER | New CP_SUBCOMPONENT_ID. See the CS_INCIDENTS_ALL_B table for more information. | ||
| OLD_CP_SUBCOMPONENT_ID | NUMBER | Old CP_SUBCOMPONENT_ID. See the CS_INCIDENTS_ALL_B table for more information. | ||
| CHANGE_CP_SUBCOMPONENT_ID_FLAG | VARCHAR2 | (1) | Flag to indicate that the CP_SUBCOMPONENT_ID column has changed. | |
| CP_SUBCOMPONENT_VERSION_ID | NUMBER | New CP_SUBCOMPONENT_VERSION_ID. See the CS_INCIDENTS_ALL_B table for more information. | ||
| OLD_CP_SUBCOMPONENT_VERSION_ID | NUMBER | Old CP_SUBCOMPONENT_VERSION_ID. See the CS_INCIDENTS_ALL_B table for more information. | ||
| CHANGE_CP_SUBCOMP_VER_ID_FLAG | VARCHAR2 | (1) | Flag to indicate that the CP_SUBCOMPONENT_VERSION_ID column has changed. | |
| LANGUAGE_ID | NUMBER | New LANGUAGE_ID. See the CS_INCIDENTS_ALL_B table for more information. | ||
| OLD_LANGUAGE_ID | NUMBER | Old LANGUAGE_ID. See the CS_INCIDENTS_ALL_B table for more information. | ||
| CHANGE_LANGUAGE_ID_FLAG | VARCHAR2 | (1) | Flag to indicate that the LANGUAGE_ID column has changed. | |
| TERRITORY_ID | NUMBER | New TERRITORY_ID. See the CS_INCIDENTS_ALL_B table for more information. | ||
| OLD_TERRITORY_ID | NUMBER | Old TERRITORY_ID. See the CS_INCIDENTS_ALL_B table for more information. | ||
| CHANGE_TERRITORY_ID_FLAG | VARCHAR2 | (1) | Flag to indicate that the TERRITORY_ID column has changed. | |
| CP_REVISION_ID | NUMBER | New CP_REVISION_ID. See the CS_INCIDENTS_ALL_B table for more information. | ||
| OLD_CP_REVISION_ID | NUMBER | Old CP_REVISION_ID. See the CS_INCIDENTS_ALL_B table for more information. | ||
| CHANGE_CP_REVISION_ID_FLAG | VARCHAR2 | (1) | Flag to indicate that the CP_REVISION_ID column has changed. | |
| INV_ITEM_REVISION | VARCHAR2 | (240) | New INV_ITEM_REVISION. See the CS_INCIDENTS_ALL_B table for more information. | |
| OLD_INV_ITEM_REVISION | VARCHAR2 | (240) | Old INV_ITEM_REVISION. See the CS_INCIDENTS_ALL_B table for more information. | |
| CHANGE_INV_ITEM_REVISION | VARCHAR2 | (1) | Flag to indicate that the INV_ITEM_REVISION column has changed. | |
| INV_COMPONENT_ID | NUMBER | New INV_COMPONENT_ID. See the CS_INCIDENTS_ALL_B table for more information. | ||
| OLD_INV_COMPONENT_ID | NUMBER | Old INV_COMPONENT_ID. See the CS_INCIDENTS_ALL_B table for more information. | ||
| CHANGE_INV_COMPONENT_ID | VARCHAR2 | (1) | Flag to indicate that the INV_COMPONENT_ID column has changed. | |
| INV_COMPONENT_VERSION | VARCHAR2 | (90) | New INV_COMPONENT_VERSION. See the CS_INCIDENTS_ALL_B table for more information. | |
| OLD_INV_COMPONENT_VERSION | VARCHAR2 | (90) | Old INV_COMPONENT_VERSION. See the CS_INCIDENTS_ALL_B table for more information. | |
| CHANGE_INV_COMPONENT_VERSION | VARCHAR2 | (1) | Flag to indicate that the INV_COMPONENT_VERSION column has changed. | |
| INV_SUBCOMPONENT_ID | NUMBER | New INV_SUBCOMPONENT_ID. See the CS_INCIDENTS_ALL_B table for more information. | ||
| OLD_INV_SUBCOMPONENT_ID | NUMBER | Old INV_SUBCOMPONENT_VERSION. See the CS_INCIDENTS_ALL_B table for more information. | ||
| CHANGE_INV_SUBCOMPONENT_ID | VARCHAR2 | (1) | Flag to indicate that the INV_SUBCOMPONENT_ID column has changed. | |
| INV_SUBCOMPONENT_VERSION | VARCHAR2 | (90) | New INV_SUBCOMPONENT_VERSION. See the CS_INCIDENTS_ALL_B table for more information. | |
| OLD_INV_SUBCOMPONENT_VERSION | VARCHAR2 | (90) | Old INV_SUBCOMPONENT_VERSION. See the CS_INCIDENTS_ALL_B table for more information. | |
| CHANGE_INV_SUBCOMP_VERSION | VARCHAR2 | (1) | Flag to indicate that the INV_SUBCOMPONENT_VERSION column has changed. | |
| RESOURCE_TYPE | VARCHAR2 | (30) | Resource Type of Service Request. For example, EMPLOYEE, TEAM, or GROUP. | |
| OLD_RESOURCE_TYPE | VARCHAR2 | (30) | Old Resource Type of Service Request. For example, EMPLOYEE, TEAM, or GROUP. | |
| CHANGE_RESOURCE_TYPE_FLAG | VARCHAR2 | (1) | Flag indicating change in Resource Type | |
| SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
| UPGRADED_STATUS_FLAG | VARCHAR2 | (1) | Flag used to determine row status during upgrade | |
| REQUEST_ID | NUMBER | Used by concurrent programs to mark updated rows. | ||
| PROGRAM_APPLICATION_ID | NUMBER | Used by concurrent programs to mark updated rows. | ||
| PROGRAM_ID | NUMBER | Used by concurrent programs to mark updated rows. | ||
| PROGRAM_UPDATE_DATE | DATE | Used by concurrent programs to mark updated rows. | ||
| OLD_GROUP_TYPE | VARCHAR2 | (30) | Old resource type of the Group Owner. | |
| GROUP_TYPE | VARCHAR2 | (30) | New resource type of the Group Owner. | |
| CHANGE_GROUP_TYPE_FLAG | VARCHAR2 | (1) | Flag indicating change in Group Resource Type | |
| OLD_OWNER_ASSIGNED_TIME | DATE | The old Date/Time at which the service request was assigned to the owner. | ||
| OWNER_ASSIGNED_TIME | DATE | The new Date/Time at which the service request was assigned to the owner. | ||
| CHANGE_ASSIGNED_TIME_FLAG | VARCHAR2 | (1) | Flag indicating change in assigned time of the owner. | |
| INV_PLATFORM_ORG_ID | NUMBER | The Organization Identifier of the Product Platform. | ||
| OLD_INV_PLATFORM_ORG_ID | NUMBER | The Old Organization Identifier of the Product Platform. | ||
| CHANGE_PLATFORM_ORG_ID_FLAG | VARCHAR2 | (1) | The Change Flag of the Organization Identifierforf the Product Platform. | |
| COMPONENT_VERSION | VARCHAR2 | (3) | The Component Version of the Installed Base Product. | |
| OLD_COMPONENT_VERSION | VARCHAR2 | (3) | The Old Component Version of the Installed Base Product. | |
| CHANGE_COMP_VER_FLAG | VARCHAR2 | (1) | The Change Flag of the Component Version for the Installed Base Product. | |
| SUBCOMPONENT_VERSION | VARCHAR2 | (3) | The SubComponent Version of the Installed Base Product. | |
| OLD_SUBCOMPONENT_VERSION | VARCHAR2 | (3) | The Old SubComponent Version of the Installed Base Product. | |
| CHANGE_SUBCOMP_VER_FLAG | VARCHAR2 | (1) | The Change Flag of the SubComponent Version for the Installed Base Product. | |
| PRODUCT_REVISION | VARCHAR2 | (240) | The Revision Code of the Installed Base Product. | |
| OLD_PRODUCT_REVISION | VARCHAR2 | (240) | The Old Revision Code of the Installed Base Product. | |
| CHANGE_PRODUCT_REVISION_FLAG | VARCHAR2 | (1) | The Change Flag of the Revision Code forf the Installed Base Product. | |
| STATUS_FLAG | VARCHAR2 | (3) | Flag to denote whether the status of the SR is open or closed. | |
| OLD_STATUS_FLAG | VARCHAR2 | (3) | Old revision code for the Flag to denote whether the status of the SR is open or closed. | |
| CHANGE_STATUS_FLAG | VARCHAR2 | (3) | Change flag for the revision code for the Flag to denote whether the status of the SR is open or closed. | |
| INVENTORY_ITEM_ID | NUMBER | (15) | Item identifier | |
| OLD_INVENTORY_ITEM_ID | NUMBER | (15) | Old revision code for the inventory item id. | |
| CHANGE_INVENTORY_ITEM_FLAG | VARCHAR2 | (3) | Change flag for the revision code for the inventory item id. | |
| INV_ORGANIZATION_ID | NUMBER | This field stores the inventory organization id based on the profile AS_PRODUCT_ORGANIZATION_ID. | ||
| OLD_INV_ORGANIZATION_ID | NUMBER | Old revision code for the inventory organization id based on the profile AS_PRODUCT_ORGANIZATION_ID. | ||
| CHANGE_INV_ORGANIZATION_FLAG | VARCHAR2 | (3) | Change flag for the revision code for the inventory organization id based on the profile AS_PRODUCT_ORGANIZATION_ID. | |
| PRIMARY_CONTACT_ID | NUMBER | Service Request Contact Point Identifier.Foreign key to sr_contact_point_id of the cs_hz_sr_contact_points table. | ||
| OLD_PRIMARY_CONTACT_ID | NUMBER | Old revision code for the Service Request Contact Point Identifier.Foreign key to sr_contact_point_id of the cs_hz_sr_contact_points table. | ||
| CHANGE_PRIMARY_CONTACT_FLAG | VARCHAR2 | (3) | Change flag for the revision code for the Service Request Contact Point Identifier.Foreign key to sr_contact_point_id of the cs_hz_sr_contact_points table. | |
| UPGRADE_FLAG_FOR_CREATE | VARCHAR2 | (1) | ||
| OLD_INCIDENT_NUMBER | VARCHAR2 | (64) | Old Incident Number | |
| INCIDENT_NUMBER | VARCHAR2 | (64) | Incident Number | |
| OLD_CUSTOMER_ID | NUMBER | (15) | Old Customer Id | |
| CUSTOMER_ID | NUMBER | (15) | Customer Id | |
| OLD_BILL_TO_SITE_USE_ID | NUMBER | (15) | Old Bill To Site Use Id | |
| BILL_TO_SITE_USE_ID | NUMBER | (15) | Bill To Site Use Id | |
| OLD_EMPLOYEE_ID | NUMBER | (15) | Old Employee Id | |
| EMPLOYEE_ID | NUMBER | (15) | Employee Id | |
| OLD_SHIP_TO_SITE_USE_ID | NUMBER | (15) | Old Ship To Site Use Id | |
| SHIP_TO_SITE_USE_ID | NUMBER | (15) | Ship To Site Use Id | |
| OLD_PROBLEM_CODE | VARCHAR2 | (50) | Old Problem Code | |
| PROBLEM_CODE | VARCHAR2 | (50) | Problem Code | |
| OLD_ACTUAL_RESOLUTION_DATE | DATE | Old Actual Resolution Date | ||
| ACTUAL_RESOLUTION_DATE | DATE | Actual Resolution Date | ||
| OLD_INSTALL_SITE_USE_ID | NUMBER | (15) | Old Install Site Use Id | |
| INSTALL_SITE_USE_ID | NUMBER | (15) | Install Site Use Id | |
| OLD_CURRENT_SERIAL_NUMBER | VARCHAR2 | (30) | Old Current Serial Number | |
| CURRENT_SERIAL_NUMBER | VARCHAR2 | (30) | Current Serial Number | |
| OLD_SYSTEM_ID | NUMBER | (15) | Old System Id | |
| SYSTEM_ID | NUMBER | (15) | System Id | |
| OLD_INCIDENT_ATTRIBUTE_1 | VARCHAR2 | (150) | Old Incident Attribute 1 | |
| INCIDENT_ATTRIBUTE_1 | VARCHAR2 | (150) | Incident Attribute 1 | |
| OLD_INCIDENT_ATTRIBUTE_2 | VARCHAR2 | (150) | Old Incident Attribute 2 | |
| INCIDENT_ATTRIBUTE_2 | VARCHAR2 | (150) | Incident Attribute 2 | |
| OLD_INCIDENT_ATTRIBUTE_3 | VARCHAR2 | (150) | Old Incident Attribute 3 | |
| INCIDENT_ATTRIBUTE_3 | VARCHAR2 | (150) | Incident Attribute 3 | |
| OLD_INCIDENT_ATTRIBUTE_4 | VARCHAR2 | (150) | Old Incident Attribute 4 | |
| INCIDENT_ATTRIBUTE_4 | VARCHAR2 | (150) | Incident Attribute 4 | |
| OLD_INCIDENT_ATTRIBUTE_5 | VARCHAR2 | (150) | Old Incident Attribute 5 | |
| INCIDENT_ATTRIBUTE_5 | VARCHAR2 | (150) | Incident Attribute 5 | |
| OLD_INCIDENT_ATTRIBUTE_6 | VARCHAR2 | (150) | Old Incident Attribute 6 | |
| INCIDENT_ATTRIBUTE_6 | VARCHAR2 | (150) | Incident Attribute 6 | |
| OLD_INCIDENT_ATTRIBUTE_7 | VARCHAR2 | (150) | Old Incident Attribute 7 | |
| INCIDENT_ATTRIBUTE_7 | VARCHAR2 | (150) | Incident Attribute 7 | |
| OLD_INCIDENT_ATTRIBUTE_8 | VARCHAR2 | (150) | Old Incident Attribute 8 | |
| INCIDENT_ATTRIBUTE_8 | VARCHAR2 | (150) | Incident Attribute 8 | |
| OLD_INCIDENT_ATTRIBUTE_9 | VARCHAR2 | (150) | Old Incident Attribute 9 | |
| INCIDENT_ATTRIBUTE_9 | VARCHAR2 | (150) | Incident Attribute 9 | |
| OLD_INCIDENT_ATTRIBUTE_10 | VARCHAR2 | (150) | Old Incident Attribute 10 | |
| INCIDENT_ATTRIBUTE_10 | VARCHAR2 | (150) | Incident Attribute 10 | |
| OLD_INCIDENT_ATTRIBUTE_11 | VARCHAR2 | (150) | Old Incident Attribute 11 | |
| INCIDENT_ATTRIBUTE_11 | VARCHAR2 | (150) | Incident Attribute 11 | |
| OLD_INCIDENT_ATTRIBUTE_12 | VARCHAR2 | (150) | Old Incident Attribute 12 | |
| INCIDENT_ATTRIBUTE_12 | VARCHAR2 | (150) | Incident Attribute 12 | |
| OLD_INCIDENT_ATTRIBUTE_13 | VARCHAR2 | (150) | Old Incident Attribute 13 | |
| INCIDENT_ATTRIBUTE_13 | VARCHAR2 | (150) | Incident Attribute 13 | |
| OLD_INCIDENT_ATTRIBUTE_14 | VARCHAR2 | (150) | Old Incident Attribute 14 | |
| INCIDENT_ATTRIBUTE_14 | VARCHAR2 | (150) | Incident Attribute 14 | |
| OLD_INCIDENT_ATTRIBUTE_15 | VARCHAR2 | (150) | Old Incident Attribute 15 | |
| INCIDENT_ATTRIBUTE_15 | VARCHAR2 | (150) | Incident Attribute 15 | |
| OLD_INCIDENT_CONTEXT | VARCHAR2 | (30) | Old Incident Context | |
| INCIDENT_CONTEXT | VARCHAR2 | (30) | Incident Context | |
| OLD_RESOLUTION_CODE | VARCHAR2 | (50) | Old Resolution Code | |
| RESOLUTION_CODE | VARCHAR2 | (50) | Resolution Code | |
| OLD_ORIGINAL_ORDER_NUMBER | NUMBER | Old Original Order Number | ||
| ORIGINAL_ORDER_NUMBER | NUMBER | Original Order Number | ||
| OLD_ORG_ID | NUMBER | Old Org Id | ||
| ORG_ID | NUMBER | Org Id | ||
| OLD_PURCHASE_ORDER_NUMBER | VARCHAR2 | (50) | Old Purchase Order Number | |
| PURCHASE_ORDER_NUMBER | VARCHAR2 | (50) | Purchase Order Number | |
| OLD_PUBLISH_FLAG | VARCHAR2 | (1) | Old Publish Flag | |
| PUBLISH_FLAG | VARCHAR2 | (1) | Publish Flag | |
| OLD_QA_COLLECTION_ID | NUMBER | Old QA Collection Id | ||
| QA_COLLECTION_ID | NUMBER | Qa Collection Id | ||
| OLD_CONTRACT_ID | NUMBER | Old Contract Id | ||
| CONTRACT_ID | NUMBER | Contract Id | ||
| OLD_CONTRACT_NUMBER | VARCHAR2 | (120) | Old Contract Number | |
| CONTRACT_NUMBER | VARCHAR2 | (120) | Contract Number | |
| OLD_CONTRACT_SERVICE_ID | NUMBER | Old Contract Service Id | ||
| CONTRACT_SERVICE_ID | NUMBER | Contract Service Id | ||
| OLD_TIME_ZONE_ID | NUMBER | (15) | Old Time Zone Id | |
| TIME_ZONE_ID | NUMBER | (15) | Time Zone Id | |
| OLD_ACCOUNT_ID | NUMBER | Old Account Id | ||
| ACCOUNT_ID | NUMBER | Account Id | ||
| OLD_TIME_DIFFERENCE | NUMBER | Old Time Difference | ||
| TIME_DIFFERENCE | NUMBER | Time Difference | ||
| OLD_CUSTOMER_PO_NUMBER | VARCHAR2 | (50) | Old Customer Po Number | |
| CUSTOMER_PO_NUMBER | VARCHAR2 | (50) | Customer Po Number | |
| OLD_CUSTOMER_TICKET_NUMBER | VARCHAR2 | (50) | Old Customer Ticket Number | |
| CUSTOMER_TICKET_NUMBER | VARCHAR2 | (50) | Customer Ticket Number | |
| OLD_CUSTOMER_SITE_ID | NUMBER | Old Customer Site Id | ||
| CUSTOMER_SITE_ID | NUMBER | Customer Site Id | ||
| OLD_CALLER_TYPE | VARCHAR2 | (30) | Old Caller Type | |
| CALLER_TYPE | VARCHAR2 | (30) | Caller Type | |
| OLD_INC_OBJECT_VERSION_NUMBER | NUMBER | (9) | Old Inc Object Version Number | |
| INC_OBJECT_VERSION_NUMBER | NUMBER | (9) | Inc Object Version Number | |
| OLD_SECURITY_GROUP_ID | NUMBER | (15) | Old Security Group Id | |
| OLD_ORIG_SYSTEM_REFERENCE | VARCHAR2 | (60) | Old Orig System Reference | |
| ORIG_SYSTEM_REFERENCE | VARCHAR2 | (60) | Orig System Reference | |
| OLD_ORIG_SYSTEM_REFERENCE_ID | NUMBER | Old Orig System Reference Id | ||
| ORIG_SYSTEM_REFERENCE_ID | NUMBER | Orig System Reference Id | ||
| OLD_INC_REQUEST_ID | NUMBER | Old Inc Request Id | ||
| INC_REQUEST_ID | NUMBER | Inc Request Id | ||
| OLD_INC_PROGRAM_APPLICATION_ID | NUMBER | Old Inc Program Application Id | ||
| INC_PROGRAM_APPLICATION_ID | NUMBER | Inc Program Application Id | ||
| OLD_INC_PROGRAM_ID | NUMBER | Old Inc Program Id | ||
| INC_PROGRAM_ID | NUMBER | Inc Program Id | ||
| OLD_INC_PROGRAM_UPDATE_DATE | DATE | Old Inc Program Update Date | ||
| INC_PROGRAM_UPDATE_DATE | DATE | Inc Program Update Date | ||
| OLD_PROJECT_NUMBER | VARCHAR2 | (120) | Old Project Number | |
| PROJECT_NUMBER | VARCHAR2 | (120) | Project Number | |
| OLD_PLATFORM_VERSION | VARCHAR2 | (250) | Old Platform Version | |
| PLATFORM_VERSION | VARCHAR2 | (250) | Platform Version | |
| OLD_DB_VERSION | VARCHAR2 | (250) | Old Db Version | |
| DB_VERSION | VARCHAR2 | (250) | Db Version | |
| OLD_CUST_PREF_LANG_ID | NUMBER | Old Cust Pref Lang Id | ||
| CUST_PREF_LANG_ID | NUMBER | Cust Pref Lang Id | ||
| OLD_TIER | VARCHAR2 | (250) | Old Tier | |
| TIER | VARCHAR2 | (250) | Tier | |
| OLD_TIER_VERSION | VARCHAR2 | (250) | Old Tier Version | |
| TIER_VERSION | VARCHAR2 | (250) | Tier Version | |
| OLD_CATEGORY_ID | NUMBER | Old Category Id | ||
| CATEGORY_ID | NUMBER | Category Id | ||
| OLD_OPERATING_SYSTEM | VARCHAR2 | (250) | Old Operating System | |
| OPERATING_SYSTEM | VARCHAR2 | (250) | Operating System | |
| OLD_OPERATING_SYSTEM_VERSION | VARCHAR2 | (250) | Old Operating System Version | |
| OPERATING_SYSTEM_VERSION | VARCHAR2 | (250) | Operating System Version | |
| OLD_DATABASE | VARCHAR2 | (250) | Old Database | |
| DATABASE | VARCHAR2 | (250) | Database | |
| OLD_GROUP_TERRITORY_ID | NUMBER | Old Group Territory Id | ||
| GROUP_TERRITORY_ID | NUMBER | Group Territory Id | ||
| OLD_COMM_PREF_CODE | VARCHAR2 | (30) | Old Comm Pref Code | |
| COMM_PREF_CODE | VARCHAR2 | (30) | Comm Pref Code | |
| OLD_LAST_UPDATE_CHANNEL | VARCHAR2 | (10) | Old Last Update Channel | |
| LAST_UPDATE_CHANNEL | VARCHAR2 | (10) | Last Update Channel | |
| OLD_CUST_PREF_LANG_CODE | VARCHAR2 | (4) | Old Cust Pref Lang Code | |
| CUST_PREF_LANG_CODE | VARCHAR2 | (4) | Cust Pref Lang Code | |
| OLD_ERROR_CODE | VARCHAR2 | (250) | Old Error Code | |
| ERROR_CODE | VARCHAR2 | (250) | Error Code | |
| OLD_CATEGORY_SET_ID | NUMBER | Old Category Set Id | ||
| CATEGORY_SET_ID | NUMBER | Category Set Id | ||
| OLD_EXTERNAL_REFERENCE | VARCHAR2 | (30) | Old External Reference | |
| EXTERNAL_REFERENCE | VARCHAR2 | (30) | External Reference | |
| OLD_INCIDENT_OCCURRED_DATE | DATE | Old Incident Occurred Date | ||
| INCIDENT_OCCURRED_DATE | DATE | Incident Occurred Date | ||
| OLD_INCIDENT_RESOLVED_DATE | DATE | Old Incident Resolved Date | ||
| INCIDENT_RESOLVED_DATE | DATE | Incident Resolved Date | ||
| OLD_INC_RESPONDED_BY_DATE | DATE | Old Incident Responded By Date | ||
| INC_RESPONDED_BY_DATE | DATE | Incident Responded By Date | ||
| OLD_INCIDENT_LOCATION_ID | NUMBER | Old Incident Location Id | ||
| INCIDENT_LOCATION_ID | NUMBER | Incident Location Id | ||
| OLD_INCIDENT_ADDRESS | VARCHAR2 | (960) | Old Incident Address | |
| INCIDENT_ADDRESS | VARCHAR2 | (960) | Incident Address | |
| OLD_INCIDENT_CITY | VARCHAR2 | (60) | Old Incident City | |
| INCIDENT_CITY | VARCHAR2 | (60) | Incident City | |
| OLD_INCIDENT_STATE | VARCHAR2 | (60) | Old Incident State | |
| INCIDENT_STATE | VARCHAR2 | (60) | Incident State | |
| OLD_INCIDENT_COUNTRY | VARCHAR2 | (60) | Old Incident Country | |
| INCIDENT_COUNTRY | VARCHAR2 | (60) | Incident Country | |
| OLD_INCIDENT_PROVINCE | VARCHAR2 | (60) | Old Incident Province | |
| INCIDENT_PROVINCE | VARCHAR2 | (60) | Incident Province | |
| OLD_INCIDENT_POSTAL_CODE | VARCHAR2 | (60) | Old Incident Postal Code | |
| INCIDENT_POSTAL_CODE | VARCHAR2 | (60) | Incident Postal Code | |
| OLD_INCIDENT_COUNTY | VARCHAR2 | (60) | Old Incident County | |
| INCIDENT_COUNTY | VARCHAR2 | (60) | Incident County | |
| OLD_SR_CREATION_CHANNEL | VARCHAR2 | (50) | Old SR Creation Channel | |
| SR_CREATION_CHANNEL | VARCHAR2 | (50) | Sr Creation Channel | |
| OLD_DEF_DEFECT_ID | NUMBER | Old Def Defect Id | ||
| DEF_DEFECT_ID | NUMBER | Def Defect Id | ||
| OLD_DEF_DEFECT_ID2 | NUMBER | Old Def Defect Id2 | ||
| DEF_DEFECT_ID2 | NUMBER | Def Defect Id2 | ||
| OLD_CREDIT_CARD_NUMBER | VARCHAR2 | (48) | Obsolete column. Old Credit Card Number | |
| CREDIT_CARD_NUMBER | VARCHAR2 | (48) | Obsolete column. Credit Card Number | |
| OLD_CREDIT_CARD_TYPE_CODE | VARCHAR2 | (30) | Obsolete column. Old Credit Card Type Code | |
| CREDIT_CARD_TYPE_CODE | VARCHAR2 | (30) | Obsolete column. Credit Card Type Code | |
| OLD_CREDIT_CARD_EXPIRATION_DT | DATE | Obsolete column. Old Credit Card Expiration Date | ||
| CREDIT_CARD_EXPIRATION_DT | DATE | Obsolete column. Credit Card Expiration Date | ||
| OLD_CREDIT_CARD_HOLDER_FNAME | VARCHAR2 | (250) | Obsolete column. Old Credit Card Holder First Name | |
| CREDIT_CARD_HOLDER_FNAME | VARCHAR2 | (250) | Obsolete column. Credit Card Holder First Name | |
| OLD_CREDIT_CARD_HOLDER_MNAME | VARCHAR2 | (250) | Obsolete column. Old Credit Card Holder Middle name | |
| CREDIT_CARD_HOLDER_MNAME | VARCHAR2 | (250) | Obsolete column. Credit Card Holder Middle Name | |
| OLD_CREDIT_CARD_HOLDER_LNAME | VARCHAR2 | (250) | Obsolete column. Old Credit Card Holder Last Name | |
| CREDIT_CARD_HOLDER_LNAME | VARCHAR2 | (250) | Obsolete column. Credit Card Holder Last Name | |
| OLD_CREDIT_CARD_ID | NUMBER | Obsolete column. Old Credit Card Id | ||
| CREDIT_CARD_ID | NUMBER | Obsolete column. Credit Card Id | ||
| OLD_EXTERNAL_ATTRIBUTE_1 | VARCHAR2 | (150) | Old External Attribute 1 | |
| EXTERNAL_ATTRIBUTE_1 | VARCHAR2 | (150) | External Attribute 1 | |
| OLD_EXTERNAL_ATTRIBUTE_2 | VARCHAR2 | (150) | Old External Attribute 2 | |
| EXTERNAL_ATTRIBUTE_2 | VARCHAR2 | (150) | External Attribute 2 | |
| OLD_EXTERNAL_ATTRIBUTE_3 | VARCHAR2 | (150) | Old External Attribute 3 | |
| EXTERNAL_ATTRIBUTE_3 | VARCHAR2 | (150) | External Attribute 3 | |
| OLD_EXTERNAL_ATTRIBUTE_4 | VARCHAR2 | (150) | Old External Attribute 4 | |
| EXTERNAL_ATTRIBUTE_4 | VARCHAR2 | (150) | External Attribute 4 | |
| OLD_EXTERNAL_ATTRIBUTE_5 | VARCHAR2 | (150) | Old External Attribute 5 | |
| EXTERNAL_ATTRIBUTE_5 | VARCHAR2 | (150) | External Attribute 5 | |
| OLD_EXTERNAL_ATTRIBUTE_6 | VARCHAR2 | (150) | Old External Attribute 6 | |
| EXTERNAL_ATTRIBUTE_6 | VARCHAR2 | (150) | External Attribute 6 | |
| OLD_EXTERNAL_ATTRIBUTE_7 | VARCHAR2 | (150) | Old External Attribute 7 | |
| EXTERNAL_ATTRIBUTE_7 | VARCHAR2 | (150) | External Attribute 7 | |
| OLD_EXTERNAL_ATTRIBUTE_8 | VARCHAR2 | (150) | Old External Attribute 8 | |
| EXTERNAL_ATTRIBUTE_8 | VARCHAR2 | (150) | External Attribute 8 | |
| OLD_EXTERNAL_ATTRIBUTE_9 | VARCHAR2 | (150) | Old External Attribute 9 | |
| EXTERNAL_ATTRIBUTE_9 | VARCHAR2 | (150) | External Attribute 9 | |
| OLD_EXTERNAL_ATTRIBUTE_10 | VARCHAR2 | (150) | Old External Attribute 10 | |
| EXTERNAL_ATTRIBUTE_10 | VARCHAR2 | (150) | External Attribute 10 | |
| OLD_EXTERNAL_ATTRIBUTE_11 | VARCHAR2 | (150) | Old External Attribute 11 | |
| EXTERNAL_ATTRIBUTE_11 | VARCHAR2 | (150) | External Attribute 11 | |
| OLD_EXTERNAL_ATTRIBUTE_12 | VARCHAR2 | (150) | Old External Attribute 12 | |
| EXTERNAL_ATTRIBUTE_12 | VARCHAR2 | (150) | External Attribute 12 | |
| OLD_EXTERNAL_ATTRIBUTE_13 | VARCHAR2 | (150) | Old External Attribute 13 | |
| EXTERNAL_ATTRIBUTE_13 | VARCHAR2 | (150) | External Attribute 13 | |
| OLD_EXTERNAL_ATTRIBUTE_14 | VARCHAR2 | (150) | Old External Attribute 14 | |
| EXTERNAL_ATTRIBUTE_14 | VARCHAR2 | (150) | External Attribute 14 | |
| OLD_EXTERNAL_ATTRIBUTE_15 | VARCHAR2 | (150) | Old External Attribute 15 | |
| EXTERNAL_ATTRIBUTE_15 | VARCHAR2 | (150) | External Attribute 15 | |
| OLD_EXTERNAL_CONTEXT | VARCHAR2 | (30) | Old External Context | |
| EXTERNAL_CONTEXT | VARCHAR2 | (30) | External Context | |
| OLD_LAST_UPDATE_PROGRAM_CODE | VARCHAR2 | (30) | Old Last Update Program Code | |
| LAST_UPDATE_PROGRAM_CODE | VARCHAR2 | (30) | Last Update Program Code | |
| OLD_CREATION_PROGRAM_CODE | VARCHAR2 | (30) | Old Creation Program Code | |
| CREATION_PROGRAM_CODE | VARCHAR2 | (30) | Last Creation Program Code | |
| OLD_COVERAGE_TYPE | VARCHAR2 | (30) | Old Coverage Type | |
| COVERAGE_TYPE | VARCHAR2 | (30) | Coverage Type | |
| OLD_BILL_TO_ACCOUNT_ID | NUMBER | (15) | Old Bill To Account Id | |
| BILL_TO_ACCOUNT_ID | NUMBER | (15) | Bill To Account Id | |
| OLD_SHIP_TO_ACCOUNT_ID | NUMBER | (15) | Old Ship To Account Id | |
| SHIP_TO_ACCOUNT_ID | NUMBER | (15) | Ship To Account Id | |
| OLD_CUSTOMER_EMAIL_ID | NUMBER | (15) | Old Customer Email Id | |
| CUSTOMER_EMAIL_ID | NUMBER | (15) | Customer Email Id | |
| OLD_CUSTOMER_PHONE_ID | NUMBER | (15) | Old Customer Phone Id | |
| CUSTOMER_PHONE_ID | NUMBER | (15) | Customer Phone Id | |
| OLD_BILL_TO_PARTY_ID | NUMBER | Old Bill To party Id | ||
| BILL_TO_PARTY_ID | NUMBER | Bill To Party Id | ||
| OLD_SHIP_TO_PARTY_ID | NUMBER | Old Ship To Party Id | ||
| SHIP_TO_PARTY_ID | NUMBER | Ship To Party Id | ||
| OLD_BILL_TO_SITE_ID | NUMBER | Old Bill To Site Id | ||
| BILL_TO_SITE_ID | NUMBER | Bill To Site Id | ||
| OLD_SHIP_TO_SITE_ID | NUMBER | Old Ship To Site Id | ||
| SHIP_TO_SITE_ID | NUMBER | Ship To Site Id | ||
| OLD_PROGRAM_LOGIN_ID | NUMBER | Old Program Login Id | ||
| PROGRAM_LOGIN_ID | NUMBER | Program Login Id | ||
| OLD_INCIDENT_POINT_OF_INTEREST | VARCHAR2 | (240) | Old Incident Point Of Interest | |
| INCIDENT_POINT_OF_INTEREST | VARCHAR2 | (240) | Incident Point Of Interest | |
| OLD_INCIDENT_CROSS_STREET | VARCHAR2 | (240) | Old Incident Cross Street | |
| INCIDENT_CROSS_STREET | VARCHAR2 | (240) | Incident Cross Street | |
| OLD_INCIDENT_DIRECTION_QUALIF | VARCHAR2 | (30) | Old Incident Direction Qualifier | |
| INCIDENT_DIRECTION_QUALIF | VARCHAR2 | (30) | Incident Direction Qualifier | |
| OLD_INCIDENT_DISTANCE_QUALIF | VARCHAR2 | (240) | Old Incident Distance Qualifier | |
| INCIDENT_DISTANCE_QUALIF | VARCHAR2 | (240) | Incident Distance Qualifier | |
| OLD_INCIDENT_DISTANCE_QUAL_UOM | VARCHAR2 | (30) | Old Incident Distance Qual UOM | |
| INCIDENT_DISTANCE_QUAL_UOM | VARCHAR2 | (30) | Incident Distance Qual UOM | |
| OLD_INCIDENT_ADDRESS2 | VARCHAR2 | (240) | Old Incident Address2 | |
| INCIDENT_ADDRESS2 | VARCHAR2 | (240) | Incident Address2 | |
| OLD_INCIDENT_ADDRESS3 | VARCHAR2 | (240) | Old Incident Address3 | |
| INCIDENT_ADDRESS3 | VARCHAR2 | (240) | Incident Address3 | |
| OLD_INCIDENT_ADDRESS4 | VARCHAR2 | (240) | Old Incident Address4 | |
| INCIDENT_ADDRESS4 | VARCHAR2 | (240) | Incident Address4 | |
| OLD_INCIDENT_ADDRESS_STYLE | VARCHAR2 | (30) | Old Incident Address Style | |
| INCIDENT_ADDRESS_STYLE | VARCHAR2 | (30) | Incident Address Style | |
| OLD_INCIDENT_ADDR_LNS_PHONETIC | VARCHAR2 | (560) | Old Incident Addr Lines Phonetic | |
| INCIDENT_ADDR_LNS_PHONETIC | VARCHAR2 | (560) | Incident Addr Lines Phonetic | |
| OLD_INCIDENT_PO_BOX_NUMBER | VARCHAR2 | (50) | Old Incident Po Box Number | |
| INCIDENT_PO_BOX_NUMBER | VARCHAR2 | (50) | Incident Po Box Number | |
| OLD_INCIDENT_HOUSE_NUMBER | VARCHAR2 | (50) | Old Incident House Number | |
| INCIDENT_HOUSE_NUMBER | VARCHAR2 | (50) | Incident House Number | |
| OLD_INCIDENT_STREET_SUFFIX | VARCHAR2 | (50) | Old Incident Street Suffix | |
| INCIDENT_STREET_SUFFIX | VARCHAR2 | (50) | Incident Street Suffix | |
| OLD_INCIDENT_STREET | VARCHAR2 | (150) | Old Incident Street | |
| INCIDENT_STREET | VARCHAR2 | (150) | Incident Street | |
| OLD_INCIDENT_STREET_NUMBER | VARCHAR2 | (50) | Old Incident Street Number | |
| INCIDENT_STREET_NUMBER | VARCHAR2 | (50) | Incident Street Number | |
| OLD_INCIDENT_FLOOR | VARCHAR2 | (50) | Old Incident Floor | |
| INCIDENT_FLOOR | VARCHAR2 | (50) | Incident Floor | |
| OLD_INCIDENT_SUITE | VARCHAR2 | (50) | Old Incident Suite | |
| INCIDENT_SUITE | VARCHAR2 | (50) | Incident Suite | |
| OLD_INCIDENT_POSTAL_PLUS4_CODE | VARCHAR2 | (30) | Old Incident Postal Plus4 Code | |
| INCIDENT_POSTAL_PLUS4_CODE | VARCHAR2 | (30) | Incident Postal Plus4 Code | |
| OLD_INCIDENT_POSITION | VARCHAR2 | (50) | Old Incident Position | |
| INCIDENT_POSITION | VARCHAR2 | (50) | Incident Position | |
| OLD_INCIDENT_LOC_DIRECTIONS | VARCHAR2 | (640) | Old Incident Loc Directions | |
| INCIDENT_LOC_DIRECTIONS | VARCHAR2 | (640) | Incident Loc Directions | |
| OLD_INCIDENT_LOC_DESCRIPTION | VARCHAR2 | (2000) | Old Incident Loc Description | |
| INCIDENT_LOC_DESCRIPTION | VARCHAR2 | (2000) | Incident Loc Description | |
| OLD_INSTALL_SITE_ID | NUMBER | Old Install Site Id | ||
| INSTALL_SITE_ID | NUMBER | Install Site Id | ||
| INCIDENT_LAST_MODIFIED_DATE | DATE | Incident Last Modified Date | ||
| UPDATED_ENTITY_CODE | VARCHAR2 | (30) | Updated Entity Code | |
| UPDATED_ENTITY_ID | NUMBER | Updated Entity Id | ||
| ENTITY_ACTIVITY_CODE | VARCHAR2 | (30) | Entity Activity Code | |
| OLD_OWNING_DEPARTMENT_ID | NUMBER | Old Owning Department Id | ||
| OWNING_DEPARTMENT_ID | NUMBER | Owning Department Id | ||
| OLD_ITEM_SERIAL_NUMBER | VARCHAR2 | (30) | Obsolete column. Old Item Serial Number | |
| ITEM_SERIAL_NUMBER | VARCHAR2 | (30) | Obsolete column. Item Serial Number | |
| OLD_INCIDENT_LOCATION_TYPE | VARCHAR2 | (30) | Old Incident Location Type | |
| INCIDENT_LOCATION_TYPE | VARCHAR2 | (30) | Incident Location Type | |
| OLD_UNASSIGNED_INDICATOR | VARCHAR2 | (1) | Old Unassigned Indicator | |
| UNASSIGNED_INDICATOR | VARCHAR2 | (1) | Unassigned Indicator | |
| OLD_OWNER_ASSIGNED_FLAG | VARCHAR2 | (1) | Old Owner Assigned Flag | |
| OWNER_ASSIGNED_FLAG | VARCHAR2 | (1) | Owner Assigned Flag | |
| OLD_MAINT_ORGANIZATION_ID | NUMBER | Old eAM Maintenance organization id. | ||
| MAINT_ORGANIZATION_ID | NUMBER | eAM Maintenance organization id. |
Cut, paste (and edit) the following text to query this object:
SELECT INCIDENT_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, CREATION_TIME
, INCIDENT_STATUS_ID
, OLD_INCIDENT_STATUS_ID
, CHANGE_INCIDENT_STATUS_FLAG
, INCIDENT_TYPE_ID
, OLD_INCIDENT_TYPE_ID
, CHANGE_INCIDENT_TYPE_FLAG
, INCIDENT_URGENCY_ID
, OLD_INCIDENT_URGENCY_ID
, CHANGE_INCIDENT_URGENCY_FLAG
, INCIDENT_SEVERITY_ID
, OLD_INCIDENT_SEVERITY_ID
, CHANGE_INCIDENT_SEVERITY_FLAG
, RESPONSIBLE_GROUP_ID
, OLD_RESPONSIBLE_GROUP_ID
, CHANGE_RESPONSIBLE_GROUP_FLAG
, INCIDENT_OWNER_ID
, OLD_INCIDENT_OWNER_ID
, CHANGE_INCIDENT_OWNER_FLAG
, CREATE_MANUAL_ACTION
, ACTION_ID
, EXPECTED_RESOLUTION_DATE
, OLD_EXPECTED_RESOLUTION_DATE
, CHANGE_RESOLUTION_FLAG
, INCIDENT_AUDIT_ID
, CHANGE_DESCRIPTION
, NEW_WORKFLOW_FLAG
, WORKFLOW_PROCESS_NAME
, WORKFLOW_PROCESS_ITEMKEY
, GROUP_ID
, OLD_GROUP_ID
, CHANGE_GROUP_FLAG
, OBLIGATION_DATE
, OLD_OBLIGATION_DATE
, CHANGE_OBLIGATION_FLAG
, SITE_ID
, OLD_SITE_ID
, CHANGE_SITE_FLAG
, BILL_TO_CONTACT_ID
, OLD_BILL_TO_CONTACT_ID
, CHANGE_BILL_TO_FLAG
, SHIP_TO_CONTACT_ID
, OLD_SHIP_TO_CONTACT_ID
, CHANGE_SHIP_TO_FLAG
, INCIDENT_DATE
, OLD_INCIDENT_DATE
, CHANGE_INCIDENT_DATE_FLAG
, CLOSE_DATE
, OLD_CLOSE_DATE
, CHANGE_CLOSE_DATE_FLAG
, CUSTOMER_PRODUCT_ID
, OLD_CUSTOMER_PRODUCT_ID
, CHANGE_CUSTOMER_PRODUCT_FLAG
, AUDIT_FIELD
, OBJECT_VERSION_NUMBER
, PLATFORM_ID
, OLD_PLATFORM_ID
, CHANGE_PLATFORM_ID_FLAG
, PLATFORM_VERSION_ID
, OLD_PLATFORM_VERSION_ID
, CHANGE_PLAT_VER_ID_FLAG
, CP_COMPONENT_ID
, OLD_CP_COMPONENT_ID
, CHANGE_CP_COMPONENT_ID_FLAG
, CP_COMPONENT_VERSION_ID
, OLD_CP_COMPONENT_VERSION_ID
, CHANGE_CP_COMP_VER_ID_FLAG
, CP_SUBCOMPONENT_ID
, OLD_CP_SUBCOMPONENT_ID
, CHANGE_CP_SUBCOMPONENT_ID_FLAG
, CP_SUBCOMPONENT_VERSION_ID
, OLD_CP_SUBCOMPONENT_VERSION_ID
, CHANGE_CP_SUBCOMP_VER_ID_FLAG
, LANGUAGE_ID
, OLD_LANGUAGE_ID
, CHANGE_LANGUAGE_ID_FLAG
, TERRITORY_ID
, OLD_TERRITORY_ID
, CHANGE_TERRITORY_ID_FLAG
, CP_REVISION_ID
, OLD_CP_REVISION_ID
, CHANGE_CP_REVISION_ID_FLAG
, INV_ITEM_REVISION
, OLD_INV_ITEM_REVISION
, CHANGE_INV_ITEM_REVISION
, INV_COMPONENT_ID
, OLD_INV_COMPONENT_ID
, CHANGE_INV_COMPONENT_ID
, INV_COMPONENT_VERSION
, OLD_INV_COMPONENT_VERSION
, CHANGE_INV_COMPONENT_VERSION
, INV_SUBCOMPONENT_ID
, OLD_INV_SUBCOMPONENT_ID
, CHANGE_INV_SUBCOMPONENT_ID
, INV_SUBCOMPONENT_VERSION
, OLD_INV_SUBCOMPONENT_VERSION
, CHANGE_INV_SUBCOMP_VERSION
, RESOURCE_TYPE
, OLD_RESOURCE_TYPE
, CHANGE_RESOURCE_TYPE_FLAG
, SECURITY_GROUP_ID
, UPGRADED_STATUS_FLAG
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, OLD_GROUP_TYPE
, GROUP_TYPE
, CHANGE_GROUP_TYPE_FLAG
, OLD_OWNER_ASSIGNED_TIME
, OWNER_ASSIGNED_TIME
, CHANGE_ASSIGNED_TIME_FLAG
, INV_PLATFORM_ORG_ID
, OLD_INV_PLATFORM_ORG_ID
, CHANGE_PLATFORM_ORG_ID_FLAG
, COMPONENT_VERSION
, OLD_COMPONENT_VERSION
, CHANGE_COMP_VER_FLAG
, SUBCOMPONENT_VERSION
, OLD_SUBCOMPONENT_VERSION
, CHANGE_SUBCOMP_VER_FLAG
, PRODUCT_REVISION
, OLD_PRODUCT_REVISION
, CHANGE_PRODUCT_REVISION_FLAG
, STATUS_FLAG
, OLD_STATUS_FLAG
, CHANGE_STATUS_FLAG
, INVENTORY_ITEM_ID
, OLD_INVENTORY_ITEM_ID
, CHANGE_INVENTORY_ITEM_FLAG
, INV_ORGANIZATION_ID
, OLD_INV_ORGANIZATION_ID
, CHANGE_INV_ORGANIZATION_FLAG
, PRIMARY_CONTACT_ID
, OLD_PRIMARY_CONTACT_ID
, CHANGE_PRIMARY_CONTACT_FLAG
, UPGRADE_FLAG_FOR_CREATE
, OLD_INCIDENT_NUMBER
, INCIDENT_NUMBER
, OLD_CUSTOMER_ID
, CUSTOMER_ID
, OLD_BILL_TO_SITE_USE_ID
, BILL_TO_SITE_USE_ID
, OLD_EMPLOYEE_ID
, EMPLOYEE_ID
, OLD_SHIP_TO_SITE_USE_ID
, SHIP_TO_SITE_USE_ID
, OLD_PROBLEM_CODE
, PROBLEM_CODE
, OLD_ACTUAL_RESOLUTION_DATE
, ACTUAL_RESOLUTION_DATE
, OLD_INSTALL_SITE_USE_ID
, INSTALL_SITE_USE_ID
, OLD_CURRENT_SERIAL_NUMBER
, CURRENT_SERIAL_NUMBER
, OLD_SYSTEM_ID
, SYSTEM_ID
, OLD_INCIDENT_ATTRIBUTE_1
, INCIDENT_ATTRIBUTE_1
, OLD_INCIDENT_ATTRIBUTE_2
, INCIDENT_ATTRIBUTE_2
, OLD_INCIDENT_ATTRIBUTE_3
, INCIDENT_ATTRIBUTE_3
, OLD_INCIDENT_ATTRIBUTE_4
, INCIDENT_ATTRIBUTE_4
, OLD_INCIDENT_ATTRIBUTE_5
, INCIDENT_ATTRIBUTE_5
, OLD_INCIDENT_ATTRIBUTE_6
, INCIDENT_ATTRIBUTE_6
, OLD_INCIDENT_ATTRIBUTE_7
, INCIDENT_ATTRIBUTE_7
, OLD_INCIDENT_ATTRIBUTE_8
, INCIDENT_ATTRIBUTE_8
, OLD_INCIDENT_ATTRIBUTE_9
, INCIDENT_ATTRIBUTE_9
, OLD_INCIDENT_ATTRIBUTE_10
, INCIDENT_ATTRIBUTE_10
, OLD_INCIDENT_ATTRIBUTE_11
, INCIDENT_ATTRIBUTE_11
, OLD_INCIDENT_ATTRIBUTE_12
, INCIDENT_ATTRIBUTE_12
, OLD_INCIDENT_ATTRIBUTE_13
, INCIDENT_ATTRIBUTE_13
, OLD_INCIDENT_ATTRIBUTE_14
, INCIDENT_ATTRIBUTE_14
, OLD_INCIDENT_ATTRIBUTE_15
, INCIDENT_ATTRIBUTE_15
, OLD_INCIDENT_CONTEXT
, INCIDENT_CONTEXT
, OLD_RESOLUTION_CODE
, RESOLUTION_CODE
, OLD_ORIGINAL_ORDER_NUMBER
, ORIGINAL_ORDER_NUMBER
, OLD_ORG_ID
, ORG_ID
, OLD_PURCHASE_ORDER_NUMBER
, PURCHASE_ORDER_NUMBER
, OLD_PUBLISH_FLAG
, PUBLISH_FLAG
, OLD_QA_COLLECTION_ID
, QA_COLLECTION_ID
, OLD_CONTRACT_ID
, CONTRACT_ID
, OLD_CONTRACT_NUMBER
, CONTRACT_NUMBER
, OLD_CONTRACT_SERVICE_ID
, CONTRACT_SERVICE_ID
, OLD_TIME_ZONE_ID
, TIME_ZONE_ID
, OLD_ACCOUNT_ID
, ACCOUNT_ID
, OLD_TIME_DIFFERENCE
, TIME_DIFFERENCE
, OLD_CUSTOMER_PO_NUMBER
, CUSTOMER_PO_NUMBER
, OLD_CUSTOMER_TICKET_NUMBER
, CUSTOMER_TICKET_NUMBER
, OLD_CUSTOMER_SITE_ID
, CUSTOMER_SITE_ID
, OLD_CALLER_TYPE
, CALLER_TYPE
, OLD_INC_OBJECT_VERSION_NUMBER
, INC_OBJECT_VERSION_NUMBER
, OLD_SECURITY_GROUP_ID
, OLD_ORIG_SYSTEM_REFERENCE
, ORIG_SYSTEM_REFERENCE
, OLD_ORIG_SYSTEM_REFERENCE_ID
, ORIG_SYSTEM_REFERENCE_ID
, OLD_INC_REQUEST_ID
, INC_REQUEST_ID
, OLD_INC_PROGRAM_APPLICATION_ID
, INC_PROGRAM_APPLICATION_ID
, OLD_INC_PROGRAM_ID
, INC_PROGRAM_ID
, OLD_INC_PROGRAM_UPDATE_DATE
, INC_PROGRAM_UPDATE_DATE
, OLD_PROJECT_NUMBER
, PROJECT_NUMBER
, OLD_PLATFORM_VERSION
, PLATFORM_VERSION
, OLD_DB_VERSION
, DB_VERSION
, OLD_CUST_PREF_LANG_ID
, CUST_PREF_LANG_ID
, OLD_TIER
, TIER
, OLD_TIER_VERSION
, TIER_VERSION
, OLD_CATEGORY_ID
, CATEGORY_ID
, OLD_OPERATING_SYSTEM
, OPERATING_SYSTEM
, OLD_OPERATING_SYSTEM_VERSION
, OPERATING_SYSTEM_VERSION
, OLD_DATABASE
, DATABASE
, OLD_GROUP_TERRITORY_ID
, GROUP_TERRITORY_ID
, OLD_COMM_PREF_CODE
, COMM_PREF_CODE
, OLD_LAST_UPDATE_CHANNEL
, LAST_UPDATE_CHANNEL
, OLD_CUST_PREF_LANG_CODE
, CUST_PREF_LANG_CODE
, OLD_ERROR_CODE
, ERROR_CODE
, OLD_CATEGORY_SET_ID
, CATEGORY_SET_ID
, OLD_EXTERNAL_REFERENCE
, EXTERNAL_REFERENCE
, OLD_INCIDENT_OCCURRED_DATE
, INCIDENT_OCCURRED_DATE
, OLD_INCIDENT_RESOLVED_DATE
, INCIDENT_RESOLVED_DATE
, OLD_INC_RESPONDED_BY_DATE
, INC_RESPONDED_BY_DATE
, OLD_INCIDENT_LOCATION_ID
, INCIDENT_LOCATION_ID
, OLD_INCIDENT_ADDRESS
, INCIDENT_ADDRESS
, OLD_INCIDENT_CITY
, INCIDENT_CITY
, OLD_INCIDENT_STATE
, INCIDENT_STATE
, OLD_INCIDENT_COUNTRY
, INCIDENT_COUNTRY
, OLD_INCIDENT_PROVINCE
, INCIDENT_PROVINCE
, OLD_INCIDENT_POSTAL_CODE
, INCIDENT_POSTAL_CODE
, OLD_INCIDENT_COUNTY
, INCIDENT_COUNTY
, OLD_SR_CREATION_CHANNEL
, SR_CREATION_CHANNEL
, OLD_DEF_DEFECT_ID
, DEF_DEFECT_ID
, OLD_DEF_DEFECT_ID2
, DEF_DEFECT_ID2
, OLD_CREDIT_CARD_NUMBER
, CREDIT_CARD_NUMBER
, OLD_CREDIT_CARD_TYPE_CODE
, CREDIT_CARD_TYPE_CODE
, OLD_CREDIT_CARD_EXPIRATION_DT
, CREDIT_CARD_EXPIRATION_DT
, OLD_CREDIT_CARD_HOLDER_FNAME
, CREDIT_CARD_HOLDER_FNAME
, OLD_CREDIT_CARD_HOLDER_MNAME
, CREDIT_CARD_HOLDER_MNAME
, OLD_CREDIT_CARD_HOLDER_LNAME
, CREDIT_CARD_HOLDER_LNAME
, OLD_CREDIT_CARD_ID
, CREDIT_CARD_ID
, OLD_EXTERNAL_ATTRIBUTE_1
, EXTERNAL_ATTRIBUTE_1
, OLD_EXTERNAL_ATTRIBUTE_2
, EXTERNAL_ATTRIBUTE_2
, OLD_EXTERNAL_ATTRIBUTE_3
, EXTERNAL_ATTRIBUTE_3
, OLD_EXTERNAL_ATTRIBUTE_4
, EXTERNAL_ATTRIBUTE_4
, OLD_EXTERNAL_ATTRIBUTE_5
, EXTERNAL_ATTRIBUTE_5
, OLD_EXTERNAL_ATTRIBUTE_6
, EXTERNAL_ATTRIBUTE_6
, OLD_EXTERNAL_ATTRIBUTE_7
, EXTERNAL_ATTRIBUTE_7
, OLD_EXTERNAL_ATTRIBUTE_8
, EXTERNAL_ATTRIBUTE_8
, OLD_EXTERNAL_ATTRIBUTE_9
, EXTERNAL_ATTRIBUTE_9
, OLD_EXTERNAL_ATTRIBUTE_10
, EXTERNAL_ATTRIBUTE_10
, OLD_EXTERNAL_ATTRIBUTE_11
, EXTERNAL_ATTRIBUTE_11
, OLD_EXTERNAL_ATTRIBUTE_12
, EXTERNAL_ATTRIBUTE_12
, OLD_EXTERNAL_ATTRIBUTE_13
, EXTERNAL_ATTRIBUTE_13
, OLD_EXTERNAL_ATTRIBUTE_14
, EXTERNAL_ATTRIBUTE_14
, OLD_EXTERNAL_ATTRIBUTE_15
, EXTERNAL_ATTRIBUTE_15
, OLD_EXTERNAL_CONTEXT
, EXTERNAL_CONTEXT
, OLD_LAST_UPDATE_PROGRAM_CODE
, LAST_UPDATE_PROGRAM_CODE
, OLD_CREATION_PROGRAM_CODE
, CREATION_PROGRAM_CODE
, OLD_COVERAGE_TYPE
, COVERAGE_TYPE
, OLD_BILL_TO_ACCOUNT_ID
, BILL_TO_ACCOUNT_ID
, OLD_SHIP_TO_ACCOUNT_ID
, SHIP_TO_ACCOUNT_ID
, OLD_CUSTOMER_EMAIL_ID
, CUSTOMER_EMAIL_ID
, OLD_CUSTOMER_PHONE_ID
, CUSTOMER_PHONE_ID
, OLD_BILL_TO_PARTY_ID
, BILL_TO_PARTY_ID
, OLD_SHIP_TO_PARTY_ID
, SHIP_TO_PARTY_ID
, OLD_BILL_TO_SITE_ID
, BILL_TO_SITE_ID
, OLD_SHIP_TO_SITE_ID
, SHIP_TO_SITE_ID
, OLD_PROGRAM_LOGIN_ID
, PROGRAM_LOGIN_ID
, OLD_INCIDENT_POINT_OF_INTEREST
, INCIDENT_POINT_OF_INTEREST
, OLD_INCIDENT_CROSS_STREET
, INCIDENT_CROSS_STREET
, OLD_INCIDENT_DIRECTION_QUALIF
, INCIDENT_DIRECTION_QUALIF
, OLD_INCIDENT_DISTANCE_QUALIF
, INCIDENT_DISTANCE_QUALIF
, OLD_INCIDENT_DISTANCE_QUAL_UOM
, INCIDENT_DISTANCE_QUAL_UOM
, OLD_INCIDENT_ADDRESS2
, INCIDENT_ADDRESS2
, OLD_INCIDENT_ADDRESS3
, INCIDENT_ADDRESS3
, OLD_INCIDENT_ADDRESS4
, INCIDENT_ADDRESS4
, OLD_INCIDENT_ADDRESS_STYLE
, INCIDENT_ADDRESS_STYLE
, OLD_INCIDENT_ADDR_LNS_PHONETIC
, INCIDENT_ADDR_LNS_PHONETIC
, OLD_INCIDENT_PO_BOX_NUMBER
, INCIDENT_PO_BOX_NUMBER
, OLD_INCIDENT_HOUSE_NUMBER
, INCIDENT_HOUSE_NUMBER
, OLD_INCIDENT_STREET_SUFFIX
, INCIDENT_STREET_SUFFIX
, OLD_INCIDENT_STREET
, INCIDENT_STREET
, OLD_INCIDENT_STREET_NUMBER
, INCIDENT_STREET_NUMBER
, OLD_INCIDENT_FLOOR
, INCIDENT_FLOOR
, OLD_INCIDENT_SUITE
, INCIDENT_SUITE
, OLD_INCIDENT_POSTAL_PLUS4_CODE
, INCIDENT_POSTAL_PLUS4_CODE
, OLD_INCIDENT_POSITION
, INCIDENT_POSITION
, OLD_INCIDENT_LOC_DIRECTIONS
, INCIDENT_LOC_DIRECTIONS
, OLD_INCIDENT_LOC_DESCRIPTION
, INCIDENT_LOC_DESCRIPTION
, OLD_INSTALL_SITE_ID
, INSTALL_SITE_ID
, INCIDENT_LAST_MODIFIED_DATE
, UPDATED_ENTITY_CODE
, UPDATED_ENTITY_ID
, ENTITY_ACTIVITY_CODE
, OLD_OWNING_DEPARTMENT_ID
, OWNING_DEPARTMENT_ID
, OLD_ITEM_SERIAL_NUMBER
, ITEM_SERIAL_NUMBER
, OLD_INCIDENT_LOCATION_TYPE
, INCIDENT_LOCATION_TYPE
, OLD_UNASSIGNED_INDICATOR
, UNASSIGNED_INDICATOR
, OLD_OWNER_ASSIGNED_FLAG
, OWNER_ASSIGNED_FLAG
, OLD_MAINT_ORGANIZATION_ID
, MAINT_ORGANIZATION_ID
FROM CS.CS_INCIDENTS_AUDIT_B;
CS.CS_INCIDENTS_AUDIT_B does not reference any database object
CS.CS_INCIDENTS_AUDIT_B is referenced by following:
APPS
CS_INCIDENTS_AUDIT_B
|
|
|
|