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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: GMS.GMS_269_HISTORY

Object Details

Object Name:	GMS_269_HISTORY
Object Type:	TABLE
Owner:	GMS
FND Design Data:	GMS.GMS_269_HISTORY
Subobject Name:
Status:	VALID

GMS_269_HISTORY stores the history of SF 269, which is a financial status report for a federal award. Each record is identified by an award identifier, version, and status code. Each record is a financial status report for an award for a reporting period.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMS_269_HISTORY_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AWARD_ID VERSION

Columns

Name	Datatype	Length	Mandatory	Comments
AWARD_ID	NUMBER	(15)	Yes	Award identification number. Identifies award for which this report is generated.
VERSION	NUMBER	(15)	Yes	Report version number. This is a system-generated running sequence number, which has a one-to-one relationship with the reporting period.
STATUS_CODE	VARCHAR2	(1)	Yes	Approval status of the report. D indicates Draft and F indicates Approved.
REPORT_CODE	VARCHAR2	(10)		Report code. For future use.
REPORT_STATUS	VARCHAR2	(1)		Report status indicates if the report is a final report or not. F indicates Final report and D indicates that it is not a final report.
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
END_DATE	DATE			End date of report. Not currently used.
DOCUMENT_NUMBER	VARCHAR2	(30)		Identification number for the report document. Default value is the award number. Users can modify it to conform to their requirements.
ACCOUNTING_BASIS	VARCHAR2	(1)		Accounting basis used for the report. Valid values are A for Accrual and C for Cash.
FUNDING_START_DATE	DATE			Starting date of funding. Start date of the first installment of the award.
FUNDING_END_DATE	DATE			End date of funding. End date installment is later than all the other installments of the award.
REPORT_PERIOD_START_DATE	DATE			Start date of period for which this report is prepared
REPORT_PERIOD_END_DATE	DATE			End date of period for which this report is prepared. Reporting periods cannot overlap.
TOTAL_OUTLAY	NUMBER	(22)		Total expenditure for this reporting period
CUM_TOTAL_OUTLAY	NUMBER	(22)		Cumulative expenditure from start of funding up to reporting period. Sum of the total outlay of this period and cumulative total outlay of previous period.
REFUND_REBATE	NUMBER	(22)		Receipts which are treated as reduction of expenditure, not as income, and excluded from total outlay during reporting period
CUM_REFUND_REBATE	NUMBER	(22)		Cumulative value of refund or rebate from start of funding up to reporting period
PROGRAM_INCOME	NUMBER	(22)		Program income amount used in accordance with deduction alternative
CUM_PROGRAM_INCOME	NUMBER	(22)		Cumulative value of program income from start of funding up to the reporting period
CONTRIBUTION	NUMBER	(22)		Contributions received from third parties during reporting period
CUM_CONTRIBUTION	NUMBER	(22)		Cumulative value of contributions from start of the funding up to reporting period
OTHER_FED_AWARD	NUMBER	(22)		Other federal awards authorized to be used to match reporting award
CUM_OTHER_FED_AWARD	NUMBER	(22)		Cumulative value of other federal awards from start of the funding up to reporting period
PROG_INCOME_MATCH	NUMBER	(22)		Program income used in accordance with the matching or cost sharing alternative
CUM_PROG_INCOME_MATCH	NUMBER	(22)		Cumulative value of program income match
OTHER_REC_OUTLAY	NUMBER	(22)		Other recipient share of net outlays
CUM_OTHER_REC_OUTLAY	NUMBER	(22)		Cumulative value of other recipient share of outlays from beginning of the award until reporting period
TOTAL_REC_OUTLAY	NUMBER	(22)		Total recipient share of net outlays. Sum of third party contribution, federal award authorized to match this award, program income used in accordance with matching criteria, and other recipient outlays.
CUM_TOTAL_REC_OUTLAY	NUMBER	(22)		Cumulative value of total recipient share of net outlays from beginning of the award until reporting period
CUM_UNLIQUID_OBLIGATION	NUMBER	(22)		Cumulative value of unliquidated obligations, including unliquidated obligations to subgrantees and contractors from beginning of the award until reporting period
CUM_RECIPIENT_OBLIGATION	NUMBER	(22)		Cumulative value of recipients' share of unliquidated obligations from beginning of the award until reporting period
CUM_PERIOD_FEDERAL_FUND	NUMBER	(22)		Cumulative value of the federal fund during reporting period. Sum of installment amounts eligible during this period.
CUM_PROGRAM_INCOME_ADDITION	NUMBER	(22)		Disbursed program income using the addition alternative
CUM_PROGRAM_INCOME_UNUSED	NUMBER	(22)		Undisbursed program income
RATE_TYPE	VARCHAR2	(30)		Rate type used for overhead costs. Valid values are Predetermined, Provisional, Final, and Fixed.
INDIRECT_COST_RATE	NUMBER	(22)		Indirect cost rate used for calculating overhead costs
ALLOWED_COST_BASE	NUMBER	(22)		Cost base used as the base for calculating overhead cost
FEDERAL_IDC_SHARE	NUMBER	(22)		Federal share of overhead or indirect cost
REMARKS	VARCHAR2	(2000)		Remarks or special notes for this report

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT AWARD_ID
,      VERSION
,      STATUS_CODE
,      REPORT_CODE
,      REPORT_STATUS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      END_DATE
,      DOCUMENT_NUMBER
,      ACCOUNTING_BASIS
,      FUNDING_START_DATE
,      FUNDING_END_DATE
,      REPORT_PERIOD_START_DATE
,      REPORT_PERIOD_END_DATE
,      TOTAL_OUTLAY
,      CUM_TOTAL_OUTLAY
,      REFUND_REBATE
,      CUM_REFUND_REBATE
,      PROGRAM_INCOME
,      CUM_PROGRAM_INCOME
,      CONTRIBUTION
,      CUM_CONTRIBUTION
,      OTHER_FED_AWARD
,      CUM_OTHER_FED_AWARD
,      PROG_INCOME_MATCH
,      CUM_PROG_INCOME_MATCH
,      OTHER_REC_OUTLAY
,      CUM_OTHER_REC_OUTLAY
,      TOTAL_REC_OUTLAY
,      CUM_TOTAL_REC_OUTLAY
,      CUM_UNLIQUID_OBLIGATION
,      CUM_RECIPIENT_OBLIGATION
,      CUM_PERIOD_FEDERAL_FUND
,      CUM_PROGRAM_INCOME_ADDITION
,      CUM_PROGRAM_INCOME_UNUSED
,      RATE_TYPE
,      INDIRECT_COST_RATE
,      ALLOWED_COST_BASE
,      FEDERAL_IDC_SHARE
,      REMARKS
FROM GMS.GMS_269_HISTORY;

Dependencies

[top of page]

GMS.GMS_269_HISTORY does not reference any database object

GMS.GMS_269_HISTORY is referenced by following:

APPS: GMS_269_HISTORY