Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| reviewID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each authorization review |
||||
| ifspID | int | 4 | √ | null |
|
|
IFSP reference - Links to IFSP table if review is related to family service plan |
||||
| authID | int | 4 | √ | null |
|
|
Authorization reference - Links to Authorize table for the authorization being reviewed |
||||
| reviewType | int | 4 | √ | null |
|
|
Review type - Type of review (Annual, Semi-annual, Medical necessity, etc.) |
||||
| DateDue | smalldatetime | 16 | √ | null |
|
|
Review due date - Date when the review is due |
||||
| DateSubmitted | smalldatetime | 16 | √ | null |
|
|
Submission date - Date when the review was submitted |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__AuthReview__69527C00 | Primary key | Asc | reviewID |
| IX_AuthID | Performance | Asc | authID |
| IX_reviewType | Performance | Asc | reviewType |
Relationships
Close relationships within degrees of separation
