added
VIZION - Columns added and changed
about 1 month ago by Evan Barry
With the June 2025 update, several columns in the Import and Export Performance products were modified.
Export Performance
The following attributes were renamed:
| New Field Name | Previous Field Name |
|---|---|
| LOAD_TEU_CLEARANCE_RATE_1_DAY | TEU_CLEARANCE_RATE_1_DAY |
| LOAD_TEU_CLEARANCE_RATE_3_DAY | TEU_CLEARANCE_RATE_3_DAY |
| LOAD_TEU_CLEARANCE_RATE_5_DAY | TEU_CLEARANCE_RATE_5_DAY |
| LOAD_TEU_CLEARANCE_RATE_7_DAY | TEU_CLEARANCE_RATE_7_DAY |
| LOAD_TEU_CLEARANCE_RATE_8_OR_MORE_DAY | TEU_CLEARANCE_RATE_8_OR_MORE_DAY |
The following attributes were added:
| Field Name | Description |
|---|---|
| N_CTNR_GTIN | The number of containers gated in |
| LOAD_TEU_CLEARANCE | The volume of twenty-foot equivalent units (TEU) loaded at the ocean port that also received a gate-in event |
| GTIN_TEU_CLEARANCE | The volume of twenty-foot equivalent units (TEU) in-gated at the ocean port |
| GTIN_TEU_CLEARANCE_RATE_1_DAY | TEUs gated in and loaded within 24 hours, divided by the total gated-in TEUs on that day |
| GTIN_TEU_CLEARANCE_RATE_3_DAY | TEUs gated in and loaded in 2–3 days, divided by the total gated-in TEUs on that day |
| GTIN_TEU_CLEARANCE_RATE_5_DAY | TEUs gated in and loaded in 4–5 days, divided by the total gated-in TEUs on that day |
| GTIN_TEU_CLEARANCE_RATE_7_DAY | TEUs gated in and loaded in 6–7 days, divided by the total gated-in TEUs on that day |
| GTIN_TEU_CLEARANCE_RATE_8_OR_MORE_DAY | TEUs gated in and loaded in 8+ days, divided by the total gated-in TEUs on that day |
Import Performance
The following attributes were added:
| Field Name | Description |
|---|---|
| DISC_TEU_CLEARANCE | The volume of twenty-foot equivalent units (TEU) discharged at the ocean port |
| DISC_TEU_CLEARANCE_RATE_1_DAY | TEUs where the difference between discharged and out-gated events is ≤ 24 hours, divided by the number of containers on the discharge date |
| DISC_TEU_CLEARANCE_RATE_3_DAY | TEUs where the difference is 2–3 days, divided by the number of containers on the discharge date |
| DISC_TEU_CLEARANCE_RATE_5_DAY | TEUs where the difference is 4–5 days, divided by the number of containers on the discharge date |
| DISC_TEU_CLEARANCE_RATE_7_DAY | TEUs where the difference is 6–7 days, divided by the number of containers on the discharge date |
| DISC_TEU_CLEARANCE_RATE_8_OR_MORE_DAY | TEUs where the difference is 8+ days, divided by the number of containers on the discharge date |