[Home] [Help] [Dependency Information]
Object Name: | PAY_STATUS_PROCESSING_RULES_F |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PAY.PAY_STATUS_PROCESSING_RULES_F |
Subobject Name: | |
Status: | VALID |
PAY_STATUS_PROCESSING_RULES_F is the DateTracked table that holds the
processing rules for each element. Formulas are attached to an
element for processing according to specific assignment statuses. For
each assignment status, it is possible to specify a different formula
to be fired for the same element. For example, salary may be
calculated differently when the employee is on leave of absence.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PAY_STATUS_PROCESSING_RULE_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
STATUS_PROCESSING_RULE_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
PAY_STATUS_PROCESSING_RULE_UK2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ELEMENT_TYPE_ID
ASSIGNMENT_STATUS_TYPE_ID BUSINESS_GROUP_ID LEGISLATION_CODE EFFECTIVE_START_DATE EFFECTIVE_END_DATE PROCESSING_RULE |
PAY_STATUS_PROCESSING_RULE_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ASSIGNMENT_STATUS_TYPE_ID |
Table | |
Foreign Table | Foreign Key Column | PAY_STATUS_PROCESSING_RULES_F | PER_ASSIGNMENT_STATUS_TYPES | PAY_STATUS_PROCESSING_RULES_F ASSIGNMENT_STATUS_TYPE_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STATUS_PROCESSING_RULE_ID | NUMBER | (9) | Yes | System-generated primary key column. |
EFFECTIVE_START_DATE | DATE | Yes | Effective start date. | |
EFFECTIVE_END_DATE | DATE | Yes | Effective end date. | |
BUSINESS_GROUP_ID | NUMBER | (15) | Foreign key to HR_ORGANIZATION_UNITS. | |
LEGISLATION_CODE | VARCHAR2 | (30) | Foreign key to FND_TERRITORIES. | |
ELEMENT_TYPE_ID | NUMBER | (9) | Yes | Foreign key to PAY_ELEMENT_TYPES. |
ASSIGNMENT_STATUS_TYPE_ID | NUMBER | (9) | Foreign key to PER_ASSIGNMENT_STATUS_TYPES. If the type is STANDARD then the rule applies to all assignment statuses. | |
FORMULA_ID | NUMBER | (9) | Foreign key to FF_FORMULAS. | |
PROCESSING_RULE | VARCHAR2 | (1) | Yes | Indicates whether or not to process. |
COMMENT_ID | NUMBER | (15) | Foreign key to HR_COMMENTS. | |
LEGISLATION_SUBGROUP | VARCHAR2 | (30) | Identifies the origin of the startup data for the processing rule. | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | System-generated version of row. Increments by one with each update. |
Cut, paste (and edit) the following text to query this object:
SELECT STATUS_PROCESSING_RULE_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, LEGISLATION_CODE
, ELEMENT_TYPE_ID
, ASSIGNMENT_STATUS_TYPE_ID
, FORMULA_ID
, PROCESSING_RULE
, COMMENT_ID
, LEGISLATION_SUBGROUP
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM HR.PAY_STATUS_PROCESSING_RULES_F;
HR.PAY_STATUS_PROCESSING_RULES_F does not reference any database object
HR.PAY_STATUS_PROCESSING_RULES_F is referenced by following:
|
|
|