[Home] [Help] [Dependency Information]
Object Name: | PA_FP_PERIOD_MASK_TMP |
---|---|
Object Type: | TABLE |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
This global temporary table stores the information about the number of periods, anchor starting date, anchor ending date, anchor period flag and anchor position.
PA.PA_FP_PERIOD_MASK_TMP 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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NUM_OF_PERIODS | NUMBER | Indicates the number of periods in this bucket. | ||
ANCHOR_PERIOD_FLAG | VARCHAR2 | (1) | Indicates whether bucket is an anchoring period bucket. Valid values: Y or N. | |
FROM_ANCHOR_START | NUMBER | Indicates the number of periods from anchoring period buckets. | ||
FROM_ANCHOR_END | NUMBER | Indicates the number of periods from anchoring period buckets. | ||
FROM_ANCHOR_POSITION | NUMBER | (15) | Indicates the position of the period bucket from anchoring period. |
Cut, paste (and edit) the following text to query this object:
SELECT NUM_OF_PERIODS
, ANCHOR_PERIOD_FLAG
, FROM_ANCHOR_START
, FROM_ANCHOR_END
, FROM_ANCHOR_POSITION
FROM PA.PA_FP_PERIOD_MASK_TMP;
PA.PA_FP_PERIOD_MASK_TMP does not reference any database object
PA.PA_FP_PERIOD_MASK_TMP is referenced by following:
|
|
|