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: ISC.ISC_FS_TASK_BAC_DATES_C

Object Details

Object Name:	ISC_FS_TASK_BAC_DATES_C
Object Type:	TABLE
Owner:	ISC
Subobject Name:
Status:	VALID

This table stores a row for all of the dates necessary to render all of the task backlog aging and backlog aging trend reports. It also stores the time (typically 23:59:59) to calculate the age up to. In the case of the current date, it stores the last collection date (time).

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
AGING_DATE	DATE		Yes	Aging Date (and time)
RECORD_TYPE_ID	NUMBER		Yes	Record Type identifier
XTD_END_DATE_FLAG	VARCHAR2	(1)	Yes	Indicates if aging date is for at least one XTD period end date
WEEK_START_DATE	DATE			Week start date if the row is for WTD, used for Backlog Aging Trend report
ENT_PERIOD_START_DATE	DATE			Enterprise Period start date if the row is for MTD, used for Backlog Aging Trend report
ENT_QTR_START_DATE	DATE			Enterprise Quarter start date if the row is for QTD, used for Backlog Aging Trend report
ENT_YEAR_START_DATE	DATE			Enterprise Year start date if the row is for YTD, used for Backlog Aging Trend report
DAY_START_DATE	DATE			Day start date if the row is for DAY, used for Backlog Aging Trend report
ROLLING7_START_DATE	DATE			Period start date if the row is for rolling 7 days, used for Backlog Aging Trend report
ROLLING30_START_DATE	DATE			Period start date if the row is for rolling 30 days, used for Backlog Aging Trend report
ROLLING90_START_DATE	DATE			Period start date if the row is for rolling 90 days, used for Backlog Aging Trend report
ROLLING365_START_DATE	DATE			Period start date if the row is for rolling 365 days, used for Backlog Aging Trend report
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column
PROGRAM_ID	NUMBER			Standard who column
PROGRAM_LOGIN_ID	NUMBER			Standard who column
PROGRAM_APPLICATION_ID	NUMBER			Standard who column
REQUEST_ID	NUMBER			Standard who column

Query Text

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


SELECT AGING_DATE
,      RECORD_TYPE_ID
,      XTD_END_DATE_FLAG
,      WEEK_START_DATE
,      ENT_PERIOD_START_DATE
,      ENT_QTR_START_DATE
,      ENT_YEAR_START_DATE
,      DAY_START_DATE
,      ROLLING7_START_DATE
,      ROLLING30_START_DATE
,      ROLLING90_START_DATE
,      ROLLING365_START_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
FROM ISC.ISC_FS_TASK_BAC_DATES_C;

Dependencies

[top of page]

ISC.ISC_FS_TASK_BAC_DATES_C does not reference any database object

ISC.ISC_FS_TASK_BAC_DATES_C is referenced by following:

APPS: ISC_FS_TASK_BAC_DATES_C