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_272_HISTORY

Object Details

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

GMS_272_HISTORY stores the history of SF 272, which is a federal cash transaction report.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMS_272_HISTORY_UK1	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 the award for which this report is generated.
VERSION	NUMBER	(15)	Yes	Report version number. System-generated running sequence number, that has a one-to-one relationship with reporting period.
STATUS_CODE	VARCHAR2	(1)	Yes	Report approval status. D indicates Draft and F indicates Approved.
CREATION_DATE	DATE			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
DOCUMENT_NUMBER	VARCHAR2	(30)		Identification number for report document. Default value is the award number. Users can modify to conform to their requirements.
RUN_DATE	DATE			Date report run
REPORT_START_DATE	DATE			Report start date
REPORT_END_DATE	DATE			Report end date
LETTER_OF_CREDIT	VARCHAR2	(15)		Letter of credit number
LAST_PAYMENT_VOUCHER_NUMBER	NUMBER			Last payment voucher number
PAYMENT_VOUCHER_CREDIT	NUMBER	(15)		Payment vouchers credited to account
TREASURY_CHECK	NUMBER			Treasury checks received, whether or not deposited
CASH_IN_HAND_BEGIN	NUMBER	(22)		Cash in hand at beginning of reporting period
LETTER_OF_CREDIT_WITHDRAWLS	NUMBER	(22)		Letter of credit withdrawals
TREASURY_CHECK_PAYMENTS	NUMBER	(15)		Treasury check payments
TOTAL_RECEIPTS	NUMBER	(22)		Total receipts. Sum of letter of credit withdrawals and Treasury check payments.
TOTAL_CASH_AVAIABLE	NUMBER	(22)		Total cash available. Sum of cash in hand at beginning of reporting period and total receipts.
GROSS_DISBURSEMENTS	NUMBER	(22)		Gross disbursements
FEDERAL_SHARE_INCOME	NUMBER	(22)		Federal share of program income
NET_DISBURSEMENTS	NUMBER	(22)		Net disbursements. Gross disbursements, federal share of program income.
ADJUSTMENTS_PRIOR_PERIODS	NUMBER	(22)		Adjustments of prior periods
CASH_IN_HAND_END	NUMBER	(22)		Cash in hand at end of period
DAYS	NUMBER			Number of days
INTEREST_INCOME	NUMBER	(22)		Interest income
ADV_TO_SUBGRANTEES	NUMBER	(22)		Advances to subgrantees or subcontractors
REMARKS	VARCHAR2	(2000)		Remarks
CREATED_BY	NUMBER	(15)		Standard Who column

Query Text

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


SELECT AWARD_ID
,      VERSION
,      STATUS_CODE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DOCUMENT_NUMBER
,      RUN_DATE
,      REPORT_START_DATE
,      REPORT_END_DATE
,      LETTER_OF_CREDIT
,      LAST_PAYMENT_VOUCHER_NUMBER
,      PAYMENT_VOUCHER_CREDIT
,      TREASURY_CHECK
,      CASH_IN_HAND_BEGIN
,      LETTER_OF_CREDIT_WITHDRAWLS
,      TREASURY_CHECK_PAYMENTS
,      TOTAL_RECEIPTS
,      TOTAL_CASH_AVAIABLE
,      GROSS_DISBURSEMENTS
,      FEDERAL_SHARE_INCOME
,      NET_DISBURSEMENTS
,      ADJUSTMENTS_PRIOR_PERIODS
,      CASH_IN_HAND_END
,      DAYS
,      INTEREST_INCOME
,      ADV_TO_SUBGRANTEES
,      REMARKS
,      CREATED_BY
FROM GMS.GMS_272_HISTORY;

Dependencies

[top of page]

GMS.GMS_272_HISTORY does not reference any database object

GMS.GMS_272_HISTORY is referenced by following:

APPS: GMS_272_HISTORY