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_FR_CONTRIBUTION_USAGES

Object Details

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

PAY_FR_CONTRIBUTION_USAGES holds the definition of statutory payroll contributions in the French legislation.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PAY_FR_CONTRIBUTION_USAG_PK

CONTRIBUTION_USAGE_ID

Unique Key: PAY_FR_CONTRIBUTION_USAGES_UK1

DATE_FROM
GROUP_CODE
PROCESS_TYPE
ELEMENT_NAME
CONTRIBUTION_USAGE_TYPE
BUSINESS_GROUP_ID

Unique Key: PAY_FR_CONTRIBUTION_USAGES_UK2

DATE_FROM
PROCESS_TYPE
ELEMENT_NAME
CONTRIBUTION_USAGE_TYPE
BUSINESS_GROUP_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_FR_CONTRIBUTION_USAGES_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DATE_FROM GROUP_CODE PROCESS_TYPE ELEMENT_NAME CONTRIBUTION_USAGE_TYPE BUSINESS_GROUP_ID
PAY_FR_CONTRIBUTION_USAGES_UK2	NORMAL	UNIQUE	APPS_TS_TX_IDX	DATE_FROM PROCESS_TYPE ELEMENT_NAME CONTRIBUTION_USAGE_TYPE BUSINESS_GROUP_ID
PAY_FR_CONTRIBUTION_USAG_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CONTRIBUTION_USAGE_ID
PAY_FR_CONTRIBUTION_USAGES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ELEMENT_NAME PROCESS_TYPE CONTRIBUTION_USAGE_TYPE DATE_FROM DATE_TO BUSINESS_GROUP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CONTRIBUTION_USAGE_ID	NUMBER	(9)	Yes	System generated primary key column
DATE_FROM	DATE		Yes	Date from which this row applies
DATE_TO	DATE			Date after which this row no longer appies
GROUP_CODE	VARCHAR2	(30)	Yes	The element group for the contribution usage.
PROCESS_TYPE	VARCHAR2	(30)	Yes	The assignments process type, eg Normal, VRP.
ELEMENT_NAME	VARCHAR2	(80)	Yes	The pay element that uses this contribution type.
RATE_TYPE	VARCHAR2	(30)		The type of rate that is used by this contribution type.
CONTRIBUTION_CODE	VARCHAR2	(30)		The standard contribution code for statutory reporting.
RETRO_CONTRIBUTION_CODE	VARCHAR2	(30)		The contribution code used on statutory reports when retropayments have been made with this contributon usage.
CONTRIBUTION_TYPE	VARCHAR2	(10)	Yes	The type of body receiving the contribution, eg 'AGIRC', 'ARRCO', 'URSSAF','ASSEDIC'.
CONTRIBUTION_USAGE_TYPE	VARCHAR2	(30)	Yes	The type of contribution usage, eg Standard, Part-Time.
RATE_CATEGORY	VARCHAR2	(1)	Yes	The categorization of the rate type used by this contribution usage, eg 'S' - Standard, 'W' - Work Accident., 'T' - Transport Tax, 'R' - Rebate, 'C' - Cadre
BUSINESS_GROUP_ID	NUMBER	(15)		Business Group owning this specific contribution usage.
OBJECT_VERSION_NUMBER	NUMBER	(15)		System generated version of row. Increments by one with each update.
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.
LAST_UPDATED_BY	NUMBER	(15)		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
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).
CODE_RATE_ID	NUMBER	(15)		A unique identifier of a Rate Type within a Contribution Code.

Query Text

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


SELECT CONTRIBUTION_USAGE_ID
,      DATE_FROM
,      DATE_TO
,      GROUP_CODE
,      PROCESS_TYPE
,      ELEMENT_NAME
,      RATE_TYPE
,      CONTRIBUTION_CODE
,      RETRO_CONTRIBUTION_CODE
,      CONTRIBUTION_TYPE
,      CONTRIBUTION_USAGE_TYPE
,      RATE_CATEGORY
,      BUSINESS_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CODE_RATE_ID
FROM HR.PAY_FR_CONTRIBUTION_USAGES;

Dependencies

[top of page]

HR.PAY_FR_CONTRIBUTION_USAGES does not reference any database object

HR.PAY_FR_CONTRIBUTION_USAGES is referenced by following:

APPS: PAY_FR_CONTRIBUTION_USAGES; PAY_FR_CONTRIBUTION_USAGES_WHO
PUBLIC: PAY_FR_CONTRIBUTION_USAGES