DRAFT Attch 5- CDRLs.pdf

DRAFT

FA445220R0009

Exhibit A-AD

EXHIBIT A-AD

CONTRACT DATA REQUIREMENTS LIST (CDRL)

Version 1.0

Remote Manifesting Resolution Center

Headquarters Air Mobility Command (HQ AMC) Air Transportation Division (A4)

Procuring Office: 763d Enterprise Sourcing Squadron (763 ESS) 510 POW/MIA Drive, Bldg P40, Suite E1004

Scott AFB, IL 62225-5022

Requiring Office: HQ AMC/A4 Scott AFB, IL 62225-5022

XX XXX 2020

DATA ITEM DESCRIPTION

Title: Summary Report of Data Records Management Activity Number: Approval Date:

ASMC Number: N/A Limitation:

DTIC Applicable: No GIDEP Applicable: No Preparing Activity: 10 (763 ESS/PKAA) Project Number: N/A

Applicable Forms: N/A

Use/relationship: The Summary Report of Data Records Management Activity is the contractor’s effort towards achieving contract objectives. This summary report documents all assistance provided to any worldwide Aerial Port Data records functions, to include requests for information (RFI’s) specific training provided as outlined in AFI 26-605, Volume 2 Section 4B.

This Data Item Description (DID) contains the format, content, and intended use information for the data deliverable resulting from the work task described in the contract. This One-Time DID is only for solicitation FA445220R0009 and the resulting contract from this solicitation.

Requirements:

1. Reference Documents. The applicable issue of the documents cited herein, including their approval dates and dates of any applicable amendments, notices and revisions, shall be as specified in the contract.

2. Format. The Summary Report of Data Records Management Activity documents shall be submitted in Microsoft Excel format. The report shall summarize monthly activities.

3. Content. The Summary Report of Data Records Management Activity documents shall contain the following:

1. Report of Data Records Transportation services as follows:

a) Any assistance provided pertaining to Personally Identified Information (PII) Requirements

b) Any assistance provided pertaining to aerial port workload reporting

c) Any assistance provided pertaining to Transportation Working Capital Fund (TWCF) and Non TWCF manifest register completion

d) Any assistance provided pertaining to creating and maintaining consolidated flight packages

e) Any assistance provided pertaining to airlift ground handling records disposition

f) Any assistance provided pertaining to deployed aerial port forces records disposition

g) Any assistance provided pertaining to small terminal record keeping

h) Any assistance provided pertaining to transportation discrepancy reporting

i) Assistance to data records functions for GATES database data integrity and management

2. Cumulative Total of Activities, identified above, for the fiscal year.

4. END of DID #.

Title: Summary Report of Reconciled Passenger and Cargo Manifests.

Number: Approval Date:

ASMC Number: N/A Limitation:

DTIC Applicable: No GIDEP Applicable: No Preparing Activity: 10 (763 ESS/PKAA) Project Number: N/A Applicable Forms: N/A

Use/relationship: The Summary Report of Reconciled Passenger and Cargo Manifest documents contractors’ effort to achieve contract objectives. This report is based upon monthly, quarterly, and fiscal year financial reconciliation efforts and activities. The report identifies Transportation Working Capital Fund (TWCF) cargo and passenger final manifests not sent via electronic interchange due to rejections and errors from Department of Defense, Distribution Component Billing System (DCBS) from the Global Aerial Port Execution System (GATES) after airlift of cargo and passenger traffic is completed to support billing and audit compliance for services to the airlift users.

This Data Item Description (DID) contains the format, content, and intended use information for the data deliverable resulting from the work task described in the contract. This One-Time DID is only for solicitation FA445220R0009 and the resulting contract from this solicitation.

Requirements:

1. Reference Documents. None.

2. Format. The Summary Report of Reconciled Passenger and Cargo Manifest documents shall be in Microsoft Excel format. Report shall be in a monthly, quarterly and cumulative fiscal year format.

3. Content. The Summary Report of Reconciled Passenger and Cargo Manifest documents shall contain the following:

a) Number of air inbound, air out bound, and surface manifests completed and successfully transmitted to DCBS to create financial transactions and billing activity through the

DCBS.

b) Report of reconciled information that will be displayed by COCOM, then Aerial Port Code that generated the manifest transaction. Each APC reported shall display the following:

1) Number of manifests

2) Corrective action taken

3) Number of attempts to clear, to include multiple attempts

4) Number of shipments cleared

5) Cargo weight in short tons

6) Total passengers cleared

7) Total Revenue and non-revenue generating manifests cleared (this is based on classification of mission flown)

DATA DESCRIPTION

Title: Report of Manual Manifesting Activity

Number: Approval Date:

ASMC Number: N/A Limitation:

DTIC Applicable: No GIDEP Applicable: No

Preparing Activity: 10 (763 ESS/PKAA) Project Number: N/A

Applicable Forms: N/A

Use/relationship: The Report of Manual Manifesting Activity documents the status of the contractor effort towards achieving contract objectives. It identifies the manual manifests inputted into Global Air Transportation Execution System (GATES).

