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_270_HISTORY

Object Details

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

GMS_270_HISTORY stores the history of SF 270, which is a financial status report for a federal award.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMS_270_HISTORY_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	AWARD_ID VERSION STATUS_CODE

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	Version number of report. System-generated running sequence number, which has a one-to-one relationship with the reporting period.
STATUS_CODE	VARCHAR2	(1)	Yes	Report approval status. D indicates Draft and F indicates Final.
RUN_DATE	DATE			Date report run
DOCUMENT_NUMBER	VARCHAR2	(30)		Identification number for report document. The default value is the award number. Users can modify to conform to their requirements.
ACCOUNTING_BASIS	VARCHAR2	(1)	Yes	Accounting basis used for report. Valid values include A for Accrual and C for Cash.
PAYMENT_TYPE	VARCHAR2	(1)	Yes	Payment types include advance or reimbursement.
PAYMENT_SCHEDULE	VARCHAR2	(1)	Yes	Payment schedules are final or partial.
REPORT_START_DATE	DATE			Start date of period for which report is prepared
REPORT_END_DATE	DATE			End date of period for which report is prepared. Reporting periods cannot overlap.
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column
TOT_PRG_OUTLAY	NUMBER	(22)		Total expenditures for reporting period
CUM_PRG_INCOME	NUMBER	(22)		Program income received to date. User-defined field.
NET_CASH_OUTLAY	NUMBER	(22)		User-defined field. Total estimated amount of cash outlays that are to be made during period covered by the advance.
NON_FED_SHARE	NUMBER	(22)		Nonfederal share of the sum of net cash outlays and net program outlays
PAYEE_ADDRESS_ID	NUMBER			Payee address identifier
REMARKS	VARCHAR2	(2000)		Remarks or special notes for this report
PAYEE_ADDRESS	VARCHAR2	(1000)		Payee Address, to which checks need to be sent.
PAYEE_NAME	VARCHAR2	(240)		Name of Payee

Query Text

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


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

Dependencies

[top of page]

GMS.GMS_270_HISTORY does not reference any database object

GMS.GMS_270_HISTORY is referenced by following:

APPS: GMS_270_HISTORY