Location*

Enter the 12-character Location of the Pipeline in either DLS (include M for meridian) or NTS format (without / or -). For example, 101504509W4M

Name*

Free-format up to  60  characters.

File Status*

Code  must  exist in  Validation Table   –   File Status Pipeline .

Note: Generally, terminating/inactivating files should be done in the Qbyte CS Land application. IF the File Status is changed in Qbyte Exchange, remember to also update the Status Date.

Status Date*

Date must be in a yyyy-MM-dd format.

Admin Company*

Code must exist in Validation Table – Owners .

Area*

Code must exist in Validation Table.

Province

Defaults automatically based on the Area chosen.

Division

Code must  exist in Validation Table.

Major Facility

Code must exist in Validation Table – Major Facility.

Major Facility Code

Will automatically default based on the Major Facility chosen.

Contract Operator

BA Code entered must  exist in Business Associates .

Cost Centre

Cost Centre Code entered must exist in Cost Centres .

Gov’t Unit Code

Code must exist in Validation Table.

DOI Number

Free-format up to 19 characters.

Reserve

Code must exist in Validation Table .

Original AFE

Free-format up to 20 characters.

Govern Agmt Oper

BA Code entered must exist in Business Associates .

Governing Agmt

Agreement must exist in Database.

File Number*

Occurrence*

Do not populate this column when inserting new data. This is a system-generated value and it will be populated during Save.

Note : The  Occurrence (Occ) Number can be renumbered at any time in the Qbyte CS Land application (if required) to change the display order of the rows.

Licence*

Free-format up to 12 characters.

Line No*

Free-format up to 4 characters.

GCA Number

Free-format up to 16 characters.

Licence Date

Value must be in a yyyy-MM-dd  format.

Pipeline Status*

Code must exist in Validation Table – Pipeline Status.

Licensee*

BA Code entered must exist in Business Associates .

Substance*

Code must exist in Validation Table – Pipeline Substance.

From Location*

Enter the 12-character Location of the Pipeline in either DLS (include M for meridian) or NTS format (without / or -). For example, 101504509W4M

To Location*

Enter the 12-character Location of the Pipeline in either DLS (include M for meridian) or NTS format (without / or -). For example, 101504509W4M

From Facility*

Code must exist in Validation Table – Facility Type.

To Facility*

Code must exist in Validation Table – Facility Type.

Length (km)

Free-format up to 15 characters.

O.D. (mm)

Decimal number up to 12 characters.

File Number*

Occurrence

Do not populate this column when inserting new data. This is a system-generated value and it will be populated during Save.

Note : The  Occurrence (Occ) Number can be renumbered at any time in the Qbyte CS Land application (if required) to change the display order of the rows.

Delete

This value is applicable on the spreadsheet only and is not stored in the table. 

When inserting a new Remarks record, enter a value of "N".  If blank, "N" is assumed.

When updating, retrieve existing data via Get Data, the Delete value will default to "N".  Change the value to "Y" to indicate that you wish to delete the specific row.  If blank, "N" is assumed. 

• Validate will display a 'Conflict' error along with message 'Row will be deleted - are you sure?'.  Simply change the Delete column back to "N", if you change your mind.  

• Upon Save, the Remarks with a delete flag of "Y" are deleted from the database and the remaining remarks occurrence number will be renumbered.  However, the just deleted row will still appear temporarily on the spreadsheet with status = 'Deleted' as a visual indication that the row has been deleted and the occurrence renumber will not be apparent.  A subsequent Get Data will omit the deleted rows and display the reordered remarks occurrence. 

Remark Type*

Code must exist in Validation Table

Remark Date

Value must be in a yyyy-MM-dd format.

Remark*

Free-format up to 1910 characters.

File Number*

When  inserting  new Rel Files, the File Number specified must already exist.

Related Subsystem*

Acceptable codes: C – Contracts, M – Minerals, S – Surface, W – Wells.  Qbyte Exchange has the same Related Files exceptions as Qbyte CS Land.

Note: Third Party/Well relationships are display only as wells are deemed related via the User Well tab.

Related File Number*

Related File Sub

Enter a Sub if the desire is to relate at the Sub Level.

