[Home] [Help] [Dependency Information]
Object Name: | IGS_FI_FEE_TYPE_HIST_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_FI_FEE_TYPE_HIST_ALL |
Subobject Name: | |
Status: | VALID |
IGS_FI_FEE_TYPE_HIST_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_HIST_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
FEE_TYPE
HIST_START_DT |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FEE_TYPE | VARCHAR2 | (10) | Yes | Describes the 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. |
HIST_START_DT | DATE | Yes | Effective start date and time of the history record. | |
HIST_END_DT | DATE | Yes | Effective end date and time of the history record. | |
HIST_WHO | NUMBER | (15) | Yes | Updated by person at the time of the history. |
S_FEE_TYPE | VARCHAR2 | (10) | Describes the system recognized fee types. For example, hecs, tuition. It is used primarily for reporting fee details to the government. | |
S_FEE_TRIGGER_CAT | VARCHAR2 | (10) | Describes the system defined fee trigger categoryapplicable to the fee type. It is used to restrict the fee triggersthat can be defined for a fee category fee liability of the fee type. | |
DESCRIPTION | VARCHAR2 | (60) | Provides an explanation of the fee type. | |
OPTIONAL_PAYMENT_IND | VARCHAR2 | (1) | Indicates if a payment is required for assessments made of this fee type. When checked payment is optional. Penalties or encumbrances cannot be applied to overdue optional payments. | |
CLOSED_IND | VARCHAR2 | (1) | 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. | |
FEE_CLASS | VARCHAR2 | (30) | This Column is used to group the fee types. | |
SUBACCOUNT_ID | NUMBER | (15) | OBSOLETE. Sub Account Identifier. | |
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 | |
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
, HIST_START_DT
, HIST_END_DT
, HIST_WHO
, S_FEE_TYPE
, S_FEE_TRIGGER_CAT
, DESCRIPTION
, OPTIONAL_PAYMENT_IND
, CLOSED_IND
, COMMENTS
, FEE_CLASS
, SUBACCOUNT_ID
, ORG_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, DESIGNATED_PAYMENT_FLAG
FROM IGS.IGS_FI_FEE_TYPE_HIST_ALL;
IGS.IGS_FI_FEE_TYPE_HIST_ALL does not reference any database object
IGS.IGS_FI_FEE_TYPE_HIST_ALL is referenced by following:
|
|
|