eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: BIV.BIV_BAC_AGE_SUM_F

Object Details

Object Name:	BIV_BAC_AGE_SUM_F
Object Type:	TABLE
Owner:	BIV
Subobject Name:
Status:	VALID

This is the Service Request Current Backlog Aging base summary table. It stores aggregated measures for the backlog, escalated backlog, and unowned backlog based on the flexible bucket boundaries as at the current refresh date and all of the dates relative to that date needed for the Current Backlog trend reports. It also resolves the product to product category relationship.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	30
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIV_BAC_AGE_SUM_F_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	REPORT_DATE GRP_ID
BIV_BAC_AGE_SUM_F_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	GRP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REPORT_DATE	DATE		Yes	The date of the backlog
GRP_ID	NUMBER			Rollup group identifier. Used to identify the rollup group attributed to the row
INCIDENT_TYPE_ID	NUMBER			Type identifier, from cs_incidents_audit_b.incident_type_id. Securing dimension
INCIDENT_SEVERITY_ID	NUMBER			Severity identifier, from cs_incidents_audit_b.incident_severity_id
PRODUCT_ID	VARCHAR2	(25)		Product identifier, from eni_oltp_item_star.master_id
VBH_CATEGORY_ID	NUMBER			Product Category identifier, from eni_oltp_item_star.vbh_category_id
CUSTOMER_ID	NUMBER			Customer identifier, from cs_incidents_all_b.customer_id
OWNER_GROUP_ID	NUMBER			Owner group identifier, from cs_incidents_audit_b.group_id
INCIDENT_STATUS_ID	NUMBER			Status identifier, from cs_incidents_audit_b.incident_status_id
BACKLOG_COUNT	NUMBER			Count of Service Requests in backlog
TOTAL_BACKLOG_AGE	NUMBER			Total for age of Service Requests in backlog. Average age can be calculated as TOTAL_BACKLOG_AGE/BACKLOG_COUNT
BACKLOG_AGE_B1	NUMBER			Count of Service Requests in backlog with age in bucket range 1
BACKLOG_AGE_B2	NUMBER			Count of Service Requests in backlog with age in bucket range 2
BACKLOG_AGE_B3	NUMBER			Count of Service Requests in backlog with age in bucket range 3
BACKLOG_AGE_B4	NUMBER			Count of Service Requests in backlog with age in bucket range 4
BACKLOG_AGE_B5	NUMBER			Count of Service Requests in backlog with age in bucket range 5
BACKLOG_AGE_B6	NUMBER			Count of Service Requests in backlog with age in bucket range 6
BACKLOG_AGE_B7	NUMBER			Count of Service Requests in backlog with age in bucket range 7
BACKLOG_AGE_B8	NUMBER			Count of Service Requests in backlog with age in bucket range 8
BACKLOG_AGE_B9	NUMBER			Count of Service Requests in backlog with age in bucket range 9
BACKLOG_AGE_B10	NUMBER			Count of Service Requests in backlog with age in bucket range 10
ESCALATED_COUNT	NUMBER			Count of escalated Service Requests in backlog
TOTAL_ESCALATED_AGE	NUMBER			Total for age of escalated Service Requests in backlog. Average age can be calculated as TOTAL_ESCALATED_AGE/ESCALATED_COUNT
ESCALATED_AGE_B1	NUMBER			Count of escalated Service Requests in backlog with age in bucket range 1
ESCALATED_AGE_B2	NUMBER			Count of escalated Service Requests in backlog with age in bucket range 2
ESCALATED_AGE_B3	NUMBER			Count of escalated Service Requests in backlog with age in bucket range 3
ESCALATED_AGE_B4	NUMBER			Count of escalated Service Requests in backlog with age in bucket range 4
ESCALATED_AGE_B5	NUMBER			Count of escalated Service Requests in backlog with age in bucket range 5
ESCALATED_AGE_B6	NUMBER			Count of escalated Service Requests in backlog with age in bucket range 6
ESCALATED_AGE_B7	NUMBER			Count of escalated Service Requests in backlog with age in bucket range 7
ESCALATED_AGE_B8	NUMBER			Count of escalated Service Requests in backlog with age in bucket range 8
ESCALATED_AGE_B9	NUMBER			Count of escalated Service Requests in backlog with age in bucket range 9
ESCALATED_AGE_B10	NUMBER			Count of escalated Service Requests in backlog with age in bucket range 10
UNOWNED_COUNT	NUMBER			Count of unowned Service Requests in backlog
TOTAL_UNOWNED_AGE	NUMBER			Total for age of unowned Service Requests in backlog. Average age can be calculated as TOTAL_UNOWNED_AGE/UNOWNED_COUNT
UNOWNED_AGE_B1	NUMBER			Count of unowned Service Requests in backlog with age in bucket range 1
UNOWNED_AGE_B2	NUMBER			Count of unowned Service Requests in backlog with age in bucket range 2
UNOWNED_AGE_B3	NUMBER			Count of unowned Service Requests in backlog with age in bucket range 3
UNOWNED_AGE_B4	NUMBER			Count of unowned Service Requests in backlog with age in bucket range 4
UNOWNED_AGE_B5	NUMBER			Count of unowned Service Requests in backlog with age in bucket range 5
UNOWNED_AGE_B6	NUMBER			Count of unowned Service Requests in backlog with age in bucket range 6
UNOWNED_AGE_B7	NUMBER			Count of unowned Service Requests in backlog with age in bucket range 7
UNOWNED_AGE_B8	NUMBER			Count of unowned Service Requests in backlog with age in bucket range 8
UNOWNED_AGE_B9	NUMBER			Count of unowned Service Requests in backlog with age in bucket range 9
UNOWNED_AGE_B10	NUMBER			Count of unowned Service Requests in backlog with age in bucket range 10
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).
INVENTORY_ITEM_ID	NUMBER			Inventory item identifier, from cs_incidents_all_b.inventory_item_id
INV_ORGANIZATION_ID	NUMBER			Inventory organization identifier, from cs_incidents_all_b.inv_organization_id
RESOLVED_FLAG	VARCHAR2	(1)		Resolved Status Flag
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

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REPORT_DATE
,      GRP_ID
,      INCIDENT_TYPE_ID
,      INCIDENT_SEVERITY_ID
,      PRODUCT_ID
,      VBH_CATEGORY_ID
,      CUSTOMER_ID
,      OWNER_GROUP_ID
,      INCIDENT_STATUS_ID
,      BACKLOG_COUNT
,      TOTAL_BACKLOG_AGE
,      BACKLOG_AGE_B1
,      BACKLOG_AGE_B2
,      BACKLOG_AGE_B3
,      BACKLOG_AGE_B4
,      BACKLOG_AGE_B5
,      BACKLOG_AGE_B6
,      BACKLOG_AGE_B7
,      BACKLOG_AGE_B8
,      BACKLOG_AGE_B9
,      BACKLOG_AGE_B10
,      ESCALATED_COUNT
,      TOTAL_ESCALATED_AGE
,      ESCALATED_AGE_B1
,      ESCALATED_AGE_B2
,      ESCALATED_AGE_B3
,      ESCALATED_AGE_B4
,      ESCALATED_AGE_B5
,      ESCALATED_AGE_B6
,      ESCALATED_AGE_B7
,      ESCALATED_AGE_B8
,      ESCALATED_AGE_B9
,      ESCALATED_AGE_B10
,      UNOWNED_COUNT
,      TOTAL_UNOWNED_AGE
,      UNOWNED_AGE_B1
,      UNOWNED_AGE_B2
,      UNOWNED_AGE_B3
,      UNOWNED_AGE_B4
,      UNOWNED_AGE_B5
,      UNOWNED_AGE_B6
,      UNOWNED_AGE_B7
,      UNOWNED_AGE_B8
,      UNOWNED_AGE_B9
,      UNOWNED_AGE_B10
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      INVENTORY_ITEM_ID
,      INV_ORGANIZATION_ID
,      RESOLVED_FLAG
,      ESCALATED_FLAG
,      INCIDENT_URGENCY_ID
,      INCIDENT_OWNER_ID
FROM BIV.BIV_BAC_AGE_SUM_F;

Dependencies

[top of page]

BIV.BIV_BAC_AGE_SUM_F does not reference any database object

BIV.BIV_BAC_AGE_SUM_F is referenced by following:

APPS: BIV_BAC_AGE_SUM_F; BIV_B_AGE_H_SUM_MV