USC-8_Att_2_Operational_Reports_Dec_2014.pdf

USC-8 Attachment 2

ATTACHMENT 2, OPERATIONAL REPORTS AND FORMATS

Attachment 2

Operational Reports

1. Cargo Lift Report – Containers and Breakbulk

1.1. Required by: 3.A.11.

1.21. Reports due: One business day after vessel departure via the Lift On Board (LOB) Portal.

1.32. Medium: Excel attachment uploaded into Pipeline Asset Tool (PAT)/LOB Portal per Point of Embarkation

(POE)

1.43. Distribution: Authorized users of PAT

1.54. Required elements:

̶ Mandatory header fields (Populates these fields for all records)

1. SCAC

2. VOYDOC (Select from dropdown)

3. Sail Date

4. POE (Select from dropdown – based on vessel schedule and voydoc selection)

5. Vessel Name (select from dropdown – based on vessel schedule and voydoc selection)

̶ Excel Columns heading (One row per shipment)

1. Van Type – 35 characters

2. TCN - 17 characters

3. Container # - 11 characters with dash

4. Consignor DODAAC – 6 characters

5. Commercial VOYDOC – 10 characters

6. Point of Debarkation (POD) – 3 characters

7. Commercial Booking Number – 25 characters

8. PCFN – 6 characters

9. Vessel Status – 2 characters (e.g., F2, W2, E2, etc)

10. Consignee DODAAC – 6 characters

11. Cargo Description

12. Cube – Numeric

13. Length – Numeric

14. Width – Numeric

15. Height - Numeric

16. Weight – Numeric

17. Measurement Tons - Numeric

18. Is Booked (Y/N) – Based on if the Contractor thinks the item has been booked

19. Has SI (Y/N) – Based on whether Contractor has VSI

20. Ocean Bill of Lading (OBL) – Required for all DOD shipments (containers/breakbulk) with

CONUS POD.

21. Comment One – free form text field for any Contractor comment on the item (250 characters max)

22. Comment Two – free form text field for any Contractor comment on the item (250 characters max)

2. Pre-Arrival Notice

2.1. Required by: 3.A.11.

2.21. Reports due: Three business days (3) days prior to the scheduled arrival of the delivering vessel, or one business day after sail if less than seven (7) days sail time to POD.

2.32. Medium: Excel attachment uploaded into PAT per POD.

2.43. Distribution: Authorized users of PAT

2.54. As required locally or upon request of SDDC Terminals, Contractor will provide information to support Customs Clearance via email or LOB Portal in Element #22 (Comment Two Field).

Formatted: Centered, Space After: 12 pt

2.65. Required elements:

̶ Excel column headings (One row per shipment)

1. TCN – 17 Alpha-numeric characters

2. Consignee DODAAC – 6 Alpha-numeric characters

3. Container Number – 11 alpha-numeric characters

4. Estimated date of Vessel Arrival – M/D/YYYY

5. Estimated time of Vessel Arrival – XXXX (e.g., 0800)

6. Contractor Name/SCAC – 4 characters

7. PCFN – 6 digits

8. Commercial Booking Number – 25 characters

9. Vessel Name

10. Commercial Voyage Number

11. Military VOYDOC – 5 characters (from IBS)

12. Seal Number (when applicable for containers and/or breakbulk)

13. POD – 3 characters

14. Vessel Name of Mother Vessel (if transshipped)

15. Commercial Voyage Number of Mother Vessel (if transshipped)

3. Containerization Report:

3.1. Required by: 3.A.11.

3.12. Reports due: Next business day after Contractor provides container cargo handling service or LCL service

3.32. Medium: Excel attachment to email

3.43. Distribution: Cognizant SDDC terminal as advised by Contracting Officer Representative (COR)

3.54. Required elements:

1. Booked container TCN

2. POE

3. Cargo TCN, pieces, weight, cube

4. Container number and prefix

5. Seal number

6. Date stuffed

7. POD

8. Consignee if for inland delivery by the Contractor

9. Booking reference

10. Booked / scheduled vessel

11. Location stuffed

4. Direct Booking Report:

4.1. Required by: 3.A.11.

4.21. Reports due: Within 24 hours of booking or booking cancellation/ decrease/ increase via the LOB Portal

4.32. Medium: Excel attachment uploaded into PAT

4.43. Distribution: Authorized users of PAT

4.54. Required elements:

1. Contractor name

2. Vessel name

3. TCN

4. DTR Commodity code

5. SCAC code

6. Booked VOYDOC#

7. Estimated sail date

8. POE

9. POD

10. Shipper DODAAC

11. Shipper POC

12. Consignee DODAAC

13. Equipment size and type

14. Estimated arrival date at POD

15. Date booked

16. Flag

17. RDD (Required Delivery Date)

18. Report type (new booking or cancellation/decrease/rolled)

5. Container Fleet Report

5.1. Required by: 3.A.11.

5.21. Reports due: Monthly, on the first business day of the month.

5.32. Medium: Excel attachment uploaded into PAT

5.43. Distribution: Authorized users of ETA/PAT

5.54. Required elements:

1. SCAC

2. Container Number (Full ISO Container Number – 11 Characters)

3. Equipment Type Code (ISO Size/Type Code, for example 22G1 – 4 Characters)

4. Date acquired (MMDDYYYY format)

5.65. Other data elements may be provided for reference and ease of transmitting.