VIEW: FV.FV_TREASURY_SYMBOLS#

Source

View Text - Preformatted

select TREASURY_SYMBOL_ID TREASURY_SYMBOL_ID, TREASURY_SYMBOL TREASURY_SYMBOL, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, SF224_TYPE_CODE SF224_TYPE_CODE, FUND_GROUP_CODE FUND_GROUP_CODE, TIME_FRAME TIME_FRAME, ESTABLISHED_FISCAL_YR ESTABLISHED_FISCAL_YR, DEPARTMENT_ID DEPARTMENT_ID, BUREAU_ID BUREAU_ID, 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, EXPIRATION_DATE EXPIRATION_DATE, CANCELLATION_DATE CANCELLATION_DATE, RESOURCE_TYPE RESOURCE_TYPE, PRECLOSING_UNEXPENDED_AMT PRECLOSING_UNEXPENDED_AMT, CLOSE_REQUISITIONS CLOSE_REQUISITIONS, YEARS_AVAILABLE YEARS_AVAILABLE, BUSINESS_LINE BUSINESS_LINE, 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, ORG_ID ORG_ID, FEDERAL_ACCT_SYMBOL_ID FEDERAL_ACCT_SYMBOL_ID, DEPT_TRANSFER DEPT_TRANSFER, TAFS_SUB_ACCT TAFS_SUB_ACCT, TAFS_SPLIT_CODE TAFS_SPLIT_CODE, TAFS_SPLIT_NAME TAFS_SPLIT_NAME, PUBLIC_LAW_CODE PUBLIC_LAW_CODE, TS_FLAG TS_FLAG, DEF_INDEF_FLAG DEF_INDEF_FLAG, SF224_QTR1_OUTLAY SF224_QTR1_OUTLAY, SF224_QTR2_OUTLAY SF224_QTR2_OUTLAY, SF224_QTR3_OUTLAY SF224_QTR3_OUTLAY, SF224_QTR4_OUTLAY SF224_QTR4_OUTLAY, CUST_NON_CUST CUST_NON_CUST, END_YEAR_AVAIL END_YEAR_AVAIL, FUND_TYPE FUND_TYPE, FINANCING_ACCOUNT FINANCING_ACCOUNT, FACTS_REPORTABLE_INDICATOR FACTS_REPORTABLE_INDICATOR, START_DATE START_DATE, RECEIPT_ACCOUNT_INDICATOR RECEIPT_ACCOUNT_INDICATOR, AUTO_CREATE AUTO_CREATE, AVAILABILITY_TYPE_CODE AVAILABILITY_TYPE_CODE, SUB_LEVEL_PREFIX_CODE SUB_LEVEL_PREFIX_CODE, NO_PYA_ACCT_FLAG NO_PYA_ACCT_FLAG, AUTO_CREATE_FLAG_BETC AUTO_CREATE_FLAG_BETC, GTAS_REPORTABLE_INDICATOR GTAS_REPORTABLE_INDICATOR from "FV"."FV_TREASURY_SYMBOLS"

View Text - HTML Formatted

SELECT TREASURY_SYMBOL_ID TREASURY_SYMBOL_ID
, TREASURY_SYMBOL TREASURY_SYMBOL
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, SF224_TYPE_CODE SF224_TYPE_CODE
, FUND_GROUP_CODE FUND_GROUP_CODE
, TIME_FRAME TIME_FRAME
, ESTABLISHED_FISCAL_YR ESTABLISHED_FISCAL_YR
, DEPARTMENT_ID DEPARTMENT_ID
, BUREAU_ID BUREAU_ID
, 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
, EXPIRATION_DATE EXPIRATION_DATE
, CANCELLATION_DATE CANCELLATION_DATE
, RESOURCE_TYPE RESOURCE_TYPE
, PRECLOSING_UNEXPENDED_AMT PRECLOSING_UNEXPENDED_AMT
, CLOSE_REQUISITIONS CLOSE_REQUISITIONS
, YEARS_AVAILABLE YEARS_AVAILABLE
, BUSINESS_LINE BUSINESS_LINE
, 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
, ORG_ID ORG_ID
, FEDERAL_ACCT_SYMBOL_ID FEDERAL_ACCT_SYMBOL_ID
, DEPT_TRANSFER DEPT_TRANSFER
, TAFS_SUB_ACCT TAFS_SUB_ACCT
, TAFS_SPLIT_CODE TAFS_SPLIT_CODE
, TAFS_SPLIT_NAME TAFS_SPLIT_NAME
, PUBLIC_LAW_CODE PUBLIC_LAW_CODE
, TS_FLAG TS_FLAG
, DEF_INDEF_FLAG DEF_INDEF_FLAG
, SF224_QTR1_OUTLAY SF224_QTR1_OUTLAY
, SF224_QTR2_OUTLAY SF224_QTR2_OUTLAY
, SF224_QTR3_OUTLAY SF224_QTR3_OUTLAY
, SF224_QTR4_OUTLAY SF224_QTR4_OUTLAY
, CUST_NON_CUST CUST_NON_CUST
, END_YEAR_AVAIL END_YEAR_AVAIL
, FUND_TYPE FUND_TYPE
, FINANCING_ACCOUNT FINANCING_ACCOUNT
, FACTS_REPORTABLE_INDICATOR FACTS_REPORTABLE_INDICATOR
, START_DATE START_DATE
, RECEIPT_ACCOUNT_INDICATOR RECEIPT_ACCOUNT_INDICATOR
, AUTO_CREATE AUTO_CREATE
, AVAILABILITY_TYPE_CODE AVAILABILITY_TYPE_CODE
, SUB_LEVEL_PREFIX_CODE SUB_LEVEL_PREFIX_CODE
, NO_PYA_ACCT_FLAG NO_PYA_ACCT_FLAG
, AUTO_CREATE_FLAG_BETC AUTO_CREATE_FLAG_BETC
, GTAS_REPORTABLE_INDICATOR GTAS_REPORTABLE_INDICATOR
FROM "FV"."FV_TREASURY_SYMBOLS"