[Home] [Help] [Dependency Information]
Object Name: | IGS_AS_EXM_SES_VN_SP |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AS_EXM_SES_VN_SP |
Subobject Name: | |
Status: | VALID |
IGS_AS_EXM_SES_VN_SP describes linking of examination supervisor to examination session venue.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AS_EXM_SES_VN_SP_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PERSON_ID
EXAM_CAL_TYPE EXAM_CI_SEQUENCE_NUMBER DT_ALIAS DAI_SEQUENCE_NUMBER START_TIME VENUE_CD END_TIME |
IGS_AS_EXM_SES_VN_SP_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EXAM_SUPERVISOR_TYPE |
IGS_AS_EXM_SES_VN_SP_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ESE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | (15) | Yes | The person ID of the supervisor. |
EXAM_CAL_TYPE | VARCHAR2 | (10) | Yes | The examination calendar in which the supervised examinations arescheduled. |
EXAM_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | The examination calendar sequence number. |
DT_ALIAS | VARCHAR2 | (10) | Yes | The examination session date alias instance. |
DAI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | The examination session date alias instance sequence number. |
START_TIME | DATE | Yes | The start time of the examination session. | |
END_TIME | DATE | Yes | The end time of the examination session. | |
ESE_ID | NUMBER | (6) | Yes | The examination session ID. |
VENUE_CD | VARCHAR2 | (10) | Yes | The venue code of the venue in which the examination is beingsupervised. |
EXAM_SUPERVISOR_TYPE | VARCHAR2 | (10) | Yes | The supervisor type assigned to the supervisor. Supervisor type forthe exam session venue is inherited from the supervisor's pre-assignedtype, but may be overridden here. It is an indication of the level ofresponsibility allocated to the supervisor, and the role they willplay in the supervision of exams. For example, chief, assistant |
OVERRIDE_START_TIME | DATE | The time a supervisor commences supervision of an examination session. If no value is specified the system will default to the start time of the examination session. For example, the supervisor may be required to start earlier to assist with setting up and will therefore have a start time that is earlier that the standard session start time. | ||
OVERRIDE_END_TIME | DATE | The time a supervisor ends supervision of an examination session. If no value is specified, the system will take the default value to the end time of the examination session. For example, the supervisor may be required to stay later to assist with packing up and may therefor have an end time that is later than the standard session end time. | ||
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
, EXAM_CAL_TYPE
, EXAM_CI_SEQUENCE_NUMBER
, DT_ALIAS
, DAI_SEQUENCE_NUMBER
, START_TIME
, END_TIME
, ESE_ID
, VENUE_CD
, EXAM_SUPERVISOR_TYPE
, OVERRIDE_START_TIME
, OVERRIDE_END_TIME
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_AS_EXM_SES_VN_SP;
IGS.IGS_AS_EXM_SES_VN_SP does not reference any database object
IGS.IGS_AS_EXM_SES_VN_SP is referenced by following:
|
|
|