FND Design Data [Home] [Help]

Table: PAY_ALL_PAYROLLS_F

Product: PAY - Payroll
Description: Payroll group definitions.
Implementation/DBA Data: TableHR.PAY_ALL_PAYROLLS_F
Primary Key: PAY_PAYROLLS_F_PK
  1. ColumnPAYROLL_ID
  2. ColumnEFFECTIVE_START_DATE
  3. ColumnEFFECTIVE_END_DATE
Foreign Keys
Table
Foreign Table Foreign Key Column
PAY_ALL_PAYROLLS_F FK Joins to TableHR_ALL_ORGANIZATION_UNITS PAY_ALL_PAYROLLS_F.BUSINESS_GROUP_ID
PAY_ALL_PAYROLLS_F FK Joins to TablePAY_CONSOLIDATION_SETS PAY_ALL_PAYROLLS_F.CONSOLIDATION_SET_ID
PAY_ALL_PAYROLLS_F FK Joins to TablePAY_COST_ALLOCATION_KEYFLEX PAY_ALL_PAYROLLS_F.COST_ALLOCATION_KEYFLEX_ID
PAY_ALL_PAYROLLS_F FK Joins to TablePAY_COST_ALLOCATION_KEYFLEX PAY_ALL_PAYROLLS_F.SUSPENSE_ACCOUNT_KEYFLEX_ID
PAY_ALL_PAYROLLS_F FK Joins to TableHR_SOFT_CODING_KEYFLEX PAY_ALL_PAYROLLS_F.SOFT_CODING_KEYFLEX_ID
PAY_ALL_PAYROLLS_F FK Joins to TablePER_TIME_PERIOD_TYPES PAY_ALL_PAYROLLS_F.PERIOD_TYPE
PAY_ALL_PAYROLLS_F FK Joins to TableHR_ALL_ORGANIZATION_UNITS PAY_ALL_PAYROLLS_F.ORGANIZATION_ID