FND Design Data [Home] [Help]

Table: PAY_USER_COLUMNS

Product: PAY - Payroll
Description: Column definitions for user defined tables.
Implementation/DBA Data: TableHR.PAY_USER_COLUMNS
Primary Key: PAY_USER_COLUMNS_PK
  1. ColumnUSER_COLUMN_ID
Primary Key: PAY_USER_COLUMNS_UK2
  1. ColumnUSER_COLUMN_NAME
  2. ColumnUSER_TABLE_ID
  3. ColumnBUSINESS_GROUP_ID
  4. ColumnLEGISLATION_CODE
Foreign Keys
Table
Foreign Table Foreign Key Column
PAY_USER_COLUMNS FK Joins to TablePAY_USER_TABLES PAY_USER_COLUMNS.USER_TABLE_ID
TablePAY_USER_COLUMN_INSTANCES_F FK Joins to PAY_USER_COLUMNS PAY_USER_COLUMN_INSTANCES_F.USER_COLUMN_ID