Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AgencyId | Unknown | 0 | null |
|
|
Agency reference - Reference to agency that had the package assignment |
||
| DeletedBy | Unknown | 0 | null |
|
|
Deletion administrator - User who deleted the assignment |
||
| PackageAssignedId | int identity | 4 | √ | null |
|
|
Original assignment ID - Reference to the original package assignment that was deleted |
|
| PackageId | int | 4 | √ | null |
|
|
Package reference - Reference to the package that was assigned |
|
| AgencyAssigned | int | 4 | √ | null |
|
|
Assigned agency - Agency that was assigned the package |
|
| AssignedDate | date | 20 | √ | null |
|
|
Assignment date - When the package was originally assigned |
|
| AssignedBy | int | 4 | √ | null |
|
|
Assignment administrator - User who originally assigned the package |
|
| Cost | int | 4 | √ | null |
|
|
Assignment cost - Cost associated with the deleted package assignment |
|
| DeletedDate | date | 20 | √ | null |
|
|
Deletion timestamp - When the assignment was deleted |