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 edit summary |
||
| Line 21: | Line 21: | ||
The following columns will be available to query: | The following columns will be available to query: | ||
STA_SCHED_NAME | STA_SCHED_NAME<br /> | ||
STA_TRIP_ID | STA_TRIP_ID<br /> | ||
STA_TRIP_STATUS | STA_TRIP_STATUS<br /> | ||
STA_ACTION_DATE | STA_ACTION_DATE<br /> | ||
STA_ACTIONED_BY | STA_ACTIONED_BY | ||
The data will be selected in the following sequence: | The data will be selected in the following sequence: | ||
STA_SCHED_NAME | STA_SCHED_NAME<br /> | ||
STA_TRIP_ID | STA_TRIP_ID | ||
Revision as of 12:20, 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 The data will be selected in the following sequence: STA_SCHED_NAME 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. |
