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: GMS.GMS_425_HISTORY#

Source

View Text - Preformatted


select REPORT_TRN_ID REPORT_TRN_ID, AWARD_ID AWARD_ID, VERSION VERSION, STATUS_CODE STATUS_CODE, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, RUN_DATE RUN_DATE, REPORT_START_DATE REPORT_START_DATE, CREATED_BY CREATED_BY, REPORT_TYPE_CODE REPORT_TYPE_CODE, BASIS_OF_ACCNT_CODE BASIS_OF_ACCNT_CODE, GRANT_PERIOD_FROM_DATE GRANT_PERIOD_FROM_DATE, GRANT_PERIOD_TO_DATE GRANT_PERIOD_TO_DATE, REPORT_END_DATE REPORT_END_DATE, CASH_RECEIPTS_AMT CASH_RECEIPTS_AMT, CASH_DISBURSEMENTS_AMT CASH_DISBURSEMENTS_AMT, TOTAL_FED_FUNDS_AUTH_AMT TOTAL_FED_FUNDS_AUTH_AMT, FED_SHARE_OF_EXP_AMT FED_SHARE_OF_EXP_AMT, FED_SHARE_OF_UNLIQ_OBL_AMT FED_SHARE_OF_UNLIQ_OBL_AMT, TOTAL_RECPT_SHARE_REQ_AMT TOTAL_RECPT_SHARE_REQ_AMT, RECPT_SHARE_EXP_AMT RECPT_SHARE_EXP_AMT, TOTAL_FED_PRG_INC_EARN_AMT TOTAL_FED_PRG_INC_EARN_AMT, PRG_INC_EXP_DEDUCT_ALT_AMT PRG_INC_EXP_DEDUCT_ALT_AMT, PRG_INC_EXP_ADD_ALT_AMT PRG_INC_EXP_ADD_ALT_AMT, REMARKS REMARKS, NAME NAME, TELEPHONE TELEPHONE, EMAIL EMAIL, REPORT_SUBMIT_DATE REPORT_SUBMIT_DATE from "GMS"."GMS_425_HISTORY"

View Text - HTML Formatted

SELECT REPORT_TRN_ID REPORT_TRN_ID
, AWARD_ID AWARD_ID
, VERSION VERSION
, STATUS_CODE STATUS_CODE
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RUN_DATE RUN_DATE
, REPORT_START_DATE REPORT_START_DATE
, CREATED_BY CREATED_BY
, REPORT_TYPE_CODE REPORT_TYPE_CODE
, BASIS_OF_ACCNT_CODE BASIS_OF_ACCNT_CODE
, GRANT_PERIOD_FROM_DATE GRANT_PERIOD_FROM_DATE
, GRANT_PERIOD_TO_DATE GRANT_PERIOD_TO_DATE
, REPORT_END_DATE REPORT_END_DATE
, CASH_RECEIPTS_AMT CASH_RECEIPTS_AMT
, CASH_DISBURSEMENTS_AMT CASH_DISBURSEMENTS_AMT
, TOTAL_FED_FUNDS_AUTH_AMT TOTAL_FED_FUNDS_AUTH_AMT
, FED_SHARE_OF_EXP_AMT FED_SHARE_OF_EXP_AMT
, FED_SHARE_OF_UNLIQ_OBL_AMT FED_SHARE_OF_UNLIQ_OBL_AMT
, TOTAL_RECPT_SHARE_REQ_AMT TOTAL_RECPT_SHARE_REQ_AMT
, RECPT_SHARE_EXP_AMT RECPT_SHARE_EXP_AMT
, TOTAL_FED_PRG_INC_EARN_AMT TOTAL_FED_PRG_INC_EARN_AMT
, PRG_INC_EXP_DEDUCT_ALT_AMT PRG_INC_EXP_DEDUCT_ALT_AMT
, PRG_INC_EXP_ADD_ALT_AMT PRG_INC_EXP_ADD_ALT_AMT
, REMARKS REMARKS
, NAME NAME
, TELEPHONE TELEPHONE
, EMAIL EMAIL
, REPORT_SUBMIT_DATE REPORT_SUBMIT_DATE
FROM "GMS"."GMS_425_HISTORY"