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

TABLE: GMS.GMS_425_EXPENSE

Object Details
Object Name: GMS_425_EXPENSE
Object Type: TABLE
Owner: GMS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
REPORT_TRN_ID NUMBER
Yes Identifier of the transaction used to generate the SF-425 report
EXPENSE_TRN_ID NUMBER
Yes Identifier of the indirect cost transaction
CREATION_DATE DATE

INDIRECT_EXP_TYPE_CODE VARCHAR2 (120)
Code specifying type of indirect cost rate if provisional, predetermined, final, or fixed
INDIRECT_EXP_RATE NUMBER (22)
Indirect cost rate or rates used for the reporting period
INDIRECT_EXP_PERIOD_FROM DATE

Effective start date of the rate
INDIRECT_EXP_PERIOD_TO DATE

Effective end date of the rate
INDIRECT_EXP_BASE_AMT NUMBER (22)
Base amount to which rate was applied
INDIRECT_EXP_FED_SHARE_AMT NUMBER (22)
Federal share of the total amount of indirect costs charged for the reporting period
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
Query Text

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


SELECT REPORT_TRN_ID
,      EXPENSE_TRN_ID
,      CREATION_DATE
,      INDIRECT_EXP_TYPE_CODE
,      INDIRECT_EXP_RATE
,      INDIRECT_EXP_PERIOD_FROM
,      INDIRECT_EXP_PERIOD_TO
,      INDIRECT_EXP_BASE_AMT
,      INDIRECT_EXP_FED_SHARE_AMT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
FROM GMS.GMS_425_EXPENSE;

Dependencies

[top of page]

GMS.GMS_425_EXPENSE does not reference any database object

GMS.GMS_425_EXPENSE is referenced by following:

SchemaGMS
ViewGMS_425_EXPENSE#