VIEW: FV.FV_FACTS_TEMP#

Source

View Text - Preformatted

select TREASURY_SYMBOL_ID TREASURY_SYMBOL_ID, SGL_ACCT_NUMBER SGL_ACCT_NUMBER, COHORT COHORT, BEGIN_END BEGIN_END, INDEF_DEF_FLAG INDEF_DEF_FLAG, APPOR_CAT_B_DTL APPOR_CAT_B_DTL, APPOR_CAT_B_TXT APPOR_CAT_B_TXT, PUBLIC_LAW PUBLIC_LAW, APPOR_CAT_CODE APPOR_CAT_CODE, AUTHORITY_TYPE AUTHORITY_TYPE, TRANSACTION_PARTNER TRANSACTION_PARTNER, REIMBURSEABLE_FLAG REIMBURSEABLE_FLAG, BEA_CATEGORY BEA_CATEGORY, BORROWING_SOURCE BORROWING_SOURCE, DEF_LIQUID_FLAG DEF_LIQUID_FLAG, DEFICIENCY_FLAG DEFICIENCY_FLAG, AVAILABILITY_FLAG AVAILABILITY_FLAG, LEGISLATION_FLAG LEGISLATION_FLAG, AMOUNT AMOUNT, DEBIT_CREDIT DEBIT_CREDIT, FCT_INT_RECORD_CATEGORY FCT_INT_RECORD_CATEGORY, FCT_INT_RECORD_TYPE FCT_INT_RECORD_TYPE, FACTS_REPORT_INFO FACTS_REPORT_INFO, TBAL_FUND_VALUE TBAL_FUND_VALUE, TBAL_ACCT_NUM TBAL_ACCT_NUM, DOCUMENT_NUMBER DOCUMENT_NUMBER, DOCUMENT_DATE DOCUMENT_DATE, TBAL_INDICATOR TBAL_INDICATOR, ADVANCE_FLAG ADVANCE_FLAG, TRANSFER_DEPT_ID TRANSFER_DEPT_ID, TRANSFER_MAIN_ACCT TRANSFER_MAIN_ACCT, YEAR_BUDGET_AUTH YEAR_BUDGET_AUTH, BUDGET_FUNCTION BUDGET_FUNCTION, EDIT_CHECK_NUMBER EDIT_CHECK_NUMBER, AMOUNT1 AMOUNT1, AMOUNT2 AMOUNT2, PERIOD_ACTIVITY PERIOD_ACTIVITY, CODE_COMBINATION_ID CODE_COMBINATION_ID, PARENT_SGL_ACCT_NUMBER PARENT_SGL_ACCT_NUMBER, DOCUMENT_SOURCE DOCUMENT_SOURCE, DOCUMENT_CREATED_BY DOCUMENT_CREATED_BY, DOCUMENT_CREATION_DATE DOCUMENT_CREATION_DATE, PAGEBREAK PAGEBREAK, 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, PROGRAM_RPT_CAT_TXT PROGRAM_RPT_CAT_TXT, PROGRAM_RPT_CAT_NUM PROGRAM_RPT_CAT_NUM, PYA_FLAG PYA_FLAG, CLOSING_GRP CLOSING_GRP, SGL_BEG_BAL_ACCT_NUM SGL_BEG_BAL_ACCT_NUM, NON_FED_EXC_FLAG NON_FED_EXC_FLAG from "FV"."FV_FACTS_TEMP"

View Text - HTML Formatted

SELECT TREASURY_SYMBOL_ID TREASURY_SYMBOL_ID
, SGL_ACCT_NUMBER SGL_ACCT_NUMBER
, COHORT COHORT
, BEGIN_END BEGIN_END
, INDEF_DEF_FLAG INDEF_DEF_FLAG
, APPOR_CAT_B_DTL APPOR_CAT_B_DTL
, APPOR_CAT_B_TXT APPOR_CAT_B_TXT
, PUBLIC_LAW PUBLIC_LAW
, APPOR_CAT_CODE APPOR_CAT_CODE
, AUTHORITY_TYPE AUTHORITY_TYPE
, TRANSACTION_PARTNER TRANSACTION_PARTNER
, REIMBURSEABLE_FLAG REIMBURSEABLE_FLAG
, BEA_CATEGORY BEA_CATEGORY
, BORROWING_SOURCE BORROWING_SOURCE
, DEF_LIQUID_FLAG DEF_LIQUID_FLAG
, DEFICIENCY_FLAG DEFICIENCY_FLAG
, AVAILABILITY_FLAG AVAILABILITY_FLAG
, LEGISLATION_FLAG LEGISLATION_FLAG
, AMOUNT AMOUNT
, DEBIT_CREDIT DEBIT_CREDIT
, FCT_INT_RECORD_CATEGORY FCT_INT_RECORD_CATEGORY
, FCT_INT_RECORD_TYPE FCT_INT_RECORD_TYPE
, FACTS_REPORT_INFO FACTS_REPORT_INFO
, TBAL_FUND_VALUE TBAL_FUND_VALUE
, TBAL_ACCT_NUM TBAL_ACCT_NUM
, DOCUMENT_NUMBER DOCUMENT_NUMBER
, DOCUMENT_DATE DOCUMENT_DATE
, TBAL_INDICATOR TBAL_INDICATOR
, ADVANCE_FLAG ADVANCE_FLAG
, TRANSFER_DEPT_ID TRANSFER_DEPT_ID
, TRANSFER_MAIN_ACCT TRANSFER_MAIN_ACCT
, YEAR_BUDGET_AUTH YEAR_BUDGET_AUTH
, BUDGET_FUNCTION BUDGET_FUNCTION
, EDIT_CHECK_NUMBER EDIT_CHECK_NUMBER
, AMOUNT1 AMOUNT1
, AMOUNT2 AMOUNT2
, PERIOD_ACTIVITY PERIOD_ACTIVITY
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, PARENT_SGL_ACCT_NUMBER PARENT_SGL_ACCT_NUMBER
, DOCUMENT_SOURCE DOCUMENT_SOURCE
, DOCUMENT_CREATED_BY DOCUMENT_CREATED_BY
, DOCUMENT_CREATION_DATE DOCUMENT_CREATION_DATE
, PAGEBREAK PAGEBREAK
, 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
, PROGRAM_RPT_CAT_TXT PROGRAM_RPT_CAT_TXT
, PROGRAM_RPT_CAT_NUM PROGRAM_RPT_CAT_NUM
, PYA_FLAG PYA_FLAG
, CLOSING_GRP CLOSING_GRP
, SGL_BEG_BAL_ACCT_NUM SGL_BEG_BAL_ACCT_NUM
, NON_FED_EXC_FLAG NON_FED_EXC_FLAG
FROM "FV"."FV_FACTS_TEMP"