[Home] [Help] [Dependency Information]
Object Name: | IGS_FI_GOVT_HEC_CNTB |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_FI_GOVT_HEC_CNTB |
Subobject Name: | |
Status: | VALID |
IGS_FI_GOVT_HEC_CNTB describes the list of government defined HECS, Higher Education Contribution Scheme, contribution bands. These bands are mapped against government discipline groups.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_FI_GOVT_HEC_CNTB_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | GOVT_HECS_CNTRBTN_BAND |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GOVT_HECS_CNTRBTN_BAND | NUMBER | (2) | Yes | Contains the government contribution band. These contribution bands are mapped to government discipline groups and are relevant in calculating the contribution liability applicable to a unit ofstudy. |
DESCRIPTION | VARCHAR2 | (60) | Yes | Describes the government contribution band. |
CLOSED_IND | VARCHAR2 | (1) | Yes | Indicator that specifies if the government contribution band is open or closed. Setting the checkbox to closed prevents use of the contribution band in new or modified records in other parts of the system. |
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_CNTRBTN_BAND
, DESCRIPTION
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_FI_GOVT_HEC_CNTB;
IGS.IGS_FI_GOVT_HEC_CNTB does not reference any database object
IGS.IGS_FI_GOVT_HEC_CNTB is referenced by following:
|
|
|