FND Design Data [Home] [Help]

Table: PAY_MX_EARN_EXEMPTION_RULES_F

Product: PAY - Payroll
Description: Used to hold the Earnings exemption rules for Mexico
Implementation/DBA Data: TableHR.PAY_MX_EARN_EXEMPTION_RULES_F
Primary Key: PAY_MX_EARN_EXEMPTION_RULES_PK
  1. ColumnEXEMPTION_RULE_ID
  2. ColumnEFFECTIVE_START_DATE
  3. ColumnEFFECTIVE_END_DATE
Primary Key: PAY_MX_EARN_EXEMPTION_RULES_UK
  1. ColumnELEMENT_CLASSIFICATION_ID
  2. ColumnSTATE_CODE
  3. ColumnEFFECTIVE_START_DATE
  4. ColumnEFFECTIVE_END_DATE
Foreign Keys
Table
Foreign Table Foreign Key Column
PAY_MX_EARN_EXEMPTION_RULES_F FK Joins to TablePAY_ELEMENT_CLASSIFICATIONS PAY_MX_EARN_EXEMPTION_RULES_F.ELEMENT_CLASSIFICATION_ID