Results for “segment_value_desc”
22 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The database view IGS_PS_UNIT_ACCTS_V belongs to the Oracle Student System (IGS) product family, which is documented as obsolete in the E-Business Suite 12.1.1 and 12.2.2 releases. The view exposes account segment values associated with a Unit, where a Unit represents an academic organizational entity such as a department, faculty, or teaching unit within the Student System. Its stated description is "Account segment values for a Unit," indicating that the view serves as a consolidated access point for General Ledger-style accounting segment information attached to units.
In EBS reporting and integration contexts, this view would have been used to retrieve the accounting flexfield segment assignments for a given unit code and version. Rather than querying the underlying unit account table directly, external reports, concurrent programs, or integration interfaces could select from this view to obtain both the stored segment values and their human-readable descriptions, resolved through the Accounting Flexfield value set definitions. The view joins unit account records to account segment metadata, making it convenient for reporting scenarios where the descriptive name of each segment must be presented alongside its stored value.
Underlying Base Objects
The view text references two source objects. The primary transactional object is IGS_PS_UNIT_ACCTS (aliased PSUA), which stores the unit-level account segment values keyed by row identifier, unit account identifier, unit code, and version number. The second object is IGS_FI_ACCT_SEGS_V (aliased ACCSEG), which supplies segment-level metadata including the segment name, segment number, flex value set identifier, validation type, independent segment number, and display flag.
The join is expressed with outer-join syntax (PSUA.SEGMENT(+) and PSUA.SEGMENT_NUM(+)), meaning that segment definitions from IGS_FI_ACCT_SEGS_V are retained even where no corresponding unit account value exists. This is significant for complete reporting, since segments without assigned values still appear with null segment values. The result set is ordered by segment number, producing a predictable sequence that mirrors the accounting flexfield structure.
Key Columns
ROW_ID,UNIT_ACCOUNT_ID— unique identifiers for the underlying unit account record.UNIT_CD— the code identifying the academic unit to which the account values belong.VERSION_NUMBER— versioning discriminator allowing multiple effective versions of unit account data.SEGMENT,SEGMENT_NAME,SEGMENT_NUM— the accounting flexfield segment identifier, its descriptive name, and its ordinal position.SEGMENT_VALUE— the stored segment value assigned to the unit.SEGMENT_VALUE_DESC— derived viaIGS_FI_GEN_007.GET_SEGVAL_DESC, resolving the flex value set ID and segment value into a description; returns NULL when the segment value is NULL.FLEX_VALUE_SET_ID,VALIDATION_TYPE,INDEPENDENT_SEGMENT_NUM,DISPLAY_FLAG— flexfield configuration attributes governing how the segment is validated and displayed.ORG_ID— the operating unit (multi-org) context for the record.CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN— standard audit columns.
Common Use Cases and Queries
The view would typically support reporting on which accounting segments and values are configured for a given academic unit and version. A representative query retrieves the segment order, name, value, and resolved description for a specific unit:
SELECT segment_num, segment_name, segment_value, segment_value_desc FROM igs_ps_unit_accts_v WHERE unit_cd = :unit_code AND version_number = :version ORDER BY segment_num;- Filtering by
org_idto restrict results to a single operating unit when multi-org access is in effect. - Joining the view to other IGS unit or finance integration objects using
unit_cdandversion_numberto correlate unit definitions with their accounting segment assignments.
Because the product is obsolete and the view is documented as not implemented in the reference database, these queries should be treated as illustrative of the view's intended shape rather than as verified execution against a live 12.2.2 instance. Where the object is absent, equivalent data would be sourced from the underlying IGS_PS_UNIT_ACCTS and IGS_FI_ACCT_SEGS_V objects directly, applying the same outer-join and segment-number ordering logic.
-
View: IGS_PS_UNIT_ACCTS_V 12.1.1
Account segment values for a Unit.
APPS.IGS_PS_UNIT_ACCTS_V·↳ IGS_FI_ACCT_SEGS_V·↳ IGS_FI_GEN_007·↳ IGS_PS_UNIT_ACCTS·Explore IGS module →
-
View: IGS_PS_USEC_ACCTS_V 12.1.1
Revenue account segment values for an unit section.
APPS.IGS_PS_USEC_ACCTS_V·↳ IGS_FI_ACCT_SEGS_V·↳ IGS_FI_GEN_007·↳ IGS_PS_USEC_ACCTS·Explore IGS module →
-
View: IGS_AD_LOC_ACCTS_V 12.1.1
Shows the location account details for a person
APPS.IGS_AD_LOC_ACCTS_V·↳ IGS_AD_LOC_ACCTS·↳ IGS_FI_ACCT_SEGS_V·↳ IGS_FI_GEN_007·Explore IGS module →
-
View: IGS_FI_F_TYPE_ACCTS_V 12.1.1
Finance Type Accounts information
APPS.IGS_FI_F_TYPE_ACCTS_V·↳ IGS_FI_ACCT_SEGS_V·↳ IGS_FI_F_TYPE_ACCTS·↳ IGS_FI_GEN_007·Explore IGS module →
-
View: IGS_FI_SA_SEGMENTS_V 12.1.1
GL Accounting Flexfield segment values.
APPS.IGS_FI_SA_SEGMENTS_V·↳ IGS_FI_ACCT_SEGS_V·↳ IGS_FI_GEN_007·↳ IGS_FI_SA_SEGMENTS·Explore IGS module →
-
View: IGS_PS_ACCTS_V 12.1.1
Account segment values for a program.
APPS.IGS_PS_ACCTS_V·↳ IGS_FI_ACCT_SEGS_V·↳ IGS_FI_GEN_007·↳ IGS_PS_ACCTS·Explore IGS module →
-
View: IGS_OR_UNIT_ACCTS_V 12.1.1
revenue segment values for an organization unit
APPS.IGS_OR_UNIT_ACCTS_V·↳ IGS_FI_ACCT_SEGS_V·↳ IGS_FI_GEN_007·↳ IGS_OR_UNIT_ACCTS·Explore IGS module →
-
VIEW: APPS.IGS_PS_ACCTS_V 12.1.1
-
View: IGS_PS_UNIT_ACCTS_V 12.2.2
Account segment values for a Unit.
Not implemented in this database·Explore IGS module →
-
View: IGS_OR_UNIT_ACCTS_V 12.2.2
revenue segment values for an organization unit
Not implemented in this database·Explore IGS module →
-
View: IGS_FI_SA_SEGMENTS_V 12.2.2
GL Accounting Flexfield segment values.
Not implemented in this database·Explore IGS module →
-
View: IGS_PS_USEC_ACCTS_V 12.2.2
Revenue account segment values for an unit section.
Not implemented in this database·Explore IGS module →
-
View: IGS_FI_F_TYPE_ACCTS_V 12.2.2
Finance Type Accounts information
Not implemented in this database·Explore IGS module →
-
View: IGS_PS_ACCTS_V 12.2.2
Account segment values for a program.
Not implemented in this database·Explore IGS module →
-
View: IGS_AD_LOC_ACCTS_V 12.2.2
Shows the location account details for a person
Not implemented in this database·Explore IGS module →
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.