[Home] [Help] [Dependency Information]
Object Name: | IGS_FI_GOV_HEC_PA_OP |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_FI_GOV_HEC_PA_OP |
Subobject Name: | |
Status: | VALID |
IGS_FI_GOV_HEC_PA_OP describes the list of government defined HECS, Higher Education Contribution Scheme, payment options.These options are what is reported to the government in the submissions, so the institutionally defined options must map back onto these for that purpose.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_FI_GOV_HEC_PA_OP_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | GOVT_HECS_PAYMENT_OPTION |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GOVT_HECS_PAYMENT_OPTION | VARCHAR2 | (10) | Yes | Government-defined contribution payment option code. These codes are used for reporting student contribution details to Government. |
DESCRIPTION | VARCHAR2 | (60) | Yes | Description of the government contribution payment option. These codes are used for reporting student contribution details to Government. |
S_HECS_PAYMENT_TYPE | VARCHAR2 | (30) | Yes | Name of the system-defined contribution payment type to that the government contribution payment option is mapped. This mapping enables the system to determine how students will discharge their contribution liability. |
ALLOW_DISCOUNT_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether the government contribution payment option allows discount for up-front and partial payments. Setting the indicator allows the discount. To comply with 1998 contribution guidelines, the indicator should be ticked for options 10 and 11. |
CLOSED_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether the government contribution payment option is open or closed. If closed, the option cannot be linked to any further institution-defined contribution payment options. |
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 GOVT_HECS_PAYMENT_OPTION
, DESCRIPTION
, S_HECS_PAYMENT_TYPE
, ALLOW_DISCOUNT_IND
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_FI_GOV_HEC_PA_OP;
IGS.IGS_FI_GOV_HEC_PA_OP does not reference any database object
IGS.IGS_FI_GOV_HEC_PA_OP is referenced by following:
|
|
|