Results for “ci_start_dt”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_PS_UNIT_OFR_PAT_V is a reporting view within the Oracle E-Business Suite Student System (IGS) product family. Despite the "IGS - Student System (Obsolete)" designation in the ETRM metadata, the view remains documented in the 12.2.2 reference set and appears in 12.1.1 environments where the Student System schema objects were originally deployed. The name decomposes into its functional intent: IGS (Student System), PS (Public Sector/Student), UNIT_OFR_PAT (unit offering pattern), and the _V suffix indicating a database view rather than a base table.
The view presents a denormalized, human-readable projection of unit offering patterns — the recurring scheduling definitions that describe when and how a teachable unit is offered within a calendar instance. Its primary purpose is to join the pattern record to its parent calendar instance so that downstream reports, self-service pages, and integration extracts can display descriptive calendar text alongside the offering pattern identifiers without requiring the consumer to re-implement the join.
The ETRM metadata records that the view is not implemented in this database, meaning the source system used to generate the documentation did not host the object. This is expected for obsolete or licensing-restricted IGS components. The view definition supplied in the ETRM excerpt is therefore the authoritative implementation reference rather than a live object listing.
Underlying Base Objects
The ETRM metadata states that no base objects are documented and lists the view owner as blank. The view text itself, however, is explicit. The definition selects from two base tables:
- IGS_PS_UNIT_OFR_PAT (aliased
UOP) — the driving table holding the unit offering pattern rows, including unit code, version, calendar type, calendar instance sequence, and theABORT_FLAGattribute. - IGS_CA_INST (aliased
CI) — the calendar instance master, supplying the descriptive instance text.
The join predicate is UOP.CAL_TYPE = CI.CAL_TYPE AND UOP.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER, with a filter of UOP.DELETE_FLAG = 'N' that suppresses soft-deleted pattern rows. The view also invokes two packaged functions — IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD and IGS_CA_GEN_001.CALP_GET_ALT_CD — to derive alternate academic and teaching codes, each truncated to ten characters.
Key Columns
- UNIT_CD, VERSION_NUMBER — identify the teachable unit and its effective version.
- CAL_TYPE, CI_SEQUENCE_NUMBER — the composite key linking the pattern to its calendar instance; also the join keys to IGS_CA_INST.
- CAL_DESCRIPTION — the descriptive text from IGS_CA_INST.DESCRIPTION, providing the readable calendar instance label.
- ACAD_ALTERNATE_CODE, TEACH_ALTERNATE_CODE — function-derived alternate codes used by external or regulatory reporting formats.
- CI_START_DT, CI_END_DT — the start and end dates of the calendar instance in which the pattern applies.
- ABORT_FLAG — the user's search term; this column mirrors
UOP.ABORT_FLAGand indicates whether the unit offering pattern has been aborted, i.e. cancelled and no longer available for enrolment, while remaining retained for audit and historical reporting. - CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns propagated from the base table.
Common Use Cases and Queries
Typical usage includes reporting on active versus aborted offerings, integration extracts feeding timetabling or enrolment systems, and validation reports for calendar setup. Filtering on ABORT_FLAG is the most common access pattern, since consumers generally want either all aborted patterns for audit or only non-aborted patterns for live processing.
Retrieve all aborted patterns with their calendar descriptions:
SELECT unit_cd, version_number, cal_type,
ci_sequence_number, cal_description,
ci_start_dt, ci_end_dt, abort_flag
FROM igs_ps_unit_ofr_pat_v
WHERE abort_flag = 'Y'
ORDER BY ci_start_dt DESC;
Count active and aborted patterns by unit:
SELECT unit_cd, version_number, abort_flag, COUNT(*) FROM igs_ps_unit_ofr_pat_v GROUP BY unit_cd, version_number, abort_flag;
List patterns for a specific calendar instance, including alternate codes:
SELECT unit_cd, acad_alternate_code,
teach_alternate_code, ci_start_dt, ci_end_dt
FROM igs_ps_unit_ofr_pat_v
WHERE cal_type = :cal_type
AND ci_sequence_number = :ci_seq
AND abort_flag = 'N';
Because the view encapsulates the DELETE_FLAG filter and the function calls, consumers should query it rather than reconstructing the join, ensuring consistent handling of soft-deleted rows and alternate code derivation across all reports and integrations.
-
View: IGS_PS_UNIT_OFR_PAT_V 12.1.1
APPS.IGS_PS_UNIT_OFR_PAT_V·↳ IGS_CA_GEN_001·↳ IGS_CA_INST·↳ IGS_EN_GEN_014·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
-
Stores the Cost of Attendance Objects across load calendars.
APPS.IGF_AW_CIT_LD_OVERIDE_V·↳ IGF_AW_CIT_LD_OVERIDE·↳ IGS_CA_INST·Explore IGF module →
-
View: IGS_AS_SUAO_V 12.1.1
Describes the outcome to a student unit attempt, in the form of a mark and possibly a grade.
APPS.IGS_AS_SUAO_V·↳ IGS_AS_SU_STMPTOUT·Explore IGS module →
-
This entity describes all the assessment items for a unit section.
-
View: IGF_AP_INC_PRCT_V 12.1.1
OBSOLETE
APPS.IGF_AP_INC_PRCT_V·↳ IGF_AP_EFC_MULT_FCT_V·↳ IGF_AW_GEN·↳ IGF_LOOKUPS_VIEW·Explore IGF module →
-
View: IGF_AP_GEN_TX_V 12.1.1
OBSOLETE
APPS.IGF_AP_GEN_TX_V·↳ IGF_AP_EFC_MULT_FCT_V·↳ IGF_AW_GEN·↳ IGF_LOOKUPS_VIEW·Explore IGF module →
-
View: IGS_AS_UG_ADI_V 12.1.1
Assessment Unit Grading WebADI View
APPS.IGS_AS_UG_ADI_V·↳ HZ_PARTIES·↳ IGS_AS_ANON_GRD_PKG·↳ IGS_AS_DERIVE_GRADE·Explore IGS module →
-
This entity describes the instances of a calendar type in which a particular program is on offer.
-
This view describes the outcome to a student unit attempt, in theform of a mark and possibly a grade (if the default grade for themark is overridden).It also descibes a student's attempt at studying a particularunit offered by the universit
APPS.IGS_PR_SUA_FINAL_OUTCOME_V·↳ IGS_AS_SU_STMPTOUT·↳ IGS_EN_SU_ATTEMPT·↳ IGS_PS_STDNT_UNT_TRN·Explore IGS module →
-
View: IGS_AS_SU_STMPTOUT_V 12.1.1
Multi org View for student unit attempt outcome records.
APPS.IGS_AS_SU_STMPTOUT_V·↳ FND_LOOKUP_VALUES·↳ IGS_AS_GAA_SUB_HIST·↳ IGS_AS_SU_STMPTOUT·Explore IGS module →
-
View: IGF_AW_COA_RATE_MST_V 12.1.1
Cost of Attendance Rate Table Master
APPS.IGF_AW_COA_RATE_MST_V·↳ IGF_AW_COA_RATE_DET·↳ IGF_AW_ITEM·↳ IGS_CA_INST·Explore IGF module →
-
View: IGF_GR_PELL_SETUP_V 12.1.1
Shows the federal Pell grants details
APPS.IGF_GR_PELL_SETUP_V·↳ IGF_AW_GEN·↳ IGF_GR_PELL_SETUP·↳ IGS_CA_INST·Explore IGF module →
-
View: IGF_AW_COA_GRP_ITEM_V 12.1.1
Cost of attendance group item
APPS.IGF_AW_COA_GRP_ITEM_V·↳ IGF_AW_COA_GRP_ITEM·↳ IGF_AW_ITEM·↳ IGS_CA_INST·Explore IGF module →
-
Describes the examination calendar instances that a unit assessment item record is examined. This view ignores the relationship represented in the uai.exam_cal_type, exam_ci_sequence_number fields.
APPS.IGS_AS_UAI_EXAM_CI_INIT_V·↳ IGS_AS_ASSESSMNT_ITM·↳ IGS_AS_ASSESSMNT_TYP·↳ IGS_AS_UNITASS_ITEM·Explore IGS module →
-
View: IGF_AP_EFC_MULT_FCT_V 12.1.1
OBSOLETE
APPS.IGF_AP_EFC_MULT_FCT_V·↳ IGF_AP_EFC_V·↳ IGF_AP_NEED_MTH_TYP·↳ IGF_AW_GEN·Explore IGF module →
-
View: IGF_AP_ASSET_PRCT_V 12.1.1
OBSOLETE
APPS.IGF_AP_ASSET_PRCT_V·↳ IGF_AP_EFC_MULT_FCT_V·↳ IGF_AW_GEN·↳ IGF_LOOKUPS_VIEW·Explore IGF module →
-
View: IGS_AS_SUAOA_V 12.1.1
Describes the most recent outcome of student unit attempt as grade or mark for different grading periods
APPS.IGS_AS_SUAOA_V·↳ IGS_AS_SU_STMPTOUT·Explore IGS module →
-
View: IGF_AW_FUND_DET_GRP_V 12.1.1
Stores the Fund Code wise Total Offered Amount ,Accepted Amount and Paid Amount for a student
APPS.IGF_AW_FUND_DET_GRP_V·↳ IGF_AP_FA_CON_V·↳ IGF_AW_AWARD_V·↳ IGF_AW_FUND_MAST·Explore IGF module →
-
View: IGS_PS_UNITASS_ITEM_V 12.1.1
APPS.IGS_PS_UNITASS_ITEM_V·↳ IGS_AS_ASSESSMNT_ITM_ALL·↳ IGS_AS_GRD_SCHEMA·↳ IGS_CA_INST·Explore IGS module →
-
View: IGS_AD_PERD_AD_CAT_V 12.1.1
Admission Periods which are associated with Admission Categories
APPS.IGS_AD_PERD_AD_CAT_V·↳ IGS_AD_CAT·↳ IGS_AD_PERD_AD_CAT·↳ IGS_CA_INST·Explore IGS module →
-
IGS_AS_UNITASS_ITEM describes the assessment items that are allocated to a unit version within a nominated teaching calendar instance, such as unit offering pattern. A unit might be assigned many assessment items, and in turn, an assessmen
APPS.IGS_AS_UNITASS_ITEM·↳ IGS_AS_UNITASS_ITEM_ALL·Explore IGS module →
-
Describes admission category and admission calendar instance that define admission period
-
View: IGF_AW_TERM_MAP_V 12.1.1
FA125_3160568_CS_DP1.doc - Obsolete
APPS.IGF_AW_TERM_MAP_V·↳ IGF_AW_TERM_MAP·↳ IGS_CA_INST·Explore IGF module →
-
View: IGF_GR_PELL_COA_RNG_V 12.1.1
Shows cost of attendance ranges for Pell
APPS.IGF_GR_PELL_COA_RNG_V·↳ IGF_AW_GEN·↳ IGF_GR_PELL_COA_RNG·↳ IGS_CA_INST·Explore IGF module →
-
View: IGF_AP_HOUSING_MAP_V 12.1.1
Housing Status Mapping
APPS.IGF_AP_HOUSING_MAP_V·↳ IGF_AP_HOUSING_MAP·↳ IGF_LOOKUPS_VIEW·↳ IGS_CA_INST·Explore IGF module →
-
This entity describes the offering pattern of a unit offering option.
-
Describes assessment items allocated to unit version within nominated teaching calendar instance
-
View: IGF_AW_LOAN_LIMIT_V 12.1.1
Sets the limits for Loans to be used during packaging
APPS.IGF_AW_LOAN_LIMIT_V·↳ IGF_AW_GEN·↳ IGF_AW_LOAN_LIMIT·↳ IGS_CA_INST·Explore IGF module →
-
View: IGF_GR_ALT_COA_V 12.1.1
APPS.IGF_GR_ALT_COA_V·↳ IGF_AW_GEN·↳ IGF_GR_ALT_COA·↳ IGS_CA_INST·Explore IGF module →
-
View: IGS_AS_SU_STMPTOUT_MID 12.1.1
APPS.IGS_AS_SU_STMPTOUT_MID·↳ FND_LOOKUP_VALUES·↳ IGS_AS_SU_STMPTOUT·↳ IGS_CA_INST·Explore IGS module →
-
View: IGF_SL_PE_CITI_MAP_V 12.1.1
View for the OSS and FA data mapping for Citizenship Code
APPS.IGF_SL_PE_CITI_MAP_V·↳ IGF_LOOKUPS_VIEW·↳ IGF_SL_PE_CITI_MAP·↳ IGS_CA_INST·Explore IGF module →
-
View: IGF_AP_STATE_TX_V 12.1.1
OBSOLETE
APPS.IGF_AP_STATE_TX_V·↳ IGF_AP_EFC_MULT_FCT_V·↳ IGF_AW_GEN·↳ IGF_LOOKUPS_VIEW·Explore IGF module →
-
View: IGF_AP_EFC_V 12.1.1
APPS.IGF_AP_EFC_V·↳ IGF_AP_BATCH_AW_MAP·↳ IGF_AW_GEN·↳ IGS_CA_INST·Explore IGF 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 →
-
View: IGF_AW_COA_GROUP_V 12.1.1
Stores group codes for cost of attendance
APPS.IGF_AW_COA_GROUP_V·↳ IGF_AW_COA_GROUP·↳ IGS_CA_INST·Explore IGF module →
-
View: IGF_GR_PELL_RNG_AMT_V 12.1.1
Shows the cost of attendance ranges for Pell against expected family contribution amounts
APPS.IGF_GR_PELL_RNG_AMT_V·↳ IGF_GR_PELL_RNG_AMT·↳ IGS_CA_INST·Explore IGF module →
-
View: IGF_AW_FISAP_REPSET_V 12.1.1
This entity is be used to define the category ID which consists of an Award Year, Class Standing, Dependency Status , and FISAP Section .Based on the category ID , the FISAP Income ranges would be defined
APPS.IGF_AW_FISAP_REPSET_V·↳ IGF_AW_FISAP_REPSET·↳ IGF_AW_GEN·↳ IGS_CA_INST·Explore IGF module →
-
View: IGF_AW_AWD_APT_V 12.1.1
Award Periods Terms View
APPS.IGF_AW_AWD_APT_V·↳ IGF_AW_AWARD_PRD·↳ IGF_AW_AWD_PRD_TERM·↳ IGS_CA_INST·Explore IGF module →
-
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 →
-
View: IGS_AS_SUA_ASS_V 12.1.1
APPS.IGS_AS_SUA_ASS_V·↳ HZ_PARTIES·↳ IGS_CA_GEN_001·↳ IGS_CA_INST·Explore IGS module →
-
View: IGS_PS_UNIT_OFR_PAT 12.1.1
APPS.IGS_PS_UNIT_OFR_PAT·↳ IGS_PS_UNIT_OFR_PAT_ALL·Explore IGS module →
-
View: IGF_DB_AWD_DISB_V 12.1.1
Award disbursement details
APPS.IGF_DB_AWD_DISB_V·↳ IGF_AW_AWARD_V·↳ IGF_AW_AWD_DISB_V·↳ IGF_AW_GEN·Explore IGF module →
-
View: IGS_AS_UAI_EXAM_CI_V 12.1.1
IGS_AS_UAI_EXAM_CI_V describes the examination calendar instances that a unit assessment item record is examined. This is determined based on the relationships between the teaching and examination calendar instances and the override uai.exa
APPS.IGS_AS_UAI_EXAM_CI_V·↳ IGS_AS_ASSESSMNT_ITM·↳ IGS_AS_ASSESSMNT_TYP·↳ IGS_AS_UNITASS_ITEM·Explore IGS module →
-
View: IGS_AS_SUAO_MID_V 12.1.1
Describes the outcome to a student unit attempt, in the form of a mark and possibly a grade for Midterm.
APPS.IGS_AS_SUAO_MID_V·↳ IGS_AS_SU_STMPTOUT_MID·↳ IGS_EN_GEN_003·↳ IGS_EN_GEN_007·Explore IGS module →
-
View: IGF_SL_DL_SETUP_V 12.1.1
APPS.IGF_SL_DL_SETUP_V·↳ IGF_AW_GEN·↳ IGF_SL_DL_SETUP·↳ IGS_CA_INST·Explore IGF module →
-
View: IGS_AS_UGAI_ADI_V 12.1.1
Unit Grading / Assessment Item WebADI View
APPS.IGS_AS_UGAI_ADI_V·↳ HZ_PARTIES·↳ IGS_AS_ANON_GRD_PKG·↳ IGS_AS_ASSESSMNT_ITM_ALL·Explore IGS module →
-
Table: IGS_AS_SL_INTERFACE 12.1.1
Assessment Student List Web ADI Interface Table
-
View: IGS_EN_SUA_WLST_V 12.1.1
This view describes the data pertaining to the student unit attempt waitlist.
APPS.IGS_EN_SUA_WLST_V·↳ IGS_EN_STDNT_PS_ATT·↳ IGS_EN_SU_ATTEMPT_SV·↳ IGS_PE_PERSON_BASE_V·Explore IGS module →
-
View: IGS_EN_SUA_YEAR_V 12.1.1
This view would be used for logical grouping of student unit attempts under unit set (in year of program mode) for unit set inquiry form
APPS.IGS_EN_SUA_YEAR_V·↳ IGS_AS_SU_SETATMPT·↳ IGS_CA_GEN_001·↳ IGS_CA_INST·Explore IGS module →