Search Results declined_ind

Overview

IGS_RE_THS_PNL_MBR_V is an Oracle E-Business Suite view owned by the APPS schema in the IGS (Student System) product family. It exposes thesis panel member records maintained by the Oracle Student System thesis and research management functionality. The view presents one row per thesis panel member assignment, joining the panel member base table to the trading community party table so that human-readable party numbers and related party identifiers are available alongside the raw internal person identifiers.

Because the object is a view rather than a table, it carries no independent storage and is always resolved at runtime against its underlying base tables. It is intended for reporting, inquiry forms, and integration extracts that must present panel membership data in a denormalized, display-ready form. The presence of audit columns such as CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN confirms that it is designed to support both functional inquiry and change-tracking reporting.

Underlying Base Objects

The view is defined over two documented base objects:

• IGS_RE_THS_PNL_MBR (aliased TPM) — the thesis panel member table, supplying the primary business columns and all audit and workflow attributes.
• HZ_PARTIES (aliased PE) — the trading community party table, supplying the PARTY_NUMBER column via the join condition TPM.PERSON_ID = PE.PARTY_ID.

The join is an inner join on person identity, so a panel member row is returned only when a matching party record exists in HZ_PARTIES. The view also fabricates a ROW_ID column from TPM.ROWID, which gives consumers a pseudo-key that can be used in interactive forms where a stable identifier is required.

Key Columns

• ROW_ID — the underlying row identifier of the panel member record, used as a surrogate key by forms and DML-capable regions.
• CA_PERSON_ID, CA_SEQUENCE_NUMBER — identify the candidate or academic record context for the thesis.
• THE_SEQUENCE_NUMBER — the thesis instance to which the panel member belongs.
• PERSON_ID, PERSON_NUMBER — the internal person identifier and the external party number from HZ_PARTIES.
• PANEL_MEMBER_TYPE — classifies the member role on the panel (for example examiner, supervisor, or chair).
• CONFIRMED_IND, CONFIRMED_DT — derived flag and stored date indicating whether the member confirmed participation. The flag is computed with DECODE(NVL(CONFIRMED_DT, SYSDATE), SYSDATE, 'N', 'Y'), so a null date yields 'N'.
• DECLINED_IND, DECLINED_DT — the declined equivalent, and the column most commonly searched for. DECLINED_IND is computed as DECODE(NVL(DECLINED_DT, SYSDATE), SYSDATE, 'N', 'Y'); it returns 'Y' only when DECLINED_DT is populated, and 'N' when it is null.
• ANONYMITY_IND, THESIS_RESULT_CD, PAID_DT, TRACKING_ID — anonymity control, thesis outcome, honorarium payment date, and workflow tracking reference.
• RECOMMENDATION_SUMMARY — free-text summary of the member's recommendation.

Common Use Cases and Queries

The most frequent use of this view is locating panel members who have declined an invitation, or confirming which members have and have not responded. A typical query filters on the derived indicator:

• SELECT person_number, panel_member_type, declined_dt FROM igs_re_ths_pnl_mbr_v WHERE declined_ind = 'Y';
• SELECT the_sequence_number, person_number, confirmed_ind, declined_ind FROM igs_re_ths_pnl_mbr_v WHERE the_sequence_number = :p_thesis;
• SELECT panel_member_type, COUNT(*) FROM igs_re_ths_pnl_mbr_v WHERE declined_ind = 'N' GROUP BY panel_member_type;

Additional scenarios include honorarium reconciliation filtered on PAID_DT, audit reporting on LAST_UPDATE_DATE, and integration extracts that publish panel composition to external research or examination systems. Because DECLINED_IND and CONFIRMED_IND are expressions rather than indexed columns, queries filtering on them scan the full join result; where performance is critical, filtering directly on DECLINED_DT or CONFIRMED_DT is preferable.