G7 Project Overview

HOME

PROJECT OVERVIEW

PROJECT FINDINGS

PROJECT MANAGEMENT

DOCUMENTATION

ABOUT US

PRACTICUM HOMEPAGE

 

Sponsor Data

Team Methodology

Work Scope

Project Timeline

Sponsor Data

Our sponsor will provide us test data for two clients based on their current records. The provided data will consist of some of the variables as mentioned below. For ease of explanation, variables are broadly categorized into different categories.

1. Shipment Variables: Unique identification number (HAWB Number), Origin of Shipment (ORG), Final Destination of Shipment (FDST), Type of Service (SVC), Type of Commodity Shipped (CMDTYCD)
2. Payor Variables: Payor Account (PAYOR_ACCT), Payor Name (PAYOR_NAME), Payor Corporate ID (PAYOR_CORP)
3. Shipment Weight Variables: Pieces (PCS), Chargeable Weight (WGT), Actual Weight (AWGT), Dim Factor (DIM_FTR), Volume of Shipment (VOL)
4. Payment Variables: Freight Charge (WTCHG), Handling Charge (HNDLG), Pickup charge (PU), Miscellaneous Charge (MISC), Total Charges (TTG), Advanced Charges (ADV)
5. Timestamp Variables: Freight Received Date (FRTRDATE), Final Recovery Date (FNLRCVYDT), Time Broker Notified Date (TBH_DATE), Entered Customs Date (CUS_DATE), Cleared Customs Date (CLC_DATE), Out for Delivery Date (OFDDATE), Arrival Date (ARRIVEDATE), Due Date (DUEDATE), POD Date (PODATE)
6. Gateway Variables: Gateway Origin (GTWY_ORG), Gateway Airline (GTWYAIRL), Gateway Master Airway Bill (GTWYMAWB), Gateway Destination (GTWY_DST), Gateway Flight Number (GWWY_FLT), Gateway Flight Date (GTWYFLTDT), Gateway Recovery Date (GTWYRCVYDT), Origin (ORG1), Airline (AIRL1), Master Airway Bill Number (MAWB01), Destination (DST1), Flight Number (ALFLT1), MB Flight Date (MBFLTDT1), MB Recovery Date (MBRCVYDT1)
7. Warehouse Timestamp Variables: Freight Physically Recovered Date (FRTPHYDRATE), Actual Pick Up Date & Time (APT_DATE), Consol Closed (CLS_DATE), Departed Origin Airport (CFM_DATE), Delivery Matrix Criteria (DM_CRITERIA), Delivery Matrix Level (DM_LVL), Delivery Matrix Transit Time (DM_AGREED_TRANSIT_TIME)

Overall, Project STP+ will map the road towards efficient collaboration, and drive towards greater business growth.