ClockingsAlias (CLOA)

Keys

Name Attributes Fields CLOA:GuidKey Primary +CLOA:Guid CLOA:datekey Dup +CLOA:Date ,+CLOA:Time CLOA:key Dup +CLOA:Site ,+CLOA:CardNumber ,+CLOA:Date ,+CLOA:Time CLOA:EmpKey Dup +CLOA:Site ,+CLOA:EmpNumber ,+CLOA:Date ,+CLOA:Time CLOA:DateEmpKey Dup +CLOA:Date ,+CLOA:Site ,+CLOA:EmpNumber ,+CLOA:Time

Fields

Name Type Picture Description CLOA:Guid STRING @s16 Internal System Identifier CLOA:RecordNumber LONG @n-14 CLOA:Site STRING @s4 CLOA:CardNumber STRING @s10 CLOA:EmpNumber STRING @s10 CLOA:Date LONG @d6 CLOA:Time LONG @t4 CLOA:Device STRING @s8 CLOA:Direction STRING @s1 CLOA:Type STRING @s1 Bulk / Manual / Collected / Request CLOA:Status STRING @s1 Tna / Access / Job / Info / Request CLOA:Deleted STRING @s1 D = Deleted CLOA:User STRING @s12 CLOA:AccessData LONG @n-13 CLOA:JobData LONG @n-13 CLOA:Comment MEMO 250 CLOA:OriginalDate LONG @d6 CLOA:OriginalTime LONG @t4 CLOA:OriginalDirection STRING @s1

RelationShips

Table Type This Key Foreign Key