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: HR.PAY_ACCRUAL_PLANS

Object Details

Object Name:	PAY_ACCRUAL_PLANS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PAY.PAY_ACCRUAL_PLANS
Subobject Name:
Status:	VALID

PAY_ACCRUAL_PLANS holds plan details for accrual of paid time off,
(PTO). It includes start dates and qualifying periods. Each plan is
linked to a number of specific elements and input values for
enrollment of employees, recording time off, recording carryover and
residual leave at the end of each period. The accrual calculation
process uses these input values to calculate time taken against
entitlement.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PAY_ACCRUAL_PLANS_PK

ACCRUAL_PLAN_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_ACCRUAL_PLANS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACCRUAL_PLAN_ID
PAY_ACCRUAL_PLANS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID
PAY_ACCRUAL_PLANS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCRUAL_PLAN_ELEMENT_TYPE_ID
PAY_ACCRUAL_PLANS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PTO_INPUT_VALUE_ID
PAY_ACCRUAL_PLANS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CO_INPUT_VALUE_ID
PAY_ACCRUAL_PLANS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESIDUAL_INPUT_VALUE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PAY_ACCRUAL_PLANS	HR_ALL_ORGANIZATION_UNITS	PAY_ACCRUAL_PLANS BUSINESS_GROUP_ID
PAY_ACCRUAL_BANDS	PAY_ACCRUAL_PLANS	PAY_ACCRUAL_BANDS ACCRUAL_PLAN_ID
PAY_NET_CALCULATION_RULES	PAY_ACCRUAL_PLANS	PAY_NET_CALCULATION_RULES ACCRUAL_PLAN_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ACCRUAL_PLAN_ID	NUMBER	(9)	Yes	System-generated primary key column.
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Foreign key to HR_ORGANIZATION_UNITS.
OBJECT_VERSION_NUMBER	NUMBER	(9)		System-generated version of row. Increments by one with each update.
ACCRUAL_PLAN_ELEMENT_TYPE_ID	NUMBER	(9)	Yes	Foreign key to PAY_ELEMENT_TYPES. Identifies the element that is used to enrol employees in the accrual plan.
PTO_INPUT_VALUE_ID	NUMBER	(9)		No longer used.
CO_FORMULA_ID	NUMBER	(9)		Foreign key to FF_FORMULAS_F. Identifies the formula to be used to calculate values for the PTO carryover process.
CO_INPUT_VALUE_ID	NUMBER	(9)	Yes	Identifies the input value that is used to record carryover entitlement from one period to the next.
CO_DATE_INPUT_VALUE_ID	NUMBER	(9)	Yes	Foreign key to PAY_INPUT_VALUES_F. Identifies the element and input value which stores the date when carried over time becomes effective.
CO_EXP_DATE_INPUT_VALUE_ID	NUMBER	(9)		Foreign key to PAY_INPUT_VALUES_F. Identifies the element and input value which stores the date when carried over time expires.
RESIDUAL_INPUT_VALUE_ID	NUMBER	(9)	Yes	Identifies the element and input value that is used to record residual leave at the end of a period.
RESIDUAL_DATE_INPUT_VALUE_ID	NUMBER	(9)	Yes	Foreign key to PAY_INPUT_VALUES_F. Identifies the element and input value which stores the date when residual time becomes effective.
ACCRUAL_FORMULA_ID	NUMBER	(9)		Foreign key to FF_FORMULAS_F. Identifies the formula used to calculate accrued time.
ACCRUAL_PLAN_NAME	VARCHAR2	(80)	Yes	User defined accrual plan name.
ACCRUAL_CATEGORY	VARCHAR2	(30)	Yes	Indicates whether a plan is Sickness or Vacation.
ACCRUAL_START	VARCHAR2	(30)		Indicates accrual start rule. This can be hire date, beginning of year, or six months after hire.
ACCRUAL_UNITS_OF_MEASURE	VARCHAR2	(30)	Yes	Indicates whether the accrual units are hours or days.
INELIGIBLE_PERIOD_LENGTH	NUMBER	(22)		User defined period of ineligibility, in conjunction with the ineligible period type.
INELIGIBLE_PERIOD_TYPE	VARCHAR2	(30)		Period type for the INELIGIBLE_PERIOD_LENGTH, for example, weeks or months.
DESCRIPTION	VARCHAR2	(240)		Description of the accrual plan.
INELIGIBILITY_FORMULA_ID	NUMBER	(9)		Foreign key to FF_FORMULAS_F. Identifies the formula used to calculate whether an employee is eligible to accrue time.
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	NUMBER	(15)		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
PAYROLL_FORMULA_ID	NUMBER	(15)		Foreign key to FF_FORMULAS_F. Identifies the formula specified in run result rules used by payroll processing.
DEFINED_BALANCE_ID	NUMBER	(15)		Foreign key to PAY_DEFINED_BALANCES. Identifies the defined balance used to store Accruals.
TAGGING_ELEMENT_TYPE_ID	NUMBER	(15)		Foreign key to PAY_ELEMENT_TYPES. Identifies the element that is used to flag retrospective net calculation rule element entries.
BALANCE_ELEMENT_TYPE_ID	NUMBER	(15)		Foreign key to PAY_ELEMENT_TYPES. Identifies the element that is used to manage the maintainance of an accrual payroll balance.
INFORMATION_CATEGORY	VARCHAR2	(30)		Developer descriptive flexfield structure defining column.
INFORMATION1	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION2	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION3	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION4	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION5	VARCHAR2	(240)		Developer descriptive flexfield column.
INFORMATION6	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION7	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION8	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION9	VARCHAR2	(240)		Developer descriptive flexfield column.
INFORMATION10	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION11	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION12	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION13	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION14	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION15	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION16	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION17	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION18	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION19	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION20	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION21	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION22	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION23	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION24	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION25	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION26	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION27	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION28	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION29	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION30	VARCHAR2	(150)		Developer descriptive flexfield column.

