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

TABLE: IGS.IGS_AD_CT_HECS_PAYOP

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


IGS_AD_CT_HECS_PAYOP describes admission HECS payment option, which enables fees to be assessed from admission fee category.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_AD_CT_HECS_PAYOP_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnADMISSION_CAT
ColumnHECS_PAYMENT_OPTION
IGS_AD_CT_HECS_PAYOP_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnHECS_PAYMENT_OPTION
Columns
Name Datatype Length Mandatory Comments
ADMISSION_CAT VARCHAR2 (10) Yes Institution-defined admission category code. An admission category is used to group a set of applicants whose applications will be processed by a common set of admission procedure steps.
HECS_PAYMENT_OPTION VARCHAR2 (10) Yes Describes the possible HECS payment options available to the admission category, for example, 10 - deferred,11 - up-front. These options will enable fees to be assessed from the admission fee category.
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
Query Text

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


SELECT ADMISSION_CAT
,      HECS_PAYMENT_OPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_AD_CT_HECS_PAYOP;

Dependencies

[top of page]

IGS.IGS_AD_CT_HECS_PAYOP does not reference any database object

IGS.IGS_AD_CT_HECS_PAYOP is referenced by following:

SchemaAPPS
SynonymIGS_AD_CT_HECS_PAYOP