[Home] [Help] [Dependency Information]
Object Name: | PA_WORK_PATTERN_TEMP_TABLE |
---|---|
Object Type: | TABLE |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
This is an internal table that is used to store temporary data required for PJR Weekly Schedule
PA.PA_WORK_PATTERN_TEMP_TABLE 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$TRANSACTION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_ID | NUMBER | (15) | ||
PROJECT_NAME | VARCHAR2 | (30) | ||
ASSIGNMENT_NAME | VARCHAR2 | (80) | ||
START_DATE | DATE | |||
END_DATE | DATE | |||
STATUS_NAME | VARCHAR2 | (80) | ||
ASSIGNMENT_ID | NUMBER | (15) | ||
RESOURCE_ID | NUMBER | (15) | ||
STATUS_CODE | VARCHAR2 | (30) | ||
RECORD_VERSION_NUMBER | NUMBER | (15) | ||
ASSIGNMENT_TYPE | VARCHAR2 | (30) | ||
CALENDAR_ID | NUMBER | (15) | ||
CALENDAR_TYPE | VARCHAR2 | (30) | ||
PROJECT_ROLE_NAME | VARCHAR2 | (80) | ||
APPRVL_STATUS_NAME | VARCHAR2 | (80) | ||
ASSIGNMENT_EFFORT | NUMBER | |||
ASSIGNMENT_DURATION | NUMBER | |||
PROJECT_SYSTEM_STATUS_CODE | VARCHAR2 | (30) | ||
DAY1 | DATE | |||
DAY2 | DATE | |||
DAY3 | DATE | |||
DAY4 | DATE | |||
DAY5 | DATE | |||
DAY6 | DATE | |||
DAY7 | DATE | |||
DAY8 | DATE | |||
DAY9 | DATE | |||
DAY10 | DATE | |||
DAY11 | DATE | |||
DAY12 | DATE | |||
DAY13 | DATE | |||
DAY14 | DATE | |||
QTY1 | NUMBER | |||
QTY2 | NUMBER | |||
QTY3 | NUMBER | |||
QTY4 | NUMBER | |||
QTY5 | NUMBER | |||
QTY6 | NUMBER | |||
QTY7 | NUMBER | |||
QTY8 | NUMBER | |||
QTY9 | NUMBER | |||
QTY10 | NUMBER | |||
QTY11 | NUMBER | |||
QTY12 | NUMBER | |||
QTY13 | NUMBER | |||
QTY14 | NUMBER | |||
ROW_TYPE_CODE | NUMBER | |||
READ_ONLY_FLAG | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, PROJECT_NAME
, ASSIGNMENT_NAME
, START_DATE
, END_DATE
, STATUS_NAME
, ASSIGNMENT_ID
, RESOURCE_ID
, STATUS_CODE
, RECORD_VERSION_NUMBER
, ASSIGNMENT_TYPE
, CALENDAR_ID
, CALENDAR_TYPE
, PROJECT_ROLE_NAME
, APPRVL_STATUS_NAME
, ASSIGNMENT_EFFORT
, ASSIGNMENT_DURATION
, PROJECT_SYSTEM_STATUS_CODE
, DAY1
, DAY2
, DAY3
, DAY4
, DAY5
, DAY6
, DAY7
, DAY8
, DAY9
, DAY10
, DAY11
, DAY12
, DAY13
, DAY14
, QTY1
, QTY2
, QTY3
, QTY4
, QTY5
, QTY6
, QTY7
, QTY8
, QTY9
, QTY10
, QTY11
, QTY12
, QTY13
, QTY14
, ROW_TYPE_CODE
, READ_ONLY_FLAG
FROM PA.PA_WORK_PATTERN_TEMP_TABLE;
PA.PA_WORK_PATTERN_TEMP_TABLE does not reference any database object
PA.PA_WORK_PATTERN_TEMP_TABLE is referenced by following:
|
|
|