Employee (EMP)

Emp data file #

Keys

Name Attributes Fields EMP:GuidKey Case +EMP:Guid EMP:IDKey Dup +EMP:IdNumber EMP:Key Primary +EMP:Site ,+EMP:EmpNumber EMP:JobKey Dup +EMP:Job ,+EMP:Site ,+EMP:EmpNumber EMP:TimeLineKey Dup +EMP:TimeLineCode EMP:NameKey Dup +EMP:Surname ,+EMP:FirstName EMP:CompanyKey Dup +EMP:Company ,+EMP:Site ,+EMP:EmpNumber EMP:BranchKey Dup +EMP:Branch ,+EMP:Site ,+EMP:EmpNumber EMP:DeptKey Dup +EMP:Department ,+EMP:Site ,+EMP:EmpNumber EMP:ScaleKey Dup +EMP:Scale ,+EMP:Site ,+EMP:EmpNumber EMP:TypeKey Dup +EMP:Type ,+EMP:Site ,+EMP:EmpNumber EMP:CostCenterKey Dup +EMP:CostCenter ,+EMP:Site ,+EMP:EmpNumber EMP:WorkGroupKey Dup +EMP:Workgroup ,+EMP:Site ,+EMP:EmpNumber EMP:CategoryKey Dup +EMP:Category ,+EMP:Site ,+EMP:EmpNumber EMP:LimitKey Dup +EMP:LimitCode EMP:MedicalKey Dup +EMP:Condition EMP:OtherKey Dup EMP:AreaKey Dup +EMP:Site ,+EMP:AccessArea ,+EMP:EmpNumber EMP:TimeZoneKey Dup +EMP:TimeZone ,+EMP:Site ,+EMP:EmpNumber EMP:EmpClassKey Dup +EMP:EmpClass ,+EMP:Site ,+EMP:EmpNumber EMP:LanguageKey Dup +EMP:Language ,+EMP:Site ,+EMP:EmpNumber EMP:BankCodeKey Dup +EMP:BankCode ,+EMP:Site ,+EMP:EmpNumber EMP:BankTypeKey Dup +EMP:BankAccountType ,+EMP:Site ,+EMP:EmpNumber EMP:BankBranchKey Dup +EMP:BankBranch ,+EMP:Site ,+EMP:EmpNumber EMP:BankPaymentMethodKey Dup +EMP:BankPaymentMethod ,+EMP:Site ,+EMP:EmpNumber

Fields

Name Type Picture Description EMP:Guid STRING @s16 Internal System Identifier EMP:Site STRING @s4 EMP:EmpNumber STRING @s10 EMP:Title STRING @s6 EMP:FirstName STRING @s20 EMP:Surname STRING @s20 EMP:IdNumber STRING @s20 EMP:PayNumber STRING @s20 EMP:CardNumber STRING @s10 EMP:Branch LONG @n-14 EMP:Category LONG @n-14 EMP:Company LONG @n-14 EMP:CostCenter LONG @n-14 EMP:Department LONG @n-14 EMP:Scale LONG @n-14 EMP:Type LONG @n-14 EMP:Workgroup LONG @n-14 EMP:Job LONG @n-14 EMP:HiredDate LONG @d6 EMP:TerminationDate LONG @d6 EMP:TerminationReason STRING @s40 EMP:Remarks MEMO 1000 EMP:TimeLineCode STRING @s6 EMP:HolidayShift STRING @s6 EMP:YearlyLeave DECIMAL @n7.3 EMP:YearlyLeaveStartDate LONG @d6 EMP:YearlyLeaveEarns DECIMAL @n5.2 EMP:YearlyLeavePer LONG @n3 EMP:YearlySickLeaveEarns DECIMAL @n5.2 EMP:YearlySickLeavePer BYTE @n3 EMP:EmpClass LONG @n-14 EMP:Sex STRING @s1 EMP:Language LONG @n-14 EMP:MaritalStatus STRING @s1 EMP:Children BYTE @n3 EMP:TaxDependants BYTE @n3 EMP:DateOfBirth LONG @d6 EMP:BankPaymentMethod LONG @n-14 EMP:BankCode STRING @s20 EMP:BankBranch LONG @n-14 EMP:BankAccount STRING @s20 EMP:BankAccountType LONG @n-14 EMP:YearlySickLeaveStartDate LONG @d6 EMP:YearlySickLeave DECIMAL @n7.3 EMP:Var1 STRING @s20 EMP:Var2 STRING @s20 EMP:Var3 STRING @s20 EMP:Var4 STRING @s20 EMP:Var5 STRING @s20 EMP:Var6 STRING @s20 EMP:Var7 STRING @s20 EMP:Var8 STRING @s20 EMP:Var9 STRING @s20 EMP:Var10 STRING @s20 EMP:PostalAddress STRING @s30 EMP:ResidentialAddress STRING @s30 EMP:Phone STRING @s21 EMP:Photo STRING @s255 EMP:TimeZone BYTE @n3 1 - 16 EMP:AccessArea SHORT @n-6 EMP:AntiPassBack BYTE @n3 EMP:AntiPassBackOut BYTE @n3 EMP:LimitCode STRING @s6 EMP:LastMedical LONG @d06 EMP:MedicalAid STRING @s40 EMP:MedicalAidNumber STRING @s10 EMP:Condition LONG @n-13 EMP:Doctor STRING @s20 Doctors name EMP:DoctorPhone STRING @s21 Doctors phone number EMP:NextOfKin STRING @s40 EMP:MedicalComments MEMO 1000 EMP:YearlyHours LONG @n5 EMP:TNAClock BYTE @n3 0=default, 1=yes, 2=no

