Search Results pnote_print_ind_desc

Overview

The view IGF_SL_DL_SETUP_V belongs to the IGF — Financial Aid product family, a module that Oracle has marked Obsolete in the EBS 12.1.1 / 12.2.2 documentation set. Functionally it exposes setup configuration data associated with the Direct Loan (DL) processing performed by the financial aid subsystem, joining the Direct Loan setup entity to the academic calendar instance that defines its effective period. The view is not a transactional or inquiry screen object; it is a denormalized, read-oriented projection intended for reporting, integration extracts, and downstream lookups where coded values must be presented alongside their descriptive translations.

A defining characteristic of this view is its heavy use of the IGF_AW_GEN.LOOKUP_DESC function, which resolves stored lookup codes into their human-readable descriptions at query time. Attributes such as PNOTE_PRINT_IND, DISCLOSURE_PRINT_IND, DL_VERSION, RESPONSE_OPTION_CODE, and FUNDING_METHOD are each paired with a derived description column, making the view suitable for direct presentation without additional decoding in the reporting layer. The ETRM metadata records that the object is not implemented in the reference database, and that no base objects are formally documented; the view text nevertheless provides the authoritative definition.

Underlying Base Objects

The view text defines two source objects:

• IGF_SL_DL_SETUP (aliased DLSET) — the primary Direct Loan setup table, supplying all configuration attributes and audit columns.
• IGS_CA_INST (aliased CI) — the academic calendar instance table, supplying start date, end date, and alternate code context.

The two are joined on the composite key CI_CAL_TYPE and CI_SEQUENCE_NUMBER, meaning each Direct Loan setup row is anchored to a specific calendar instance. Auxiliary lookups are resolved against the generic lookup mechanism through IGF_AW_GEN.LOOKUP_DESC with the lookup types IGF_SL_PNOTE_PRINT_IND, IGF_SL_DISCLOSURE_PRINT_IND, IGF_SL_DL_VERSION, IGF_SL_RESP_OPTIONS, and IGF_SL_FUNDING_METHODS.

Key Columns

• ROW_ID, DLSET_ID — surrogate and business identifiers for the setup record.
• CI_CAL_TYPE, CI_SEQUENCE_NUMBER, CI_START_DT, CI_END_DT, CI_ALTERNATE_CODE — calendar context and effective dating inherited from IGS_CA_INST.
• SCHOOL_ID — the school to which the Direct Loan configuration applies.
• ORIG_FEE_PERCT_STAFFORD, ORIG_FEE_PERCT_PLUS, INT_REBATE — origination fee percentages and interest rebate parameters.
• PNOTE_PRINT_IND / PNOTE_PRINT_IND_DESC, PNOTE_PRINT_COPIES — promissory note printing controls and their decoded descriptions.
• ACC_NOTE_FOR_DISB, AFFIRMATION_REQD, INTERVIEW_REQD — disbursement note, affirmation, and interview requirements.
• DISCLOSURE_PRINT_IND / DISCLOSURE_PRINT_DESC — disclosure statement print flags.
• DL_VERSION / DL_VERSION_DESC — Direct Loan program version indicator.
• RESPONSE_OPTION_CODE and its decoded description — the response option configuration the user searched for, resolved from lookup type IGF_SL_RESP_OPTIONS.
• FUNDING_METHOD and its description — funding mechanism resolved from IGF_SL_FUNDING_METHODS.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

The principal use case is configuration review: confirming which response option, funding method, promissory note, and disclosure settings apply to a given school and calendar instance. A representative query returning the response option configuration is:

SELECT school_id,
       ci_cal_type,
       ci_sequence_number,
       ci_start_dt,
       ci_end_dt,
       response_option_code,
       funding_method,
       dl_version_desc
  FROM igf_sl_dl_setup_v
 WHERE school_id = :school_id
 ORDER BY ci_start_dt DESC;

A second scenario validates that every setup row maps to a valid calendar instance, joining through IGS_CA_INST as the view already does. Because the underlying product is obsolete and the view is not implemented in current databases, organizations upgrading from earlier releases should treat references to IGF_SL_DL_SETUP_V as migration candidates, extracting the configuration to a supported target before decommissioning the financial aid schema.