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

TABLE: PA.PA_RES_AVAILABILITY

Object Details
Object Name: PA_RES_AVAILABILITY
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_RES_AVAILABILITY
Subobject Name:
Status: VALID


PA_RES_AVAILABILITY is a table storing available/overcommitted percent and hours of a resource for a given period.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_RES_AVAILABILITY_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESOURCE_ID
ColumnSTART_DATE
ColumnRECORD_TYPE
ColumnPERCENT
Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER (15) Yes Identifier of the resource
START_DATE DATE
Yes The start date of the availability or overcommitment of the resource
END_DATE DATE

The end date of the availability or overcommitment of the resource
RECORD_TYPE VARCHAR2 (2) Yes Indicates if the record stores only confirmed or confirmed and provisional data for availability and overcommitment
PERCENT NUMBER

Percent available or overcommitted based on capacity
HOURS NUMBER

Number of hours the resource is available or overcommitted in the period
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
Query Text

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


SELECT RESOURCE_ID
,      START_DATE
,      END_DATE
,      RECORD_TYPE
,      PERCENT
,      HOURS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM PA.PA_RES_AVAILABILITY;

Dependencies

[top of page]

PA.PA_RES_AVAILABILITY does not reference any database object

PA.PA_RES_AVAILABILITY is referenced by following:

SchemaPA
ViewPA_RES_AVAILABILITY#