[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CS_INCIDENTS_ALL_B |
|---|---|
| Object Type: | TABLE |
| Owner: | CS |
| FND Design Data: |  CS.CS_INCIDENTS_ALL_B
|
| Subobject Name: | |
| Status: | VALID |
CS_INCIDENTS_ALL_B stores information about service requests. A service request can be logged against any product, any product in inventory, or any product in the install base. Each row contains information about a single service request.This table is partitioned by ORG_ID in a multi-organizational environment.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_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 INCIDENT_ID
|
| CS_INCIDENTS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
INCIDENT_NUMBER
|
| CS_INCIDENTS_U3 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
RMA_HEADER_ID
|
| CS_INCIDENTS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INVENTORY_ITEM_ID
|
| CS_INCIDENTS_N12 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CLOSE_DATE
EXPECTED_RESOLUTION_DATE
|
| CS_INCIDENTS_N13 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
EXPECTED_RESOLUTION_DATE
CLOSE_DATE
|
| CS_INCIDENTS_N14 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
OWNER_GROUP_ID
STATUS_FLAG
UNASSIGNED_INDICATOR
|
| CS_INCIDENTS_N15 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INCIDENT_OWNER_ID
STATUS_FLAG
|
| CS_INCIDENTS_N16 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CREATION_DATE
|
| CS_INCIDENTS_N17 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PROBLEM_CODE
|
| CS_INCIDENTS_N18 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
RESOLUTION_CODE
|
| CS_INCIDENTS_N19 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CUSTOMER_TICKET_NUMBER
|
| CS_INCIDENTS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CUSTOMER_ID
|
| CS_INCIDENTS_N20 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
STATUS_FLAG
UNASSIGNED_INDICATOR
|
| CS_INCIDENTS_N21 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CURRENT_SERIAL_NUMBER
|
| CS_INCIDENTS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INCIDENT_OWNER_ID
INCIDENT_STATUS_ID
|
| CS_INCIDENTS_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INCIDENT_STATUS_ID
INCIDENT_OWNER_ID
|
| CS_INCIDENTS_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INCIDENT_TYPE_ID
|
| CS_INCIDENTS_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INCIDENT_URGENCY_ID
|
| CS_INCIDENTS_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INCIDENT_SEVERITY_ID
|
| CS_INCIDENTS_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CUSTOMER_PRODUCT_ID
|
| CS_INCIDENTS_N9 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INCIDENT_DATE
|
| 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) | ||
| INCIDENT_NUMBER | VARCHAR2 | (64) | Yes | Service request number |
| INCIDENT_DATE | DATE | Service request date | ||
| OPEN_FLAG | VARCHAR2 | (1) | ||
| SERVICE_ENTITY_ID | NUMBER | (15) | ||
| INCIDENT_STATUS_ID | NUMBER | (15) | Yes | Identifier for service request status |
| INCIDENT_TYPE_ID | NUMBER | (15) | Yes | Identifier for service request type |
| INCIDENT_URGENCY_ID | NUMBER | (15) | Identifier for service request urgency | |
| INCIDENT_SEVERITY_ID | NUMBER | (15) | Yes | Identifier for service request severity |
| SUMMARY | VARCHAR2 | (80) | ||
| RESPONSIBLE_GROUP_ID | NUMBER | (15) | ||
| SECURITY_LEVEL_CODE | VARCHAR2 | (30) | ||
| INCIDENT_OWNER_ID | NUMBER | (15) | Identifier for the owner of the service request | |
| CLASSIFICATION_CODE | VARCHAR2 | (30) | ||
| INVENTORY_ITEM_ID | NUMBER | (15) | Item identifier | |
| COMPONENT_INVENTORY_ITEM_ID | NUMBER | (15) | ||
| CUSTOMER_ID | NUMBER | (15) | Customer identifier | |
| ORIGINAL_CUSTOMER_ID | NUMBER | (15) | ||
| CUSTOMER_NAME | VARCHAR2 | (50) | ||
| BILL_TO_SITE_USE_ID | NUMBER | (15) | Identifier for bill-to site use | |
| PURCHASE_ORDER_NUM | VARCHAR2 | (50) | Not Used. | |
| IDENTIFICATION_NUMBER | VARCHAR2 | (50) | ||
| SERVICE_INVENTORY_ITEM_ID | NUMBER | (15) | ||
| EMPLOYEE_ID | NUMBER | (15) | Obsolete | |
| FILED_BY_EMPLOYEE_FLAG | VARCHAR2 | (1) | Indicates whether the request was made by an employee | |
| BILLABLE_FLAG | VARCHAR2 | (1) | ||
| SHIP_TO_SITE_USE_ID | NUMBER | (15) | Identifier for ship- to site use | |
| PROBLEM_CODE | VARCHAR2 | (50) | Problem code | |
| EXPECTED_RESOLUTION_DATE | DATE | Expected date for the problem resolution | ||
| ACTUAL_RESOLUTION_DATE | DATE | Actual date of resolution | ||
| PROBLEM_DESCRIPTION | VARCHAR2 | (2000) | ||
| RESOLUTION_DESCRIPTION | VARCHAR2 | (2000) | ||
| RUNNING_TOTALS | NUMBER | |||
| CURRENT_CONTACT_PERSON_ID | NUMBER | (15) | ||
| INITIATING_PERSON_ID | NUMBER | (15) | ||
| CURRENT_CONTACT_NAME | VARCHAR2 | (100) | ||
| CURRENT_CONTACT_AREA_CODE | VARCHAR2 | (10) | ||
| CURRENT_CONTACT_TELEPHONE | VARCHAR2 | (25) | ||
| CURRENT_CONTACT_EXTENSION | VARCHAR2 | (20) | ||
| CURRENT_CONTACT_EMAIL_ADDRESS | VARCHAR2 | (240) | ||
| CURRENT_CONTACT_TIME_DIFF | NUMBER | (3) | ||
| CURRENT_CONTACT_FAX_AREA_CODE | VARCHAR2 | (10) | ||
| CURRENT_CONTACT_FAX_NUMBER | VARCHAR2 | (25) | ||
| REPRESENTED_BY_EMPLOYEE | VARCHAR2 | (1) | ||
| REPRESENTED_BY_NAME | VARCHAR2 | (100) | ||
| REPRESENTED_BY_TIME_DIFFERENCE | NUMBER | (3) | ||
| REPRESENTED_BY_AREA_CODE | VARCHAR2 | (10) | ||
| REPRESENTED_BY_TELEPHONE | VARCHAR2 | (25) | ||
| REPRESENTED_BY_EXTENSION | VARCHAR2 | (20) | ||
| REPRESENTED_BY_FAX_AREA_CODE | VARCHAR2 | (10) | ||
| REPRESENTED_BY_FAX_NUMBER | VARCHAR2 | (25) | ||
| REPRESENTED_BY_EMAIL_ADDRESS | VARCHAR2 | (240) | ||
| START_DATE_ACTIVE | DATE | |||
| END_DATE_ACTIVE | DATE | |||
| INTERNAL_CONTACT_ID | NUMBER | (15) | ||
| HOURS_AFTER_GMT | NUMBER | (38) | ||
| INITIATING_TIME_DIFFERENCE | NUMBER | (2) | ||
| CUSTOMER_PRODUCT_ID | NUMBER | (15) | Customer product identifier | |
| CP_SERVICE_ID | NUMBER | (15) | ||
| CURRENTLY_SERVICED_FLAG | VARCHAR2 | (1) | ||
| LAST_CUSTOMER_CALLBACK_TIME | VARCHAR2 | (30) | ||
| PREVENTIVE_MAINTENANCE_FLAG | VARCHAR2 | (1) | ||
| BILL_TO_TITLE | VARCHAR2 | (40) | ||
| BILL_TO_CUSTOMER | VARCHAR2 | (50) | ||
| BILL_TO_ADDRESS_LINE_1 | VARCHAR2 | (240) | ||
| BILL_TO_ADDRESS_LINE_2 | VARCHAR2 | (240) | ||
| BILL_TO_ADDRESS_LINE_3 | VARCHAR2 | (240) | ||
| BILL_TO_CONTACT | VARCHAR2 | (100) | ||
| SHIP_TO_TITLE | VARCHAR2 | (40) | ||
| SHIP_TO_CUSTOMER | VARCHAR2 | (50) | ||
| SHIP_TO_ADDRESS_LINE_1 | VARCHAR2 | (240) | ||
| SHIP_TO_ADDRESS_LINE_2 | VARCHAR2 | (240) | ||
| SHIP_TO_ADDRESS_LINE_3 | VARCHAR2 | (240) | ||
| SHIP_TO_CONTACT | VARCHAR2 | (100) | ||
| INSTALL_TITLE | VARCHAR2 | (40) | ||
| INSTALL_CUSTOMER | VARCHAR2 | (50) | ||
| INSTALL_ADDRESS_LINE_1 | VARCHAR2 | (240) | ||
| INSTALL_ADDRESS_LINE_2 | VARCHAR2 | (240) | ||
| INSTALL_ADDRESS_LINE_3 | VARCHAR2 | (240) | ||
| INSTALL_SITE_USE_ID | NUMBER | (15) | Identifier for installed site use | |
| BILL_TO_CONTACT_ID | NUMBER | (15) | Bill-to contact identifier | |
| SHIP_TO_CONTACT_ID | NUMBER | (15) | Ship-to contact identifier | |
| INITIATING_NAME | VARCHAR2 | (100) | ||
| INITIATING_AREA_CODE | VARCHAR2 | (10) | ||
| INITIATING_TELEPHONE | VARCHAR2 | (25) | ||
| INITIATING_EXTENSION | VARCHAR2 | (20) | ||
| INITIATING_FAX_AREA_CODE | VARCHAR2 | (10) | ||
| INITIATING_FAX_NUMBER | VARCHAR2 | (25) | ||
| PRODUCT_NAME | VARCHAR2 | (240) | ||
| PRODUCT_DESCRIPTION | VARCHAR2 | (240) | ||
| CURRENT_SERIAL_NUMBER | VARCHAR2 | (30) | Product serial number for product not in installed base | |
| PRODUCT_REVISION | VARCHAR2 | (240) | Not used. | |
| CUSTOMER_NUMBER | VARCHAR2 | (30) | Customer number for non-verified requests | |
| SYSTEM_ID | NUMBER | (15) | Not used | |
| INCIDENT_ATTRIBUTE_1 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| INCIDENT_ATTRIBUTE_2 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| INCIDENT_ATTRIBUTE_3 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| INCIDENT_ATTRIBUTE_4 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| INCIDENT_ATTRIBUTE_5 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| INCIDENT_ATTRIBUTE_6 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| INCIDENT_ATTRIBUTE_7 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| INCIDENT_ATTRIBUTE_8 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| INCIDENT_ATTRIBUTE_9 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| INCIDENT_ATTRIBUTE_10 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| INCIDENT_ATTRIBUTE_11 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| INCIDENT_ATTRIBUTE_12 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| INCIDENT_ATTRIBUTE_13 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| INCIDENT_ATTRIBUTE_14 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| INCIDENT_ATTRIBUTE_15 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| INCIDENT_CONTEXT | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| RECORD_IS_VALID_FLAG | VARCHAR2 | (1) | Flag to denote if the service request is verified or not | |
| INCIDENT_COMMENTS | VARCHAR2 | (255) | ||
| RESOLUTION_CODE | VARCHAR2 | (50) | Problem resolution quick code | |
| RMA_NUMBER | NUMBER | (15) | ||
| RMA_HEADER_ID | NUMBER | |||
| RMA_FLAG | VARCHAR2 | (1) | ||
| ORG_ID | NUMBER | Operating unit identifier | ||
| ORIGINAL_ORDER_NUMBER | NUMBER | Order number for the product if installed base is not used | ||
| WORKFLOW_PROCESS_ID | NUMBER | Sequence number used for this action's last workflow process | ||
| WEB_ENTRY_FLAG | VARCHAR2 | (1) | ||
| CLOSE_DATE | DATE | Date the service request is closed | ||
| PUBLISH_FLAG | VARCHAR2 | (1) | Flag to denote whether the service request is published or not. | |
| MAKE_PUBLIC_PROBLEM | VARCHAR2 | (1) | ||
| MAKE_PUBLIC_RESOLUTION | VARCHAR2 | (1) | ||
| ESTIMATE_ID | NUMBER | (15) | ||
| ESTIMATE_BUSINESS_GROUP_ID | NUMBER | (15) | ||
| INTERFACED_TO_DEPOT_FLAG | VARCHAR2 | (1) | Flag to denote service request is linked to repairs | |
| QA_COLLECTION_ID | NUMBER | Foreign key to Quality results table | ||
| PROJECT_ID | NUMBER | This column is not currently used. | ||
| TASK_ID | NUMBER | This column is not currently used. | ||
| CONTRACT_ID | NUMBER | Header Id of a Contract Line associated with a Service Request | ||
| CONTRACT_NUMBER | VARCHAR2 | (120) | Contract Number | |
| CONTRACT_SERVICE_ID | NUMBER | Service line unique identifier | ||
| RESOURCE_TYPE | VARCHAR2 | (30) | Identifier for the owner type of the Individual Owner of the service request. | |
| RESOURCE_SUBTYPE_ID | NUMBER | No longer used. | ||
| ACCOUNT_ID | NUMBER | Account Identifier | ||
| KB_TYPE | VARCHAR2 | (15) | Not used. | |
| KB_SOLUTION_ID | VARCHAR2 | (240) | External knowledge base solution identifier. | |
| TIME_ZONE_ID | NUMBER | (15) | This field stores the time zone id of the time zone specified in the field service request form | |
| TIME_DIFFERENCE | NUMBER | GMT offset of the contact person's time. | ||
| CUSTOMER_PO_NUMBER | VARCHAR2 | (50) | Customers Purchase Order number. | |
| OWNER_GROUP_ID | NUMBER | Identifier for the Group Owner of the Service Request | ||
| CUSTOMER_TICKET_NUMBER | VARCHAR2 | (50) | Customer's internal helpdesk tracking number. | |
| OBLIGATION_DATE | DATE | Obligation Date | ||
| SITE_ID | NUMBER | Identifier for Support Site. | ||
| CUSTOMER_SITE_ID | NUMBER | Identifier for Customer Site. | ||
| CALLER_TYPE | VARCHAR2 | (30) | Type of the Service Request Customer | |
| PLATFORM_VERSION_ID | NUMBER | Identifier for Platform Version. | ||
| OBJECT_VERSION_NUMBER | NUMBER | (9) | Sequential number used for database locking control when using HTML as a user interface | |
| CP_COMPONENT_ID | NUMBER | Identifier for Installed Base Component. | ||
| CP_COMPONENT_VERSION_ID | NUMBER | Identifier for Installed Base Component Revision. | ||
| CP_SUBCOMPONENT_ID | NUMBER | Identifier for Installed Base Subcomponent. | ||
| CP_SUBCOMPONENT_VERSION_ID | NUMBER | Identifier for Installed Base Subcomponent Revision. | ||
| PLATFORM_ID | NUMBER | Identifier for Platform. | ||
| LANGUAGE_ID | NUMBER | Identifier for the Product's Language. | ||
| TERRITORY_ID | NUMBER | Identifier for the Territory of the Service Request. | ||
| CP_REVISION_ID | NUMBER | Identifier for Installed Base Product Revision. | ||
| INV_ITEM_REVISION | VARCHAR2 | (240) | Identifier for the Item Revision for a product not in Installed Base. | |
| INV_COMPONENT_ID | NUMBER | Identifier for the Component for a product not in Installed Base. | ||
| INV_COMPONENT_VERSION | VARCHAR2 | (90) | Identifier for the Component Revision for a product not in Installed Base. | |
| INV_SUBCOMPONENT_ID | NUMBER | Identifier for the Subcomponent for a product not in Installed Base. | ||
| INV_SUBCOMPONENT_VERSION | VARCHAR2 | (90) | Identifier for the Subcomponent Revision for a product not in Installed Base. | |
| INV_ORGANIZATION_ID | NUMBER | This field stores the inventory organization id based on the profile AS_PRODUCT_ORGANIZATION_ID. | ||
| SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
| UPGRADED_STATUS_FLAG1 | VARCHAR2 | (1) | Flag used to determine row status during upgrade | |
| UPGRADED_STATUS_FLAG2 | VARCHAR2 | (1) | Flag used to determine row status during upgrade | |
| UPGRADED_STATUS_FLAG3 | VARCHAR2 | (1) | Flag used to determine row status during upgrade | |
| ORIG_SYSTEM_REFERENCE | VARCHAR2 | (60) | Source table name during upgrade | |
| ORIG_SYSTEM_REFERENCE_ID | NUMBER | Source table id 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. | ||
| PROJECT_NUMBER | VARCHAR2 | (120) | Project Number associated with a service request | |
| PLATFORM_VERSION | VARCHAR2 | (250) | The platform Version. | |
| DB_VERSION | VARCHAR2 | (250) | DB Version | |
| CUST_PREF_LANG_ID | NUMBER | The Customer preferred language identifier. | ||
| TIER | VARCHAR2 | (250) | The Tier of the Product, against which the SR has been created. | |
| TIER_VERSION | VARCHAR2 | (250) | The Tier Version for the Product, against which the SR has been created. | |
| CATEGORY_ID | NUMBER | The product category Identifier. | ||
| OPERATING_SYSTEM | VARCHAR2 | (250) | The Operating System of the product. | |
| OPERATING_SYSTEM_VERSION | VARCHAR2 | (250) | The version of the Operating System for the product. | |
| DATABASE | VARCHAR2 | (250) | The database on which the product is installed. | |
| GROUP_TYPE | VARCHAR2 | (30) | Resource type of the Group Owner. | |
| GROUP_TERRITORY_ID | NUMBER | The territory identifier of the Group owner. | ||
| OWNER_ASSIGNED_TIME | DATE | The Date/Time at which the service request was assigned to the owner. | ||
| OWNER_ASSIGNED_FLAG | VARCHAR2 | (1) | Flag indicates if either a group owner or individual owner has been assigned to the service request. The valid values are Y and N. | |
| INV_PLATFORM_ORG_ID | NUMBER | Organization identifier for the product platform. | ||
| COMPONENT_VERSION | VARCHAR2 | (3) | The version of the Installed Base Component. | |
| SUBCOMPONENT_VERSION | VARCHAR2 | (3) | The version of the Installed Base Sub-Component. | |
| COMM_PREF_CODE | VARCHAR2 | (30) | Prefered communication mode for the customer. | |
| LAST_UPDATE_CHANNEL | VARCHAR2 | (30) | This indicates from which channel the service request was last updated. The values can be WEB (iSupport) and PHONE (TeleService). | |
| CUST_PREF_LANG_CODE | VARCHAR2 | (4) | The code for customer's preferred language. | |
| ERROR_CODE | VARCHAR2 | (250) | The error code of the problem reported in the service request. | |
| CATEGORY_SET_ID | NUMBER | Category set identifier for Customer Product | ||
| EXTERNAL_REFERENCE | VARCHAR2 | (30) | External Reference number Store the Tag Number from the UI | |
| INCIDENT_OCCURRED_DATE | DATE | The date on which the Incident occurred. | ||
| INCIDENT_RESOLVED_DATE | DATE | Date on which Incident was resolved. | ||
| INC_RESPONDED_BY_DATE | DATE | Responded Date for the Incident. | ||
| INCIDENT_LOCATION_ID | NUMBER | Identifier of the incident location for a Service Request. | ||
| INCIDENT_ADDRESS | VARCHAR2 | (960) | First Line of Incident address for a Service Request. | |
| INCIDENT_CITY | VARCHAR2 | (60) | Incident City for a Service Request. | |
| INCIDENT_STATE | VARCHAR2 | (60) | Incident State for a Service Request. | |
| INCIDENT_COUNTRY | VARCHAR2 | (60) | Incident Country for a Service Request. | |
| INCIDENT_PROVINCE | VARCHAR2 | (60) | Incident Province for a Service Request. | |
| INCIDENT_POSTAL_CODE | VARCHAR2 | (60) | Incident Postal Code for a Service Request. | |
| INCIDENT_COUNTY | VARCHAR2 | (60) | Incident County for a Service Request. | |
| SR_CREATION_CHANNEL | VARCHAR2 | (50) | The channel through which the service request was created. | |
| DEF_DEFECT_ID | NUMBER | Not currently used. | ||
| DEF_DEFECT_ID2 | NUMBER | Not currently used. | ||
| CREDIT_CARD_NUMBER | VARCHAR2 | (48) | Obsolete column. Encrypted format of the Credit Card Number. Credit card numbers are stored in Base64 format. Service public API's are available to decrypt/encrypt these numbers. | |
| CREDIT_CARD_TYPE_CODE | VARCHAR2 | (30) | Obsolete column. Credit card type. This type code is a lookup code for lookup type CS_CREDIT_CARD_TYPES. The allowed values are Visa,Master Card,Amex,Discover, Enroute and JCB. | |
| CREDIT_CARD_EXPIRATION_DATE | DATE | Obsolete column. Date of expiration of the Credit Card. The last day of the month is stored as the expiration date. | ||
| CREDIT_CARD_HOLDER_FNAME | VARCHAR2 | (250) | Obsolete column. First name on the Credit Card. | |
| CREDIT_CARD_HOLDER_MNAME | VARCHAR2 | (250) | Obsolete column. Middle name on the Credit Card. | |
| CREDIT_CARD_HOLDER_LNAME | VARCHAR2 | (250) | Obsolete column. Last name on the Credit Card. | |
| CREDIT_CARD_ID | NUMBER | (15) | Obsolete column. This column is an FK reference to the ID in the Credit Card Master table. As of 11.5.9 this column is not functionally active. | |
| EXTERNAL_ATTRIBUTE_1 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| EXTERNAL_ATTRIBUTE_2 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| EXTERNAL_ATTRIBUTE_3 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| EXTERNAL_ATTRIBUTE_4 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| EXTERNAL_ATTRIBUTE_5 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| EXTERNAL_ATTRIBUTE_6 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| EXTERNAL_ATTRIBUTE_7 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| EXTERNAL_ATTRIBUTE_8 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| EXTERNAL_ATTRIBUTE_9 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| EXTERNAL_ATTRIBUTE_10 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| EXTERNAL_ATTRIBUTE_11 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| EXTERNAL_ATTRIBUTE_12 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| EXTERNAL_ATTRIBUTE_13 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| EXTERNAL_ATTRIBUTE_14 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| EXTERNAL_ATTRIBUTE_15 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| EXTERNAL_CONTEXT | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| LAST_UPDATE_PROGRAM_CODE | VARCHAR2 | (30) | Last Update Program Code For SR Source | |
| CREATION_PROGRAM_CODE | VARCHAR2 | (30) | Creation Program Code For SR Source. | |
| COVERAGE_TYPE | VARCHAR2 | (30) | Coverage Type | |
| BILL_TO_ACCOUNT_ID | NUMBER | (15) | Bill To Account ID | |
| SHIP_TO_ACCOUNT_ID | NUMBER | (15) | Ship To Account Id | |
| CUSTOMER_EMAIL_ID | NUMBER | (15) | Customer Email ID | |
| CUSTOMER_PHONE_ID | NUMBER | (15) | Customer Phone ID | |
| BILL_TO_PARTY_ID | NUMBER | Bill to party identifier. | ||
| SHIP_TO_PARTY_ID | NUMBER | Ship to party indentifier. | ||
| BILL_TO_SITE_ID | NUMBER | Bill to site indentifier. | ||
| SHIP_TO_SITE_ID | NUMBER | Ship to site identifier. | ||
| PROGRAM_LOGIN_ID | NUMBER | Standard Who Column | ||
| STATUS_FLAG | VARCHAR2 | (3) | Yes | Flag to denote whether the status of the SR is open or closed. |
| PRIMARY_CONTACT_ID | NUMBER | Service Request Contact Point Identifier.Foreign key to sr_contact_point_id of the cs_hz_sr_contact_points table. | ||
| INCIDENT_POINT_OF_INTEREST | VARCHAR2 | (240) | Point Of Interest of the Incident Address | |
| INCIDENT_CROSS_STREET | VARCHAR2 | (240) | Cross Street of the Incident Address | |
| INCIDENT_DIRECTION_QUALIFIER | VARCHAR2 | (30) | Indicates the Direction of Incident Address, while using a non-Postal Location . Directional Qualifiers are defined as lookup Codes | |
| INCIDENT_DISTANCE_QUALIFIER | VARCHAR2 | (240) | Indicates the distance of the Incident Address from the Incident Point of Interest | |
| INCIDENT_DISTANCE_QUAL_UOM | VARCHAR2 | (30) | Unit of Measure for the Distance from the point of Interest. Distance Unit of Measures are defined as Lookup Codes | |
| INCIDENT_ADDRESS2 | VARCHAR2 | (240) | Second Line of Incident address for a Service Request. | |
| INCIDENT_ADDRESS3 | VARCHAR2 | (240) | Third Line of Incident address for a Service Request. | |
| INCIDENT_ADDRESS4 | VARCHAR2 | (240) | Fourth Line of Incident address for a Service Request. | |
| INCIDENT_ADDRESS_STYLE | VARCHAR2 | (30) | Address Style for Incident Address | |
| INCIDENT_ADDR_LINES_PHONETIC | VARCHAR2 | (560) | Phonetic representation of Incident Address Lines | |
| INCIDENT_PO_BOX_NUMBER | VARCHAR2 | (50) | Post Office Box Number | |
| INCIDENT_HOUSE_NUMBER | VARCHAR2 | (50) | House Number of the Incident Address | |
| INCIDENT_STREET_SUFFIX | VARCHAR2 | (50) | Street Name Suffix such as Road, Avenue or Street | |
| INCIDENT_STREET | VARCHAR2 | (150) | Street Name of Incident Address | |
| INCIDENT_STREET_NUMBER | VARCHAR2 | (50) | Street Number in the Incident Address Line | |
| INCIDENT_FLOOR | VARCHAR2 | (50) | Number or Name assigned to a level within a building or Address | |
| INCIDENT_SUITE | VARCHAR2 | (50) | Numer or Name Given to a Group of Rooms referred as a unit | |
| INCIDENT_POSTAL_PLUS4_CODE | VARCHAR2 | (30) | Extension to the United States postal ZIP Code | |
| INCIDENT_POSITION | VARCHAR2 | (50) | Position of the Incident Address | |
| INCIDENT_LOCATION_DIRECTIONS | VARCHAR2 | (640) | Directions to the Incident Location | |
| INCIDENT_LOCATION_DESCRIPTION | VARCHAR2 | (2000) | Description of the Location | |
| INSTALL_SITE_ID | NUMBER | Party site id of the location where the Item is installed | ||
| OWNING_DEPARTMENT_ID | NUMBER | Owning department identifier. | ||
| ITEM_SERIAL_NUMBER | VARCHAR2 | (30) | Obsoloete Column. Asset number or rebuildable serial number for maintenance SR's | |
| INCIDENT_LOCATION_TYPE | VARCHAR2 | (30) | Location type code. | |
| INCIDENT_LAST_MODIFIED_DATE | DATE | Stores the date on which either the SR Header table or any of the SR Childern tables were last updated for a given SR. | ||
| UNASSIGNED_INDICATOR | VARCHAR2 | (1) | If Service Request is Unassigned at Agent/Group or at both level | |
| MAINT_ORGANIZATION_ID | NUMBER | eAM maintenance organization id. | ||
| INSTRUMENT_PAYMENT_USE_ID | NUMBER | (15) | Instrument Payment Identifier | |
| PROJECT_TASK_ID | NUMBER | (15) | Column to store Project Task Id | |
| SLA_DATE_1 | DATE | Additional Place Holder to store SLA Date | ||
| SLA_DATE_2 | DATE | Additional Place Holder to store SLA Date | ||
| SLA_DATE_3 | DATE | Additional Place Holder to store SLA Date | ||
| SLA_DATE_4 | DATE | Additional Place Holder to store SLA Date | ||
| SLA_DATE_5 | DATE | Additional Place Holder to store SLA Date | ||
| SLA_DATE_6 | DATE | Additional Place Holder to store SLA Date | ||
| SLA_DURATION_1 | NUMBER | (15) | Additional Place Holder to store SLA Duration | |
| SLA_DURATION_2 | NUMBER | (15) | Additional Place Holder to store SLA Duration | |
| PRICE_LIST_HEADER_ID | NUMBER | Price List Identifier | ||
| EXPENDITURE_ORG_ID | NUMBER | Expenditure Organization Identifier |
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_NUMBER
, INCIDENT_DATE
, OPEN_FLAG
, SERVICE_ENTITY_ID
, INCIDENT_STATUS_ID
, INCIDENT_TYPE_ID
, INCIDENT_URGENCY_ID
, INCIDENT_SEVERITY_ID
, SUMMARY
, RESPONSIBLE_GROUP_ID
, SECURITY_LEVEL_CODE
, INCIDENT_OWNER_ID
, CLASSIFICATION_CODE
, INVENTORY_ITEM_ID
, COMPONENT_INVENTORY_ITEM_ID
, CUSTOMER_ID
, ORIGINAL_CUSTOMER_ID
, CUSTOMER_NAME
, BILL_TO_SITE_USE_ID
, PURCHASE_ORDER_NUM
, IDENTIFICATION_NUMBER
, SERVICE_INVENTORY_ITEM_ID
, EMPLOYEE_ID
, FILED_BY_EMPLOYEE_FLAG
, BILLABLE_FLAG
, SHIP_TO_SITE_USE_ID
, PROBLEM_CODE
, EXPECTED_RESOLUTION_DATE
, ACTUAL_RESOLUTION_DATE
, PROBLEM_DESCRIPTION
, RESOLUTION_DESCRIPTION
, RUNNING_TOTALS
, CURRENT_CONTACT_PERSON_ID
, INITIATING_PERSON_ID
, CURRENT_CONTACT_NAME
, CURRENT_CONTACT_AREA_CODE
, CURRENT_CONTACT_TELEPHONE
, CURRENT_CONTACT_EXTENSION
, CURRENT_CONTACT_EMAIL_ADDRESS
, CURRENT_CONTACT_TIME_DIFF
, CURRENT_CONTACT_FAX_AREA_CODE
, CURRENT_CONTACT_FAX_NUMBER
, REPRESENTED_BY_EMPLOYEE
, REPRESENTED_BY_NAME
, REPRESENTED_BY_TIME_DIFFERENCE
, REPRESENTED_BY_AREA_CODE
, REPRESENTED_BY_TELEPHONE
, REPRESENTED_BY_EXTENSION
, REPRESENTED_BY_FAX_AREA_CODE
, REPRESENTED_BY_FAX_NUMBER
, REPRESENTED_BY_EMAIL_ADDRESS
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, INTERNAL_CONTACT_ID
, HOURS_AFTER_GMT
, INITIATING_TIME_DIFFERENCE
, CUSTOMER_PRODUCT_ID
, CP_SERVICE_ID
, CURRENTLY_SERVICED_FLAG
, LAST_CUSTOMER_CALLBACK_TIME
, PREVENTIVE_MAINTENANCE_FLAG
, BILL_TO_TITLE
, BILL_TO_CUSTOMER
, BILL_TO_ADDRESS_LINE_1
, BILL_TO_ADDRESS_LINE_2
, BILL_TO_ADDRESS_LINE_3
, BILL_TO_CONTACT
, SHIP_TO_TITLE
, SHIP_TO_CUSTOMER
, SHIP_TO_ADDRESS_LINE_1
, SHIP_TO_ADDRESS_LINE_2
, SHIP_TO_ADDRESS_LINE_3
, SHIP_TO_CONTACT
, INSTALL_TITLE
, INSTALL_CUSTOMER
, INSTALL_ADDRESS_LINE_1
, INSTALL_ADDRESS_LINE_2
, INSTALL_ADDRESS_LINE_3
, INSTALL_SITE_USE_ID
, BILL_TO_CONTACT_ID
, SHIP_TO_CONTACT_ID
, INITIATING_NAME
, INITIATING_AREA_CODE
, INITIATING_TELEPHONE
, INITIATING_EXTENSION
, INITIATING_FAX_AREA_CODE
, INITIATING_FAX_NUMBER
, PRODUCT_NAME
, PRODUCT_DESCRIPTION
, CURRENT_SERIAL_NUMBER
, PRODUCT_REVISION
, CUSTOMER_NUMBER
, SYSTEM_ID
, INCIDENT_ATTRIBUTE_1
, INCIDENT_ATTRIBUTE_2
, INCIDENT_ATTRIBUTE_3
, INCIDENT_ATTRIBUTE_4
, INCIDENT_ATTRIBUTE_5
, INCIDENT_ATTRIBUTE_6
, INCIDENT_ATTRIBUTE_7
, INCIDENT_ATTRIBUTE_8
, INCIDENT_ATTRIBUTE_9
, INCIDENT_ATTRIBUTE_10
, INCIDENT_ATTRIBUTE_11
, INCIDENT_ATTRIBUTE_12
, INCIDENT_ATTRIBUTE_13
, INCIDENT_ATTRIBUTE_14
, INCIDENT_ATTRIBUTE_15
, INCIDENT_CONTEXT
, RECORD_IS_VALID_FLAG
, INCIDENT_COMMENTS
, RESOLUTION_CODE
, RMA_NUMBER
, RMA_HEADER_ID
, RMA_FLAG
, ORG_ID
, ORIGINAL_ORDER_NUMBER
, WORKFLOW_PROCESS_ID
, WEB_ENTRY_FLAG
, CLOSE_DATE
, PUBLISH_FLAG
, MAKE_PUBLIC_PROBLEM
, MAKE_PUBLIC_RESOLUTION
, ESTIMATE_ID
, ESTIMATE_BUSINESS_GROUP_ID
, INTERFACED_TO_DEPOT_FLAG
, QA_COLLECTION_ID
, PROJECT_ID
, TASK_ID
, CONTRACT_ID
, CONTRACT_NUMBER
, CONTRACT_SERVICE_ID
, RESOURCE_TYPE
, RESOURCE_SUBTYPE_ID
, ACCOUNT_ID
, KB_TYPE
, KB_SOLUTION_ID
, TIME_ZONE_ID
, TIME_DIFFERENCE
, CUSTOMER_PO_NUMBER
, OWNER_GROUP_ID
, CUSTOMER_TICKET_NUMBER
, OBLIGATION_DATE
, SITE_ID
, CUSTOMER_SITE_ID
, CALLER_TYPE
, PLATFORM_VERSION_ID
, OBJECT_VERSION_NUMBER
, CP_COMPONENT_ID
, CP_COMPONENT_VERSION_ID
, CP_SUBCOMPONENT_ID
, CP_SUBCOMPONENT_VERSION_ID
, PLATFORM_ID
, LANGUAGE_ID
, TERRITORY_ID
, CP_REVISION_ID
, INV_ITEM_REVISION
, INV_COMPONENT_ID
, INV_COMPONENT_VERSION
, INV_SUBCOMPONENT_ID
, INV_SUBCOMPONENT_VERSION
, INV_ORGANIZATION_ID
, SECURITY_GROUP_ID
, UPGRADED_STATUS_FLAG1
, UPGRADED_STATUS_FLAG2
, UPGRADED_STATUS_FLAG3
, ORIG_SYSTEM_REFERENCE
, ORIG_SYSTEM_REFERENCE_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PROJECT_NUMBER
, PLATFORM_VERSION
, DB_VERSION
, CUST_PREF_LANG_ID
, TIER
, TIER_VERSION
, CATEGORY_ID
, OPERATING_SYSTEM
, OPERATING_SYSTEM_VERSION
, DATABASE
, GROUP_TYPE
, GROUP_TERRITORY_ID
, OWNER_ASSIGNED_TIME
, OWNER_ASSIGNED_FLAG
, INV_PLATFORM_ORG_ID
, COMPONENT_VERSION
, SUBCOMPONENT_VERSION
, COMM_PREF_CODE
, LAST_UPDATE_CHANNEL
, CUST_PREF_LANG_CODE
, ERROR_CODE
, CATEGORY_SET_ID
, EXTERNAL_REFERENCE
, INCIDENT_OCCURRED_DATE
, INCIDENT_RESOLVED_DATE
, INC_RESPONDED_BY_DATE
, INCIDENT_LOCATION_ID
, INCIDENT_ADDRESS
, INCIDENT_CITY
, INCIDENT_STATE
, INCIDENT_COUNTRY
, INCIDENT_PROVINCE
, INCIDENT_POSTAL_CODE
, INCIDENT_COUNTY
, SR_CREATION_CHANNEL
, DEF_DEFECT_ID
, DEF_DEFECT_ID2
, CREDIT_CARD_NUMBER
, CREDIT_CARD_TYPE_CODE
, CREDIT_CARD_EXPIRATION_DATE
, CREDIT_CARD_HOLDER_FNAME
, CREDIT_CARD_HOLDER_MNAME
, CREDIT_CARD_HOLDER_LNAME
, CREDIT_CARD_ID
, EXTERNAL_ATTRIBUTE_1
, EXTERNAL_ATTRIBUTE_2
, EXTERNAL_ATTRIBUTE_3
, EXTERNAL_ATTRIBUTE_4
, EXTERNAL_ATTRIBUTE_5
, EXTERNAL_ATTRIBUTE_6
, EXTERNAL_ATTRIBUTE_7
, EXTERNAL_ATTRIBUTE_8
, EXTERNAL_ATTRIBUTE_9
, EXTERNAL_ATTRIBUTE_10
, EXTERNAL_ATTRIBUTE_11
, EXTERNAL_ATTRIBUTE_12
, EXTERNAL_ATTRIBUTE_13
, EXTERNAL_ATTRIBUTE_14
, EXTERNAL_ATTRIBUTE_15
, EXTERNAL_CONTEXT
, LAST_UPDATE_PROGRAM_CODE
, CREATION_PROGRAM_CODE
, COVERAGE_TYPE
, BILL_TO_ACCOUNT_ID
, SHIP_TO_ACCOUNT_ID
, CUSTOMER_EMAIL_ID
, CUSTOMER_PHONE_ID
, BILL_TO_PARTY_ID
, SHIP_TO_PARTY_ID
, BILL_TO_SITE_ID
, SHIP_TO_SITE_ID
, PROGRAM_LOGIN_ID
, STATUS_FLAG
, PRIMARY_CONTACT_ID
, INCIDENT_POINT_OF_INTEREST
, INCIDENT_CROSS_STREET
, INCIDENT_DIRECTION_QUALIFIER
, INCIDENT_DISTANCE_QUALIFIER
, INCIDENT_DISTANCE_QUAL_UOM
, INCIDENT_ADDRESS2
, INCIDENT_ADDRESS3
, INCIDENT_ADDRESS4
, INCIDENT_ADDRESS_STYLE
, INCIDENT_ADDR_LINES_PHONETIC
, INCIDENT_PO_BOX_NUMBER
, INCIDENT_HOUSE_NUMBER
, INCIDENT_STREET_SUFFIX
, INCIDENT_STREET
, INCIDENT_STREET_NUMBER
, INCIDENT_FLOOR
, INCIDENT_SUITE
, INCIDENT_POSTAL_PLUS4_CODE
, INCIDENT_POSITION
, INCIDENT_LOCATION_DIRECTIONS
, INCIDENT_LOCATION_DESCRIPTION
, INSTALL_SITE_ID
, OWNING_DEPARTMENT_ID
, ITEM_SERIAL_NUMBER
, INCIDENT_LOCATION_TYPE
, INCIDENT_LAST_MODIFIED_DATE
, UNASSIGNED_INDICATOR
, MAINT_ORGANIZATION_ID
, INSTRUMENT_PAYMENT_USE_ID
, PROJECT_TASK_ID
, SLA_DATE_1
, SLA_DATE_2
, SLA_DATE_3
, SLA_DATE_4
, SLA_DATE_5
, SLA_DATE_6
, SLA_DURATION_1
, SLA_DURATION_2
, PRICE_LIST_HEADER_ID
, EXPENDITURE_ORG_ID
FROM CS.CS_INCIDENTS_ALL_B;
CS.CS_INCIDENTS_ALL_B does not reference any database object
CS.CS_INCIDENTS_ALL_B is referenced by following:
CS
CS_INCIDENTS_ALL_B#
|
|
|
|