[Home] [Help] [Dependency Information]
Object Name: | IGS_EN_ATD_TYPE_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_EN_ATD_TYPE_ALL |
Subobject Name: | |
Status: | VALID |
IGS_EN_ATD_TYPE_ALL describes available university program attendance types. Examples include full-time and part-time.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_EN_ATD_TYPE_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ATTENDANCE_TYPE |
IGS_EN_ATD_TYPE_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | GOVT_ATTENDANCE_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ATTENDANCE_TYPE | VARCHAR2 | (2) | Yes | Code of an institution-defined attendance type. An attendance type identifies whether a student is classified as part-time or full-time in the program, based on their study load in the reference year. |
DESCRIPTION | VARCHAR2 | (60) | Yes | Description of an institution-defined attendance type. An attendance type identifies whether a student is classified as part-time or full-time in the program, based on their study load in the reference year. |
GOVT_ATTENDANCE_TYPE | VARCHAR2 | (30) | Yes | Code of a government attendance type, DETYA element 330. An attendance type identifies whether a student is classified as part-time or full-time in the program, based on their study load in the reference year. |
LOWER_ENR_LOAD_RANGE | NUMBER | (7) | Yes | Lower end of the enrolment load range, in EFTSU, that defines the attendance type. The range specified by the lower and upper load values is used by the system to derive the student program attendance type in an academic period. |
UPPER_ENR_LOAD_RANGE | NUMBER | (7) | Yes | Upper end of the enrolment load range that defines the attendance type. The range specified by the lower and upper load values is used by the system to derive the student program attendance type in an academic period. |
RESEARCH_PERCENTAGE | NUMBER | (5) | Describes the default attendance percentage for a given attendance type. Attendance percentage is one of the factors considered in the calculation of minimum and maximum submission dates for research students. | |
CLOSED_IND | VARCHAR2 | (1) | Yes | Indicator that specifies if the attendance type is open or closed. Setting the checkbox to 'closed' prevents use of the attendance type in new program offering option records. |
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 ATTENDANCE_TYPE
, DESCRIPTION
, GOVT_ATTENDANCE_TYPE
, LOWER_ENR_LOAD_RANGE
, UPPER_ENR_LOAD_RANGE
, RESEARCH_PERCENTAGE
, CLOSED_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
FROM IGS.IGS_EN_ATD_TYPE_ALL;
IGS.IGS_EN_ATD_TYPE_ALL does not reference any database object
IGS.IGS_EN_ATD_TYPE_ALL is referenced by following:
|
|
|