Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each deleted claim transaction record |
|
| TransId | int | 4 | √ | null |
|
|
Transaction identifier - Internal transaction ID for system tracking |
|
| ClaimId | int | 4 | √ | null |
|
|
Claim reference - Reference to claim associated with deleted transaction |
|
| DateTransaction | datetime | 16,3 | √ | null |
|
|
Transaction processing date - Date when the transaction was processed in the system |
|
| Amount | money | 21,4 | √ | null |
|
|
Transaction amount - Monetary amount of the deleted transaction |
|
| BillingUnit | decimal | 20 | √ | null |
|
|
Billing unit - Unit of measurement for billing purposes (hours, sessions, etc.) |
|
| TransType | varchar | 20 | √ | null |
|
|
Transaction type code - Coded value representing the type of transaction |
|
| DateTransType | datetime | 16,3 | √ | null |
|
|
Transaction type date - Date when the transaction type was determined or changed |
|
| InsertBy | int | 4 | √ | null |
|
|
Insert user - User who originally inserted the transaction before deletion |
|
| UpdateBy | int | 4 | √ | null |
|
|
Update user - User who last updated the transaction before deletion |
|
| DeletedBy | int | 4 | √ | null |
|
|
Deletion user - User who deleted the transaction |
|
| DeletedDate | Unknown | 0 | null |
|
|
Deletion timestamp - When the transaction was deleted |
||
| DeleteReason | Unknown | 0 | null |
|
|
Deletion reason - Reason provided for deleting the transaction |
||
| TransactionDate | Unknown | 0 | null |
|
|
Transaction date - Date of the deleted transaction |
||
| TransactionId | Unknown | 0 | null |
|
|
Original transaction ID - Reference to the original claim transaction that was deleted |
||
| TransactionType | Unknown | 0 | null |
|
|
Transaction type - Type of transaction that was deleted |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__DeletedC__3214EC274924D839 | Primary key | Asc | ID |