[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_FI_F_CAT_FEE_LBL_SCA_PRR_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_FI_F_CAT_FEE_LBL_SCA_PRR_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Describes the fee types applicable to a fee category period, fee category calendar instance for even the prior fee calnedars and describes it in relation to a student's attempt at studying a particular program offered by the university.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PERSON_ID | NUMBER | (15) | Yes | Describes the ID code that uniquely identifies a person |
| COURSE_CD | VARCHAR2 | (6) | Yes | A code used to identify the course in which the student is enrolled. |
| VERSION_NUMBER | NUMBER | (3) | Yes | A number signifying the version of the course in that the student enrolls. |
| CAL_TYPE | VARCHAR2 | (10) | Yes | The name of the calendar type in that the course is offered. It is usual for award courses to be offered in the standard academic calendar. |
| LOCATION_CD | VARCHAR2 | (10) | Yes | The location, typically a campus, if the student's course is offered |
| ATTENDANCE_MODE | VARCHAR2 | (2) | Yes | The institution-defined attendance modes in that the course is offered. Institution-defined attendance modes can include, for example, N, on campus, F, off campus and M multi-modal. When displayed in the student course attempt inquiry this field displays the derived attendance mode and attendance type for enrolled courses. |
| ATTENDANCE_TYPE | VARCHAR2 | (2) | Yes | The institution-defined attendance type in that the course is offered. Institution-defined attendance types can include, for example, F, full-time and P part-time. |
| HECS_PAYMENT_OPTION | VARCHAR2 | (4000) | The contribution payment option relevant to a fee assessment period | |
| COURSE_ATTEMPT_STATUS | VARCHAR2 | (30) | The student course attempt status is a system derived value and will be one of the following: unconfirmed, inactive, enrolled, discontinued, intermitted, lapsed or completed. Under certain circumstances a course may also have been deleted. | |
| COMMENCEMENT_DT | DATE | The date on that the student commenced the current course for the first time. | ||
| DISCONTINUED_DT | DATE | The effective date on that the student's course attempt was discontinued. | ||
| FEE_ASS_IND | VARCHAR2 | (1) | Describes whether or not to count student program attempts with these statuses in fee assessments | |
| FEE_CAT | VARCHAR2 | (10) | 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. | |
| FEE_CAL_TYPE | VARCHAR2 | (10) | Yes | Calendar type with calendar category fee |
| FEE_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Uniquely identifies the calendar instance |
| 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. However, once a fee type is allocated to a fee category it is known as a liability. A fee type that is a liability in more than one fee category may have different attributes in each of these categories. |
| S_FEE_TYPE | VARCHAR2 | (10) | Yes | Describes the system recognized fee types. For example, tution and other. It is used primarily for reporting fee details to the government. Tution are reported to the government whereas other is not. |
| S_FEE_TRIGGER_CAT | VARCHAR2 | (10) | Yes | Describes the system defined fee trigger category applicable to the fee type. It is used to restrict the fee triggers that can be defined for a fee category fee liability of the fee type. For example,program and institution. |
| FEE_LIABILITY_STATUS | VARCHAR2 | (10) | Yes | Describes the status assigned to a fee category fee liability to indicate its current level of activity. These statuses are user-definable and will map back onto the system fee liability statuses that will define the attached functionality. For example, active, inactive, planned. |
| START_DT_ALIAS | VARCHAR2 | (10) | The code that identifies the start date alias for the date alias instance at that fee assessment processing begins. | |
| START_DAI_SEQUENCE_NUMBER | NUMBER | Uniquely identifies the start fee assessment processing date alias instance | ||
| START_DT | DATE | Uiquely identifies the start fee assessment processing date alias instance | ||
| END_DT_ALIAS | VARCHAR2 | (10) | Code identifying the date alias for the date alias instance at which fee assessment processing ends | |
| END_DAI_SEQUENCE_NUMBER | NUMBER | Uniquely identifies the end fee assessment processing date alias instance | ||
| END_DT | DATE | Uniquely identifies the end fee assessment processing date alias instance | ||
| RETRO_DT_ALIAS | VARCHAR2 | (10) | The code which identifies the date alias for a date alias instance representing the period until retrospective fee assessment can be made. The date alias instance can be optionally used to define a period running past the fee calendar instance processing cycle. If not specified, retrospective fee assessments are not permitted. | |
| RETRO_DAI_SEQUENCE_NUMBER | NUMBER | Uniquely identifies the retrospective fee assessment processing date alias instance | ||
| RETRO_DT | DATE | Uniquely identifies the retrospective fee assessment processing date alias instance | ||
| S_CHG_METHOD_TYPE | VARCHAR2 | (30) | Describes the methods for determining the number of "charge elements" for use in a fee assessment calculation. For example, point, enrolled. Note: Per effective full time student, per unit and per credit point only apply to enrollment fee classifications. | |
| RUL_SEQUENCE_NUMBER | NUMBER | Uniquely identifies the rule that will be used in the assessment of fees | ||
| CURRENCY_CD | VARCHAR2 | (15) | Contains the currency codes that fee liabilities and payments can be made | |
| 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 | |
| PRIMARY_PROGRAM_TYPE | VARCHAR2 | (10) | Type of the program attempt. | |
| KEY_PROGRAM | VARCHAR2 | (1) | Key Program Indicator. |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, COURSE_CD
, VERSION_NUMBER
, CAL_TYPE
, LOCATION_CD
, ATTENDANCE_MODE
, ATTENDANCE_TYPE
, HECS_PAYMENT_OPTION
, COURSE_ATTEMPT_STATUS
, COMMENCEMENT_DT
, DISCONTINUED_DT
, FEE_ASS_IND
, FEE_CAT
, FEE_CAL_TYPE
, FEE_CI_SEQUENCE_NUMBER
, FEE_TYPE
, S_FEE_TYPE
, S_FEE_TRIGGER_CAT
, FEE_LIABILITY_STATUS
, START_DT_ALIAS
, START_DAI_SEQUENCE_NUMBER
, START_DT
, END_DT_ALIAS
, END_DAI_SEQUENCE_NUMBER
, END_DT
, RETRO_DT_ALIAS
, RETRO_DAI_SEQUENCE_NUMBER
, RETRO_DT
, S_CHG_METHOD_TYPE
, RUL_SEQUENCE_NUMBER
, CURRENCY_CD
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PRIMARY_PROGRAM_TYPE
, KEY_PROGRAM
FROM APPS.IGS_FI_F_CAT_FEE_LBL_SCA_PRR_V;
APPS
IGS_CA_DA_INST_V
IGS_CA_GEN_001
- show dependent code
IGS_CA_GEN_002
- show dependent code
IGS_EN_GEN_002
- show dependent code
IGS_EN_STDNT_PS_ATT
IGS_FI_FEE_TYPE
IGS_FI_F_CAT_FEE_LBL_V
IGS_FI_GEN_001
- show dependent code
IGS_LOOKUPS_VIEW
APPS.IGS_FI_F_CAT_FEE_LBL_SCA_PRR_V is not referenced by any database object
|
|
|
|