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_MX_EARN_EXEMPTION_RULES_F

Object Details

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

PAY_MX_EARN_EXEMPTION_RULES_F is the DateTracked table which holds the
Earning Exemption rules for Mexico.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_MX_EARN_EXEMPTION_RULES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	EXEMPTION_RULE_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE ZD_EDITION_NAME
PAY_MX_EARN_EXEMPTION_RULES_UK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ELEMENT_CLASSIFICATION_ID STATE_CODE EFFECTIVE_START_DATE EFFECTIVE_END_DATE ZD_EDITION_NAME
SYS_IL0000408617C00014$$	LOB	UNIQUE	APPS_TS_TX_DATA

Columns

Name	Datatype	Length	Mandatory	Comments
EXEMPTION_RULE_ID	NUMBER	(9)	Yes	Part of the primary key
EFFECTIVE_START_DATE	DATE		Yes	Effective start date
EFFECTIVE_END_DATE	DATE		Yes	Effective end date
TAX_TYPE	VARCHAR2	(30)	Yes	Type of Tax for which this exemption is defined
ELEMENT_CLASSIFICATION_ID	NUMBER	(9)	Yes	The Element Classification for the Earnings Category. Foreign Key to PAY_ELEMENT_CLASSIFICATIONS.
STATE_CODE	VARCHAR2	(30)		State Code
CALC_RULE	VARCHAR2	(30)	Yes	Type of calculation involved
LOW_EXEMPT_FACTOR	NUMBER	(7)		Factor of Earnings that is exempt in the Lower Range
LOW_RANGE_FACTOR	NUMBER	(7)		Factor of Range Basis that is used to determine the limit of the Lower Range
LOW_RANGE_BASIS	VARCHAR2	(30)		Earnings Basis used in the Lower Range limit. Eg: MW, GMW, etc.
HIGH_RANGE_FACTOR	NUMBER	(7)		Factor of Range Basis that is used to determine the limit of the Higher Range
HIGH_EXEMPT_FACTOR	NUMBER	(7)		Factor of Earnings that is exempt in the Higher Range
HIGH_RANGE_BASIS	VARCHAR2	(30)		Earnings Basis used in the Higher Range limit. Eg: MW, GMW, etc.
DESCRIPTION	CLOB	(4000)		Description of the Exemption computation process
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.
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT EXEMPTION_RULE_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      TAX_TYPE
,      ELEMENT_CLASSIFICATION_ID
,      STATE_CODE
,      CALC_RULE
,      LOW_EXEMPT_FACTOR
,      LOW_RANGE_FACTOR
,      LOW_RANGE_BASIS
,      HIGH_RANGE_FACTOR
,      HIGH_EXEMPT_FACTOR
,      HIGH_RANGE_BASIS
,      DESCRIPTION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      ZD_EDITION_NAME
FROM HR.PAY_MX_EARN_EXEMPTION_RULES_F;

Dependencies

[top of page]

HR.PAY_MX_EARN_EXEMPTION_RULES_F does not reference any database object

HR.PAY_MX_EARN_EXEMPTION_RULES_F is referenced by following:

HR: PAY_MX_EARN_EXEMPTION_RULES_F#