[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GMS_425_HISTORY |
|---|---|
| Object Type: | TABLE |
| Owner: | GMS |
| Subobject Name: | |
| Status: | VALID |
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| REPORT_TRN_ID | NUMBER | (15) | Yes | Identifier of the transaction used to generate the SF425 report |
| AWARD_ID | NUMBER | (15) | Yes | Identifier of the award for which the report was generated |
| VERSION | NUMBER | (15) | Yes | Version number of the report |
| STATUS_CODE | VARCHAR2 | (3) | Yes | Code specifying report status |
| CREATION_DATE | DATE | Yes | ||
| LAST_UPDATE_DATE | DATE | |||
| LAST_UPDATED_BY | NUMBER | (15) | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| RUN_DATE | DATE | Yes | Date of report generation | |
| REPORT_START_DATE | DATE | Yes | Start date of the period covered by this report | |
| CREATED_BY | NUMBER | (15) | Yes | |
| REPORT_TYPE_CODE | VARCHAR2 | (150) | Yes | Type of report if quarterly, semi-annual, annual, or final |
| BASIS_OF_ACCNT_CODE | VARCHAR2 | (120) | Yes | Basis of accounting if cash or accrual |
| GRANT_PERIOD_FROM_DATE | DATE | Yes | Start date of Federal sponsorship for this award | |
| GRANT_PERIOD_TO_DATE | DATE | Yes | End date of Federal sponsorship for this award | |
| REPORT_END_DATE | DATE | Yes | End date of the period covered by this report | |
| CASH_RECEIPTS_AMT | NUMBER | (22) | Total amount of cash received from the Federal Agency for the report period | |
| CASH_DISBURSEMENTS_AMT | NUMBER | (22) | Total amount of Federal funds disbursed as cash or checks for charges, advances, and payments | |
| TOTAL_FED_FUNDS_AUTH_AMT | NUMBER | (22) | Total amount of Federal funds authorized for the report period | |
| FED_SHARE_OF_EXP_AMT | NUMBER | (22) | Total amount of Federal funds expended including cash and check payment, expenses charged to the award or incurred, and applied in-kind contributions | |
| FED_SHARE_OF_UNLIQ_OBL_AMT | NUMBER | (22) | Amount constituting Federal share of obligations incurred but not yet paid or charged to the award | |
| TOTAL_RECPT_SHARE_REQ_AMT | NUMBER | (22) | ||
| RECPT_SHARE_EXP_AMT | NUMBER | (22) | Amount of actual recipient share of expenses for the reporting period | |
| TOTAL_FED_PRG_INC_EARN_AMT | NUMBER | (22) | Total amount of Federal program income earned | |
| PRG_INC_EXP_DEDUCT_ALT_AMT | NUMBER | (22) | Amount of program income used to reduce the Federal share of total project costs | |
| PRG_INC_EXP_ADD_ALT_AMT | NUMBER | (22) | Amount of program income added to funds committed to the total project costs and expended to further eligible project or program activities | |
| REMARKS | VARCHAR2 | (2000) | Explanations or additional information required by the Federal sponsoring agency including excess cash | |
| NAME | VARCHAR2 | (360) | Name of authorized certifying official | |
| TELEPHONE | VARCHAR2 | (360) | Telephone area code and number of certifying official | |
| VARCHAR2 | (240) | Email address of certifying official | ||
| REPORT_SUBMIT_DATE | DATE | Date of submission of report to the Federal agency |
Cut, paste (and edit) the following text to query this object:
SELECT REPORT_TRN_ID
, AWARD_ID
, VERSION
, STATUS_CODE
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, RUN_DATE
, REPORT_START_DATE
, CREATED_BY
, REPORT_TYPE_CODE
, BASIS_OF_ACCNT_CODE
, GRANT_PERIOD_FROM_DATE
, GRANT_PERIOD_TO_DATE
, REPORT_END_DATE
, CASH_RECEIPTS_AMT
, CASH_DISBURSEMENTS_AMT
, TOTAL_FED_FUNDS_AUTH_AMT
, FED_SHARE_OF_EXP_AMT
, FED_SHARE_OF_UNLIQ_OBL_AMT
, TOTAL_RECPT_SHARE_REQ_AMT
, RECPT_SHARE_EXP_AMT
, TOTAL_FED_PRG_INC_EARN_AMT
, PRG_INC_EXP_DEDUCT_ALT_AMT
, PRG_INC_EXP_ADD_ALT_AMT
, REMARKS
, NAME
, TELEPHONE
, EMAIL
, REPORT_SUBMIT_DATE
FROM GMS.GMS_425_HISTORY;
GMS.GMS_425_HISTORY does not reference any database object
GMS.GMS_425_HISTORY is referenced by following:
GMS
GMS_425_HISTORY#
|
|
|
|