[Home] [Help] [Dependency Information]
Object Name: | IGS_GR_AWD_CRM_UT_ST |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_GR_AWD_CRM_UT_ST |
Subobject Name: | |
Status: | VALID |
IGS_GR_AWD_CRM_US_ST describes the unit sets that make up the unit set groups that are being processed during the nominated graduation ceremony.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_GR_AWD_CRM_UT_ST_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
GRD_CAL_TYPE
GRD_CI_SEQUENCE_NUMBER CEREMONY_NUMBER AWARD_COURSE_CD AWARD_CRS_VERSION_NUMBER AWARD_CD US_GROUP_NUMBER UNIT_SET_CD US_VERSION_NUMBER |
IGS_GR_AWD_CRM_UT_ST_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
UNIT_SET_CD
US_VERSION_NUMBER |
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 |
CEREMONY_NUMBER | NUMBER | (3) | Yes | Describes the number uniquely identifying the graduation ceremony. |
AWARD_COURSE_CD | VARCHAR2 | (6) | Yes | Describes the program code that the award is being specified |
AWARD_CRS_VERSION_NUMBER | NUMBER | (3) | Yes | Describes the version number of the program that the award is being specified |
AWARD_CD | VARCHAR2 | (10) | Yes | Unique identifier for the award |
US_GROUP_NUMBER | NUMBER | (6) | Yes | Uniquely identifies a group of one or more unit sets being awarded at. |
UNIT_SET_CD | VARCHAR2 | (10) | Yes | The code of a unit set assigned to the unit set group.Typically, USG's contain only a single unit set. However, if it is necessary to identify and allocate graduands to a ceremony based on enrolment in or completion of multiple primary unit sets, then the USG can contain more than one unit set. For example, if it is necessary to identify and allocate graduands based on their completion of both the accounting and finance majors, then a USG containing both majors must be created. |
US_VERSION_NUMBER | NUMBER | (3) | Yes | Unit set version number |
ORDER_IN_GROUP | NUMBER | (3) | Yes | Order of unit sets within the unit set group default title. This value does not control the order of graduands within the unit set group. |
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
, CEREMONY_NUMBER
, AWARD_COURSE_CD
, AWARD_CRS_VERSION_NUMBER
, AWARD_CD
, US_GROUP_NUMBER
, UNIT_SET_CD
, US_VERSION_NUMBER
, ORDER_IN_GROUP
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_GR_AWD_CRM_UT_ST;
IGS.IGS_GR_AWD_CRM_UT_ST does not reference any database object
IGS.IGS_GR_AWD_CRM_UT_ST is referenced by following:
|
|
|