[Home] [Help] [Dependency Information]
Object Name: | BIV_DBI_CLOSED_SUM_F |
---|---|
Object Type: | TABLE |
Owner: | BIV |
Subobject Name: | |
Status: | VALID |
This is the Closed Service Request base summary table. It stores details of closed service requests. There is up to one row per service request. When the service request is first closed, a row is inserted into this table. If the service request is reopened, the row is updated with the reopened date. If the service request is reclosed, the row is updated with the new dimensional values and the reopened date is nulled out. The dimensional values are based on the audit row at the time the service request was last closed.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 30 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BIV_DBI_CLOSED_SUM_F_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | INCIDENT_ID |
BIV_DBI_CLOSED_SUM_F_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | CUSTOMER_ID |
BIV_DBI_CLOSED_SUM_F_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | REPORT_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REPORT_DATE | DATE | Yes | The date on which the service request was closed. Trunc of cs_incidents_audit_b.creation_date | |
INCIDENT_ID | NUMBER | Yes | Incident identifier | |
INCIDENT_TYPE_ID | NUMBER | Yes | Type identifier, from cs_incidents_audit_b.incident_type_id - Securing dimension | |
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory item identifier, from cs_incidents_all_b.inventory_item_id | |
INV_ORGANIZATION_ID | NUMBER | Yes | Inventory organization identifier, from cs_incidents_all_b.inv_organization_id | |
INCIDENT_SEVERITY_ID | NUMBER | Yes | Severity identifier, from cs_incidents_audit_b.incident_severity_id | |
CUSTOMER_ID | NUMBER | Yes | Customer identifier, from cs_incidents_all_b.customer_id | |
OWNER_GROUP_ID | NUMBER | Yes | Owner group identifier, from cs_incidents_audit_b.group_id | |
SR_CREATION_CHANNEL | VARCHAR2 | (50) | Yes | Channel identifier, from cs_incidents_all_b.sr_creation_channel |
RESOLUTION_CODE | VARCHAR2 | (50) | Yes | Resolution code identifer, from cs_incidents_all_b.resolution_code |
REOPENED_DATE | DATE | Date service request was subsequently reopened. Null if service request has not subsequently been reopened. | ||
TIME_TO_CLOSE | NUMBER | If the service request was not subsequently reopened, elapsed time between incident_date and close_date. | ||
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
ESCALATED_FLAG | VARCHAR2 | (1) | Flag indicating a SR ever been escalated y/n | |
INCIDENT_URGENCY_ID | NUMBER | Identifier for service request urgency | ||
INCIDENT_OWNER_ID | NUMBER | Identifier for the owner of the service request |
Cut, paste (and edit) the following text to query this object:
SELECT REPORT_DATE
, INCIDENT_ID
, INCIDENT_TYPE_ID
, INVENTORY_ITEM_ID
, INV_ORGANIZATION_ID
, INCIDENT_SEVERITY_ID
, CUSTOMER_ID
, OWNER_GROUP_ID
, SR_CREATION_CHANNEL
, RESOLUTION_CODE
, REOPENED_DATE
, TIME_TO_CLOSE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ESCALATED_FLAG
, INCIDENT_URGENCY_ID
, INCIDENT_OWNER_ID
FROM BIV.BIV_DBI_CLOSED_SUM_F;
BIV.BIV_DBI_CLOSED_SUM_F does not reference any database object
BIV.BIV_DBI_CLOSED_SUM_F is referenced by following:
|
|
|