RelationShips

Table Type This Key Foreign Key BankPaymentMethod MANY:1 EMP:BankPaymentMethodKey BPM:Key EmpClass MANY:1 EMP:EmpClassKey CLA:Key BankAcountType MANY:1 EMP:BankTypeKey BAT:Key BankCode MANY:1 EMP:BankCodeKey BCO:Key BankBranch MANY:1 EMP:BankBranchKey BAN:Key Language MANY:1 EMP:LanguageKey LAN:Key JobHours 1:MANY EMP:Key JHR:Key Blacklist 1:MANY EMP:IDKey BLA:IDKey MoveDailyTime 1:MANY EMP:Key MDA:Key ExpectedHours 1:MANY EMP:Key EXP:EmpKey MoveTime 1:MANY EMP:Key MTI:EmpKey System MANY:1 EMP:Key SYS:SiteKey Overrides 1:MANY EMP:Key OVE:EmpKey MoveWorkGroup 1:MANY EMP:Key MWO:EmpKey TimeZoneNames MANY:1 EMP:TimeZoneKey TZN:Key MoveType 1:MANY EMP:Key MTY:EmpKey MoveScale 1:MANY EMP:Key MSC:EmpKey MoveJob 1:MANY EMP:Key MJO:EmpKey MoveDepartment 1:MANY EMP:Key MDE:EmpKey MoveCostCenter 1:MANY EMP:Key MCC:EmpKey MoveCompany 1:MANY EMP:Key MCO:EmpKey MoveCategory 1:MANY EMP:Key MCA:EmpKey MoveBranch 1:MANY EMP:Key MBR:EmpKey Job MANY:1 EMP:JobKey JOB:Key Access 1:MANY EMP:Key ACC:Key Dependants 1:MANY EMP:Key DPN:EmpKey Fitness MANY:1 EMP:MedicalKey FIT:CodeKey History 1:MANY EMP:Key HIS:EmpKey Training 1:MANY EMP:Key TRA:EmpKey Disciplinary 1:MANY EMP:Key DIS:EmpKey Limits MANY:1 EMP:LimitKey LIM:key Running 1:MANY EMP:Key RUN:empkey Errors 1:MANY EMP:Key ERR:EmpKey Department MANY:1 EMP:DeptKey DEP:key Areas MANY:1 EMP:AreaKey ARE:key Scale MANY:1 EMP:ScaleKey SCA:key WorkGroup MANY:1 EMP:WorkGroupKey WOR:key Type MANY:1 EMP:TypeKey Type:key CostCenter MANY:1 EMP:CostCenterKey COS:key Category MANY:1 EMP:CategoryKey CAT:key Company MANY:1 EMP:CompanyKey COM:key Branch MANY:1 EMP:BranchKey BRA:key Details 1:MANY EMP:Key DET:key TimeLine MANY:1 EMP:TimeLineKey TIL:CodeKey Warnings 1:MANY EMP:Key WAR:Key WeeklyHours 1:MANY EMP:Key WEE:key DailyHours 1:MANY EMP:Key DAI:Key Cards 1:MANY EMP:Key CAR:EmployeeKey Clockings 1:MANY EMP:Key CLO:EmpKey Leave 1:MANY EMP:Key LEA:key