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_COMPENSATION_RULE_SETS

Object Details

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

PA_COMPENSATION_RULE_SETS stores
implementation-defined classifications used to
describe how employees are compensated, particularly
for premium overtime hours. We refer to compensation
rule sets as compensation rules throughout the
documentation for Oracle Projects.
.
.
An employee's compensation rule may determine premium
hours if premium overtime hours are calculated using
the Overtime Calculation program. See the overtime
essay in the Oracle Projects User's Guide for more information
about using compensation rules to process overtime hours.
.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	3
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_COMPENSATION_RULE_SETS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	COMPENSATION_RULE_SET

Columns

Name	Datatype	Length	Mandatory	Comments
COMPENSATION_RULE_SET	VARCHAR2	(20)	Yes	Implementation-defined name that uniquely identifies the compensation rule
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column
START_DATE_ACTIVE	DATE		Yes	First effective date of the compensation rule
ALLOCATED_OVERTIME_EXP_TYPE	VARCHAR2	(30)		The overtime expenditure type used to create overtime expenditure items in the Overtime Calculation program for employees assigned this compensation rule
END_DATE_ACTIVE	DATE			Last effective date of the compensation rule
PROJECT_ID	NUMBER	(15)
TASK_ID	NUMBER	(15)
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield context field
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
COSTING_METHOD	VARCHAR2	(150)	Yes	Indicates the method that is used for calculating the labor cost.This can be either Standard Costing, Actual Costing with accrual or Actual Costing.
RATE_SOURCE_CODE	VARCHAR2	(30)		Name of the source from which employee rates are derived
ENABLE_ACCRUAL_CODE	VARCHAR2	(30)		Flag to indicate whether labor costs accrue based on reported hours from time cards and the rate source selected in the labor costing rule.
ENABLE_PLANNING_CODE	VARCHAR2	(30)		Flag to indicate whether users intend to use labor costing during planning
TOTAL_TIME_COSTING_CODE	VARCHAR2	(30)		Flag to indicate usage of uncompensated overtime hours in the distribution of labor costs

Query Text

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


SELECT COMPENSATION_RULE_SET
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      START_DATE_ACTIVE
,      ALLOCATED_OVERTIME_EXP_TYPE
,      END_DATE_ACTIVE
,      PROJECT_ID
,      TASK_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      COSTING_METHOD
,      RATE_SOURCE_CODE
,      ENABLE_ACCRUAL_CODE
,      ENABLE_PLANNING_CODE
,      TOTAL_TIME_COSTING_CODE
FROM PA.PA_COMPENSATION_RULE_SETS;

Dependencies

[top of page]

PA.PA_COMPENSATION_RULE_SETS does not reference any database object

PA.PA_COMPENSATION_RULE_SETS is referenced by following:

PA: PA_COMPENSATION_RULE_SETS#