Please see the attachment for detailed pictures that accompany this report description.
What does this report show?
The Contract Payment Notifications report allows for the tracking of contract progress payment activity, displaying each select details from each contract and related payment, along with the various activity dates of each.
Report Overview
The Contract Payment Notifications report displays each eSettlements contract payment and its status in the subcontractor acknowledgement process.
Report Prompts
The first section of the report contains the available prompts. Utilize the prompts to narrow down your report results or find specific values. The values applied to the prompts will appear in the “Report Filters” section described below. Leaving a prompt blank is equivalent to selecting all available values with values associated with them (e.g., if you leave Department blank, your report will show all departments’ contracts).
Prompt Descriptions
Fiscal Year: The fiscal year associated with the contract payment date, as defined above.
Fiscal Period: The fiscal period (month) associated with the contract payment date, as defined above.
Department Group Code: The three-character top-level department code associated with the department recorded on the PeopleSoft contract entry page.
Department Group Description: The description of the three-character top-level department code associated with the department recorded on the PeopleSoft contract entry page.
Supplier Number: The number of the prime supplier to which the contract was awarded.
Supplier Name: The name of the prime supplier to which the contract was awarded.
Agreement Number: The PeopleSoft contract number.
Agreement Description: The PeopleSoft contract description.
Contract Type Description: The description of the contract type recorded on the PeopleSoft contract entry page.
14B Compliance Officer: The CMD contract compliance officer (CCO) responsible for the contract.
Header Start Date: The contract term start date from the PeopleSoft contract entry page. This is a required prompt and defaults to include the two most recently completed fiscal years.
Header End Date: The contract term end date from the PeopleSoft contract entry page.
Subcontractor Number: The number of the supplier (prime or sub) associated with the contract.
Subcontractor Name: The name of the supplier (prime or sub) associated with the contract.
Progress Payment Invoice Number: The progress payment invoice number entered into eSettlements.
Progress Payment Voucher Number: The PeopleSoft voucher number associated with the progress payment invoice number.
Progress Payment Reporting Begin Date: The begin date of the progress payment reporting period entered into eSettlements.
Progress Payment Reporting End Date: The begin date of the progress payment reporting period entered into eSettlements.
Progress Payment Prime Payment Date: The date of the payment issued to the prime contractor.
Progress Payment Date: The date of the payment sent from the prime to the subcontractor.
Progress Payment Invoiced Date: The date on which the subcontractor invoiced the prime, as recorded in eSettlements.
Progress Payment Confirmed Payment Date: The date on which the subcontractor confirmed that payment was received as agreed from the prime, as recorded in eSettlements.
Progress Payment Failed to Confirm Payment Date: The date on which the subcontractor failed to confirm payment, as defined by five business days elapsing without confirmation recorded in eSettlements.
Progress Payment Rejected Date: The date on which the subcontractor rejected the payment recorded by the prime in eSettlements, if applicable.
Progress Team Prime Payment Amount: The progress payment amount paid to the prime contractor.
Report Results
The second section of the report contains the report results.
Column Descriptions
Supplier Number: The number of the prime supplier to which the contract was awarded.
Supplier Name: The name of the prime supplier to which the contract was awarded.
Agreement Number: The PeopleSoft contract number.
Agreement Description: The PeopleSoft contract description.
14B Compliance Officer: The CMD contract compliance officer (CCO) responsible for the contract.
Department Group Code: The three-character top-level department code associated with the department recorded on the PeopleSoft contract entry page.
Project Team Constituent Name: The name of the supplier (prime or sub) associated with the contract.
Progress Payment Invoice Number: The progress payment invoice number entered into eSettlements.
Project Team Gross Payment Amount: The progress payment amount entered into eSettlements by the prime.
Progress Payment Reporting Period Begin Date: The begin date of the progress payment reporting period entered into eSettlements.
Progress Payment Reporting Period End Date: The begin date of the progress payment reporting period entered into eSettlements.
Progress Payment Prime Payment Date: The progress payment amount paid to the prime contractor.
Progress Payment Payment Date: The date of the payment sent from the prime to the subcontractor.
Progress Payment Invoiced Date: The date on which the subcontractor invoiced the prime, as recorded in eSettlements.
Progress Payment Confirmed Payment Date: The date on which the subcontractor confirmed that payment was received as agreed from the prime, as recorded in eSettlements.
Progress Payment Failed to Confirm Payment Date: The date on which the subcontractor failed to confirm payment, as defined by five business days elapsing without confirmation recorded in eSettlements.
Progress Payment Rejected Date: The date on which the subcontractor rejected the payment recorded by the prime in eSettlements, if applicable.
Report Filters
Just under the report output are the report filters. The filters include several “hard-coded” filter values which are mandatory for basic report functionality, as well as any prompts applied by the user.
Progress Payment Invoice Number will always be non-null.
Agreement Approval Status will always equal only approved contracts.
Any other filters that you have selected in the report filters will also appear in this section.
Please see the attachment for detailed pictures that accompany this report description.
For more information about LBE Participation and Utilization Dashboards, please read the following articles: