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