Results for “hist_start_dt”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IGS_PS_UNT_DSCP_HIST_V is a valid APPS-owned database view within the IGS (Student System) product family of Oracle E-Business Suite, present in both release 12.1.1 and 12.2.2. Its documented purpose is to merge unit discipline history records with the current unit discipline details, allowing the full set of attribute values to be queried across time up to the present day. Each row returned represents a complete set of column values valid over a defined time period.
In institutional terms, a "unit" is a course or module within the student system, and "discipline" refers to the academic discipline grouping to which a unit's teaching or funding is attributed. The percentage column records how much of a unit is apportioned to a given discipline group. Because this apportionment can change over time, the Student System maintains history rows rather than only the current value. This view is therefore the reporting and integration access point that presents a continuous, time-sliced picture of discipline apportionment without requiring callers to reconcile history and current tables themselves.
The view is read-only and is intended for enquiry, reporting, and downstream integration rather than for maintenance. It exposes standard Oracle EBS audit columns alongside the functional attributes.
Underlying Base Objects
The view text is defined over three documented sources:
- IGS_PS_UNT_DSCP_HIST (aliased UDH1/UDH2) — the historical unit discipline apportionment records, holding effective-dated percentage changes.
- IGS_PS_UNIT_DSCP (aliased UD1/UD2) — the current unit discipline details, holding the values in force today.
- IGS_PS_UNIT_VER (aliased UV) — the unit version header, used to validate and constrain the unit and version combination in the historical branch.
Although the ETRM metadata lists no referenced base objects explicitly, the view definition itself confirms these three tables. The structure is a UNION ALL of two branches. The first branch joins history to current and to the unit version, using an outer join on the current table so that history rows continue to appear even when no matching current detail exists; the percentage is resolved as the historical value, falling back to a custom hook function, and then to the current value. The second branch selects from the current table alone, again outer-joined to history, and uses MAX(HIST_END_DT) aggregated by unit, version, discipline group and audit attributes to synthesise an open-ended "today" entry with a null end date.
Key Columns
- UNIT_CD — the code identifying the unit (course). Part of the composite key.
- VERSION_NUMBER — the unit version, allowing different versions of a unit to be maintained independently.
- DISCIPLINE_GROUP_CD — the discipline group to which the unit is attributed for this record.
- HIST_START_DT — the date from which this set of values is effective.
- HIST_END_DT — the date on which this set of values ceases to be effective; null for the current, open-ended entry.
- HIST_WHO — the user or process that made the historical change.
- PERCENTAGE — the proportion of the unit attributed to the discipline group, resolved through the documented fallback chain.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle audit columns describing who created and last modified the row.
Common Use Cases and Queries
Typical uses include reporting the discipline split of a unit at a point in time, reconciling historical changes to discipline apportionment, and extracting a time-sliced feed for data warehousing or regulatory reporting. Because the view can return multiple rows per unit, version and discipline group, queries should always filter by date range and aggregate or order appropriately.
Current discipline apportionment for a unit:
SELECT unit_cd, version_number, discipline_group_cd, percentage FROM igs_ps_unt_dscp_hist_v WHERE unit_cd = :unit_cd AND hist_end_dt IS NULL;
Discipline apportionment as at a given date:
SELECT unit_cd, version_number, discipline_group_cd, percentage FROM igs_ps_unt_dscp_hist_v WHERE unit_cd = :unit_cd AND :as_of_date BETWEEN hist_start_dt AND NVL(hist_end_dt, :as_of_date);
Full audit trail of all changes for a unit and discipline group:
SELECT unit_cd, version_number, discipline_group_cd, hist_start_dt, hist_end_dt, hist_who, percentage FROM igs_ps_unt_dscp_hist_v WHERE unit_cd = :unit_cd AND discipline_group_cd = :discipline_group_cd ORDER BY hist_start_dt;
As with all APPS views in the Student System, queries should observe the standard multi-org and security context of the calling responsibility, and results should be treated as read-only reference data.
-
View: IGS_PS_UNT_DSCP_HIST_V 12.1.1
This view is used to merge unit discipline history with the current unit discipline details enabling all details to be accessed over time, up till the current day. Each entry represents all column values over defined time periods.
APPS.IGS_PS_UNT_DSCP_HIST_V·↳ IGS_AU_GEN_004·↳ IGS_PS_UNIT_DSCP·↳ IGS_PS_UNIT_VER·Explore IGS module →
-
View: IGS_PS_TCH_RESP_HIST_V 12.1.1
This view is used to merge teaching responsibility history with the current teaching responsibility details enabling all details to be accessed over time, up till the current day.
APPS.IGS_PS_TCH_RESP_HIST_V·↳ IGS_AU_GEN_004·↳ IGS_PS_TCH_RESP·↳ IGS_PS_TCH_RESP_HIST·Explore IGS module →
-
This entity describes the history of changes for a unit internal program level.
-
This entity describes the history of changes to a unit version's reference codes.
-
View: IGS_RE_CDT_ATT_HIST 12.1.1
APPS.IGS_RE_CDT_ATT_HIST·↳ IGS_RE_CDT_ATT_HIST_ALL·Explore IGS module →
-
This entity describes the history of changes to a unit version's teaching responsibility.
-
View: IGS_FI_FUND_SRC_HIST 12.1.1
APPS.IGS_FI_FUND_SRC_HIST·↳ IGS_FI_FUND_SRC_HIST_ALL·Explore IGS module →
-
This table describes the history of the attendance of a research student for the duration of their candidature. It stores details of both attendance type and attendance percentage details in a consolidated view.
-
View: IGS_PS_UNIT_REF_HIST_V 12.1.1
This view is used to merge unit reference code history with the current unit reference code details enabling all details to be accessed over time, up till the current day. Each entry represents all column values over defined time periods.
APPS.IGS_PS_UNIT_REF_HIST_V·↳ IGS_AU_GEN_004·↳ IGS_PS_UNIT_REF_CD·↳ IGS_PS_UNIT_REF_HIST·Explore IGS module →
-
This entity describes the history of changes to a unit version's unit discipline.
-
View: IGS_PS_OWN_HIST_V 12.1.1
This view is used to merge program ownership history with the current program ownership details enabling all details to be accessed over time, up till the current day. Each entry represents all column values over defined time periods.
APPS.IGS_PS_OWN_HIST_V·↳ IGS_AU_GEN_001·↳ IGS_PS_OWN·↳ IGS_PS_OWN_HIST·Explore IGS module →
-
This view is used to merge program field of study history with the current program field of study details enabling all details to be accessed over time, up till the current day. Entries represents all column values over defined time periods
APPS.IGS_PS_FLD_STUDY_HIST_V·↳ IGS_AU_GEN_001·↳ IGS_PS_FIELD_STUDY·↳ IGS_PS_FLD_STD_HIST·Explore IGS module →
-
This entity describes the history of changes to a unit version's program unit level.
-
View: IGS_PS_REF_CD_HIST 12.1.1
APPS.IGS_PS_REF_CD_HIST·↳ IGS_PS_REF_CD_HIST_ALL·Explore IGS module →
-
View: IGS_PS_TCH_RESP_HIST 12.1.1
APPS.IGS_PS_TCH_RESP_HIST·↳ IGS_PS_TCH_RESP_HIST_ALL·Explore IGS module →
-
This entity describes the history of program field of study changes for a program version.
-
View: IGS_PS_FLD_STDY_HIST 12.1.1
APPS.IGS_PS_FLD_STDY_HIST·↳ IGS_LOOKUP_VALUES·↳ IGS_PS_FLD_STDY_HIST_ALL·Explore IGS module →
-
This table maintains the history of special permission request transactions.
-
View: IGS_PS_OWN_HIST 12.1.1
APPS.IGS_PS_OWN_HIST·↳ IGS_PS_OWN_HIST_ALL·Explore IGS module →
-
View: IGS_FI_FUND_SRC_HIST_V 12.1.1
This view is used to merge funding source history with the current funding source details enabling all details to be accessed over time, up till the current day. Each entry represents all column values over defined time periods.
APPS.IGS_FI_FUND_SRC_HIST_V·↳ IGS_AU_GEN_002·↳ IGS_FI_FUND_SRC·↳ IGS_FI_FUND_SRC_HIST·Explore IGS module →
-
View: IGS_PS_DSCP_HIST 12.1.1
APPS.IGS_PS_DSCP_HIST·↳ IGS_PS_DSCP_HIST_ALL·Explore IGS module →
-
This entity describes special contract based fee assessment rates
-
This entity describes the history of changes for a program type.
-
View: IGS_PS_TYPE_HIST_V 12.1.1
This view is used to merge program type history with the current program type details enabling all details to be accessed over time, up till the current day. Each entry represents all column values over defined time periods.
APPS.IGS_PS_TYPE_HIST_V·↳ IGS_AU_GEN_001·↳ IGS_LOOKUP_VALUES·↳ IGS_PS_TYPE·Explore IGS module →
-
This entity describes the history of changes to an organizational unit.
-
View: IGS_AD_PS_APPL_HIST 12.1.1
APPS.IGS_AD_PS_APPL_HIST·↳ IGS_AD_PS_APPL_HIST_ALL·Explore IGS module →
-
Describes history of changes to admission program application
-
View: IGS_OR_UNIT_HIST_V 12.1.1
APPS.IGS_OR_UNIT_HIST_V·↳ HZ_PARTIES·↳ IGS_AU_GEN_003·↳ IGS_GE_DATE·Explore IGS module →
-
View: IGS_PS_TCH_RSOV_HIST_V 12.1.1
This view is used to merge teaching responsibility override history with the current teaching responsibility override details enabling all details to be accessed over time, up till the current day.
APPS.IGS_PS_TCH_RSOV_HIST_V·↳ IGS_AU_GEN_004·↳ IGS_PS_TCH_RESP_OVRD·↳ IGS_PS_TCH_RSOV_HIST·Explore IGS module →
-
This entity describes the history of program ownership changes for a program version.
-
View: IGS_PS_UNT_DSCP_HIST 12.1.1
APPS.IGS_PS_UNT_DSCP_HIST·↳ IGS_PS_UNT_DSCP_HIST_ALL·Explore IGS module →
-
View: IGS_PS_FLD_STDY_HIST_V 12.1.1
This view is used to merge field of study history with the current field of study details enabling all details to be accessed over time, up till the current day. Each entry represents all column values over defined time periods.
APPS.IGS_PS_FLD_STDY_HIST_V·↳ IGS_AU_GEN_002·↳ IGS_PS_FLD_OF_STUDY·↳ IGS_PS_FLD_STDY_HIST·Explore IGS module →
-
Describes history of changes to admission application
-
This entity describes the history of changes to a fee retention schedule.
-
View: IGS_PS_TYPE_HIST 12.1.1
APPS.IGS_PS_TYPE_HIST·↳ IGS_PS_TYPE_HIST_ALL·Explore IGS module →
-
View: IGS_FI_FEE_AS_RT_HT 12.1.1
APPS.IGS_FI_FEE_AS_RT_HT·↳ IGS_FI_FEE_AS_RT_HT_ALL·Explore IGS module →
-
View: IGS_FI_FEE_CAT_CI_HT 12.1.1
APPS.IGS_FI_FEE_CAT_CI_HT·↳ IGS_FI_FEE_CAT_CI_HT_ALL·Explore IGS module →
-
View: IGS_FI_F_CAT_F_LBL_H 12.1.1
APPS.IGS_FI_F_CAT_F_LBL_H·↳ IGS_FI_F_CAT_F_LBL_H_ALL·Explore IGS module →
-
View: IGS_FI_FEE_TYPE_HIST 12.1.1
APPS.IGS_FI_FEE_TYPE_HIST·↳ IGS_FI_FEE_TYPE_HIST_ALL·Explore IGS module →
-
Describes the history of changes to an elements range
-
View: IGS_PS_DSCP_HIST_V 12.1.1
This view is used to merge discipline history with the current discipline details enabling all details to be accessed over time, up till the current day. Each entry represents all column values over defined time periods.
APPS.IGS_PS_DSCP_HIST_V·↳ IGS_AU_GEN_002·↳ IGS_PS_DSCP·↳ IGS_PS_DSCP_HIST·Explore IGS module →
-
View: IGS_PS_UNIT_LVL_HIST_V 12.1.1
This view is used to merge program unit level history with the current program unit level details enabling all details to be accessed over time, up till the current day. Each entry represents all column values over defined time periods.
APPS.IGS_PS_UNIT_LVL_HIST_V·↳ IGS_AU_GEN_002·↳ IGS_PS_UNIT_LVL·↳ IGS_PS_UNIT_LVL_HIST·Explore IGS module →
-
View: IGS_PS_FLD_STD_HIST 12.1.1
APPS.IGS_PS_FLD_STD_HIST·↳ IGS_PS_FLD_STD_HIST_ALL·Explore IGS module →
-
View: IGS_PS_UNIT_REF_HIST 12.1.1
APPS.IGS_PS_UNIT_REF_HIST·↳ IGS_PS_UNIT_REF_HIST_ALL·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 →
-
This entity describes the fee types used throughout the system for the purpose of applying fees and charges.
-
This entity describes special contract based fee assessment rates
-
This entity describes the history of changes for a discipline.
-
Hods the Admission application history details that need to get imported for an application, during legacy import
-
This entity describes the history of changes to a unit/unit offering option fee trigger.