Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| IPReviewID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each IFSP provider review submission |
|
| fkIFSPReviewID | int | 4 | √ | null |
|
|
IFSP review reference - Links to IFSPReview table for the main review process |
|
| fkUserID | int | 4 | √ | null |
|
|
Provider user reference - Links to AccessUser table for the provider submitting the review |
|
| DateSubmitted | smalldatetime | 16 | √ | null |
|
|
Submission date - Date when the provider submitted their review |
|
| DateActual | smalldatetime | 16 | √ | null |
|
|
Actual date - Actual date when the review activity occurred |
|
| fkServiceTypeId | int | 4 | √ | null |
|
|
Service type reference - Links to iCS2.dbo.ServiceType for centralized service type definitions for the type of service being reviewed |
|
| Comments | varchar | 4000 | √ | null |
|
|
Review comments - Provider comments and observations about the IFSP review |
|
| DateCreated | smalldatetime | 16 | √ | null |
|
|
Creation date - Date when this review submission record was created |
|
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Last update date - Date when this record was last updated |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated this record |
Relationships
Close relationships within degrees of separation
