Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| wkStudentNZMOEGetNSNSeq | int | 4 | null |
|
|
|||
| SystemProcessNumber | int | 4 | √ | null |
|
|
||
| ID | int | 4 | √ | null |
|
|
||
| RequestDate | datetime | 16,3 | √ | null |
|
|
||
| ResponseDate | datetime | 16,3 | √ | null |
|
|
||
| SynergeticNSN | varchar | 10 | null |
|
|
|||
| ENROLNSN | varchar | 10 | null |
|
|
|||
| SynergeticURL | varchar | 255 | null |
|
|
|||
| ENROLURL | varchar | 255 | null |
|
|
|||
| SynergeticFirstName | varchar | 70 | null |
|
|
|||
| ENROLFirstName | varchar | 70 | null |
|
|
|||
| SynergeticSurname | varchar | 30 | null |
|
|
|||
| ENROLSurname | varchar | 30 | null |
|
|
|||
| SynergeticGender | varchar | 15 | null |
|
|
|||
| ENROLGender | varchar | 15 | null |
|
|
|||
| SynergeticBirthDate | datetime | 16,3 | √ | null |
|
|
||
| ENROLBirthDate | datetime | 16,3 | √ | null |
|
|
||
| ENROLConfidentialFlag | bit | 1 | √ | null |
|
|
||
| EnrolledAt | varchar | 50 | null |
|
|
|||
| ENROLStartDate | datetime | 16,3 | √ | null |
|
|
||
| ENROLLastAttendance | datetime | 16,3 | √ | null |
|
|
||
| Comment | varchar | 1000 | null |
|
|
|||
| CompleteMatchFlag | bit | 1 | null |
|
|
|||
| ResponseType | varchar | 1 | null |
|
|
|||
| UpdatedInSynergetic | bit | 1 | null |
|
|
|||
| NameInternal | varchar | 100 | √ | null |
|
|
Table contained 0 rows