[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PSB_CONSTRAINT_FORMULAS |
|---|---|
| Object Type: | TABLE |
| Owner: | PSB |
| FND Design Data: |  PSB.PSB_CONSTRAINT_FORMULAS
|
| Subobject Name: | |
| Status: | VALID |
PSB_CONSTRAINT_FORMULAS stores information about the formulas used to
define constraints. The formula may be for an Account Constraint,
Position Constraint, or Element Constraint.
Account constraints are applied to account sets. Based on whether the
constraint is applied at the summary or detail level, the sum of
estimates of all accounts or each account must satisfy the condition
specified in the constraint formula. Balances to be evaluated in the
formula are identified using the year type and the balance type such
as Current Year Budget Balance.
Element constraints are applicable globally. They specify whether an
element option or value can be modified.
Position constraints are applied to position sets. Constraints specify
element assignments that must be satisfied.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PSB_CONSTRAINT_FORMULAS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 CONSTRAINT_FORMULA_ID
|
| PSB_CONSTRAINT_FORMULAS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CONSTRAINT_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CONSTRAINT_ID | NUMBER | (15) | Yes | Constraint unique identifier |
| CONSTRAINT_FORMULA_ID | NUMBER | (15) | Yes | Constraint formula unique identifier |
| STEP_NUMBER | NUMBER | User-assigned sequence for constraint formula line | ||
| BUDGET_YEAR_TYPE_ID | NUMBER | (15) | Budget year type unique identifier. This formula applies to budget periods in the calendar with this type. | |
| BALANCE_TYPE | VARCHAR2 | (1) | Balance type. Valid values are B (Budget), A (Actual), and E (Estimate). | |
| CURRENCY_CODE | VARCHAR2 | (20) | Functional currency code for the General Ledger Set of Books or STAT for statistical | |
| TEMPLATE_ID | NUMBER | (15) | Summary template identifier. Used if the constraint is defined at the summary level. | |
| CONCATENATED_SEGMENTS | VARCHAR2 | (2000) | Concatenated accounting segment values entered. Used only for display purposes in the form. | |
| SEGMENT1 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT2 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT3 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT4 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT5 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT6 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT7 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT8 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT9 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT10 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT11 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT12 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT13 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT14 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT15 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT16 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT17 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT18 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT19 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT20 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT21 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT22 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT23 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT24 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT25 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT26 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT27 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT28 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT29 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT30 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| AMOUNT | NUMBER | Formula line amount which is monetary or statistical based on the currency code | ||
| PREFIX_OPERATOR | VARCHAR2 | (2) | Formula line prefix operator. Valid prefix operators are +, - , *, /, = , <>, >, < , >=, and <=. | |
| POSTFIX_OPERATOR | VARCHAR2 | (1) | Formula line postfix operator. Valid postfix operators are +, - , *, /. | |
| ALLOW_MODIFY | VARCHAR2 | (1) | Indicates if this element can be modified at the worksheet or budget revision level | |
| PAY_ELEMENT_ID | NUMBER | (15) | Pay element unique identifier. Element for which this formula applies if this is an element constraint or a position constraint. | |
| PAY_ELEMENT_OPTION_ID | NUMBER | Pay element option unique identifier | ||
| ELEMENT_VALUE | NUMBER | Pay element value | ||
| ELEMENT_VALUE_TYPE | VARCHAR2 | (2) | Pay element value type | |
| EFFECTIVE_START_DATE | DATE | Effective start date for position and element formulas | ||
| EFFECTIVE_END_DATE | DATE | Effective end date for position and element formulas | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield context | |
| LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
| LAST_UPDATE_DATE | DATE | Standard Who column | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| CREATION_DATE | DATE | Yes | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT CONSTRAINT_ID
, CONSTRAINT_FORMULA_ID
, STEP_NUMBER
, BUDGET_YEAR_TYPE_ID
, BALANCE_TYPE
, CURRENCY_CODE
, TEMPLATE_ID
, CONCATENATED_SEGMENTS
, SEGMENT1
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, SEGMENT8
, SEGMENT9
, SEGMENT10
, SEGMENT11
, SEGMENT12
, SEGMENT13
, SEGMENT14
, SEGMENT15
, SEGMENT16
, SEGMENT17
, SEGMENT18
, SEGMENT19
, SEGMENT20
, SEGMENT21
, SEGMENT22
, SEGMENT23
, SEGMENT24
, SEGMENT25
, SEGMENT26
, SEGMENT27
, SEGMENT28
, SEGMENT29
, SEGMENT30
, AMOUNT
, PREFIX_OPERATOR
, POSTFIX_OPERATOR
, ALLOW_MODIFY
, PAY_ELEMENT_ID
, PAY_ELEMENT_OPTION_ID
, ELEMENT_VALUE
, ELEMENT_VALUE_TYPE
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, CONTEXT
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM PSB.PSB_CONSTRAINT_FORMULAS;
PSB.PSB_CONSTRAINT_FORMULAS does not reference any database object
PSB.PSB_CONSTRAINT_FORMULAS is referenced by following:
APPS
PSB_CONSTRAINT_FORMULAS
|
|
|
|