| TTVisitationRegistrationHistoryID |
primary key |
| TTVisitationRegistrationID |
foreign key |
| TTVisitationRegistrationContactID |
foreign key |
| TTVisitationContactTypeID |
foreign key |
| ReasonDescription |
Reason description |
| RegistrationDate |
Interviewdate |
| Created |
the creation date |
| DisplayOrder |
a datetime field for ordering |
| tblUsersID |
a user who created |
| Corrected |
Timestamp for the correction |
| CorrectionUserID |
The user who corrected |
| ParentTTVisitationRegistrationHistoryID |
A parent id of visitation registration contact history. Null if not relevant. |
| CorrectionText |
The reason for the correction |
| TimeStamp |
the timestamp |
| CorrectionAuthorityID |
The authority that made a correction. Null if not relevant. |
| TTCommonAuthorityId |
foreign key |
| TTVisitationCaseID |
Primary or foreign key |
| IsFirstInContact |
First registriton in the contact cycle 1 = Yes, 0 = No |
| UnemploymentRegionOfficeID |
foreign key with TTCommonAuthorityTypeID=6 |
| TTVisitationInterviewTypeID |
foreign key |