FND Design Data [Home] [Help]

Table: PAY_ELEMENT_CLASSIFICATIONS

Product: PAY - Payroll
Description: Element classifications for legislation and information needs.
Implementation/DBA Data: TableHR.PAY_ELEMENT_CLASSIFICATIONS
Primary Key: PAY_ELEMENT_CLASSIFICATION_PK
  1. ColumnCLASSIFICATION_ID
Primary Key: PAY_ELEMENT_CLASSIFICATION_UK2
  1. ColumnCLASSIFICATION_NAME
  2. ColumnBUSINESS_GROUP_ID
  3. ColumnLEGISLATION_CODE
Foreign Keys
Table
Foreign Table Foreign Key Column
PAY_ELEMENT_CLASSIFICATIONS FK Joins to TablePAY_ELEMENT_CLASSIFICATIONS PAY_ELEMENT_CLASSIFICATIONS.PARENT_CLASSIFICATION_ID
TablePAY_BALANCE_CLASSIFICATIONS FK Joins to PAY_ELEMENT_CLASSIFICATIONS PAY_BALANCE_CLASSIFICATIONS.CLASSIFICATION_ID
TablePAY_ELEMENT_CLASSIFICATIONS FK Joins to PAY_ELEMENT_CLASSIFICATIONS PAY_ELEMENT_CLASSIFICATIONS.PARENT_CLASSIFICATION_ID
TablePAY_ELEMENT_TYPES_F FK Joins to PAY_ELEMENT_CLASSIFICATIONS PAY_ELEMENT_TYPES_F.CLASSIFICATION_ID
TablePAY_ELE_CLASSIFICATION_RULES FK Joins to PAY_ELEMENT_CLASSIFICATIONS PAY_ELE_CLASSIFICATION_RULES.CLASSIFICATION_ID
TablePAY_SUB_CLASSIFICATION_RULES_F FK Joins to PAY_ELEMENT_CLASSIFICATIONS PAY_SUB_CLASSIFICATION_RULES_F.CLASSIFICATION_ID
TablePAY_TAXABILITY_RULES FK Joins to PAY_ELEMENT_CLASSIFICATIONS PAY_TAXABILITY_RULES.CLASSIFICATION_ID
TablePAY_TAXABILITY_RULES FK Joins to PAY_ELEMENT_CLASSIFICATIONS PAY_TAXABILITY_RULES.SECONDARY_CLASSIFICATION_ID
TablePAY_MX_EARN_EXEMPTION_RULES_F FK Joins to PAY_ELEMENT_CLASSIFICATIONS PAY_MX_EARN_EXEMPTION_RULES_F.ELEMENT_CLASSIFICATION_ID