This Data Item Description (DID) contains the format, content, and intended use information for the data deliverable resulting from the work task described in the contract. This One-Time DID is only for solicitation FA445220R0009 and the resulting contract from this solicitation.

Requirements:

1. Reference Documents. None.

2. Format. The Report of Manual Manifesting Activity shall be in the Microsoft Excel format.

3. Content. The Report of Manual Manifesting Activity shall contain the following:

a. Number of manifests entered for each non-GATES location by Area of Responsibility (AOR)

a. Total tons of cargo manifested

b. Total passengers (space required and space available) manifested

b. Number of manifests entered for each GATES location during system unavailability

a. Total tons of cargo

b. Total passengers (space required and space available) manifested

c. Number of manifests entered for each Web GATES location supported

a. Total tons of cargo

b. Total passengers manifested

d. Cumulative Total of Activities, identified above, for the fiscal year.

Title: Summary Report of Missing Passenger and Cargo Manifests.

Number: Approval Date:

ASMC Number: N/A Limitation:

DTIC Applicable: No GIDEP Applicable: No Preparing Activity: 10 (763 ESS/PKAA) Project Number: N/A Applicable Forms: N/A

Use/relationship: The Summary Report of Missing Passenger and Cargo Manifest documents contractors’ effort to achieve contract objectives. This report is based upon monthly, quarterly, and fiscal year financial reconciliation efforts and activities. The report identifies Transportation Working Capital Fund (TWCF) cargo and passenger final manifests that are in a missing status for more than seven days between not sent via electronic interchange due to rejeftions and errors from Department of Defense, Distribution Component Billing System (DCBS) from the Global Air Transportation Execution System (GATES) after airlift of cargo and passenger traffic is completed to support billing and audit compliance for services to the airlift users.

This Data Item Description (DID) contains the format, content, and intended use information for the data deliverable resulting from the work task described in the contract. This One-Time DID is only for solicitation FA445220R0009 and the resulting contract from this solicitation.

Requirements:

1. Reference Documents. None.

2. Format. The Summary Report of Reconciled Passenger and Cargo Manifest documents shall be in Microsoft Excel format. Report shall be in a monthly, quarterly and cumulative fiscal year format.

3. Content. The Summary Report of Reconciled Passenger and Cargo Manifest documents shall contain the following:

a) Number of air inbound, air out bound, and surface manifests greater than seven days not successfully transmitted to DCBS.

b) Report of corrected missing manifests information that will be displayed by COCOM, then Aerial Port Code that generated the manifest transaction. Each APC reported shall display the following:

1) Number of missing manifests

2) Corrective action taken

3) Number of attempts to submit

4) Number of shipments cleared

5) Cargo weight in short tons

6) Total passengers cleared

7) Total Revenue and non-revenue generating manifests cleared (this is based on classification of mission flown)

Title: Over/Short Shipment Report

Number: Approval Date:

ASMC Number: N/A Limitation:

DTIC Applicable: No GIDEP Applicable: No

Preparing Activity: 10 (763 ESS/PKAA) Project Number: N/A

Applicable Forms: N/A

Use/relationship: The Over/Short Shipment Report documents the status of the contractor effort towards achieving contract objectives. It identifies any cargo manifested which was processed as an overage or a shortage at an Aerial Port of Debarkation (APOD).

This Data Item Description (DID) contains the format, content, and intended use information for the data deliverable resulting from the work task described in the contract. This One-Time DID is only for solicitation FA445220R0009 and the resulting contract from this solicitation.

Requirements:

2. Format. The Over/Short Shipment Report shall be in Microsoft Excel format.

3. Content. The Over/Short Shipment Report shall contain the following:

a. Broken out by Combat Command (COCOM)

a. Number Over Shipments for Month

b. Number Short Shipments for Month

c. Transportation Control Number

d. Number of Transportation discrepancies reports (TDR) for Month

e. Number closed by Contractor for Month

f. Number closed by Aerial Port for Month

b. Cumulative Total of Activities, identified above, for the fiscal year.

Title: Ad Hoc Data Requests

Number: Approval Date:

ASMC Number: N/A Limitation:

DTIC Applicable: No GIDEP Applicable: No Preparing Activity: 10 (763 ESS/PKAA) Project Number: N/A Applicable Forms: N/A

Use/relationship: The Ad Hoc Data Requests provide Air Transportation enterprise analysis and decision support for AMC A4T and AMC Senior Leadership.

This Data Item Description (DID) contains the format, content, and intended use information for the data deliverable resulting from the work task described in the contract. This One-Time DID is only for solicitation FA445220R0009 and the resulting contract from this solicitation.

Requirements:

1. Reference Documents. None.

2. Format. The Ad Hoc Data Requests documents shall be delivered in one of the following formats specified by the government to include graphical (Power Point, Tableau), dashboard, scorecard, excel flat file and workbooks and PDF formats.

3. Content. The Ad Hoc Data Requests shall contain the following:

a) Summary of data requested

b) Derived data source

c) Version control sequence

d) Impacts relevant to the request

Title: Workload Reporting System Report

Number: Approval Date:

