[dbo].[resetCurrentDates] stored procedure
- Last UpdatedJun 20, 2025
- 1 minute read
The resetCurrrentDates and writeCurrentData routines allow the SCADA system to record various currentData items that were uploaded that have not been aggregated to a granularity row and sent to AVEVA Measurement Advisor.The information sent is protocol-specific.
In order to perform these routines, you will need to be assigned the Meas Data Entry permission.
resetCurrentDates is first routine called when the SCADA system polls the remote terminal unit.
resetCurrentDates deletes the data from the previous upload and records the time of the poll.
After the resetCurrentDates routine is called, the SCADA system will send all the items it uploaded to Measurement with calls to this routine.
|
Internal Field (Parameter) Name |
Field req'd? |
Data Type (alias, SQL data type) |
Description |
|---|---|---|---|
|
@objectId |
Y |
T_tagIDType, int |
The ID number associated with the object. |
|
@sampleGMT |
Y |
T_GMTtime, int |
Time of the last sample in seconds from 1/1/70 in Coordinated Universal Time (UTC). |
|
@sampleOffset |
Y |
T_GMTtime, int |
Offset in minutes from UTC for the sampleGMT. |
|
@pollGMT |
Y |
T_GMTtime, int |
Time of the poll in seconds from 1/1/70 in UTC. |
|
@pollOffset |
Y |
T_GMTtime, int |
Offset in minutes from UTC for the pollGMT. |
|
@datasetId |
N |
T_tagIDType, int |
The datasetId configured for the object. The @datasetId will get set to the dataset configured for the object if it is not specified. |
|
@ownSysId |
N |
T_tagIDType, int |
This is set to the CD_OWNSYSID of the system on which the procedure is run. It is recommended that you do not provide a value for this entry, and let the system set the value. |