[Home] [Help] [Dependency Information]
Object Name: | PAY_FORMULA_RESULT_RULES_F |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PAY.PAY_FORMULA_RESULT_RULES_F |
Subobject Name: | |
Status: | VALID |
PAY_FORMULA_RESULT_RULES_F is the DateTracked table that holds the
rules that control what happens to the results produced by a specific
formula calculation. When a formula has been attached to an element
via a status processing rule, it may produce results. The formula
result rules for an element determine the destination of those
results. The direct result from any formula is held in the Pay Value
of the element, indirect results will create a nonrecurring entry,
update recurring results can be update input values of the same
element or of others. If the formula does not return a value, or
returns a null value as a result the formula result rule will not
insert or update entries. There is no error.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PAY_FORMULA_RESULT_RULES_F_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
FORMULA_RESULT_RULE_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
PAY_FORMULA_RESULT_RULES_F_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | STATUS_PROCESSING_RULE_ID |
PAY_FORMULA_RESULT_RULES_F_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ELEMENT_TYPE_ID |
PAY_FORMULA_RESULT_RULES_F_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | INPUT_VALUE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORMULA_RESULT_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) | Foreign key to PAY_ELEMENT_TYPES. | |
STATUS_PROCESSING_RULE_ID | NUMBER | (9) | Yes | Foreign key to PAY_STATUS_PROCESSING_RULES. |
RESULT_NAME | VARCHAR2 | (80) | Yes | Name of the variable returned by the formula. |
RESULT_RULE_TYPE | VARCHAR2 | (30) | Yes | Formula result type for the formula result rule, for example, direct, indirect, message. (Validated by a lookup). |
LEGISLATION_SUBGROUP | VARCHAR2 | (30) | Identifies the startup data legislation for the formula result rule. | |
SEVERITY_LEVEL | VARCHAR2 | (1) | Severity level for a message type result. Used to control the effect produced by the message.(Validated by a lookup). | |
INPUT_VALUE_ID | NUMBER | (9) | Foreign key to PAY_INPUT_VALUES_F. | |
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 FORMULA_RESULT_RULE_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, LEGISLATION_CODE
, ELEMENT_TYPE_ID
, STATUS_PROCESSING_RULE_ID
, RESULT_NAME
, RESULT_RULE_TYPE
, LEGISLATION_SUBGROUP
, SEVERITY_LEVEL
, INPUT_VALUE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM HR.PAY_FORMULA_RESULT_RULES_F;
HR.PAY_FORMULA_RESULT_RULES_F does not reference any database object
HR.PAY_FORMULA_RESULT_RULES_F is referenced by following:
|
|
|