Section C Final - Attachment 3.docx

GSA SOLICITATION QMAD-JM-100001-N

August 23, 2010

GSA SOLICITATION QMAD-JM-100001-N

Attachment 3 – ETS2 Standard Reports August 23, 2010

Attachment 3 ETS2 Standard Reports Purpose This attachment includes a list of Standard Process and Operational Information reports required within ETS2 as referenced in Section C.9.1, Queries and Reports.

The desired performance outcome is the delivery of comprehensive, streamlined, high quality, reporting functionality to the Federal agencies by ensuring all expectations are clearly understood.

Standard Process and Operational Information Reporting Requirements The Contractor shall provide the Government with the following reports if they are not included in the Contractor’s standard report suite:

the ability to track and report travel obligation and liquidation information, for each customer agency organization, sub-organization(s), and funding organization(s), and for any time period for which ETS2 data exists, based on the FTR Travel Purpose Identifiers (TPIs);

the travel documents for which approval is outstanding more than x business days where “x” is a configurable number up to 30;

a list of authorized travel documents for which a voucher has not been completed more than x business days after return date where “x” is a configurable number up to 30;

total number of travel authorizations and amendments in a given date range;

total number of travel vouchers and amendments in a given date range.

the ability to track and report obligation and liquidation information of approved travel documents, for each customer agency organization, sub-organization(s), and funding organization(s), and for any time period for which ETS2 data exists, based on one or more of the following data elements: agency organization, traveler, TDY location, accounting string, length of trip, and approval date;

the ability to track and report cancelled travel documents, for each customer agency organization, sub-organization(s), and funding organization(s), and for any time period for which ETS2 data exists, based on one or more of the following data elements: agency organization, traveler, accounting string, and cancelled date;

the ability to track and report travel obligation and liquidation information, for each customer agency organization, sub-organization(s), and funding organization(s), and for any time period for which ETS2 data exists, based on the OCONUS/CONUS;

the ability to track, age, and report unused air and rail tickets (including restricted and unrestricted fares) for each customer agency organization, sub-organization(s), and funding organization(s), and for any time period for which ETS2 data exists, based on at least the following data elements: authorization number, agency organization and traveler;

the ability to track, age, and report on the disposition of unused tickets, including voided and refunded transactions as well as reclaimed value from previously unused non-refundable air and rail tickets for each customer agency organization, sub-organization(s), and funding organization(s), and for any time period for which ETS2 data exists, based on at least the following data elements: authorization number, agency organization and traveler;

a list of travel authorizations with an advance for which a voucher has not been completed more than x business days after return date where “x” is a configurable number up to 30 (See Section C.4.2.15.1, Travel Advances);

the capability for the customer agency to generate a report on all non-Federally sponsored travel trips. The report shall include, at a minimum; traveler name; organization/agency of assignment; trip identifying information, such as travel authorization number, document name, trip dates, location, purpose, and so on; and amount paid by non-Federal sponsor per expense, as allocated per non-Federal sponsored LOA (See Section C.4.2.23.1);

the ability to track and report unapproved travel documents, for each customer agency organization, sub-organization(s), and funding organization(s), and for any time period for which ETS2 data exists, based on one or more of the following data elements: agency organization, traveler, TDY Location, accounting string, and current status;

a list of users and associated profile information based on one or more of the following data elements: agency organization, traveler, default accounting string, and activation status;

document routing details based on one or more of the following data elements: agency organization, traveler, and document type;

a list of accounting strings and associated details of the accounting string based on one or more of the following data elements: agency organization, accounting string label, and fiscal year, the total number of self-service and full-service reservation fees (separated by type) for each customer agency organization, sub-organization(s), funding organization(s), and for any time period for which ETS2 data exists, and provide ability to distinguish with which reservation the fees are associated, by traveler; and a list of fees by type of service for each of the transaction based CLINs as defined in Section B for each customer agency organization, sub-organization(s), and funding organization(s), and for any time period for which ETS2 data exists, to include, at a minimum the agency organization, travel authorization number and traveler ID.