eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: FV.FV_FUND_PARAMETERS_HISTORY

Object Details

Object Name:	FV_FUND_PARAMETERS_HISTORY
Object Type:	TABLE
Owner:	FV
FND Design Data:	FV.FV_FUND_PARAMETERS_HISTORY
Subobject Name:
Status:	VALID

FV_FUND_PARAMETERS_HISTORY table is used to history details of purged fund parameter values.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FUND_PARAMETER_HIST_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FUND_PARAMETER_ID
FV_FUND_PARAMETERS_HIST_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FUND_VALUE SET_OF_BOOKS_ID
FV_FUND_PARAMETERS_HIST_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TREASURY_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

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
FROM FV.FV_FUND_PARAMETERS_HISTORY;

Dependencies

[top of page]

FV.FV_FUND_PARAMETERS_HISTORY does not reference any database object

FV.FV_FUND_PARAMETERS_HISTORY is referenced by following:

APPS: FV_FUND_PARAMETERS_HISTORY