VIEW: FV.FV_GTAS_TEMP#

Source

View Text - Preformatted

select TREASURY_SYMBOL_NAME TREASURY_SYMBOL_NAME, TREASURY_SYMBOL_ID TREASURY_SYMBOL_ID, SGL_ACCT_NUMBER SGL_ACCT_NUMBER, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, SUB_LEVEL_PREFIX_CODE SUB_LEVEL_PREFIX_CODE, ALLOCATION_AGENCY_TRX_ID ALLOCATION_AGENCY_TRX_ID, AGENCY_ID AGENCY_ID, BEG_PERIOD_AVAIL BEG_PERIOD_AVAIL, END_PERIOD_AVAIL END_PERIOD_AVAIL, AVAILABILITY_TYPE_CODE AVAILABILITY_TYPE_CODE, MAIN_ACCOUNT_CODE MAIN_ACCOUNT_CODE, SUB_ACCOUNT_CODE SUB_ACCOUNT_CODE, FUND_VALUE FUND_VALUE, ACCOUNT_NUMBER ACCOUNT_NUMBER, DIR_REIMB_CODE DIR_REIMB_CODE, APPORTIONMENT_CATEGORY_CODE APPORTIONMENT_CATEGORY_CODE, APPORTIONMENT_CATEGORY__B__COD APPORTIONMENT_CATEGORY__B__COD, PROGRAM_REPT_CODE PROGRAM_REPT_CODE, FED_NON_FED FED_NON_FED, TRADING_PARTNER_AGENCY_ID TRADING_PARTNER_AGENCY_ID, TRADING_PARTNER_MAIN_ACCOUNT TRADING_PARTNER_MAIN_ACCOUNT, NEW_BAL_CODE NEW_BAL_CODE, CUR_SUB_CODE CUR_SUB_CODE, BEA_CATEGORY BEA_CATEGORY, BORROWING_SOURCE BORROWING_SOURCE, EXCH_NON_EXCH EXCH_NON_EXCH, CUST_NON_CUST CUST_NON_CUST, AUTHORITY_TYPE_CODE AUTHORITY_TYPE_CODE, BUDGET_IMPACT_IND BUDGET_IMPACT_IND, PYA_CODE PYA_CODE, CREDIT_COHORT_YEAR CREDIT_COHORT_YEAR, PROGRAM_COST_IND PROGRAM_COST_IND, DOLLAR_AMOUNT DOLLAR_AMOUNT, RECORD_CATEGORY RECORD_CATEGORY, CREATION_DATE CREATION_DATE, D_C_INDICATOR D_C_INDICATOR, GTAS_REPORT_INFO GTAS_REPORT_INFO, GTAS_INT_RECORD_CATEGORY GTAS_INT_RECORD_CATEGORY, GTAS_INT_RECORD_TYPE GTAS_INT_RECORD_TYPE, DESCRIPTION DESCRIPTION, BEG_BALANCE BEG_BALANCE, END_BALANCE END_BALANCE, CUR_PERIOD_DEBIT CUR_PERIOD_DEBIT, CUR_PERIOD_CREDIT CUR_PERIOD_CREDIT, SEGMENT1 SEGMENT1, SEGMENT2 SEGMENT2, SEGMENT3 SEGMENT3, SEGMENT4 SEGMENT4, SEGMENT5 SEGMENT5, SEGMENT6 SEGMENT6, SEGMENT7 SEGMENT7, SEGMENT8 SEGMENT8, SEGMENT9 SEGMENT9, SEGMENT10 SEGMENT10, SEGMENT11 SEGMENT11, SEGMENT12 SEGMENT12, SEGMENT13 SEGMENT13, SEGMENT14 SEGMENT14, SEGMENT15 SEGMENT15, SEGMENT16 SEGMENT16, SEGMENT17 SEGMENT17, SEGMENT18 SEGMENT18, SEGMENT19 SEGMENT19, SEGMENT20 SEGMENT20, SEGMENT21 SEGMENT21, SEGMENT22 SEGMENT22, SEGMENT23 SEGMENT23, SEGMENT24 SEGMENT24, SEGMENT25 SEGMENT25, SEGMENT26 SEGMENT26, SEGMENT27 SEGMENT27, SEGMENT28 SEGMENT28, SEGMENT29 SEGMENT29, SEGMENT30 SEGMENT30, AMOUNT AMOUNT from "FV"."FV_GTAS_TEMP"

View Text - HTML Formatted