ASMC Number: N/A Limitation:

DTIC Applicable: No GIDEP Applicable: No

Preparing Activity: 10 (763 ESS/PKAA) Project Number: N/A

Applicable Forms: N/A

Use/relationship: The Workload Reporting System Report documents the status of the contractor effort towards achieving contract objectives. The Workload Reporting System (WRS) is used to compile monthly work data for resource management purposes. Air Mobility Command Form 82 “Monthly Station Traffic Handling Report” is used as a manual reporting procedure for locations unable to access the WRS site. This report identifies a breakdown of specific workload activities at each Aerial Port Location.

This Data Item Description (DID) contains the format, content, and intended use information for the data deliverable resulting from the work task described in the contract. This One-Time DID is only for solicitation FA445220R0009 and the resulting contract from this solicitation.

Requirements:

2. Format. The Workload Reporting System Report shall be in Microsoft Excel format.

3. Content. The Workload Reporting System Report shall contain the following:

a. For each Aerial Port Code location:

a. Number of Returned Reports per month

b. Number of Inputted Reports per month

c. Number of Rejected Reports per month

b. System account information:

a. Number of Accounts requested per month

b. Number of Accounts deleted per month

c. Number of Accounts reset per month

d. Number of Inactive accounts per month

c. Cumulative Total of Activities, identified above, for the fiscal year.

Title: Daily Shift Log

Number: Approval Date:

ASMC Number: N/A Limitation:

DTIC Applicable: No GIDEP Applicable: No Preparing Activity: 10 (763 ESS/PKAA) Project Number: N/A Applicable Forms: N/A

Use/relationship: The Daily Shift Log displays the contractors’ effort to achieve contract objectives. This report is a log of work accomplished during the applicable shift. The report shall include the highlights of the past shift, work tempo and completion, anomalies in data, issues, contacts from ports, Global Air Transportation Execution outages and requests for manual manifesting assistance, Customs and Border Patrol passenger vetting, and Homeland Security contagious disease passenger screening, that may need to be addressed by the next shift or the Government point of contact (POC), and any additional data that is requested.

This Data Item Description (DID) contains the format, content, and intended use information for the data deliverable resulting from the work task described in the contract. This One-Time DID is only for solicitation FA445220R0009 and the resulting contract from this solicitation.

Requirements:

2. Format. The Daily Shift Log shall be in the contractor’s format.

3. Content. Daily Shift Log shall contain the following:

a) Names of personnel on shift

b) Log of contacts made to external organizations

c) Security check verification

d) Date and time of event(s)

e) Meeting Minutes from any meetings throughout the day

1) Significant events

2) Notable takeaways

3) Any recommendations

Title: Department of Homeland Security (DHS) Log Summary

Number: Approval Date:

ASMC Number: N/A Limitation:

DTIC Applicable: No GIDEP Applicable: No

Preparing Activity: 10 (763 ESS/PKAA) Project Number: N/A

Applicable Forms: N/A

Use/relationship: The DHS Log Summary documents the status of the contractor effort towards achieving contract objectives. It identifies passenger vetting prior to manifesting specific passenger categories on Department of Defense (DoD) controlled airlift.

This Data Item Description (DID) contains the format, content, and intended use information for the data deliverable resulting from the work task described in the contract. This One-Time DID is only for solicitation FA445220R0009 and the resulting contract from this solicitation.

Requirements:

2. Format. The DHS Log Summary shall be in Microsoft Excel format.

3. Content. The DHS Log Summary shall contain the following:

a. Aerial Port of Embarkation for passengers

b. Aerial Port of Debarkation for passengers

c. Date

d. Mission Number

e. Time

f. Number of passengers

g. Reason for submitting data to either eSF or EAPIS

Title: Baggage Resolution Center Daily Log

Number: Approval Date:

ASMC Number: N/A Limitation:

DTIC Applicable: No GIDEP Applicable: No

Preparing Activity: 10 (763 ESS/PKAA) Project Number: N/A

Applicable Forms: N/A

Use/relationship: The Baggage Resolution Center Daily Log documents the status of the contractor effort towards achieving contract objectives. It identifies open and resolved lost baggage claims.

This Data Item Description (DID) contains the format, content, and intended use information for the data deliverable resulting from the work task described in the contract. This One-Time DID is only for solicitation FA445220R0009 and the resulting contract from this solicitation.

Requirements:

1. Reference Documents. None.

2. Format. The Baggage Resolution Center Daily Log shall be maintained in Microsoft Access and/or Microsoft Excel format.

3. Content. The Baggage Resolution Center Daily Log shall contain the following:

a. Daily Log

a. Baggage Service Center (BSC) Case File

b. Passenger Name

c. Number of Bags associated with the claim

d. Branch of Service

e. Type of claim

f. Carrier

g. Reporting station

h. Status of claim

i. Date form sent to passenger for damage or lost claims

j. Date claim closed

k. Additional remarks

b. Monthly Report:

a. Number of open claims

b. Number of resolved claims

i. Bag returned to the passenger

ii. Directed to DoD for reimbursement or contract carrier for reimbursement