DBA Data[Home] [Help] [Dependency Information]

TABLE: IGS.IGS_AV_UNT_REF_CDS

Object Details
Object Name: IGS_AV_UNT_REF_CDS
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_AV_UNT_REF_CDS
Subobject Name:
Status: VALID


Table containing the reference codes that have been associated with an advanced standing unit.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_AV_UNT_REF_CDS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAV_STND_UNIT_ID
IGS_AV_UNT_REF_CDS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPLIED_COURSE_CD
ColumnPERSON_ID
Columns
Name Datatype Length Mandatory Comments
AVU_REFERENCE_CD_ID NUMBER
Yes System Generated number to store the primary key.
PERSON_ID NUMBER (15) Yes Person Identifier and foreign key to HZ_PARTIES.
AV_STND_UNIT_ID NUMBER (15) Yes Advanced Standing Unit ID.
REFERENCE_CODE_ID NUMBER (10) Yes Uniquely identifies an institution-defined reference code type.
CREATED_BY NUMBER (15) Yes Created By
CREATION_DATE DATE
Yes Creation Date
LAST_UPDATED_BY NUMBER (15) Yes Last Updated By
LAST_UPDATE_DATE DATE
Yes Last Update Date
LAST_UPDATE_LOGIN NUMBER (15)
Last Update Login
DELETED_DATE DATE

The date the record was marked as deleted.
APPLIED_COURSE_CD VARCHAR2 (6) Yes The program code under which the reference code is saved.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT AVU_REFERENCE_CD_ID
,      PERSON_ID
,      AV_STND_UNIT_ID
,      REFERENCE_CODE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DELETED_DATE
,      APPLIED_COURSE_CD
FROM IGS.IGS_AV_UNT_REF_CDS;

Dependencies

[top of page]

IGS.IGS_AV_UNT_REF_CDS does not reference any database object

IGS.IGS_AV_UNT_REF_CDS is referenced by following:

SchemaAPPS
SynonymIGS_AV_UNT_REF_CDS