[Home] [Help] [Dependency Information]
Object Name: | HR_ASSIGNMENT_SETS |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PER.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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HR_ASSIGNMENT_SETS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | ASSIGNMENT_SET_ID |
HR_ASSIGNMENT_SETS_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
HR_ASSIGNMENT_SETS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PAYROLL_ID |
Table | |
Foreign Table | Foreign Key Column | HR_ASSIGNMENT_SETS | HR_ALL_ORGANIZATION_UNITS | HR_ASSIGNMENT_SETS BUSINESS_GROUP_ID | HR_ASSIGNMENT_SET_AMENDMENTS | HR_ASSIGNMENT_SETS | HR_ASSIGNMENT_SET_AMENDMENTS ASSIGNMENT_SET_ID | HR_ASSIGNMENT_SET_CRITERIA | HR_ASSIGNMENT_SETS | HR_ASSIGNMENT_SET_CRITERIA ASSIGNMENT_SET_ID | PAY_PAYROLL_ACTIONS | HR_ASSIGNMENT_SETS | PAY_PAYROLL_ACTIONS ASSIGNMENT_SET_ID |
---|
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. |
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;
HR.HR_ASSIGNMENT_SETS does not reference any database object
HR.HR_ASSIGNMENT_SETS is referenced by following:
|
|
|