Visits (VIT)

Record of each visit #

Keys

Name Attributes Fields VIT:GuidKey Case +VIT:Guid VIT:key Primary +VIT:Site ,+VIT:VisNumber ,+VIT:Date ,+VIT:InTime VIT:OutKey Dup +VIT:OutTime ,+VIT:CardNumber VIT:DateKey Dup +VIT:Date ,+VIT:InTime VIT:AreaKey Dup,Nulls +VIT:Site ,+VIT:Area VIT:CardKey Dup +VIT:Site ,+VIT:CardNumber

Fields

Name Type Picture Description VIT:Guid STRING @s16 Internal System Identifier VIT:VisNumber LONG @n-14 VIT:Site STRING @s4 VIT:CardNumber STRING @s10 VIT:Date LONG @d6 VIT:InTime LONG @t1 VIT:OutTime LONG @t1 VIT:Contact STRING @s30 VIT:AntiPassBack BYTE @n3 VIT:TimeZone BYTE @n2 1 - 16 VIT:Area SHORT @n4 VIT:Operator STRING @s12

RelationShips

Table Type This Key Foreign Key System MANY:1 VIT:CardKey SYS:SiteKey Visitors MANY:1 VIT:key VIS:Key Areas MANY:1 VIT:AreaKey ARE:key Cards MANY:1 VIT:CardKey CAR:CardKey