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_270_HISTORY#

Source

View Text - Preformatted


select AWARD_ID AWARD_ID, VERSION VERSION, STATUS_CODE STATUS_CODE, RUN_DATE RUN_DATE, DOCUMENT_NUMBER DOCUMENT_NUMBER, ACCOUNTING_BASIS ACCOUNTING_BASIS, PAYMENT_TYPE PAYMENT_TYPE, PAYMENT_SCHEDULE PAYMENT_SCHEDULE, REPORT_START_DATE REPORT_START_DATE, REPORT_END_DATE REPORT_END_DATE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TOT_PRG_OUTLAY TOT_PRG_OUTLAY, CUM_PRG_INCOME CUM_PRG_INCOME, NET_CASH_OUTLAY NET_CASH_OUTLAY, NON_FED_SHARE NON_FED_SHARE, PAYEE_ADDRESS_ID PAYEE_ADDRESS_ID, REMARKS REMARKS, PAYEE_ADDRESS PAYEE_ADDRESS, PAYEE_NAME PAYEE_NAME from "GMS"."GMS_270_HISTORY"

View Text - HTML Formatted

SELECT AWARD_ID AWARD_ID
, VERSION VERSION
, STATUS_CODE STATUS_CODE
, RUN_DATE RUN_DATE
, DOCUMENT_NUMBER DOCUMENT_NUMBER
, ACCOUNTING_BASIS ACCOUNTING_BASIS
, PAYMENT_TYPE PAYMENT_TYPE
, PAYMENT_SCHEDULE PAYMENT_SCHEDULE
, REPORT_START_DATE REPORT_START_DATE
, REPORT_END_DATE REPORT_END_DATE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TOT_PRG_OUTLAY TOT_PRG_OUTLAY
, CUM_PRG_INCOME CUM_PRG_INCOME
, NET_CASH_OUTLAY NET_CASH_OUTLAY
, NON_FED_SHARE NON_FED_SHARE
, PAYEE_ADDRESS_ID PAYEE_ADDRESS_ID
, REMARKS REMARKS
, PAYEE_ADDRESS PAYEE_ADDRESS
, PAYEE_NAME PAYEE_NAME
FROM "GMS"."GMS_270_HISTORY"