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...") |
m (Text replacement - "[[Category:{{#var:System}} ER]]↵</noinclude>" to "[[Category:{{#var:System}} ER]]Category:ER CTMS 041 </noinclude>") |
||
| (One intermediate revision by one other user not shown) | |||
| 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 | ||
| Line 40: | Line 40: | ||
<noinclude> | <noinclude> | ||
[[Category:{{#var:System}} ER]] | [[Category:{{#var:System}} ER]][[Category:ER CTMS 041]] | ||
</noinclude> | </noinclude> | ||
Latest revision as of 09:57, 14 July 2025
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. |
