[Home] [Help] [Dependency Information]
Object Name: | IGS_FI_FEE_AS_RT_HT_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_FI_FEE_AS_RT_HT_ALL |
Subobject Name: | |
Status: | VALID |
IGS_FI_FEE_AS_RT_HT_ALL describes the history of changes to a contract fee assessment rate.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_FI_FEE_AS_RT_HT_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PERSON_ID
COURSE_CD FEE_TYPE START_DT HIST_START_DT |
IGS_FI_FEE_AS_RT_HT_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | FEE_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | (15) | Yes | Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value. |
COURSE_CD | VARCHAR2 | (6) | Yes | Describes program code |
FEE_TYPE | VARCHAR2 | (10) | Yes | Describes the fee types used for the purpose of applying fees and charges. A fee type might be used with many fee categories, permitting a single system wide fee definition to be used. For example, contribution, guild. |
START_DT | DATE | Yes | Describes the date a contract fee assessment rate is effective from. | |
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. |
END_DT | DATE | Describes the date a contract fee assessment rate is no longer effective. | ||
LOCATION_CD | VARCHAR2 | (10) | Describes the program locations for that the fee should be assessed. If the field is left blank, the assessment rate applies to all locations. If a value is entered the contract rate applies only to the nominated location. | |
ATTENDANCE_TYPE | VARCHAR2 | (2) | Describes the attendance types for that the fee should be assessed. These types are user-defined. For example, full-time ,part-time. If the field is left blank the assessment rate applies to all attendance types. If a value is entered the contract rate applies only to the nominated attendance type. | |
ATTENDANCE_MODE | VARCHAR2 | (2) | Describes the attendance modes for that the fee should be assessed. These modes are user-defined. For example , on campus, off campus. If the field is left blank, the assessment rate applies to all attendance modes. If a value is entered the contract rate applies only to the nominated attendance mode. | |
CHG_RATE | NUMBER | Describes the monetary value of the contract fee assessment rate. | ||
LOWER_NRML_RATE_OVRD_IND | VARCHAR2 | (1) | Describes whether or not a lower normal fee assessment rate will override the contract fee assessment rate. | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, COURSE_CD
, FEE_TYPE
, START_DT
, HIST_START_DT
, HIST_END_DT
, HIST_WHO
, END_DT
, LOCATION_CD
, ATTENDANCE_TYPE
, ATTENDANCE_MODE
, CHG_RATE
, LOWER_NRML_RATE_OVRD_IND
, ORG_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_FI_FEE_AS_RT_HT_ALL;
IGS.IGS_FI_FEE_AS_RT_HT_ALL does not reference any database object
IGS.IGS_FI_FEE_AS_RT_HT_ALL is referenced by following:
|
|
|