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

TABLE: PSB.PSB_PARAMETER_FORMULAS

Object Details
Object Name: PSB_PARAMETER_FORMULAS
Object Type: TABLE
Owner: PSB
FND Design Data: TablePSB.PSB_PARAMETER_FORMULAS
Subobject Name:
Status: VALID


PSB_PARAMETER_FORMULAS stores information about the parameters used to
create worksheets. Each parameter is defined as a multi-step formula.
Each step of a formula is defined as a row in this table.
Parameters can be of the type ACCOUNT, POSITION, or ELEMENT.
ACCOUNT type formulas are defined in the following form:
Estimate = Balance for the current account or different account
Operator
Amount
If the ACCOUNT type is a multi-step formula, then it is defined in the
following form:
Estimate = Step1 Formula
Prefix Operator Step2 Formula
Prefix Operator Step3 Formula
POSITION type formulas are defined in the following form:
For positions hired in a certain date range or adjustment in a
certain date, change the element assignment.
ELEMENT type formulas are defined in the following form:
For an element, change the rate to a new value for a given date
range.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PSB_PARAMETER_FORMULAS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARAMETER_FORMULA_ID
PSB_PARAMETER_FORMULAS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARAMETER_ID
Columns
Name Datatype Length Mandatory Comments
PARAMETER_ID NUMBER (20) Yes Parameter unique identifier
PARAMETER_FORMULA_ID NUMBER (20) Yes Parameter formula unique identifier
STEP_NUMBER NUMBER

User-assigned sequence for parameter formula line
BUDGET_YEAR_TYPE_ID NUMBER (15)
Budget year type unique identifier. This formula applies to budget period in the calendar with this type.
BALANCE_TYPE VARCHAR2 (1)
Balance type is B (Budget), A (Actual), or E (Estimate)
TEMPLATE_ID NUMBER (15)
Summary template identifier
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
CURRENCY_CODE VARCHAR2 (15)
Formula line currency. Functional currency code for the General Ledger Set of Books or STAT for statistical.
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 +, - , *, /, = .
POSTFIX_OPERATOR VARCHAR2 (1)
Formula line postfix operator. Valid postfix operators are +, - , *, or /.
HIREDATE_BETWEEN_FROM NUMBER

Range in days applied to position hire date
HIREDATE_BETWEEN_TO NUMBER

Range in days applied to position hire date
ADJDATE_BETWEEN_FROM NUMBER

Range in days applied to position adjustment date
ADJDATE_BETWEEN_TO NUMBER

Range in days applied to position adjustment date
INCREMENT_BY NUMBER

Auto increment value
INCREMENT_TYPE VARCHAR2 (1)
Type of auto increment value
ASSIGNMENT_TYPE VARCHAR2 (10)
Assignment type is POSITION or ELEMENT.
ATTRIBUTE_ID NUMBER

Attribute unique identifier
ATTRIBUTE_VALUE VARCHAR2 (240)
Attribute value
PAY_ELEMENT_ID NUMBER (20)
Pay element unique identifier
PAY_ELEMENT_OPTION_ID NUMBER

Pay element option unique identifier
GRADE_STEP NUMBER

Grade step for salary elements
ELEMENT_VALUE NUMBER

Element value
ELEMENT_VALUE_TYPE VARCHAR2 (2)
Type of element value
EFFECTIVE_START_DATE DATE

Effective start date for the new option
EFFECTIVE_END_DATE DATE

Effective end date for the new option
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_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes 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
Query Text

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


SELECT PARAMETER_ID
,      PARAMETER_FORMULA_ID
,      STEP_NUMBER
,      BUDGET_YEAR_TYPE_ID
,      BALANCE_TYPE
,      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
,      CURRENCY_CODE
,      AMOUNT
,      PREFIX_OPERATOR
,      POSTFIX_OPERATOR
,      HIREDATE_BETWEEN_FROM
,      HIREDATE_BETWEEN_TO
,      ADJDATE_BETWEEN_FROM
,      ADJDATE_BETWEEN_TO
,      INCREMENT_BY
,      INCREMENT_TYPE
,      ASSIGNMENT_TYPE
,      ATTRIBUTE_ID
,      ATTRIBUTE_VALUE
,      PAY_ELEMENT_ID
,      PAY_ELEMENT_OPTION_ID
,      GRADE_STEP
,      ELEMENT_VALUE
,      ELEMENT_VALUE_TYPE
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      CONTEXT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM PSB.PSB_PARAMETER_FORMULAS;

Dependencies

[top of page]

PSB.PSB_PARAMETER_FORMULAS does not reference any database object

PSB.PSB_PARAMETER_FORMULAS is referenced by following:

SchemaAPPS
SynonymPSB_PARAMETER_FORMULAS