[Home] [Help] [Dependency Information]
Object Name: | IGS_FI_FEE_CAT_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_FI_FEE_CAT_ALL |
Subobject Name: | |
Status: | VALID |
IGS_FI_FEE_CAT_ALL describes the fee categories applicable to enrolled students. The purpose of the fee category is to identify the distinct fee assessment groups assigned fee type liabilities.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_FI_FEE_CAT_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | FEE_CAT |
IGS_FI_FEE_CAT_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CURRENCY_CD |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FEE_CAT | VARCHAR2 | (10) | Yes | Fee categories are created to identify distinct fee assessment groupsand may contain one or more fee types. |
DESCRIPTION | VARCHAR2 | (60) | Yes | Description of the fee category created to identify distinct fee assessment groups. |
CURRENCY_CD | VARCHAR2 | (15) | Currency codes in that fee assessments and payments might be made. If not defined, fee assessments default to the local currency. | |
CLOSED_IND | VARCHAR2 | (1) | Yes | Indicator that specifies if the fee category is open or closed. Setting the checkbox to 'closed' ticked prevents use of the category in new records. The fee category will continue to operate where the category was assigned to a student program attempt prior to closure. |
ORG_ID | NUMBER | (15) | Operating unit identifier | |
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 FEE_CAT
, DESCRIPTION
, CURRENCY_CD
, CLOSED_IND
, ORG_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_FI_FEE_CAT_ALL;
IGS.IGS_FI_FEE_CAT_ALL does not reference any database object
IGS.IGS_FI_FEE_CAT_ALL is referenced by following:
|
|
|