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

TABLE: FV.FV_FUND_PARAMETERS

Object Details
Object Name: FV_FUND_PARAMETERS
Object Type: TABLE
Owner: FV
FND Design Data: TableFV.FV_FUND_PARAMETERS
Subobject Name:
Status: VALID


FV_FUND_PARAMETERS table is used to further classify the balancing segment. Users are required to assign parameters for each balancing segment defined in Oracle U.S. Federal Financials.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FUND_PARAMETER_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnFUND_PARAMETER_ID
FV_FUND_PARAMETERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnFUND_VALUE
ColumnSET_OF_BOOKS_ID
FV_FUND_PARAMETERS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTREASURY_SYMBOL_ID
Columns
Name Datatype Length Mandatory Comments
FUND_PARAMETER_ID NUMBER (15) Yes Fund parameter identifier
FUND_VALUE VARCHAR2 (25) Yes Balancing segment value
TREASURY_SYMBOL VARCHAR2 (35)
Treasury symbol
SET_OF_BOOKS_ID NUMBER (15) Yes Set of Books identifier
FUND_GROUP_CODE VARCHAR2 (30)
Valid fund group
FUND_CATEGORY VARCHAR2 (1) Yes Fund category
FUND_TIME_FRAME VARCHAR2 (25)
Valid fund time frames
SF224_TYPE_CODE VARCHAR2 (25) Yes SF224 report fund type
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ESTABLISHED_FISCAL_YR NUMBER (15) Yes Fiscal year fund is established.
TREASURY_SYMBOL_ID NUMBER (15) Yes Treasury symbol identifier
FUND_EXPIRE_DATE DATE

Fund expiration date used for year-end processing
FUND_CANCEL_DATE DATE

Fund cancel date used for year- end processing
RESOURCE_TYPE VARCHAR2 (80)
Type used for year-end processing
FISCAL_YEAR NUMBER (15)
Closing fiscal year for Year-End Closing process
PRECLOSING_UNEXPENDED_AMT NUMBER

Preclosing unexpended amount designated by Treasury Department used for Year-End Closing process
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
DESCRIPTION VARCHAR2 (255)
Description
ORG_ID NUMBER (15)
Organization identifier
BUDGET_AUTHORITY VARCHAR2 (25)
Budget authority account
TRANSFERS_IN VARCHAR2 (25)
Transfers in account
TRANSFERS_OUT VARCHAR2 (25)
Transfers out account
UNLIQUID_COMMITMENTS VARCHAR2 (25)
Unliquidated commitments account
UNLIQUID_OBLIGATIONS VARCHAR2 (25)
Unliquidated obligations account
EXPENDED_AMOUNT VARCHAR2 (25)
Expended amount account
YEARS_AVAILABLE NUMBER (4)
Number of years appropriation is available.
DEPARTMENT_ID VARCHAR2 (2)
Department identifier of agency
BUREAU_ID VARCHAR2 (2)
Bureau identifier
BUSINESS_LINE VARCHAR2 (2)
Business line for this Treasury symbol
CLOSE_REQUISITIONS VARCHAR2 (1)
Yes or no value determines if requisition must be closed.
RED_STATUS VARCHAR2 (1)
Flag that indicates whether fund is in red status
PRIOR_YEAR_RECOVERIES VARCHAR2 (1)
Flag that indicates whether fund is available for prior year recoveries
BUDGET_SUBFUNCTION VARCHAR2 (3)
Budget Sub-function
BEA_CATEGORY VARCHAR2 (25)
Budget Enforcement Act category
MAPPED_TO_TREASURY_SYMBOL_ID NUMBER

Mapped Treasury Symbol Idenfier
MAPPED_TO_FUND_PARAMETER_ID NUMBER

Mapped Fund parameter Identifier
Query Text

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


SELECT FUND_PARAMETER_ID
,      FUND_VALUE
,      TREASURY_SYMBOL
,      SET_OF_BOOKS_ID
,      FUND_GROUP_CODE
,      FUND_CATEGORY
,      FUND_TIME_FRAME
,      SF224_TYPE_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      ESTABLISHED_FISCAL_YR
,      TREASURY_SYMBOL_ID
,      FUND_EXPIRE_DATE
,      FUND_CANCEL_DATE
,      RESOURCE_TYPE
,      FISCAL_YEAR
,      PRECLOSING_UNEXPENDED_AMT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      DESCRIPTION
,      ORG_ID
,      BUDGET_AUTHORITY
,      TRANSFERS_IN
,      TRANSFERS_OUT
,      UNLIQUID_COMMITMENTS
,      UNLIQUID_OBLIGATIONS
,      EXPENDED_AMOUNT
,      YEARS_AVAILABLE
,      DEPARTMENT_ID
,      BUREAU_ID
,      BUSINESS_LINE
,      CLOSE_REQUISITIONS
,      RED_STATUS
,      PRIOR_YEAR_RECOVERIES
,      BUDGET_SUBFUNCTION
,      BEA_CATEGORY
,      MAPPED_TO_TREASURY_SYMBOL_ID
,      MAPPED_TO_FUND_PARAMETER_ID
FROM FV.FV_FUND_PARAMETERS;

Dependencies

[top of page]

FV.FV_FUND_PARAMETERS does not reference any database object

FV.FV_FUND_PARAMETERS is referenced by following:

SchemaAPPS
SynonymFV_FUND_PARAMETERS