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

VIEW: GMS.GMS_269_HISTORY#

Object Details
Object Name: GMS_269_HISTORY#
Object Type: VIEW
Owner: GMS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
AWARD_ID NUMBER (15) Yes
VERSION NUMBER (15) Yes
STATUS_CODE VARCHAR2 (1) Yes
REPORT_CODE VARCHAR2 (10)
REPORT_STATUS VARCHAR2 (1)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
END_DATE DATE

DOCUMENT_NUMBER VARCHAR2 (30)
ACCOUNTING_BASIS VARCHAR2 (1)
FUNDING_START_DATE DATE

FUNDING_END_DATE DATE

REPORT_PERIOD_START_DATE DATE

REPORT_PERIOD_END_DATE DATE

TOTAL_OUTLAY NUMBER (22)
CUM_TOTAL_OUTLAY NUMBER (22)
REFUND_REBATE NUMBER (22)
CUM_REFUND_REBATE NUMBER (22)
PROGRAM_INCOME NUMBER (22)
CUM_PROGRAM_INCOME NUMBER (22)
CONTRIBUTION NUMBER (22)
CUM_CONTRIBUTION NUMBER (22)
OTHER_FED_AWARD NUMBER (22)
CUM_OTHER_FED_AWARD NUMBER (22)
PROG_INCOME_MATCH NUMBER (22)
CUM_PROG_INCOME_MATCH NUMBER (22)
OTHER_REC_OUTLAY NUMBER (22)
CUM_OTHER_REC_OUTLAY NUMBER (22)
TOTAL_REC_OUTLAY NUMBER (22)
CUM_TOTAL_REC_OUTLAY NUMBER (22)
CUM_UNLIQUID_OBLIGATION NUMBER (22)
CUM_RECIPIENT_OBLIGATION NUMBER (22)
CUM_PERIOD_FEDERAL_FUND NUMBER (22)
CUM_PROGRAM_INCOME_ADDITION NUMBER (22)
CUM_PROGRAM_INCOME_UNUSED NUMBER (22)
RATE_TYPE VARCHAR2 (30)
INDIRECT_COST_RATE NUMBER (22)
ALLOWED_COST_BASE NUMBER (22)
FEDERAL_IDC_SHARE NUMBER (22)
REMARKS VARCHAR2 (2000)
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# references the following:

SchemaGMS
TableGMS_269_HISTORY
GMS.GMS_269_HISTORY# is referenced by following:

SchemaAPPS
SynonymGMS_269_HISTORY