[Home] [Help] [Dependency Information]
Object Name: | IGS_AV_STD_UNT_BASIS_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AV_STD_UNT_BASIS_ALL |
Subobject Name: | |
Status: | VALID |
IGS_AV_STD_UNT_BASIS_ALL describes the basis on which a unit has been granted as advanced standing.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AV_STD_UNT_BASIS_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | AV_STND_UNIT_ID |
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 against the advanced standing that is approved or granted. | |
AS_VERSION_NUMBER | NUMBER | (3) | Describes the version number of the program against the advanced standing that is approved or granted. | |
S_ADV_STND_TYPE | VARCHAR2 | (10) | Describes the type of advanced standing. | |
UNIT_CD | VARCHAR2 | (10) | Describes the unit that advanced standing has been given. | |
VERSION_NUMBER | NUMBER | (3) | Describes the version number of the unit that advanced standing has been given. | |
AV_STND_UNIT_ID | NUMBER | (15) | Yes | System generated number to store the primary key |
BASIS_COURSE_TYPE | VARCHAR2 | (10) | Describes the program type of the program that forms the basis of the unit advanced standing. | |
BASIS_YEAR | NUMBER | (4) | Describes the year the person was last enrolledin the program that forms the basis of the unit advancedstanding. | |
BASIS_COMPLETION_IND | VARCHAR2 | (1) | Indicates whether the student completed the programthat forms the basis of the unit advanced standing. | |
ORG_ID | NUMBER | (15) | Operating unit identifier |
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
, BASIS_COURSE_TYPE
, BASIS_YEAR
, BASIS_COMPLETION_IND
, ORG_ID
FROM IGS.IGS_AV_STD_UNT_BASIS_ALL;
IGS.IGS_AV_STD_UNT_BASIS_ALL does not reference any database object
IGS.IGS_AV_STD_UNT_BASIS_ALL is referenced by following:
|
|
|