VIEW: FV.FV_FUND_PARAMETERS_HISTORY#

Source

View Text - Preformatted

select FUND_PARAMETER_ID FUND_PARAMETER_ID, FUND_VALUE FUND_VALUE, TREASURY_SYMBOL TREASURY_SYMBOL, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, FUND_GROUP_CODE FUND_GROUP_CODE, FUND_CATEGORY FUND_CATEGORY, FUND_TIME_FRAME FUND_TIME_FRAME, SF224_TYPE_CODE SF224_TYPE_CODE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, ESTABLISHED_FISCAL_YR ESTABLISHED_FISCAL_YR, TREASURY_SYMBOL_ID TREASURY_SYMBOL_ID, FUND_EXPIRE_DATE FUND_EXPIRE_DATE, FUND_CANCEL_DATE FUND_CANCEL_DATE, RESOURCE_TYPE RESOURCE_TYPE, FISCAL_YEAR FISCAL_YEAR, PRECLOSING_UNEXPENDED_AMT PRECLOSING_UNEXPENDED_AMT, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, DESCRIPTION DESCRIPTION, ORG_ID ORG_ID, BUDGET_AUTHORITY BUDGET_AUTHORITY, TRANSFERS_IN TRANSFERS_IN, TRANSFERS_OUT TRANSFERS_OUT, UNLIQUID_COMMITMENTS UNLIQUID_COMMITMENTS, UNLIQUID_OBLIGATIONS UNLIQUID_OBLIGATIONS, EXPENDED_AMOUNT EXPENDED_AMOUNT, YEARS_AVAILABLE YEARS_AVAILABLE, DEPARTMENT_ID DEPARTMENT_ID, BUREAU_ID BUREAU_ID, BUSINESS_LINE BUSINESS_LINE, CLOSE_REQUISITIONS CLOSE_REQUISITIONS, RED_STATUS RED_STATUS, PRIOR_YEAR_RECOVERIES PRIOR_YEAR_RECOVERIES, BUDGET_SUBFUNCTION BUDGET_SUBFUNCTION, BORROWING_SOURCE_CODE BORROWING_SOURCE_CODE, DIRECT_OR_REIMB_CODE DIRECT_OR_REIMB_CODE, DEF_INDEF_FLAG DEF_INDEF_FLAG, CUST_NON_CUST CUST_NON_CUST, AUTO_CREATE AUTO_CREATE, AUTO_CREATE_FUND_VALUE AUTO_CREATE_FUND_VALUE from "FV"."FV_FUND_PARAMETERS_HISTORY"

View Text - HTML Formatted

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