Results for “dai_sequence_number”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_AS_ESE_EXMVNUS_UNAVLBL_V is a reporting view in the Oracle EBS Student System (IGS) product family, which is documented as obsolete in Release 12.1.1 and 12.2.2. The view presents the inverse of the examination venue availability model: rather than listing which venues are available for a given examination session, it selects all venues that are unavailable for each examination session. This inverse presentation is useful because venue availability is typically stored sparsely — records exist only where availability has been explicitly declared — so a direct "unavailable" list must be derived by negation.
The ETRM metadata states that the object is "Not implemented in this database," meaning the view may exist only in certain installations, patches, or customizations, and is not guaranteed to be present in a standard 12.1.1 or 12.2.2 instance. The user search term "ese_id" corresponds directly to the ESE_ID column, which is the examination session identifier and the principal join key within this view. Because the view is obsolete, it should be treated as a reference structure for legacy reporting rather than a supported integration point.
Underlying Base Objects
The documented view text is defined over two base tables and a correlated availability table:
- IGS_GR_VENUE (aliased VE) — the venue master, filtered by CLOSED_IND = 'N' so that closed venues are excluded from the result set.
- IGS_AS_EXAM_SESSION (aliased ESE) — the examination session header, supplying the calendar type, sequence numbers, date alias, session number, and start/end times.
- IGS_AD_LOCATION and IGS_AD_LOCATION_TYPE — joined inside an EXISTS subquery to restrict results to venues whose EXAM_LOCATION_CD is a location of type 'EXAM_CTR' (examination centre).
- IGS_AS_EXMVNU_SESAVL — the session-availability table, referenced in a NOT EXISTS subquery that removes any venue/session combination for which an availability record already exists.
The view also invokes the function IGS_CA_GEN_001.CALP_GET_ALIAS_VAL to resolve the display alias value from the date alias, DAI_SEQUENCE_NUMBER, and examination calendar type. No base objects are separately documented in the ETRM metadata, so the tables above are taken from the supplied view text.
Key Columns
- ESE_ID — examination session identifier; the key linkage returned by the correlating NOT EXISTS subquery against IGS_AS_EXMVNU_SESAVL.
- VENUE_CD — venue code from IGS_GR_VENUE, identifying the open examination centre.
- EXAM_CAL_TYPE, EXAM_CI_SEQUENCE_NUMBER — examination calendar type and calendar instance sequence, locating the session within the academic calendar.
- DT_ALIAS, DAI_SEQUENCE_NUMBER — date alias and its sequence, identifying the examination date.
- EXAM_SESSION_NUMBER, START_TIME, END_TIME — session sequencing and its time window.
- ALIAS_VAL — the resolved calendar alias value returned by CALP_GET_ALIAS_VAL.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns from the session record.
Common Use Cases and Queries
The primary use case is examination timetabling and venue planning: identifying which open examination centres have no declared availability for a given session, so that availability records can be created or exams reassigned. A representative query for a specific session is:
SELECT venue_cd, exam_cal_type, exam_session_number, start_time, end_time FROM igs_as_ese_exmvnus_unavllbl_v WHERE ese_id = :p_ese_id ORDER BY venue_cd;
To list unavailable venues across all sessions of a calendar, omit the ESE_ID predicate and filter on EXAM_CAL_TYPE and EXAM_CI_SEQUENCE_NUMBER. Because the EXISTS subquery restricts results to locations of type 'EXAM_CTR', the output is already scoped to genuine examination centres. Note that the view is not implemented in all databases and is documented as obsolete; any query should first confirm object existence via ALL_VIEWS and, for long-term solutions, be migrated to the supported availability structures.
-
Selects all venues that are unavailable for each examination session. This is the reverse of the data structure that stores the 'availability'. The view will contain a record for each examination session for each open venue, if no availabi
APPS.IGS_AS_ESE_EXMVNUS_UNAVLBL_V·↳ IGS_AD_LOCATION·↳ IGS_AD_LOCATION_TYPE·↳ IGS_AS_EXAM_SESSION·Explore IGS module →
-
View: IGS_AS_EXAM_SESSION 12.1.1
This is the Multi org view for the table exam session details.
APPS.IGS_AS_EXAM_SESSION·↳ IGS_AS_EXAM_SESSION_ALL·Explore IGS module →
-
Describes the relationship between one date alias instance and another
-
View: IGS_CA_DA_INST_OFCNT_V 12.1.1
APPS.IGS_CA_DA_INST_OFCNT_V·↳ IGS_CA_DA_INST_OFCNT·↳ IGS_LOOKUPS_VIEW·Explore IGS module →
-
View: IGS_AS_ESE_VENUE_V 12.1.1
View containing all session/venue combinations - used to validate exam_venue_suprvsr entries
APPS.IGS_AS_ESE_VENUE_V·↳ IGS_AS_EXAM_INSTANCE·↳ IGS_AS_EXAM_SESSION·↳ IGS_CA_GEN_001·Explore IGS module →
-
Describes linking of examination supervisor to examination session venue
-
Describes a further breakdown of the program
APPS.IGS_AD_PERD_PS_OF_PAT_V·↳ IGS_AD_PECRS_OFOP_DT·↳ IGS_CA_DA_INST_V·↳ IGS_CA_GEN_001·Explore IGS module →
-
View: IGS_FI_FEE_RET_SCHD_V 12.1.1
This view represents the columns of the fee_retention_schedule table as well as including columns representing the start and end period for each schedule entry.
APPS.IGS_FI_FEE_RET_SCHD_V·↳ IGS_CA_GEN_001·↳ IGS_FI_FEE_RET_SCHD·↳ IGS_FI_GEN_001·Explore IGS module →
-
Stores the pairing of two date alias instances and enables the definition of a period of time inclusive of the two date aliases
-
Describes linking of examination supervisors to particular examination instance
-
View: IGS_AS_EXM_SES_VN_SP_V 12.1.1
APPS.IGS_AS_EXM_SES_VN_SP_V·↳ IGS_AS_EXM_SES_VN_SP·↳ IGS_EN_GEN_003·↳ IGS_EN_GEN_007·Explore IGS module →
-
Determines the fee retention schedule entries specific to a given fee category fee liability.
APPS.IGS_FI_FEE_RET_SCHD_F_TYPE_V·↳ IGS_CA_GEN_001·↳ IGS_FI_FEE_RET_SCHD·↳ IGS_FI_FEE_RET_SCHD_V·Explore IGS module →
-
View: IGS_CA_DA_INST_PAIR_V 12.1.1
APPS.IGS_CA_DA_INST_PAIR_V·↳ IGS_CA_DA_INST·↳ IGS_CA_DA_INST_PAIR·↳ IGS_CA_INST·Explore IGS module →
-
Describes available sessions, which are linked to date alias instance within the nominated examination calendar instance, during which examinations may be conducted
-
Describes the set of constraints to be applied when applying an offset to generate a date alias instance value from another date alias instance
-
View: IGS_AS_EXAM_SESSION_V 12.1.1
Examination Session View - incorporated examination session date alias value from the 'date alias instance' table.
APPS.IGS_AS_EXAM_SESSION_V·↳ IGS_AS_EXAM_SESSION·↳ IGS_CA_GEN_001·Explore IGS module →
-
APPS.IGSBV_PGM_OFR_PAT_ADM_DT·↳ IGS_AD_PECRS_OFOP_DT·Explore IGS module →
-
View: IGS_AS_EXMVNU_SESAVL 12.1.1
This is the view to get the Examination venue data.
APPS.IGS_AS_EXMVNU_SESAVL·↳ IGS_AS_EXMVNU_SESAVL_ALL·Explore IGS module →
-
View: IGS_AS_STD_EXM_INSTN_V 12.1.1
APPS.IGS_AS_STD_EXM_INSTN_V·↳ HZ_PARTIES·↳ IGS_AS_STD_EXM_INSTN·Explore IGS module →
-
Retention Schedule for the Teaching Period
-
This entity describes special contract based fee assessment rates
-
Describes availability of examination venue for examination session
-
Describes program offering option specified by the admission period program offering option
-
View: IGS_AS_EXM_INS_SPVSR_V 12.1.1
This View is for examination supervisor details.
APPS.IGS_AS_EXM_INS_SPVSR_V·↳ IGS_AS_EXM_INS_SPVSR·↳ IGS_EN_GEN_003·↳ IGS_EN_GEN_007·Explore IGS module →
-
View: IGS_FI_TP_RET_SCHD_V 12.1.1
Retention Schedule for the Teaching Period
APPS.IGS_FI_TP_RET_SCHD_V·↳ IGS_CA_GEN_001·↳ IGS_FI_TP_RET_SCHD·Explore IGS module →
-
Describes relationship between examination session instance and venue
-
This entity describes the history of changes to a fee retention schedule.
-
APPS.IGS_AD_PERD_PS_OF_PAT1_V·↳ IGS_AD_PERD_PS_OF_PAT_V·↳ IGS_CA_GEN_001·↳ IGS_CA_GEN_002·Explore IGS module →
-
View: IGS_CA_DA_INST_OFST_V 12.1.1
APPS.IGS_CA_DA_INST_OFST_V·↳ IGS_CA_DA_INST·↳ IGS_CA_DA_INST_OFST·↳ IGS_CA_INST·Explore IGS module →
-
View: IGS_FI_F_RET_SCHD_HT 12.1.1
APPS.IGS_FI_F_RET_SCHD_HT·↳ IGS_FI_F_RET_SCHD_HT_ALL·Explore IGS module →
-
APPS.IGSFV_PGM_OFR_PAT_ADM_DT·↳ IGS_AD_CAT_ALL·↳ IGS_AD_LOCATION_ALL·↳ IGS_AD_PECRS_OFOP_DT·Explore IGS module →
-
View: IGS_AS_EXAM_INSTANCE 12.1.1
This View contains Exam instance records.
APPS.IGS_AS_EXAM_INSTANCE·↳ IGS_AS_EXAM_INSTANCE_ALL·Explore IGS module →
-
Describes relationship between student unit attempt and time-tabled examination instance
-
View: IGS_AS_STD_EXM_INSTN 12.1.1
APPS.IGS_AS_STD_EXM_INSTN·↳ IGS_AS_STD_EXM_INSTN_ALL·Explore IGS module →
-
View: IGS_CA_DA_INST_OFCNT_V 12.2.2
Not implemented in this database·Explore IGS module →
-
View: IGS_AS_EXM_SES_VN_SP_V 12.2.2
Not implemented in this database·Explore IGS module →
-
Table: IGS_CA_DA_INST_PAIR 12.2.2
Stores the pairing of two date alias instances and enables the definition of a period of time inclusive of the two date aliases
Not implemented in this database·Explore IGS module →
-
View: IGS_AS_EXAM_SESSION 12.2.2
This is the Multi org view for the table exam session details.
Not implemented in this database·Explore IGS module →
-
View: IGS_AS_STD_EXM_INSTN_V 12.2.2
Not implemented in this database·Explore IGS module →
-
View: IGS_AS_EXM_INS_SPVSR_V 12.2.2
This View is for examination supervisor details.
Not implemented in this database·Explore IGS module →
-
View: IGS_CA_DA_INST_OFST_V 12.2.2
Not implemented in this database·Explore IGS module →
-
View: IGS_AS_EXMVNU_SESAVL 12.2.2
This is the view to get the Examination venue data.
Not implemented in this database·Explore IGS module →
-
Not implemented in this database·Explore IGS module →
-
View: IGS_FI_F_RET_SCHD_HT 12.2.2
Not implemented in this database·Explore IGS module →