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

Source

View Text - Preformatted


select AWARD_ID AWARD_ID, VERSION VERSION, STATUS_CODE STATUS_CODE, REPORT_CODE REPORT_CODE, REPORT_STATUS REPORT_STATUS, 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, END_DATE END_DATE, DOCUMENT_NUMBER DOCUMENT_NUMBER, ACCOUNTING_BASIS ACCOUNTING_BASIS, FUNDING_START_DATE FUNDING_START_DATE, FUNDING_END_DATE FUNDING_END_DATE, REPORT_PERIOD_START_DATE REPORT_PERIOD_START_DATE, REPORT_PERIOD_END_DATE REPORT_PERIOD_END_DATE, TOTAL_OUTLAY TOTAL_OUTLAY, CUM_TOTAL_OUTLAY CUM_TOTAL_OUTLAY, REFUND_REBATE REFUND_REBATE, CUM_REFUND_REBATE CUM_REFUND_REBATE, PROGRAM_INCOME PROGRAM_INCOME, CUM_PROGRAM_INCOME CUM_PROGRAM_INCOME, CONTRIBUTION CONTRIBUTION, CUM_CONTRIBUTION CUM_CONTRIBUTION, OTHER_FED_AWARD OTHER_FED_AWARD, CUM_OTHER_FED_AWARD CUM_OTHER_FED_AWARD, PROG_INCOME_MATCH PROG_INCOME_MATCH, CUM_PROG_INCOME_MATCH CUM_PROG_INCOME_MATCH, OTHER_REC_OUTLAY OTHER_REC_OUTLAY, CUM_OTHER_REC_OUTLAY CUM_OTHER_REC_OUTLAY, TOTAL_REC_OUTLAY TOTAL_REC_OUTLAY, CUM_TOTAL_REC_OUTLAY CUM_TOTAL_REC_OUTLAY, CUM_UNLIQUID_OBLIGATION CUM_UNLIQUID_OBLIGATION, CUM_RECIPIENT_OBLIGATION CUM_RECIPIENT_OBLIGATION, CUM_PERIOD_FEDERAL_FUND CUM_PERIOD_FEDERAL_FUND, CUM_PROGRAM_INCOME_ADDITION CUM_PROGRAM_INCOME_ADDITION, CUM_PROGRAM_INCOME_UNUSED CUM_PROGRAM_INCOME_UNUSED, RATE_TYPE RATE_TYPE, INDIRECT_COST_RATE INDIRECT_COST_RATE, ALLOWED_COST_BASE ALLOWED_COST_BASE, FEDERAL_IDC_SHARE FEDERAL_IDC_SHARE, REMARKS REMARKS from "GMS"."GMS_269_HISTORY"

View Text - HTML Formatted

SELECT AWARD_ID AWARD_ID
, VERSION VERSION
, STATUS_CODE STATUS_CODE
, REPORT_CODE REPORT_CODE
, REPORT_STATUS REPORT_STATUS
, 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
, END_DATE END_DATE
, DOCUMENT_NUMBER DOCUMENT_NUMBER
, ACCOUNTING_BASIS ACCOUNTING_BASIS
, FUNDING_START_DATE FUNDING_START_DATE
, FUNDING_END_DATE FUNDING_END_DATE
, REPORT_PERIOD_START_DATE REPORT_PERIOD_START_DATE
, REPORT_PERIOD_END_DATE REPORT_PERIOD_END_DATE
, TOTAL_OUTLAY TOTAL_OUTLAY
, CUM_TOTAL_OUTLAY CUM_TOTAL_OUTLAY
, REFUND_REBATE REFUND_REBATE
, CUM_REFUND_REBATE CUM_REFUND_REBATE
, PROGRAM_INCOME PROGRAM_INCOME
, CUM_PROGRAM_INCOME CUM_PROGRAM_INCOME
, CONTRIBUTION CONTRIBUTION
, CUM_CONTRIBUTION CUM_CONTRIBUTION
, OTHER_FED_AWARD OTHER_FED_AWARD
, CUM_OTHER_FED_AWARD CUM_OTHER_FED_AWARD
, PROG_INCOME_MATCH PROG_INCOME_MATCH
, CUM_PROG_INCOME_MATCH CUM_PROG_INCOME_MATCH
, OTHER_REC_OUTLAY OTHER_REC_OUTLAY
, CUM_OTHER_REC_OUTLAY CUM_OTHER_REC_OUTLAY
, TOTAL_REC_OUTLAY TOTAL_REC_OUTLAY
, CUM_TOTAL_REC_OUTLAY CUM_TOTAL_REC_OUTLAY
, CUM_UNLIQUID_OBLIGATION CUM_UNLIQUID_OBLIGATION
, CUM_RECIPIENT_OBLIGATION CUM_RECIPIENT_OBLIGATION
, CUM_PERIOD_FEDERAL_FUND CUM_PERIOD_FEDERAL_FUND
, CUM_PROGRAM_INCOME_ADDITION CUM_PROGRAM_INCOME_ADDITION
, CUM_PROGRAM_INCOME_UNUSED CUM_PROGRAM_INCOME_UNUSED
, RATE_TYPE RATE_TYPE
, INDIRECT_COST_RATE INDIRECT_COST_RATE
, ALLOWED_COST_BASE ALLOWED_COST_BASE
, FEDERAL_IDC_SHARE FEDERAL_IDC_SHARE
, REMARKS REMARKS
FROM "GMS"."GMS_269_HISTORY"