FND Design Data [Home] [Help]

Table: HR_DM_SEQUENCE_HISTORIES

Product: PER - Human Resources
Description: Table containing sequence information from the different Fidelity databases. To be updated before any changes to sequences are made to enable sequence history tracking.
Implementation/DBA Data: TableHR.HR_DM_SEQUENCE_HISTORIES
Primary Key: HR_DM_SEQUENCE_HISTORIES_PK
  1. ColumnSEQUENCE_HISTORY_ID
Primary Key: HR_DM_SEQUENCE_HISTORIES_UK1
  1. ColumnSEQUENCE_ID
  2. ColumnDATABASE_ID
  3. ColumnTIMESTAMP
Foreign Keys
Table
Foreign Table Foreign Key Column
HR_DM_SEQUENCE_HISTORIES FK Joins to TableHR_DM_SEQUENCE_DEFINITIONS HR_DM_SEQUENCE_HISTORIES.SEQUENCE_ID
HR_DM_SEQUENCE_HISTORIES FK Joins to TableHR_DM_DATABASES HR_DM_SEQUENCE_HISTORIES.DATABASE_ID