[Home] [Help] [Dependency Information]
Object Name: | PA_TIMELINE_COLORS |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_TIMELINE_COLORS |
Subobject Name: | |
Status: | VALID |
The PA_TIMELINE_COLORS table stores the names of the GIF files used to define the colors for the timeline. This table is used as lookup table for timeline legends. This table is seeded by development.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_TIMELINE_COLORS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
LOOKUP_TYPE
LOOKUP_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOOKUP_TYPE | VARCHAR2 | (30) | Yes | The classification by which the colors are grouped, such as RESOURCE_TIMELINE |
LOOKUP_CODE | VARCHAR2 | (30) | Yes | System status codes. Valid values are: STAFFED_ASGMT_CONF, STAFFED_ASGMT_PROV and SCH_UPDATE_PENDING_FLAG |
FILE_NAME | VARCHAR2 | (30) | Yes | This value is used to store the color code used in the time chart tables |
COLOR_PATTERN_CODE | VARCHAR2 | (1) | Yes | Color Pattern Code |
DESCRIPTION | VARCHAR2 | (80) | Status Description | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
RENDER_PRIORITY | NUMBER | (9) | 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. |
Cut, paste (and edit) the following text to query this object:
SELECT LOOKUP_TYPE
, LOOKUP_CODE
, FILE_NAME
, COLOR_PATTERN_CODE
, DESCRIPTION
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, RENDER_PRIORITY
FROM PA.PA_TIMELINE_COLORS;
PA.PA_TIMELINE_COLORS does not reference any database object
PA.PA_TIMELINE_COLORS is referenced by following:
|
|
|