Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| VSNBatchStudentsSeq | int identity | 4 | null |
|
|
|||
| VSNBatchesSeq | int | 4 | √ | null |
|
|
||
| TransactionType | varchar | 20 | null |
|
|
|||
| ID | int | 4 | √ | null |
|
|
||
| EnrolledBefore | bit | 1 | √ | null |
|
|
||
| VSN | varchar | 15 | null |
|
|
|||
| PreviousProviderID | varchar | 15 | null |
|
|
|||
| FirstName | varchar | 30 | √ | null |
|
|
||
| LastName | varchar | 30 | null |
|
|
|||
| MiddleName | varchar | 50 | null |
|
|
|||
| BirthDate | datetime | 16,3 | √ | null |
|
|
||
| Gender | varchar | 15 | null |
|
|
|||
| EnrolmentDate | datetime | 16,3 | √ | null |
|
|
||
| TimeFraction | decimal | 4,1 | √ | null |
|
|
||
| AccessRestriction | bit | 1 | √ | null |
|
|
||
| ProviderUserID | varchar | 256 | null |
|
|
|||
| NewFirstName | varchar | 30 | √ | null |
|
|
||
| NewLastName | varchar | 30 | null |
|
|
|||
| NewMiddleName | varchar | 50 | null |
|
|
|||
| NewBirthDate | datetime | 16,3 | √ | null |
|
|
||
| NewGender | varchar | 15 | null |
|
|
|||
| NewEnrolmentDate | datetime | 16,3 | √ | null |
|
|
||
| NewAccessRestriction | bit | 1 | √ | null |
|
|
||
| ExitDate | datetime | 16,3 | √ | null |
|
|
||
| Deceased | bit | 1 | √ | null |
|
|
||
| ProcessStatus | int | 4 | √ | null |
|
|
||
| TransactionSequenceNumber | int | 4 | √ | null |
|
|
||
| VSRRegistrationDate | datetime | 16,3 | √ | null |
|
|
||
| LatestRequestFlag | bit | 1 | √ | null |
|
|
Table contained 0 rows