FND Design Data [Home] [Help]

Table: PAY_US_EMP_STATE_TAX_RULES_F

Product: PAY - Payroll
Description: State level tax details for employee assignments.
Implementation/DBA Data: TableHR.PAY_US_EMP_STATE_TAX_RULES_F
Primary Key: PAY_US_EMP_STATE_TAX_RULES_PK
  1. ColumnEMP_STATE_TAX_RULE_ID
  2. ColumnEFFECTIVE_START_DATE
  3. ColumnEFFECTIVE_END_DATE
Foreign Keys
Table
Foreign Table Foreign Key Column
PAY_US_EMP_STATE_TAX_RULES_F FK Joins to TablePAY_US_STATES PAY_US_EMP_STATE_TAX_RULES_F.STATE_CODE
PAY_US_EMP_STATE_TAX_RULES_F FK Joins to TableHR_ALL_ORGANIZATION_UNITS PAY_US_EMP_STATE_TAX_RULES_F.BUSINESS_GROUP_ID