VIEW: FV.FV_GTAS1_REPORT_T2#

Source

View Text - Preformatted

select SEGMENT30 SEGMENT30, SEGMENT29 SEGMENT29, SEGMENT28 SEGMENT28, SEGMENT27 SEGMENT27, SEGMENT26 SEGMENT26, SEGMENT25 SEGMENT25, SEGMENT24 SEGMENT24, SEGMENT23 SEGMENT23, SEGMENT22 SEGMENT22, SEGMENT21 SEGMENT21, SEGMENT20 SEGMENT20, SEGMENT19 SEGMENT19, SEGMENT18 SEGMENT18, SEGMENT17 SEGMENT17, SEGMENT16 SEGMENT16, SEGMENT15 SEGMENT15, SEGMENT14 SEGMENT14, SEGMENT13 SEGMENT13, SEGMENT12 SEGMENT12, SEGMENT11 SEGMENT11, SEGMENT10 SEGMENT10, SEGMENT9 SEGMENT9, SEGMENT8 SEGMENT8, SEGMENT7 SEGMENT7, SEGMENT6 SEGMENT6, SEGMENT5 SEGMENT5, SEGMENT4 SEGMENT4, SEGMENT3 SEGMENT3, SEGMENT2 SEGMENT2, SEGMENT1 SEGMENT1, ACCOUNT_NUMBER ACCOUNT_NUMBER, AUTHORITY_TYPE_CODE AUTHORITY_TYPE_CODE, BEA_CAT_CODE BEA_CAT_CODE, BEGINNING_BALANCE BEGINNING_BALANCE, BORR_SRC_CODE BORR_SRC_CODE, BUDGET_IMPACT_IND BUDGET_IMPACT_IND, CCID CCID, CREDIT_COHORT_YR CREDIT_COHORT_YR, CR_AMOUNT CR_AMOUNT, CUR_SUBSEQUENT_CODE CUR_SUBSEQUENT_CODE, CUST_NON_CUST CUST_NON_CUST, DIRECT_OR_REIMB_CODE DIRECT_OR_REIMB_CODE, DR_AMOUNT DR_AMOUNT, D_C_INDICATOR D_C_INDICATOR, EXCH_NON_EXCH EXCH_NON_EXCH, FED_NON_FED FED_NON_FED, FISCAL_YEAR FISCAL_YEAR, FUND_VALUE FUND_VALUE, NEW_BAL_CODE NEW_BAL_CODE, PROGRAM_COST_IND PROGRAM_COST_IND, PROGRAM_REPT_CODE PROGRAM_REPT_CODE, PYA_CODE PYA_CODE, RECORD_CATEGORY RECORD_CATEGORY, REPORTED_STATUS REPORTED_STATUS, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, TRADING_PARTNER_AGENCY_ID TRADING_PARTNER_AGENCY_ID, TRADING_PARTNER_MAIN_ACCOUNT TRADING_PARTNER_MAIN_ACCOUNT, TREASURY_SYMBOL_ID TREASURY_SYMBOL_ID, USSGL_ACCOUNT USSGL_ACCOUNT, ACCOUNT_TYPE ACCOUNT_TYPE, AMOUNT AMOUNT, APPOR_CAT_B_CODE APPOR_CAT_B_CODE, APPOR_CAT_CODE APPOR_CAT_CODE from "FV"."FV_GTAS1_REPORT_T2"

View Text - HTML Formatted

SELECT SEGMENT30 SEGMENT30
, SEGMENT29 SEGMENT29
, SEGMENT28 SEGMENT28
, SEGMENT27 SEGMENT27
, SEGMENT26 SEGMENT26
, SEGMENT25 SEGMENT25
, SEGMENT24 SEGMENT24
, SEGMENT23 SEGMENT23
, SEGMENT22 SEGMENT22
, SEGMENT21 SEGMENT21
, SEGMENT20 SEGMENT20
, SEGMENT19 SEGMENT19
, SEGMENT18 SEGMENT18
, SEGMENT17 SEGMENT17
, SEGMENT16 SEGMENT16
, SEGMENT15 SEGMENT15
, SEGMENT14 SEGMENT14
, SEGMENT13 SEGMENT13
, SEGMENT12 SEGMENT12
, SEGMENT11 SEGMENT11
, SEGMENT10 SEGMENT10
, SEGMENT9 SEGMENT9
, SEGMENT8 SEGMENT8
, SEGMENT7 SEGMENT7
, SEGMENT6 SEGMENT6
, SEGMENT5 SEGMENT5
, SEGMENT4 SEGMENT4
, SEGMENT3 SEGMENT3
, SEGMENT2 SEGMENT2
, SEGMENT1 SEGMENT1
, ACCOUNT_NUMBER ACCOUNT_NUMBER
, AUTHORITY_TYPE_CODE AUTHORITY_TYPE_CODE
, BEA_CAT_CODE BEA_CAT_CODE
, BEGINNING_BALANCE BEGINNING_BALANCE
, BORR_SRC_CODE BORR_SRC_CODE
, BUDGET_IMPACT_IND BUDGET_IMPACT_IND
, CCID CCID
, CREDIT_COHORT_YR CREDIT_COHORT_YR
, CR_AMOUNT CR_AMOUNT
, CUR_SUBSEQUENT_CODE CUR_SUBSEQUENT_CODE
, CUST_NON_CUST CUST_NON_CUST
, DIRECT_OR_REIMB_CODE DIRECT_OR_REIMB_CODE
, DR_AMOUNT DR_AMOUNT
, D_C_INDICATOR D_C_INDICATOR
, EXCH_NON_EXCH EXCH_NON_EXCH
, FED_NON_FED FED_NON_FED
, FISCAL_YEAR FISCAL_YEAR
, FUND_VALUE FUND_VALUE
, NEW_BAL_CODE NEW_BAL_CODE
, PROGRAM_COST_IND PROGRAM_COST_IND
, PROGRAM_REPT_CODE PROGRAM_REPT_CODE
, PYA_CODE PYA_CODE
, RECORD_CATEGORY RECORD_CATEGORY
, REPORTED_STATUS REPORTED_STATUS
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, TRADING_PARTNER_AGENCY_ID TRADING_PARTNER_AGENCY_ID
, TRADING_PARTNER_MAIN_ACCOUNT TRADING_PARTNER_MAIN_ACCOUNT
, TREASURY_SYMBOL_ID TREASURY_SYMBOL_ID
, USSGL_ACCOUNT USSGL_ACCOUNT
, ACCOUNT_TYPE ACCOUNT_TYPE
, AMOUNT AMOUNT
, APPOR_CAT_B_CODE APPOR_CAT_B_CODE
, APPOR_CAT_CODE APPOR_CAT_CODE
FROM "FV"."FV_GTAS1_REPORT_T2"