ER CTMS 041-061

From Calidus HUB
Revision as of 12:20, 1 June 2022 by StylesC (talk | contribs)


Aptean Logo.png


EMERGENCY RELEASE - CTMS 11.0


RELNOTE ER041-061


Module Program Name Ver Call/Iss Client Ref Pr'ty Remarks
V_SCH_TRIP_AUDIT.sql Database View 1.1 02064838 - 3 A new database view called V_SCH_TRIP_STATUS has been created to select records from the auditing of the trips.

The following columns will be available to query:

STA_SCHED_NAME
STA_TRIP_ID
STA_TRIP_STATUS
STA_ACTION_DATE
STA_ACTIONED_BY

The data will be selected in the following sequence:

STA_SCHED_NAME
STA_TRIP_ID

And then by an audit number which will correspond to the STA_ACTION_DATE.

Access has been granted to MTS_USER and BOBS_ROLE.

NOTE: Access must be granted to BOBS_ROLE after release to NHSBT databases.