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

TABLE: PA.PA_TIME_CHART_TEMP

Object Details
Object Name: PA_TIME_CHART_TEMP
Object Type: TABLE
Owner: PA
Subobject Name:
Status: VALID

The PA_TIME_CHART_TEMP table stores the time chart data for displaying all timelines.

Temporary Table Details

PA.PA_TIME_CHART_TEMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
TIME_CHART_RECORD_TYPE VARCHAR2 (30) Yes Time chart record type (lookup code)
ROW_LABEL_ID NUMBER
Yes Identifier of the assignment or resource to which the time chart record belongs. It is a predefined dummy ID for Available or Overcommitted row in the Resource Details time chart.
START_DATE DATE
Yes Start date
END_DATE DATE
Yes End date
WEEK_END_DATE DATE

The week ending date for the time chart record
SCALE_TYPE VARCHAR2 (30) Yes Scale type of the time chart record, such as MONTH or THREE_MONTH (lookup code)
QUANTITY NUMBER

The daily or weekly number of hours for the time chart bars.
RENDER_PRIORITY NUMBER
Yes The priority used to render time chart bars. Only the highest priority one is rendered for a particular day or week on the time chart.
COLOR_FILE_NAME VARCHAR2 (30)
The gif file name (without file extention) for the color used to draw the time chart bars.
Query Text

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


SELECT TIME_CHART_RECORD_TYPE
,      ROW_LABEL_ID
,      START_DATE
,      END_DATE
,      WEEK_END_DATE
,      SCALE_TYPE
,      QUANTITY
,      RENDER_PRIORITY
,      COLOR_FILE_NAME
FROM PA.PA_TIME_CHART_TEMP;

Dependencies

[top of page]

PA.PA_TIME_CHART_TEMP does not reference any database object

PA.PA_TIME_CHART_TEMP is referenced by following:

SchemaAPPS
SynonymPA_TIME_CHART_TEMP