eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: FV.FV_GTAS1_PERIOD_ATTRIBUTES#

Source

View Text - Preformatted


select ACCOUNT_NUMBER ACCOUNT_NUMBER, ACCOUNT_TYPE ACCOUNT_TYPE, APPOR_CAT_B_CODE APPOR_CAT_B_CODE, APPOR_CAT_CODE APPOR_CAT_CODE, BALANCE_AMOUNT BALANCE_AMOUNT, BEA_CAT_CODE BEA_CAT_CODE, BEGIN_BALANCE BEGIN_BALANCE, BORR_SRC_CODE BORR_SRC_CODE, CCID CCID, CREDIT_COHORT_YR CREDIT_COHORT_YR, CUR_SUBSEQUENT_CODE CUR_SUBSEQUENT_CODE, CUST_NON_CUST CUST_NON_CUST, DIRECT_OR_REIMB_CODE DIRECT_OR_REIMB_CODE, END_BAL_IND END_BAL_IND, EXCH_NON_EXCH EXCH_NON_EXCH, FUND_VALUE FUND_VALUE, NEW_BAL_CODE NEW_BAL_CODE, NEW_REC_FLAG NEW_REC_FLAG, PERIOD_BEGIN_BAL PERIOD_BEGIN_BAL, PERIOD_CY_CR_BAL PERIOD_CY_CR_BAL, PERIOD_CY_DR_BAL PERIOD_CY_DR_BAL, PERIOD_NAME PERIOD_NAME, PERIOD_YEAR PERIOD_YEAR, PROGRAM_COST_IND PROGRAM_COST_IND, PROGRAM_REPT_CODE PROGRAM_REPT_CODE, PYA_CODE PYA_CODE, REPORTED_GROUP REPORTED_GROUP, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, TREASURY_SYMBOL_ID TREASURY_SYMBOL_ID, USSGL_ACCOUNT USSGL_ACCOUNT, PERIOD_NUM PERIOD_NUM from "FV"."FV_GTAS1_PERIOD_ATTRIBUTES"

View Text - HTML Formatted

SELECT ACCOUNT_NUMBER ACCOUNT_NUMBER
, ACCOUNT_TYPE ACCOUNT_TYPE
, APPOR_CAT_B_CODE APPOR_CAT_B_CODE
, APPOR_CAT_CODE APPOR_CAT_CODE
, BALANCE_AMOUNT BALANCE_AMOUNT
, BEA_CAT_CODE BEA_CAT_CODE
, BEGIN_BALANCE BEGIN_BALANCE
, BORR_SRC_CODE BORR_SRC_CODE
, CCID CCID
, CREDIT_COHORT_YR CREDIT_COHORT_YR
, CUR_SUBSEQUENT_CODE CUR_SUBSEQUENT_CODE
, CUST_NON_CUST CUST_NON_CUST
, DIRECT_OR_REIMB_CODE DIRECT_OR_REIMB_CODE
, END_BAL_IND END_BAL_IND
, EXCH_NON_EXCH EXCH_NON_EXCH
, FUND_VALUE FUND_VALUE
, NEW_BAL_CODE NEW_BAL_CODE
, NEW_REC_FLAG NEW_REC_FLAG
, PERIOD_BEGIN_BAL PERIOD_BEGIN_BAL
, PERIOD_CY_CR_BAL PERIOD_CY_CR_BAL
, PERIOD_CY_DR_BAL PERIOD_CY_DR_BAL
, PERIOD_NAME PERIOD_NAME
, PERIOD_YEAR PERIOD_YEAR
, PROGRAM_COST_IND PROGRAM_COST_IND
, PROGRAM_REPT_CODE PROGRAM_REPT_CODE
, PYA_CODE PYA_CODE
, REPORTED_GROUP REPORTED_GROUP
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, TREASURY_SYMBOL_ID TREASURY_SYMBOL_ID
, USSGL_ACCOUNT USSGL_ACCOUNT
, PERIOD_NUM PERIOD_NUM
FROM "FV"."FV_GTAS1_PERIOD_ATTRIBUTES"