DBA Data[Home] [Help] [Dependency Information]


TABLE: HR.HR_ASSIGNMENT_SETS

Object Details
Object Name: HR_ASSIGNMENT_SETS
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.HR_ASSIGNMENT_SETS
Subobject Name:
Status: VALID


HR_ASSIGNMENT_SETS identifies the assignment sets that can be used
for payroll processing or QuickPaint reporting. Criteria are defined
in an assignment set formula, or by including or excluding specific
assignments. The list of assignments in each set are recalculated
dynamically whenever the set is used for processing.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: HR_ASSIGNMENT_SETS_PK
  1. ColumnASSIGNMENT_SET_ID
Indexes
Index Type Uniqueness Tablespace Column
HR_ASSIGNMENT_SETS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSIGNMENT_SET_ID
HR_ASSIGNMENT_SETS_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
HR_ASSIGNMENT_SETS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYROLL_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
HR_ASSIGNMENT_SETS HR_ASSIGNMENT_SETS_FK1 TableHR_ALL_ORGANIZATION_UNITS HR_ASSIGNMENT_SETS BUSINESS_GROUP_ID
TableHR_ASSIGNMENT_SET_AMENDMENTS HR_ASSIGNMENT_SET_AMENDMEN_FK2 HR_ASSIGNMENT_SETS HR_ASSIGNMENT_SET_AMENDMENTS ASSIGNMENT_SET_ID
TableHR_ASSIGNMENT_SET_CRITERIA HR_ASSIGNMENT_SET_CRITERIA_FK1 HR_ASSIGNMENT_SETS HR_ASSIGNMENT_SET_CRITERIA ASSIGNMENT_SET_ID
TablePAY_PAYROLL_ACTIONS PAY_PAYROLL_ACTIONS_FK7 HR_ASSIGNMENT_SETS PAY_PAYROLL_ACTIONS ASSIGNMENT_SET_ID
Columns
Name Datatype Length Mandatory Comments
ASSIGNMENT_SET_ID NUMBER (15) Yes System-generated primary key column.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
PAYROLL_ID NUMBER (9)
Foreign key to PAY_PAYROLLS.
ASSIGNMENT_SET_NAME VARCHAR2 (80) Yes Name of the assignment set.
FORMULA_ID NUMBER (15)
Foreign key to formula of type - Assignment Set.
LAST_UPDATE_DATE DATE

Standard Who column.
LAST_UPDATED_BY NUMBER (15)
Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
CREATED_BY NUMBER (15)
Standard Who column.
CREATION_DATE DATE

Standard Who column.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ASSIGNMENT_SET_ID
,      BUSINESS_GROUP_ID
,      PAYROLL_ID
,      ASSIGNMENT_SET_NAME
,      FORMULA_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.HR_ASSIGNMENT_SETS;

Dependencies

[top of page]

HR.HR_ASSIGNMENT_SETS does not reference any database object

HR.HR_ASSIGNMENT_SETS is referenced by following:

SchemaAPPS
SynonymHR_ASSIGNMENT_SETS
TriggerHR_ASSIGNMENT_SETS_WHO
SchemaPUBLIC
SynonymHR_ASSIGNMENT_SETS