SELECT TREASURY_SYMBOL_NAME TREASURY_SYMBOL_NAME
, TREASURY_SYMBOL_ID TREASURY_SYMBOL_ID
, SGL_ACCT_NUMBER SGL_ACCT_NUMBER
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, SUB_LEVEL_PREFIX_CODE SUB_LEVEL_PREFIX_CODE
, ALLOCATION_AGENCY_TRX_ID ALLOCATION_AGENCY_TRX_ID
, AGENCY_ID AGENCY_ID
, BEG_PERIOD_AVAIL BEG_PERIOD_AVAIL
, END_PERIOD_AVAIL END_PERIOD_AVAIL
, AVAILABILITY_TYPE_CODE AVAILABILITY_TYPE_CODE
, MAIN_ACCOUNT_CODE MAIN_ACCOUNT_CODE
, SUB_ACCOUNT_CODE SUB_ACCOUNT_CODE
, FUND_VALUE FUND_VALUE
, ACCOUNT_NUMBER ACCOUNT_NUMBER
, DIR_REIMB_CODE DIR_REIMB_CODE
, APPORTIONMENT_CATEGORY_CODE APPORTIONMENT_CATEGORY_CODE
, APPORTIONMENT_CATEGORY__B__COD APPORTIONMENT_CATEGORY__B__COD
, PROGRAM_REPT_CODE PROGRAM_REPT_CODE
, FED_NON_FED FED_NON_FED
, TRADING_PARTNER_AGENCY_ID TRADING_PARTNER_AGENCY_ID
, TRADING_PARTNER_MAIN_ACCOUNT TRADING_PARTNER_MAIN_ACCOUNT
, NEW_BAL_CODE NEW_BAL_CODE
, CUR_SUB_CODE CUR_SUB_CODE
, BEA_CATEGORY BEA_CATEGORY
, BORROWING_SOURCE BORROWING_SOURCE
, EXCH_NON_EXCH EXCH_NON_EXCH
, CUST_NON_CUST CUST_NON_CUST
, AUTHORITY_TYPE_CODE AUTHORITY_TYPE_CODE
, BUDGET_IMPACT_IND BUDGET_IMPACT_IND
, PYA_CODE PYA_CODE
, CREDIT_COHORT_YEAR CREDIT_COHORT_YEAR
, PROGRAM_COST_IND PROGRAM_COST_IND
, DOLLAR_AMOUNT DOLLAR_AMOUNT
, RECORD_CATEGORY RECORD_CATEGORY
, CREATION_DATE CREATION_DATE
, D_C_INDICATOR D_C_INDICATOR
, GTAS_REPORT_INFO GTAS_REPORT_INFO
, GTAS_INT_RECORD_CATEGORY GTAS_INT_RECORD_CATEGORY
, GTAS_INT_RECORD_TYPE GTAS_INT_RECORD_TYPE
, DESCRIPTION DESCRIPTION
, BEG_BALANCE BEG_BALANCE
, END_BALANCE END_BALANCE
, CUR_PERIOD_DEBIT CUR_PERIOD_DEBIT
, CUR_PERIOD_CREDIT CUR_PERIOD_CREDIT
, SEGMENT1 SEGMENT1
, SEGMENT2 SEGMENT2
, SEGMENT3 SEGMENT3
, SEGMENT4 SEGMENT4
, SEGMENT5 SEGMENT5
, SEGMENT6 SEGMENT6
, SEGMENT7 SEGMENT7
, SEGMENT8 SEGMENT8
, SEGMENT9 SEGMENT9
, SEGMENT10 SEGMENT10
, SEGMENT11 SEGMENT11
, SEGMENT12 SEGMENT12
, SEGMENT13 SEGMENT13
, SEGMENT14 SEGMENT14
, SEGMENT15 SEGMENT15
, SEGMENT16 SEGMENT16
, SEGMENT17 SEGMENT17
, SEGMENT18 SEGMENT18
, SEGMENT19 SEGMENT19
, SEGMENT20 SEGMENT20
, SEGMENT21 SEGMENT21
, SEGMENT22 SEGMENT22
, SEGMENT23 SEGMENT23
, SEGMENT24 SEGMENT24
, SEGMENT25 SEGMENT25
, SEGMENT26 SEGMENT26
, SEGMENT27 SEGMENT27
, SEGMENT28 SEGMENT28
, SEGMENT29 SEGMENT29
, SEGMENT30 SEGMENT30
, AMOUNT AMOUNT
FROM "FV"."FV_GTAS_TEMP"