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_ELEMENT_TEMPLATES

Object Details

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

In Oracle payroll it is common to have sets of elements that are
related by the processing they carry out. For example, in US payroll,
Standard Voluntary Deductions comprise Special Inputs, Base, and
Special Features elements. Element Templates capture the
relationships between elements (and associated payroll entities) for
different types of payroll processing. Element Templates are used
to generate payroll objects according to the payroll situation. For
example, the structure of Child Support, and Parking Fine Involuntary
deductions may be similar (and modelled by one Element Template) but
different objects are generated in the payroll schema for each of
these Involuntary Deductions.
A template structure is an element template set up by a localisation
group to model commonly used groupings of HR or payroll elements.
For example, in US payroll earnings share a common underlying
structure in the elements they contain and the balances the feed. A
template structure contains names with placeholders. A template
structure is copied to a user structure, and the placeholders
substituted for a user-supplied name before generating HR or payroll
objects.
A user structure is an element template from which core schema objects
are generated. It may be created from scratch by a user, or generated
from a template structure.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PAY_ELEMENT_TEMPLATES_PK

TEMPLATE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_ELEMENT_TEMPLATES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	TEMPLATE_ID
PAY_ELEMENT_TEMPLATES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TEMPLATE_NAME TEMPLATE_TYPE

Foreign Keys

Table	Foreign Table	Foreign Key Column
PAY_SHADOW_BALANCE_TYPES	PAY_ELEMENT_TEMPLATES	PAY_SHADOW_BALANCE_TYPES TEMPLATE_ID
PAY_SHADOW_ELEMENT_TYPES	PAY_ELEMENT_TEMPLATES	PAY_SHADOW_ELEMENT_TYPES TEMPLATE_ID
PAY_TEMPLATE_CORE_OBJECTS	PAY_ELEMENT_TEMPLATES	PAY_TEMPLATE_CORE_OBJECTS TEMPLATE_ID
PAY_TEMPLATE_EXCLUSION_RULES	PAY_ELEMENT_TEMPLATES	PAY_TEMPLATE_EXCLUSION_RULES TEMPLATE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TEMPLATE_ID	NUMBER	(9)	Yes	System-generated primary key column.
TEMPLATE_TYPE	VARCHAR2	(30)	Yes	Element template type.
TEMPLATE_NAME	VARCHAR2	(80)	Yes	User name for this template.
BASE_PROCESSING_PRIORITY	NUMBER	(9)	Yes	Base value to add to differential values for element processing
BUSINESS_GROUP_ID	NUMBER	(15)		Foreign key to HR_ORGANIZATION_UNITS.
LEGISLATION_CODE	VARCHAR2	(30)		Foreign key to FND_TERRITORIES.
VERSION_NUMBER	NUMBER		Yes	Version number for the template as a whole (for support purposes).
BASE_NAME	VARCHAR2	(50)		User-supplied name for placeholder substitution.
MAX_BASE_NAME_LENGTH	NUMBER	(9)	Yes	Maximum length of BASE_NAME to avoid name clashes in generated objects e.g. database items.
PREFERENCE_INFO_CATEGORY	VARCHAR2	(30)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION1	VARCHAR2	(150)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION2	VARCHAR2	(150)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION3	VARCHAR2	(150)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION4	VARCHAR2	(150)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION5	VARCHAR2	(150)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION6	VARCHAR2	(150)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION7	VARCHAR2	(150)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION8	VARCHAR2	(150)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION9	VARCHAR2	(150)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION10	VARCHAR2	(150)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION11	VARCHAR2	(150)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION12	VARCHAR2	(150)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION13	VARCHAR2	(150)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION14	VARCHAR2	(150)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION15	VARCHAR2	(150)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION16	VARCHAR2	(150)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION17	VARCHAR2	(150)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION18	VARCHAR2	(150)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION19	VARCHAR2	(240)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION20	VARCHAR2	(150)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION21	VARCHAR2	(150)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION22	VARCHAR2	(150)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION23	VARCHAR2	(150)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION24	VARCHAR2	(150)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION25	VARCHAR2	(150)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION26	VARCHAR2	(150)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION27	VARCHAR2	(150)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION28	VARCHAR2	(150)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION29	VARCHAR2	(150)		Developer descriptive flexfield column.
PREFERENCE_INFORMATION30	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFO_CATEGORY	VARCHAR2	(30)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION1	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION2	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION3	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION4	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION5	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION6	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION7	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION8	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION9	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION10	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION11	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION12	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION13	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION14	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION15	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION16	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION17	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION18	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION19	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION20	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION21	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION22	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION23	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION24	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION25	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION26	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION27	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION28	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION29	VARCHAR2	(150)		Developer descriptive flexfield column.
CONFIGURATION_INFORMATION30	VARCHAR2	(150)		Developer descriptive flexfield column.
OBJECT_VERSION_NUMBER	NUMBER	(9)		Object version number column.
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.

