FND Design Data [Home] [Help]

Table: PAY_JOB_WC_CODE_USAGES

Product: PAY - Payroll
Description: Workers Compensation codes for specific job and state combinations.
Implementation/DBA Data: TableHR.PAY_JOB_WC_CODE_USAGES
Primary Key: PAY_JOB_WC_CODE_USAGES_PK
  1. ColumnJOB_ID
  2. ColumnSTATE_CODE
Foreign Keys
Table
Foreign Table Foreign Key Column
PAY_JOB_WC_CODE_USAGES FK Joins to TableHR_ALL_ORGANIZATION_UNITS PAY_JOB_WC_CODE_USAGES.BUSINESS_GROUP_ID
PAY_JOB_WC_CODE_USAGES FK Joins to TablePER_JOBS PAY_JOB_WC_CODE_USAGES.JOB_ID
PAY_JOB_WC_CODE_USAGES FK Joins to TablePAY_STATE_RULES PAY_JOB_WC_CODE_USAGES.STATE_CODE