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

TABLE: GMS.GMS_ALLOWABILITY_SCHEDULES

Object Details
Object Name: GMS_ALLOWABILITY_SCHEDULES
Object Type: TABLE
Owner: GMS
FND Design Data: TableGMS.GMS_ALLOWABILITY_SCHEDULES
Subobject Name:
Status: VALID


GMS_ALLOWABILITY_SCHEDULES holds cost allowability schedule information. An allowability schedule, when attached to an award, dictates what expenditure types are allowable for an award and what the limits for indirect cost are on each of the allowable expenditure types.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMS_ALLOWABILITY_SCHEDULES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnALLOWABILITY_SCHEDULE_ID
GMS_ALLOWABILITY_SCHEDULES_U2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnALLOW_SCH_NAME
Columns
Name Datatype Length Mandatory Comments
ALLOWABILITY_SCHEDULE_ID NUMBER (15) Yes Allowability schedule unique identifier
ALLOW_SCH_NAME VARCHAR2 (30) Yes Allowability schedule name
DESCRIPTION VARCHAR2 (240)
Allowability schedule description
START_DATE_ACTIVE DATE
Yes Allowability schedule start date
END_DATE_ACTIVE DATE

Allowability schedule end date
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who column
Query Text

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


SELECT ALLOWABILITY_SCHEDULE_ID
,      ALLOW_SCH_NAME
,      DESCRIPTION
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM GMS.GMS_ALLOWABILITY_SCHEDULES;

Dependencies

[top of page]

GMS.GMS_ALLOWABILITY_SCHEDULES does not reference any database object

GMS.GMS_ALLOWABILITY_SCHEDULES is referenced by following:

SchemaAPPS
SynonymGMS_ALLOWABILITY_SCHEDULES