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

TABLE: PA.PA_CAL_GEN_STATUS_TEMP

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

PA_CAL_GEN_STATUS_TEMP table is temporary table at the session level. This table stores all the calendar name and their respective calendar identifiers for a particular session for which the schedule has been
generated or not generated. If not generated, it stores the status as E, means not generated. If generated,
then the status is stored as S, and the reason is stored in message code

Temporary Table Details

PA.PA_CAL_GEN_STATUS_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
CALENDAR_ID NUMBER
Yes The identifier of the calendar for which schedule is created
CALENDAR_NAME VARCHAR2 (50)
The name of the calendar for which schedule is created
GENERATE_STATUS_FLAG VARCHAR2 (1)
This status indicates wheather or not the schedule for this calendar was created successfully
MESSAGE_CODE VARCHAR2 (50)
The identifier which indicates the reason the schedule was generated successfully or not
Query Text

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


SELECT CALENDAR_ID
,      CALENDAR_NAME
,      GENERATE_STATUS_FLAG
,      MESSAGE_CODE
FROM PA.PA_CAL_GEN_STATUS_TEMP;

Dependencies

[top of page]

PA.PA_CAL_GEN_STATUS_TEMP does not reference any database object

PA.PA_CAL_GEN_STATUS_TEMP is referenced by following:

SchemaAPPS
SynonymPA_CAL_GEN_STATUS_TEMP