eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: PA.PA_RESOURCE_FORMATS

Object Details

Object Name:	PA_RESOURCE_FORMATS
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_RESOURCE_FORMATS
Subobject Name:
Status:	VALID

PA_RESOURCE_FORMATS stores the valid, predefined resource formats
for resource transaction attributes. Examples of such valid
combinations are: Employee only, Job only, Expenditure Type only,
Employee and Expenditure Type, and Expenditure type and Non-Labor
Resource. All data in this table is predefined by Oracle Projects.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_RESOURCE_FORMATS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RESOURCE_FORMAT_ID ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
RESOURCE_FORMAT_ID	NUMBER	(15)	Yes	System generated number that uniquely identifies the resource format
DESCRIPTION	VARCHAR2	(255)		The description of the Resource format
PERSON_ID_FLAG	VARCHAR2	(1)	Yes	Set to 'Y' if one of the attributes is 'Employee',else set to 'N'
JOB_ID_FLAG	VARCHAR2	(1)	Yes	Set to 'Y' if one of the attributes is 'Job',else set to 'N'
ORGANIZATION_ID_FLAG	VARCHAR2	(1)	Yes	Set to 'Y' if one of the attributes is 'Organization',else set to 'N'
VENDOR_ID_FLAG	VARCHAR2	(1)	Yes	Set to 'Y' if one of the attributes is 'Supplier',else set to 'N'
EXPENDITURE_TYPE_FLAG	VARCHAR2	(1)	Yes	Set to 'Y' if one of the attributes is 'Expenditure Type',else set to 'N'
EVENT_TYPE_FLAG	VARCHAR2	(1)	Yes	Set to 'Y' if one of the attributes is 'Event Type',else set to 'N'
NON_LABOR_RESOURCE_FLAG	VARCHAR2	(1)	Yes	Set to 'Y' if one of the attributes is 'Non labor Resource',else set to 'N'
EXPENDITURE_CATEGORY_FLAG	VARCHAR2	(1)	Yes	Set to 'Y' if one of the attributes is 'Expenditure Category',else set to 'N'
REVENUE_CATEGORY_FLAG	VARCHAR2	(1)	Yes	Set to 'Y' if one of the attributes is 'Revenue Category',else set to 'N'
NON_LABOR_RESOURCE_ORG_ID_FLAG	VARCHAR2	(1)	Yes	Set to Y if one of the attributes is Non labor Resource, else set to N
EVENT_TYPE_CLASSIFICATION_FLAG	VARCHAR2	(1)	Yes	Set to 'Y' if one of the attributes is 'Event Type Classification',else set to 'N'
SYSTEM_LINKAGE_FUNCTION_FLAG	VARCHAR2	(1)	Yes	Set to 'Y' if one of the attributes is 'System Linkage Function',else set to 'N'
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard Who Column
PROJECT_ROLE_ID_FLAG	VARCHAR2	(1)	Yes	Set to Y if one of the attributes is Project Role, else set to N.
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT RESOURCE_FORMAT_ID
,      DESCRIPTION
,      PERSON_ID_FLAG
,      JOB_ID_FLAG
,      ORGANIZATION_ID_FLAG
,      VENDOR_ID_FLAG
,      EXPENDITURE_TYPE_FLAG
,      EVENT_TYPE_FLAG
,      NON_LABOR_RESOURCE_FLAG
,      EXPENDITURE_CATEGORY_FLAG
,      REVENUE_CATEGORY_FLAG
,      NON_LABOR_RESOURCE_ORG_ID_FLAG
,      EVENT_TYPE_CLASSIFICATION_FLAG
,      SYSTEM_LINKAGE_FUNCTION_FLAG
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PROJECT_ROLE_ID_FLAG
,      ZD_EDITION_NAME
FROM PA.PA_RESOURCE_FORMATS;

Dependencies

[top of page]

PA.PA_RESOURCE_FORMATS does not reference any database object

PA.PA_RESOURCE_FORMATS is referenced by following:

PA: PA_RESOURCE_FORMATS#