[Home] [Help] [Dependency Information]
Object Name: | IGS_GR_CRM_ROUND_PRD |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_GR_CRM_ROUND_PRD |
Subobject Name: | |
Status: | VALID |
IGS_GR_CRM_ROUND_PRD describes the completion year and period that the parent ceremony round will process gradunds for.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_GR_CRM_ROUND_PRD_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
GRD_CAL_TYPE
GRD_CI_SEQUENCE_NUMBER COMPLETION_YEAR COMPLETION_PERIOD |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GRD_CAL_TYPE | VARCHAR2 | (10) | Yes | Describes the graduation calendar type the ceremony round is for |
GRD_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Describes the calendar instance of the graduation calendar the ceremony round is for |
COMPLETION_YEAR | NUMBER | (4) | Yes | The nominated or derived completion year used to identify graduands associated with the context ceremony round. Multiple completion years can be associated with each ceremony round. The graduand indentification and creation process selects valid program attempts with nominated or derived completion periods or years matching those associated with the ceremony round. |
COMPLETION_PERIOD | VARCHAR2 | (30) | Yes | The nominated or derived completion period used to identify graduands associated with the context ceremony round. Multiple completion periods can be associated with each ceremony round. The graduand indentification and creation process selects valid program attempts with nominated or derived completion periods and years matching those associated with 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 |
Cut, paste (and edit) the following text to query this object:
SELECT GRD_CAL_TYPE
, GRD_CI_SEQUENCE_NUMBER
, COMPLETION_YEAR
, COMPLETION_PERIOD
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_GR_CRM_ROUND_PRD;
IGS.IGS_GR_CRM_ROUND_PRD does not reference any database object
IGS.IGS_GR_CRM_ROUND_PRD is referenced by following:
|
|
|