[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_FI_FEE_ASS_DEBT_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_FI_FEE_ASS_DEBT_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
No longer used.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PERSON_ID | NUMBER | (15) | Yes | A unique student information system identification number, typically incorporating a check digit, used to identify a particular person. |
| FIN_CAL_TYPE | VARCHAR2 | (10) | The code of a calendar with a category of financial. Fee assessment calendars must be subordinate to an instance of a financial calendar. - Obsolete Column | |
| FIN_CI_SEQUENCE_NUMBER | NUMBER | (6) | ACCOUNT.FIN_CI_SEQUENCE_NUMBER - Obsolete Column | |
| FEE_TYPE | VARCHAR2 | (10) | Yes | The code of the fee type that is the subject of the fee assessment |
| FEE_CAL_TYPE | VARCHAR2 | (10) | Yes | The code of a calendar type with a calendar category of Fee. Fee category calendars are used in the assessment of student fees. |
| FEE_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | FEE_ASS.FEE_CI_SEQUENCE_NUMBER |
| FEE_CAT | VARCHAR2 | (10) | Fee categories are created to identify distinct fee assessment groups. Fee categories can contain one or more fee types, these fee types are known as liabilities once they are allocated to a fee category. The fee category assigned to a student program attempt determines the fees for that they are potentially liable. | |
| COURSE_CD | VARCHAR2 | (6) | The code of the student program attempt that triggered the fee assessment | |
| LAST_TRANSACTION_DT | DATE | The date of the last fee transaction | ||
| LAST_EFFECTIVE_ASSESSMENT_DT | DATE | The date of the last effective fee assessment | ||
| LAST_NOTIFICATION_DT | DATE | The date the student, or their sponsor was last notified of the fee assessment. | ||
| ASSESSMENT_AMOUNT | NUMBER | The assessment amount of the fee type within a particular fee assessment period | ||
| CURRENCY_CD | VARCHAR2 | (15) | Yes | The currency code of the fee assessment |
| LOCAL_CURRENCY_CD | VARCHAR2 | (15) | The code of the "local" currency | |
| LOCAL_ASSESSMENT_AMOUNT | NUMBER | The amount of the fee assessment, expressed in the "local" currency | ||
| MANUAL_ENTRY_IND | VARCHAR2 | (1) | Indicates and specifies if the fee assessment was a manual or system calculated assessment. A ticked check box signifies that the assessment was manual. |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, FIN_CAL_TYPE
, FIN_CI_SEQUENCE_NUMBER
, FEE_TYPE
, FEE_CAL_TYPE
, FEE_CI_SEQUENCE_NUMBER
, FEE_CAT
, COURSE_CD
, LAST_TRANSACTION_DT
, LAST_EFFECTIVE_ASSESSMENT_DT
, LAST_NOTIFICATION_DT
, ASSESSMENT_AMOUNT
, CURRENCY_CD
, LOCAL_CURRENCY_CD
, LOCAL_ASSESSMENT_AMOUNT
, MANUAL_ENTRY_IND
FROM APPS.IGS_FI_FEE_ASS_DEBT_V;
APPS
IGS_FI_CONTROL
IGS_FI_FEE_AS
IGS_FI_F_TYP_CA_INST
IGS_FI_GEN_001
- show dependent code
IGS_LOOKUPS_VIEW
APPS.IGS_FI_FEE_ASS_DEBT_V is not referenced by any database object
|
|
|
|