ER CTMS 041-061
From Calidus HUB
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. |
