Cards (CAR)

Card allocation file #

Keys

Name Attributes Fields CAR:GuidKey Case +CAR:Guid CAR:CardKey Primary +CAR:Site ,+CAR:CardNumber CAR:PointerKey Dup +CAR:Pointer CAR:EmployeeKey Dup +CAR:Site ,+CAR:EmpNumber CAR:VisitorKey Dup +CAR:Visitor ,+CAR:CardNumber CAR:TempKey Dup +CAR:Temporary ,+CAR:CardNumber CAR:ClockKey Dup +CAR:Tna ,+CAR:CardNumber CAR:InfoKey Dup +CAR:Info ,+CAR:CardNumber CAR:RequestKey Dup +CAR:Request ,+CAR:CardNumber

Fields

Name Type Picture Description CAR:Guid STRING @s16 Internal System Identifier CAR:Site STRING @s4 CAR:CardNumber STRING @s10 CAR:EmpNumber STRING @s10 CAR:VisNumber STRING @s10 CAR:Request BYTE @n3 CAR:Tna BYTE @n3 CAR:Access BYTE @n3 CAR:Job BYTE @n3 CAR:Visitor BYTE @n3 CAR:Temporary BYTE @n3 CAR:DateIssued LONG @d6 CAR:TimeIssued LONG @t1 CAR:Info BYTE @n3 CAR:Pointer LONG @n-14 CAR:SpecialFunction BYTE @n3

RelationShips

Table Type This Key Foreign Key System MANY:1 CAR:CardKey SYS:SiteKey Visits 1:MANY CAR:CardKey VIT:CardKey Clockings 1:MANY CAR:CardKey CLO:key Employee MANY:1 CAR:EmployeeKey EMP:Key