ER CTMS 041-061: Difference between revisions
From Calidus HUB
(Created page with "<!-- MEDIA LANDSCAPE YES --> {{#vardefine:System|CTMS}} {{ERHeader |SystemVersion=CTMS 11.0 |ERNumber=ER041-061 }} {| class="wikitable" border="1" width="100%" |- bgcolor="sil...") |
(No difference)
|
Revision as of 12:19, 1 June 2022
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. |
