[Home] [Help] [Dependency Information]
Object Name: | IGS_EN_ATD_TYPE_LOAD_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_EN_ATD_TYPE_LOAD_ALL |
Subobject Name: | |
Status: | VALID |
IGS_EN_ATD_TYPE_LOAD_ALL describes relationship between load calendar type and attendance types. The purpose of the table is to define the load ranges within the load calendar that define the different attendance types.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_EN_ATD_TYPE_LOAD_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CAL_TYPE
ATTENDANCE_TYPE |
IGS_EN_ATD_TYPE_LOAD_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ATTENDANCE_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CAL_TYPE | VARCHAR2 | (10) | Yes | Name of a load calendar type associated with the specified attendance type. Load calendars are used to determine student program attendance type, student EFTSU, credit point-based fees, HECS liabilities for reporting to government. |
ATTENDANCE_TYPE | VARCHAR2 | (2) | Yes | Describes the attendance types for a program. For example, Full-time, Part-time. DETYA element reference 330. |
LOWER_ENR_LOAD_RANGE | NUMBER | (7) | Yes | Value that determines the lower limit of the attendance type load range for the specified load calendar type. |
UPPER_ENR_LOAD_RANGE | NUMBER | (7) | Yes | Value that determines the upper limit of the attendance type load range for the specified load calendar type. |
DEFAULT_EFTSU | NUMBER | (7) | Field describes the EFTSU value that is the default for the context institution-defined attendance type within a load calendar. | |
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 | |
ORG_ID | NUMBER | (15) | Operating unit identifier |
Cut, paste (and edit) the following text to query this object:
SELECT CAL_TYPE
, ATTENDANCE_TYPE
, LOWER_ENR_LOAD_RANGE
, UPPER_ENR_LOAD_RANGE
, DEFAULT_EFTSU
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
FROM IGS.IGS_EN_ATD_TYPE_LOAD_ALL;
IGS.IGS_EN_ATD_TYPE_LOAD_ALL does not reference any database object
IGS.IGS_EN_ATD_TYPE_LOAD_ALL is referenced by following:
|
|
|