Relationship

Code  must  exist in the Relationship Validation Table .

Comments

Free-format up to  120  characters.

File Number*

When inserting a new Client Defined record, the File Number specified must already exist.  Any one File Number may have multiple rows in the spreadsheet if there are more than 1 applicable Client Defined Labels/Values.  

When updating an existing Client Defined record, the File Number cannot be changed.

Label*

When inserting a new Client Defined record, the Label must be entered exactly as it appears in the Qbyte CS Land window (or as defined in Admin > Client Defined Fields update screen). 

When updating an existing Client Defined record, the Label cannot be changed.

Value*

The Value is required when inserting new rows and can also be updated after the initial save.  The cell is always defined as Text in the Qbyte Exchange spreadsheet regardless of Value entered. 

Values entered are validated accordingly per the field setup in Qbyte CS Land:

• Dates can be entered with or without a format.   For example, if a date format of 'yyyy-mm-dd' has been defined, the date must be entered as '2022-12-13'. If a date format was not defined, the date can be entered as '2022-12-13', and Qbyte Exchange will format the date to the default date format of 'Dec 13, 2022' - just like it is in the application.

• Validation codes entered must exist in the applicable validation code table.

• String values entered must not exceed 1910 alpha/numeric characters.  Alt + Enter can be used to break the text string to a new line.

• Percentage can be entered with or without a format.  

• Number can be entered with or without a format.  For number fields setup with masks:

  • The 0 (zero) character will allow a leading zero to be entered in Qbyte CS Land and all leading zeroes will be visible when the field is imported to Qbyte Exchange.  For example, with mask 000-000-00000, entered as 00-000-0001 in Qbyte CS Land, will display as 000-000-0001 in Qbyte Exchange.

  • The # character will allow a leading zero to be entered in Qbyte CS Land only if there is a non-numeric character like a dash (-) in the mask.  Leading zeroes are not displayed when the field is imported to Qbyte Exchange.  For example, with mask ###-###-####, entered 000-000-0001 in Qbyte CS Land will display as '- -1' in Qbyte Exchange.

Note:  If a Client Defined field was setup in Qbyte CS Land as being mandatory, then in Qbyte Exchange a value must be provided for that field if that Label exists in the spreadsheet.  However, if there is not a row for the Label in the spreadsheet, there is not validation to indicate it is missing.

File Number*

When inserting new Obligation records, the File Number specified must already exist.  

When updating an existing Obligation, the File Number cannot be changed.

Occurrence*

When inserting a new row do not populate this column, this is a system-generated value and it will be populated during Save.

Note: The  Occurrence (Occ) Number can be renumbered at any time in the Qbyte CS Land application (if required) to change the display order of the rows.

Delete

This value is applicable on the spreadsheet only and is not stored in the table. 

When inserting a new record, enter a value of "N".  If blank, "N" is assumed.

When updating, retrieve existing data via Get Data, the Delete value will default to "N".  Change the value to "Y" to indicate that you wish to delete the specific row.  If blank, "N" is assumed. 

• Validate will display a 'Conflict' error along with message 'Row will be deleted - are you sure?'.  Simply change the Delete column back to "N", if you change your mind.  

• Upon Save, the rows with a delete flag of "Y" are deleted from the database and the remaining rows occurrence number will be renumbered.  However, the just deleted row will still appear temporarily on the spreadsheet with status = 'Deleted' as a visual indication that the row has been deleted and the occurrence renumber will not be apparent.  A subsequent Get Data will omit the deleted rows and display the reordered rows occurrence. 

Obligation Type*

Code must exist in Validation Table – Obligation Pipelines.

Date*

Date must be in a yyyy-MM-dd format.  Cell format must be Text.

Frequency*

Value must be O, A, SA, Q, M, 2Y, 3Y, 4Y, 5Y, 10, 20, 21 or 25.

Company*

Value must be Y or N.

Satisfied*

Value must be Y or N.

Comp Date

Date must be in a yyyy-MM-dd format.  Cell format must be Text.

Party Resp*

Code must exist in Validation Table – Obligation Responsibility.

Description*

Free-format up to 1910 characters.