[Home] [Help] [Dependency Information]
Object Name: | IGS_AV_STND_ALT_UNIT |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AV_STND_ALT_UNIT |
Subobject Name: | |
Status: | VALID |
IGS_AV_STND_ALT_UNIT describes alternate units for a specified precluded unit.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AV_STND_ALT_UNIT_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
AV_STND_UNIT_ID
ALT_UNIT_CD ALT_VERSION_NUMBER |
IGS_AV_STND_ALT_UNIT_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ALT_UNIT_CD
ALT_VERSION_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
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 | |
PERSON_ID | NUMBER | (15) | Describes the ID that uniquely identifies a person. | |
AS_COURSE_CD | VARCHAR2 | (6) | Describes the program code against advancedstanding that is being given. | |
AS_VERSION_NUMBER | NUMBER | (3) | Describes the version number of the program against advanced standing that is being given. | |
S_ADV_STND_TYPE | VARCHAR2 | (10) | Describes the type of advanced standing. For example, PRECLUSION. | |
UNIT_CD | VARCHAR2 | (10) | Describes the unit thath the student is being precludedfrom studying, as a result of the advanced standing assessment. | |
VERSION_NUMBER | NUMBER | (3) | Describes the version number of the unit. | |
AV_STND_UNIT_ID | NUMBER | (15) | Yes | System generated number to store the primary key |
ALT_UNIT_CD | VARCHAR2 | (10) | Yes | Describes the alternate unit that has beenspecified in place of a unit that the student has been precludedfrom studying. |
ALT_VERSION_NUMBER | NUMBER | (3) | Yes | Describes the version number of the alternate unit that has been specified in place of a precluded unit. |
OPTIONAL_IND | VARCHAR2 | (1) | Yes | Indicates whether the alternate unit is mandatory or whether a choice is available. Setting the indicator to checked means that the alternate unit is optional. |
Cut, paste (and edit) the following text to query this object:
SELECT LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, PERSON_ID
, AS_COURSE_CD
, AS_VERSION_NUMBER
, S_ADV_STND_TYPE
, UNIT_CD
, VERSION_NUMBER
, AV_STND_UNIT_ID
, ALT_UNIT_CD
, ALT_VERSION_NUMBER
, OPTIONAL_IND
FROM IGS.IGS_AV_STND_ALT_UNIT;
IGS.IGS_AV_STND_ALT_UNIT does not reference any database object
IGS.IGS_AV_STND_ALT_UNIT is referenced by following:
|
|
|