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

TABLE: PSB.PSB_ENTITY

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


PSB_ENTITY stores information about parameters, constraints,
period allocation rules, or budget revision rules. ENTITY_TYPE has values of PARAMETER,
CONSTRAINT, or ALLOCRULE based on the type of entity.
ENTITY_SUB_TYPE further classifies this as an account
parameter, constraint, or allocation rule, position
parameter, constraint, or allocation rule, or element
parameteror constraint. Each entity can be assigned to one or more
entity sets.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PSB_ENTITY_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnENTITY_ID
PSB_ENTITY_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnNAME
ColumnENTITY_TYPE
Columns
Name Datatype Length Mandatory Comments
ENTITY_ID NUMBER (15) Yes Entity unique identifier
ENTITY_TYPE VARCHAR2 (20) Yes Entity type. Valid values are PARAMETER, CONSTRAINT, or ALLOCRULE.
ENTITY_SUBTYPE VARCHAR2 (10) Yes Entity subtype. Entity type of PARAMETER and CONSTRAINT can have the values ACCOUNT, POSITION, or ELEMENT. Entity type of ALLOCRULE can have the values ACCOUNT or POSITION.
NAME VARCHAR2 (30) Yes Entity name
DESCRIPTION VARCHAR2 (80)
Entity description
DATA_EXTRACT_ID NUMBER

Data extract identifier
SET_OF_BOOKS_ID NUMBER (15)
General Ledger Set of Books identifier
BUDGET_GROUP_ID NUMBER (15)
Budget group unique identifier for local parameter
ALLOCATION_TYPE VARCHAR2 (10)
Allocation type is PROFILE or PERCENT.
BUDGET_YEAR_TYPE_ID NUMBER (15)
Budget year type unique identifier. The parameter, constraint, or allocation rule is defined for the budget period of this type in the calendar.
BALANCE_TYPE VARCHAR2 (1)
Balance type is B (Budget), A (Actual), or E (Estimate).
FTE_CONSTRAINT VARCHAR2 (1)
Indicates if this position constraint applies to full-time equivalency values
PARAMETER_AUTOINC_RULE VARCHAR2 (1)
Indicates if this is an auto increment salary parameter
PARAMETER_COMPOUND_ANNUALLY VARCHAR2 (1)
Indicates if formula percentages are compounded annually
CURRENCY_CODE VARCHAR2 (20)
Functional currency code for the General Ledger Set of Books or STAT for statistical
CONSTRAINT_DETAILED_FLAG VARCHAR2 (1)
Indicates if constraint is applicable to individual accounts in the assigned account sets
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
EFFECTIVE_START_DATE DATE

Effective start date for local parameter
EFFECTIVE_END_DATE DATE

Effective end date for local parameter
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
APPLY_ACCOUNT_SET_FLAG VARCHAR2 (1)
Not used currently
BALANCE_ACCOUNT_SET_FLAG VARCHAR2 (1)
Not used currently
Query Text

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


SELECT ENTITY_ID
,      ENTITY_TYPE
,      ENTITY_SUBTYPE
,      NAME
,      DESCRIPTION
,      DATA_EXTRACT_ID
,      SET_OF_BOOKS_ID
,      BUDGET_GROUP_ID
,      ALLOCATION_TYPE
,      BUDGET_YEAR_TYPE_ID
,      BALANCE_TYPE
,      FTE_CONSTRAINT
,      PARAMETER_AUTOINC_RULE
,      PARAMETER_COMPOUND_ANNUALLY
,      CURRENCY_CODE
,      CONSTRAINT_DETAILED_FLAG
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      CONTEXT
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      APPLY_ACCOUNT_SET_FLAG
,      BALANCE_ACCOUNT_SET_FLAG
FROM PSB.PSB_ENTITY;

Dependencies

[top of page]

PSB.PSB_ENTITY does not reference any database object

PSB.PSB_ENTITY is referenced by following:

SchemaAPPS
SynonymPSB_ENTITY