[Home] [Help] [Dependency Information]
Object Name: | IGS_AS_STD_EXM_INSTN_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AS_STD_EXM_INSTN_ALL |
Subobject Name: | |
Status: | VALID |
IGS_AS_STD_EXM_INSTN_ALL describes relationship between student unit attempt and time-tabled examination instance.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AS_STD_EXM_INSTN_ALL_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | STD_EXM_INSTN_ID |
IGS_AS_STD_EXM_INSTN_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ASS_ID
EXAM_CAL_TYPE EXAM_CI_SEQUENCE_NUMBER VENUE_CD |
IGS_AS_STD_EXM_INSTN_ALL_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ESE_ID |
IGS_AS_STD_EXM_INSTN_ALL_U1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PERSON_ID
COURSE_CD UOO_ID ASS_ID CREATION_DT EXAM_CAL_TYPE EXAM_CI_SEQUENCE_NUMBER DT_ALIAS DAI_SEQUENCE_NUMBER END_TIME START_TIME VENUE_CD |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASS_ID | NUMBER | (10) | Yes | The ID of the assessment item examination. |
EXAM_CAL_TYPE | VARCHAR2 | (10) | Yes | The examination calendar type in which the examination is timetabled. |
EXAM_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | The examination calendar sequence number. |
DT_ALIAS | VARCHAR2 | (10) | Yes | The date alias instance on which the examination session is held. |
DAI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | The examination session date alias instance sequence number. |
START_TIME | DATE | Yes | The start time of the examination. | |
END_TIME | DATE | Yes | The end time of the examination. | |
ESE_ID | NUMBER | (6) | Yes | The examination session ID. |
VENUE_CD | VARCHAR2 | (10) | Yes | The code which describes the venue in which the examination is being held. |
PERSON_ID | NUMBER | (15) | Yes | The person ID of the student. |
COURSE_CD | VARCHAR2 | (6) | Yes | The code of the student's program attempt. |
UNIT_CD | VARCHAR2 | (10) | Yes | The unit code being examined. |
CAL_TYPE | VARCHAR2 | (10) | Yes | The teaching calendar type in which the student unit attempt is enrolled. |
CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | The teaching calendar sequence number in which the unit being examined is being studied. |
CREATION_DT | DATE | Yes | The date the student examination instance was created. | |
ATTENDANCE_IND | VARCHAR2 | (1) | Yes | Indicates and specifies if or not the student attended the examination. When the checkbox is set ticked, the student is flagged as having attended. |
TIMESLOT | DATE | The timeslot allocated to the student within the examination session. Timeslots are used when individual appointments are scheduled for students. For example, music performance. | ||
TIMESLOT_DURATION | DATE | The duration of the student's timeslot. Timeslots are used when individual appointments are scheduled for students. For example, music performance. | ||
SEAT_NUMBER | NUMBER | (4) | The seat number allocated to the student for the examination. | |
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 | |
UOO_ID | NUMBER | (7) | Yes | Unit Section identifier |
STD_EXM_INSTN_ID | NUMBER | (7) | Yes | Unique identifier |
Cut, paste (and edit) the following text to query this object:
SELECT ASS_ID
, EXAM_CAL_TYPE
, EXAM_CI_SEQUENCE_NUMBER
, DT_ALIAS
, DAI_SEQUENCE_NUMBER
, START_TIME
, END_TIME
, ESE_ID
, VENUE_CD
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, CREATION_DT
, ATTENDANCE_IND
, TIMESLOT
, TIMESLOT_DURATION
, SEAT_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
, UOO_ID
, STD_EXM_INSTN_ID
FROM IGS.IGS_AS_STD_EXM_INSTN_ALL;
IGS.IGS_AS_STD_EXM_INSTN_ALL does not reference any database object
IGS.IGS_AS_STD_EXM_INSTN_ALL is referenced by following:
|
|
|