[Home] [Help] [Dependency Information]
Object Name: | IGS_FI_HECS_PAY_OPTN |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_FI_HECS_PAY_OPTN |
Subobject Name: | |
Status: | VALID |
IGS_FI_HECS_PAY_OPTN describes the list of possible contribution payment options. For example,10 - Deferred, 11 -Upfront, 24 - Overseas students.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_FI_HECS_PAY_OPTN_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | HECS_PAYMENT_OPTION |
IGS_FI_HECS_PAY_OPTN_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | GOVT_HECS_PAYMENT_OPTION |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HECS_PAYMENT_OPTION | VARCHAR2 | (10) | Yes | This field describes the possible Contribution payment options.Examples DEFERRED, UPFRONT, EXEMPT. |
GOVT_HECS_PAYMENT_OPTION | VARCHAR2 | (10) | This field describes the possible types of Contribution payment options | |
DESCRIPTION | VARCHAR2 | (60) | Yes | This field provides an explanation of the Contribution payment option. |
EXPIRE_AFTR_ACDMC_PERD_IND | VARCHAR2 | (1) | Yes | This field describes whether students having this Contribution option have their option expire at the end of the current academic period.Setting the indicator means that the Contribution option of students who have this option will expire at the end of the academic period. |
CLOSED_IND | VARCHAR2 | (1) | Yes | This field describes whether the Contribution payment option is open orclosed. Setting the indicator to 'closed' means that the Contribution payment option cannot be used in new or modified student Contribution records. |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT HECS_PAYMENT_OPTION
, GOVT_HECS_PAYMENT_OPTION
, DESCRIPTION
, EXPIRE_AFTR_ACDMC_PERD_IND
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_FI_HECS_PAY_OPTN;
IGS.IGS_FI_HECS_PAY_OPTN does not reference any database object
IGS.IGS_FI_HECS_PAY_OPTN is referenced by following:
|
|
|