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

TABLE: IGS.IGS_GR_CRMN_ROUND_ALL

Object Details
Object Name: IGS_GR_CRMN_ROUND_ALL
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_GR_CRMN_ROUND_ALL
Subobject Name:
Status: VALID


IGS_GR_CRMN_ROUND_ALL describes a round of graduation ceremonies.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_GR_CRMN_ROUND_ALL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGRD_CAL_TYPE
ColumnGRD_CI_SEQUENCE_NUMBER
ColumnEND_DT_ALIAS
ColumnEND_DAI_SEQUENCE_NUMBER
IGS_GR_CRMN_ROUND_ALL_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGRD_CAL_TYPE
ColumnGRD_CI_SEQUENCE_NUMBER
ColumnSTART_DT_ALIAS
ColumnSTART_DAI_SEQUENCE_NUMBER
Columns
Name Datatype Length Mandatory Comments
GRD_CAL_TYPE VARCHAR2 (10) Yes The calendar type of the graduation calendar used for the ceremony round. Each graduation ceremony round is a pre-existing graduation calendar instance, created in CALF0220.
GRD_CI_SEQUENCE_NUMBER NUMBER (6) Yes Describes the calendar instance of the graduation calendar the ceremony round is for
START_DT_ALIAS VARCHAR2 (10) Yes The date alias used to represent the date that processing to identify graduands for the context ceremony round can commence. The date alias selected, must exist within calendar instance of the ceremony round.
START_DAI_SEQUENCE_NUMBER NUMBER (6) Yes Describes the date alias instance for the start of processing to identify graduands for this ceremony round. The date alias is related to the graduation calendar type and calendar instance of the ceremony round.
END_DT_ALIAS VARCHAR2 (10) Yes The date alias used to represent the date on which the graduand identification and creation process ends for the context ceremony round. The date alias selected, must exist within the calendar instance of the ceremony round.
END_DAI_SEQUENCE_NUMBER NUMBER (6) Yes Describes the date alias instance for the end of processing to identify graduands for this ceremony round. The date alias is related to the graduation calendar type and calendar instance of the ceremony round.
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
ORG_ID NUMBER (15)
Operating unit identifier
CONFERRAL_START_DATE DATE

The Conferral Start and End Date are used to identify Student Program Attempt Award records that have a Conferral Date that falls within this range.
CONFERRAL_END_DATE DATE

The Conferral Start and End Date are used to identify Student Program Attempt Award records that have a Conferral Date that falls within this range
COMPLETION_START_DATE DATE

The Program Completion Start and End Date are used to identify Student Program Attempt records that have a Program Requirements Complete Date that falls within this range
COMPLETION_END_DATE DATE

The Program Completion Start and End Date are used to identify Student Program Attempt records that have a Program Requirements Complete Date that falls within this range.
Query Text

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


SELECT GRD_CAL_TYPE
,      GRD_CI_SEQUENCE_NUMBER
,      START_DT_ALIAS
,      START_DAI_SEQUENCE_NUMBER
,      END_DT_ALIAS
,      END_DAI_SEQUENCE_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      CONFERRAL_START_DATE
,      CONFERRAL_END_DATE
,      COMPLETION_START_DATE
,      COMPLETION_END_DATE
FROM IGS.IGS_GR_CRMN_ROUND_ALL;

Dependencies

[top of page]

IGS.IGS_GR_CRMN_ROUND_ALL does not reference any database object

IGS.IGS_GR_CRMN_ROUND_ALL is referenced by following:

SchemaAPPS
SynonymIGS_GR_CRMN_ROUND_ALL