[Home] [Help] [Dependency Information]
Object Name: | IGS_AS_SUA_REF_CDS |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AS_SUA_REF_CDS |
Subobject Name: | |
Status: | VALID |
This table stores the Student Unit Attempt Reference Codes
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AS_SUA_REF_CDS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PERSON_ID
COURSE_CD UOO_ID REFERENCE_CODE_ID APPLIED_COURSE_CD DELETED_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUAR_ID | NUMBER | Yes | Unique key for Student Unit Attempt Reference Code | |
PERSON_ID | NUMBER | (15) | Yes | Person ID - part of foreign key to SUA |
COURSE_CD | VARCHAR2 | (6) | Yes | Program ID - part of foreign key to SUA |
UOO_ID | NUMBER | (7) | Yes | Unit Offering Option ID - part of foreign key to SUA |
REFERENCE_CODE_ID | NUMBER | (10) | Yes | Reference Code ID - foreign key to reference code |
REFERENCE_CD_TYPE | VARCHAR2 | (10) | Yes | The reference code type |
REFERENCE_CD | VARCHAR2 | (30) | Yes | The reference code applied to the student unit attempt |
APPLIED_COURSE_CD | VARCHAR2 | (6) | Yes | The program code under which the reference code is saved. |
DELETED_DATE | DATE | The date the record was marked as deleted. | ||
CREATED_BY | NUMBER | (15) | Yes | Created By -Standard Who Column |
CREATION_DATE | DATE | Yes | Creation Date -Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Last Updated By -Standard Who Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Last Update Login Standard Who Column | |
LAST_UPDATE_DATE | DATE | Yes | Last Update Date Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT SUAR_ID
, PERSON_ID
, COURSE_CD
, UOO_ID
, REFERENCE_CODE_ID
, REFERENCE_CD_TYPE
, REFERENCE_CD
, APPLIED_COURSE_CD
, DELETED_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
FROM IGS.IGS_AS_SUA_REF_CDS;
IGS.IGS_AS_SUA_REF_CDS does not reference any database object
IGS.IGS_AS_SUA_REF_CDS is referenced by following:
|
|
|