[Home] [Help] [Dependency Information]
Object Name: | IGS_FI_FEE_TYPE_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_FI_FEE_TYPE_ALL |
Subobject Name: | |
Status: | VALID |
IGS_FI_FEE_TYPE_ALL describes the fee types used throughout the system for the purpose of applying fees and charges.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_FI_FEE_TYPE_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | FEE_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FEE_TYPE | VARCHAR2 | (10) | Yes | Fee types used for the purpose of applying fees and charges. A fee type can be used with many fee categories, permitting a single system wide fee definition to be used. For example, hecs, guild. |
S_FEE_TYPE | VARCHAR2 | (10) | Yes | Describes the system recognized fee types hecs, tuition, and other. The system type determines characteristics of the fee and determines those that are reported to the commonwealth government hecs, tuition and those that are not other . |
S_FEE_TRIGGER_CAT | VARCHAR2 | (10) | Yes | Describes the system defined fee trigger category applicable to the fee type. |
DESCRIPTION | VARCHAR2 | (60) | Yes | Provides an explanation of the fee type. |
OPTIONAL_PAYMENT_IND | VARCHAR2 | (1) | Yes | Indicator that specifies whether payment of assessed amounts is optional or mandatory. |
CLOSED_IND | VARCHAR2 | (1) | Yes | Indicator that specifies if the fee type is open or closed. Setting the checkbox to closed ticked prevents use of the fee type in new or modified records in other parts of the system. |
COMMENTS | VARCHAR2 | (2000) | Contains any comments or notes applicable to the fee type. | |
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 | |
FEE_CLASS | VARCHAR2 | (30) | This Column is used to group the fee types so that once a charge is created for the person for any of the fee type, the Financial Aid Disbursement can look at this value tagged for the particular fee type for disbursement of funds. | |
SUBACCOUNT_ID | NUMBER | (15) | No longer used. | |
DESIGNATED_PAYMENT_FLAG | VARCHAR2 | (1) | This flag indicates whether the particular Fee Type can be included in Targeted Applications in the context of self-service or lockbox. |
Cut, paste (and edit) the following text to query this object:
SELECT FEE_TYPE
, S_FEE_TYPE
, S_FEE_TRIGGER_CAT
, DESCRIPTION
, OPTIONAL_PAYMENT_IND
, CLOSED_IND
, COMMENTS
, ORG_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, FEE_CLASS
, SUBACCOUNT_ID
, DESIGNATED_PAYMENT_FLAG
FROM IGS.IGS_FI_FEE_TYPE_ALL;
IGS.IGS_FI_FEE_TYPE_ALL does not reference any database object
IGS.IGS_FI_FEE_TYPE_ALL is referenced by following:
|
|
|