Search Results batch_seq_num




Overview
Explore in AI Chat

Overview

IGF_SL_DL_MANIFEST_V is an Oracle E-Business Suite APPS-owned view within the IGF (Financial Aid) product family. It exposes the loan manifest data required for the Federal Direct Loan (DL) origination and disbursement process, presenting one record per loan record staged for transmission to the Common Origination and Disbursement (COD) system. The view is defined as a straightforward projection over the base table IGF_SL_DL_MANIFEST, aliased as PNMNV, and carries a STATUS column that reports the processing state of each manifest entry (for example, unprocessed, transmitted, or error). Because the Financial Aid module must assemble loan-level demographic and identifier data before submission, this view serves as the reporting and integration surface over the manifest table, allowing concurrent programs, extracts, and downstream interfaces to read the staged records without directly binding to the physical table. The BATCH_SEQ_NUM column, which is central to the user's search, is the sequence value that orders and groups records inside a submission batch, enabling a single manifest run to be broken into logical, ordered groupings.

Underlying Base Objects

ETRM documents the view as defined over a single referenced object: IGF_SL_DL_MANIFEST (aliased PNMNV in the view text). No additional base tables, synonyms, or remote objects are documented as contributing to the definition; the view is a direct column list over that one table. Every column returned by the view originates from IGF_SL_DL_MANIFEST, including PNMN_ID, BATCH_SEQ_NUM, LOAN_ID, and LOAN_NUMBER. Consequently, joins to person, loan, or award data are not embedded in the view; consumers must join outward to the appropriate Financial Aid and student records tables when demographic detail beyond the columns exposed here is required. The view inherits the ORG_ID column from the base table, indicating that manifest rows are partitioned by operating unit, and inherits the standard EBS audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) plus the concurrent program context columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) from the underlying table.

Key Columns

  • PNMN_ID — Primary identifier for the manifest record.
  • BATCH_SEQ_NUM — Sequence number that orders records within a manifest batch; drives batch grouping and ordering of loan submissions.
  • LOAN_ID / LOAN_NUMBER — Internal and external identifiers for the loan being reported.
  • B_SSN, B_FIRST_NAME, B_MIDDLE_NAME, B_LAST_NAME — Borrower identity attributes (the "B_" prefix denotes borrower) carried on the manifest.
  • STATUS — Processing state of the manifest entry.
  • ORG_ID — Operating unit that owns the manifest record.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS who-columns.
  • REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Concurrent program context identifying the process that created or updated the row.

Common Use Cases and Queries

Typical uses include verifying what is staged for a COD submission, diagnosing records stuck at a given STATUS, and auditing batches by sequence. To inspect the ordering and grouping established by BATCH_SEQ_NUM:

  • SELECT batch_seq_num, loan_number, b_ssn, status FROM igf_sl_dl_manifest_v WHERE org_id = :p_org_id ORDER BY batch_seq_num;
  • SELECT status, COUNT(*) FROM igf_sl_dl_manifest_v GROUP BY status;
  • SELECT * FROM igf_sl_dl_manifest_v WHERE request_id = :p_request_id; — to trace all manifest rows produced by a specific concurrent request.

Because BATCH_SEQ_NUM is exposed but not unique by itself, queries that group or order by it should also qualify on ORG_ID or REQUEST_ID to isolate the intended batch.