[Home] [Help] [Dependency Information]
Object Name: | IGS_FI_FEE_RET_SCHD_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_FI_FEE_RET_SCHD_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | This field identifies a row in the data base. | |
FEE_CAL_TYPE | VARCHAR2 | (10) | Yes | Calendar type with calendar category FEE used in the assessment of student fees. |
FEE_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | This field uniquely identifies the calendar instance. |
S_RELATION_TYPE | VARCHAR2 | (10) | Yes | This field describes the system relation type to which the schedule entry belongs. |
SEQUENCE_NUMBER | NUMBER | (6) | Yes | A system-generated number which is used to uniquely identify the fee retention schedule. |
FEE_TYPE | VARCHAR2 | (10) | This field describes the fee types used for the purpose of applying fees and charges. A fee type may be used with many fee categories, permitting a single system wide fee definition to be used. Examples: HECS, GUILD. | |
FEE_CAT | VARCHAR2 | (10) | This field 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. | |
SCHEDULE_NUMBER | NUMBER | (6) | Yes | This field describes the sequence number which uniquely identifies a payment schedule. |
DT_ALIAS | VARCHAR2 | (10) | Yes | The code which identifies the date alias for the date alias instance from which the retention schedule entry starts. |
DAI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | fee_retention_schedule.dai_sequence_number |
START_DT | DATE | This field indicates the date from which the retention schedule entry applies. | ||
END_DT | DATE | This field indicates the date at which the retention schedule entry ends. | ||
RETENTION_PERCENTAGE | NUMBER | (5) | This field records the percentage of the student's previously assessed liability that the institution wishes to retain as a result of a re-assessment resulting in a reduction of liability. The amount retained is based on the student's maximum assessed liability during the period retention applies. If the student continues to reduce their liability once retention has been applied, the proportion of liability retained remains at the amount calculated when retention first applied. If the student increases their liability to an amount which is greater than the retained amount, any subsequent decrease in liability and retention calculation will be based on the higher assessment liability. | |
RETENTION_AMOUNT | NUMBER | |||
DEDUCTION_AMOUNT | NUMBER | This field indicates the amount that should be deducted from astudent's credit amount prior to a refund being issued. This comes into play once retention has already been appliedand the student still has an amount in credit.- Obsoleted Column. | ||
CURRENCY_CD | VARCHAR2 | (15) | The currency code of the fee assessment. | |
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, FEE_CAL_TYPE
, FEE_CI_SEQUENCE_NUMBER
, S_RELATION_TYPE
, SEQUENCE_NUMBER
, FEE_TYPE
, FEE_CAT
, SCHEDULE_NUMBER
, DT_ALIAS
, DAI_SEQUENCE_NUMBER
, START_DT
, END_DT
, RETENTION_PERCENTAGE
, RETENTION_AMOUNT
, DEDUCTION_AMOUNT
, CURRENCY_CD
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGS_FI_FEE_RET_SCHD_V;
|
|
|