SuspensionDetail
Name: Suspension Detail
Type: Ancillary
Modules: SUS
Description: Contains detailed letter/client information to be used if letters need to be resent (that is, a log of pending, unconfirmed letters).
| Field | Documentation |
|---|---|
| SFileID | Numeric identifier of the suspension file (from the SuspensionFile table). |
| ClientId | Numeric identifier of the client (from the Clients table). |
| PUDate | Date the booking pick-up event occurred. |
| PUTime | Time the booking pick-up event occurred. |
| PUAddr | Address where the booking pick-up event occurred. |
| DOAddr | Address where the booking drop-off event occurred. |
| SchedStatusName | Name of the booking schedule status that caused the suspension (e.g., No-Show or Missed trip). |
| BookingId | Numeric identifier of the booking (from the Booking table). |
| SFilePoints | Total number of infraction points accumulated by the client. |
| SletterTitle | Name of the letter sent to the client (from the SuspensionLetters table). |