Query Text

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


SELECT ACCRUAL_PLAN_ID
,      BUSINESS_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      ACCRUAL_PLAN_ELEMENT_TYPE_ID
,      PTO_INPUT_VALUE_ID
,      CO_FORMULA_ID
,      CO_INPUT_VALUE_ID
,      CO_DATE_INPUT_VALUE_ID
,      CO_EXP_DATE_INPUT_VALUE_ID
,      RESIDUAL_INPUT_VALUE_ID
,      RESIDUAL_DATE_INPUT_VALUE_ID
,      ACCRUAL_FORMULA_ID
,      ACCRUAL_PLAN_NAME
,      ACCRUAL_CATEGORY
,      ACCRUAL_START
,      ACCRUAL_UNITS_OF_MEASURE
,      INELIGIBLE_PERIOD_LENGTH
,      INELIGIBLE_PERIOD_TYPE
,      DESCRIPTION
,      INELIGIBILITY_FORMULA_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      PAYROLL_FORMULA_ID
,      DEFINED_BALANCE_ID
,      TAGGING_ELEMENT_TYPE_ID
,      BALANCE_ELEMENT_TYPE_ID
,      INFORMATION_CATEGORY
,      INFORMATION1
,      INFORMATION2
,      INFORMATION3
,      INFORMATION4
,      INFORMATION5
,      INFORMATION6
,      INFORMATION7
,      INFORMATION8
,      INFORMATION9
,      INFORMATION10
,      INFORMATION11
,      INFORMATION12
,      INFORMATION13
,      INFORMATION14
,      INFORMATION15
,      INFORMATION16
,      INFORMATION17
,      INFORMATION18
,      INFORMATION19
,      INFORMATION20
,      INFORMATION21
,      INFORMATION22
,      INFORMATION23
,      INFORMATION24
,      INFORMATION25
,      INFORMATION26
,      INFORMATION27
,      INFORMATION28
,      INFORMATION29
,      INFORMATION30
FROM HR.PAY_ACCRUAL_PLANS;

Dependencies

[top of page]

HR.PAY_ACCRUAL_PLANS does not reference any database object

HR.PAY_ACCRUAL_PLANS is referenced by following:

HR: PAY_ACCRUAL_PLANS#