Query Text

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


SELECT TEMPLATE_ID
,      TEMPLATE_TYPE
,      TEMPLATE_NAME
,      BASE_PROCESSING_PRIORITY
,      BUSINESS_GROUP_ID
,      LEGISLATION_CODE
,      VERSION_NUMBER
,      BASE_NAME
,      MAX_BASE_NAME_LENGTH
,      PREFERENCE_INFO_CATEGORY
,      PREFERENCE_INFORMATION1
,      PREFERENCE_INFORMATION2
,      PREFERENCE_INFORMATION3
,      PREFERENCE_INFORMATION4
,      PREFERENCE_INFORMATION5
,      PREFERENCE_INFORMATION6
,      PREFERENCE_INFORMATION7
,      PREFERENCE_INFORMATION8
,      PREFERENCE_INFORMATION9
,      PREFERENCE_INFORMATION10
,      PREFERENCE_INFORMATION11
,      PREFERENCE_INFORMATION12
,      PREFERENCE_INFORMATION13
,      PREFERENCE_INFORMATION14
,      PREFERENCE_INFORMATION15
,      PREFERENCE_INFORMATION16
,      PREFERENCE_INFORMATION17
,      PREFERENCE_INFORMATION18
,      PREFERENCE_INFORMATION19
,      PREFERENCE_INFORMATION20
,      PREFERENCE_INFORMATION21
,      PREFERENCE_INFORMATION22
,      PREFERENCE_INFORMATION23
,      PREFERENCE_INFORMATION24
,      PREFERENCE_INFORMATION25
,      PREFERENCE_INFORMATION26
,      PREFERENCE_INFORMATION27
,      PREFERENCE_INFORMATION28
,      PREFERENCE_INFORMATION29
,      PREFERENCE_INFORMATION30
,      CONFIGURATION_INFO_CATEGORY
,      CONFIGURATION_INFORMATION1
,      CONFIGURATION_INFORMATION2
,      CONFIGURATION_INFORMATION3
,      CONFIGURATION_INFORMATION4
,      CONFIGURATION_INFORMATION5
,      CONFIGURATION_INFORMATION6
,      CONFIGURATION_INFORMATION7
,      CONFIGURATION_INFORMATION8
,      CONFIGURATION_INFORMATION9
,      CONFIGURATION_INFORMATION10
,      CONFIGURATION_INFORMATION11
,      CONFIGURATION_INFORMATION12
,      CONFIGURATION_INFORMATION13
,      CONFIGURATION_INFORMATION14
,      CONFIGURATION_INFORMATION15
,      CONFIGURATION_INFORMATION16
,      CONFIGURATION_INFORMATION17
,      CONFIGURATION_INFORMATION18
,      CONFIGURATION_INFORMATION19
,      CONFIGURATION_INFORMATION20
,      CONFIGURATION_INFORMATION21
,      CONFIGURATION_INFORMATION22
,      CONFIGURATION_INFORMATION23
,      CONFIGURATION_INFORMATION24
,      CONFIGURATION_INFORMATION25
,      CONFIGURATION_INFORMATION26
,      CONFIGURATION_INFORMATION27
,      CONFIGURATION_INFORMATION28
,      CONFIGURATION_INFORMATION29
,      CONFIGURATION_INFORMATION30
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PAY_ELEMENT_TEMPLATES;

Dependencies

[top of page]

HR.PAY_ELEMENT_TEMPLATES does not reference any database object

HR.PAY_ELEMENT_TEMPLATES is referenced by following:

APPS: PAY_ELEMENT_TEMPLATES; PAY_ELEMENT_TEMPLATES_WHO
PUBLIC: PAY_ELEMENT_TEMPLATES