The following table lists the fields in the argo_chargeable_marine_events which is extracted from billable events which occur on the vessel visit:
|
Field Label |
Data Type |
Field Size |
Description/Applicable Reportable Entity Tag |
|---|---|---|---|
|
gkey |
bigint(auto_increment) |
20 |
|
|
batch_id |
bigint |
20 |
Batch number is assigned by auto increment for every extract. |
|
is_locked |
tinyint |
1 |
Boolean value of 0 or 1 is stored. If it is TRUE then N4 will not update the row. |
|
status |
varchar |
30 |
"QUEUED" indicates that the record is extracted. |
|
event_type |
varchar |
30 |
Id field from the event type screen |
|
event_gkey |
bigint |
20 |
Gkey of srv_event table is extracted for internal reference. |
|
event_quantity |
double |
22 |
Quantity. |
|
event_quantity_unit |
varchar |
|
Quantity Unit of measure |
|
facility_gkey |
bigint |
20 |
Internal reference |
|
facility_id |
varchar |
20 |
Facility Id |
|
complex_id |
varchar |
20 |
Complex Id |
|
operator_id |
varchar |
20 |
Operator Id |
|
vvd_gkey |
bigint |
20 |
Internal reference |
|
vv_id |
varchar |
30 |
Vessel visit id |
|
operator_id |
varchar |
30 |
Vessel visit Id |
|
vv_ata |
datetime |
19 |
Actual arrival time |
|
vv_atd |
datetime |
19 |
Actual departue time |
|
vsl_id |
varchar |
30 |
Vessel id |
|
vsl_name |
varchar |
80 |
Vessel name |
|
vsl_type_id |
varchar |
80 |
Vessel type id |
|
vsl_class_id |
varchar |
80 |
Vessel class id |
|
vsl_loa_cm |
bigint |
20 |
LOA number |
|
vsl_beam_cm |
bigint |
20 |
Beam length |
|
vsl_net_revenue_tons |
bigint |
20 |
Net registered tons |
|
vsl_is_self_sustaining |
tinyint |
1 |
Boolean value. Vessel is Self Sustaining. |
|
vsl_operator_id |
varchar |
20 |
Vessel Operator Id |
|
vsl_operator_name |
varchar |
20 |
Vessel Operator name |
|
vsl_operator_name |
varchar |
20 |
Vessel Operator name |
|
vv_eta |
datetime |
19 |
Vessel visit ETA |
|
vv_etd |
datetime |
19 |
Vessel visit ETD |
|
vv_time_start_work |
datetime |
19 |
Vessel work starting time |
|
vv_time_end_work |
datetime |
19 |
Vessel work ending time |
|
flex_string01 |
varchar |
255 |
Refer to Flex field mapping. |
|
flex_string02 |
varchar |
255 |
|
|
flex_string03 |
varchar |
255 |
|
|
flex_string04 |
varchar |
255 |
|
|
flex_string05 |
varchar |
255 |
|
|
flex_date01 |
datetime |
19 |
|
|
flex_date02 |
datetime |
19 |
|
|
flex_date03 |
datetime |
19 |
|
|
flex_date04 |
datetime |
19 |
|
|
flex_date05 |
datetime |
19 |
|
|
flex_long01 |
bigint |
20 |
|
|
flex_long02 |
bigint |
20 |
|
|
flex_long03 |
bigint |
20 |
|
|
flex_long04 |
bigint |
20 |
|
|
flex_long05 |
bigint |
20 |
|
|
created |
datetime |
19 |
Extract record created date and time |
|
creator |
varchar |
30 |
Extract record creator |
|
changed |
datetime |
19 |
Extract record last modified date and time |
|
changer |
varchar |
30 |
Extract record last modified user |