Search Results hrs_worked

Overview

IGF_SE_PAYMENT_V is an Oracle E-Business Suite supplementary view owned by the APPS schema and registered under FND Design Data as IGF.IGF_SE_PAYMENT_V. It resides in the IGF product family, which supports Oracle's Student Systems / financial aid and disbursement processing. According to its documented View Type, this object is classified as a supplementary view used to simplify forms coding, and Oracle explicitly warns that it should not be queried or altered directly because its definition may change dramatically in subsequent minor or major releases.

Functionally, the view exposes payment-level records tied to payroll disbursement transactions. It presents a denormalized projection of payment rows, including payroll identifiers, dates, person references, fund and authorization references, paid amounts, and audit/WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and so on). The view carries a status of VALID in the documented environment, confirming that its underlying dependencies resolve correctly at that release level.

Underlying Base Objects

The documented dependency list identifies the following base references for the view:

• APPS.IGF_AW_GEN — the general awards/source generation table referenced by the view definition.
• APPS.IGF_SE_PAYMENT — the core payment detail (student/disbursement payment) table.

APPS.IGF_SE_PAYMENT_V is not referenced by any other database object, meaning it is a leaf-level reporting/forms convenience object rather than a dependency for other views or packages. The ETRM metadata records no additional documented base objects for this release beyond those above.

Key Columns

The view exposes the following columns, based on documented datatypes and comments:

• ROW_ID (ROWID) — row identifier for the view output.
• TRANSACTION_ID, PAYROLL_ID (NUMBER) — transaction and payroll identifiers linking the payment row to its parent processing entities.
• PAYROLL_DATE (DATE) — the date associated with the payroll/payment record.
• PERSON_ID (NUMBER) — the person/student associated with the payment.
• FUND_ID, AUTH_ID (NUMBER) — fund and authorization identifiers used in aid/disbursement accounting.
• LD_CAL_TYPE, LD_SEQUENCE_NUMBER, LD_ALTERNATE_CODE, LD_START_DATE, LD_END_DATE (VARCHAR2) — all documented as "No longer used." Legacy calendar references retained for backward compatibility.
• PAID_AMOUNT (NUMBER) — the amount paid on the record.
• HRS_WORKED (VARCHAR2) — documented as "No longer used." This is the column most relevant to the user search "hrs_worked." Note that it is a legacy VARCHAR2 field and is explicitly deprecated; it should not be relied upon for current reporting of work hours.
• ORG_UNIT_CD (VARCHAR2(360)), SOURCE (VARCHAR2(30)), SOURCE_DESCRIPTION (VARCHAR2(4000)) — organizational and source-descriptive attributes.
• WHO/audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

Because Oracle documents this as a forms-coding aid with a stability warning, production reporting should generally reference the underlying tables (IGF_SE_PAYMENT, IGF_AW_GEN) rather than the view. Where the view is used, functions typically retrieve payment amounts, payroll and person associations, fund/authorization references, and organizational context.

A representative query retrieving selected payment columns follows:

• SELECT TRANSACTION_ID, PAYROLL_ID, PAYROLL_DATE, PERSON_ID, FUND_ID, AUTH_ID, PAID_AMOUNT, ORG_UNIT_CD FROM APPS.IGF_SE_PAYMENT_V;
• To constrain by payroll and person: ... WHERE PAYROLL_ID = :payroll_id AND PERSON_ID = :person_id;

Users searching on "hrs_worked" should note that HRS_WORKED exists in this view but is explicitly documented as no longer used and typed as VARCHAR2. It therefore cannot be depended upon for numeric hours reporting in 12.1.1 or 12.2.2; alternative source columns or underlying tables must be consulted for current hours-worked data.