[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_FI_FEE_TYPE_CI_H_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | IGS |
| FND Design Data: |  IGS.IGS_FI_FEE_TYPE_CI_H_ALL
|
| Subobject Name: | |
| Status: | VALID |
IGS_FI_FEE_TYPE_CI_H_ALL describes the history of changes to a fee type calendar instance.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGS_FI_FEE_TYPE_CI_H_ALL_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 FEE_TYPE
FEE_CAL_TYPE
FEE_CI_SEQUENCE_NUMBER
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. |
| FEE_CAL_TYPE | VARCHAR2 | (10) | Yes | Calendar type with calendar category fee. |
| FEE_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Uniquely identifies the calendar instance |
| 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. |
| FEE_TYPE_CI_STATUS | VARCHAR2 | (10) | Yes | Describes the status assigned to a fee type calendarinstance to indicate its current level of activity. |
| START_DT_ALIAS | VARCHAR2 | (10) | Code identifying the date alias for the date aliasinstance at that fee assessment processing starts. | |
| START_DAI_SEQUENCE_NUMBER | NUMBER | (6) | Uniquely identifies the start fee assessment processingdate alias instance. | |
| END_DT_ALIAS | VARCHAR2 | (10) | Code identifying the date alias for the date aliasinstance at that fee assessment processing ends. | |
| END_DAI_SEQUENCE_NUMBER | NUMBER | (6) | Uniquely identifies the end fee assessment processing datealias instance. | |
| RETRO_DT_ALIAS | VARCHAR2 | (10) | Code identifying the date alias for a date aliasinstance representing the period till that retrospective feeassessment can be made. The date alias instance can be optionally usedto define a period running past the fee calendar instance processingcycle. If not specified, retrospective fee assessments are notpermitted. | |
| RETRO_DAI_SEQUENCE_NUMBER | NUMBER | (6) | Uniquely identifies the retrospective fee assessmentprocessing date alias instance. | |
| S_CHG_METHOD_TYPE | VARCHAR2 | (10) | Describes the methods for determining the number of charge rate units for use in a fee assessment calculation. For example, flat rate, per eftsu load, per unit student unit attempts, per credit point enrolled . Note, per eftsu, per unit and per credit point only apply to enrollment fee classifications. | |
| RUL_SEQUENCE_NUMBER | NUMBER | (6) | Uniquely identifies a rule | |
| FIN_CAL_TYPE | VARCHAR2 | (10) | Calendar type of finance category - Obsolete Column | |
| FIN_CI_SEQUENCE_NUMBER | NUMBER | (6) | This field uniquely identifies the calendar instance of finance category - Obsolete Column | |
| ACCOUNT_CD | VARCHAR2 | (40) | General ledger account code specific to a financial reporting period. - Obsolete Column | |
| PAYMENT_HIERARCHY_RANK | NUMBER | (5) | Ranking of the payment to implement the apportionment hierarchy. Partial payments will be allocated firstly to invoice lines fee types of a higher rank. | |
| INITIAL_DEFAULT_AMOUNT | NUMBER | The amount that is used by the Fee Assessment when run in the Initial Default or Initial Prior modes. | ||
| 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 | |
| NONZERO_BILLABLE_CP_FLAG | VARCHAR2 | (1) | Flag to identify if fee needs to be assessed for any student unit attempt with zero billable credit point. | |
| SCOPE_RUL_SEQUENCE_NUM | NUMBER | (6) | Rule Sequence Number which defines the Fee Assessment Scope for a Fee Type Calendar Instance | |
| ELM_RNG_ORDER_NAME | VARCHAR2 | (30) | Element Range Order Name which defines the order in which fee assessment computes fees. | |
| MAX_CHG_ELEMENTS | NUMBER | (7) | The maximum number of charge elements that will be considered for charge amount calculation during Fee Assessment |
Cut, paste (and edit) the following text to query this object:
SELECT FEE_TYPE
, FEE_CAL_TYPE
, FEE_CI_SEQUENCE_NUMBER
, HIST_START_DT
, HIST_END_DT
, HIST_WHO
, FEE_TYPE_CI_STATUS
, START_DT_ALIAS
, START_DAI_SEQUENCE_NUMBER
, END_DT_ALIAS
, END_DAI_SEQUENCE_NUMBER
, RETRO_DT_ALIAS
, RETRO_DAI_SEQUENCE_NUMBER
, S_CHG_METHOD_TYPE
, RUL_SEQUENCE_NUMBER
, FIN_CAL_TYPE
, FIN_CI_SEQUENCE_NUMBER
, ACCOUNT_CD
, PAYMENT_HIERARCHY_RANK
, INITIAL_DEFAULT_AMOUNT
, ORG_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, NONZERO_BILLABLE_CP_FLAG
, SCOPE_RUL_SEQUENCE_NUM
, ELM_RNG_ORDER_NAME
, MAX_CHG_ELEMENTS
FROM IGS.IGS_FI_FEE_TYPE_CI_H_ALL;
IGS.IGS_FI_FEE_TYPE_CI_H_ALL does not reference any database object
IGS.IGS_FI_FEE_TYPE_CI_H_ALL is referenced by following:
APPS
IGS_FI_FEE_TYPE_CI_H_ALL
|
|
|
|