JobHours (JHR)

Keys

Name Attributes Fields JHR:GuidKey Case +JHR:Guid JHR:Key Dup +JHR:Site ,+JHR:EmpNumber ,+JHR:Date ,+JHR:Time JHR:JobKey Dup +JHR:Job ,+JHR:Site ,+JHR:EmpNumber ,+JHR:Date ,+JHR:Time JHR:DateKey Dup +JHR:Date ,+JHR:Time ,+JHR:Job JHR:JobTimeKey Dup +JHR:Job ,+JHR:Date ,+JHR:Time JHR:CompanyKey Dup +JHR:Company ,+JHR:Date ,+JHR:Time JHR:RateKey Dup +JHR:Rate ,+JHR:Date ,+JHR:Time JHR:BranchKey Dup +JHR:Branch ,+JHR:Date ,+JHR:Time JHR:DepartmentKey Dup +JHR:Department ,+JHR:Date ,+JHR:Time JHR:WorkGroupKey Dup +JHR:WorkGroup ,+JHR:Date ,+JHR:Time JHR:ScaleKey Dup +JHR:Scale ,+JHR:Date ,+JHR:Time JHR:CostCenterKey Dup +JHR:CostCenter ,+JHR:Date ,+JHR:Time JHR:CategoryKey Dup +JHR:Category ,+JHR:Date ,+JHR:Time JHR:EmpTypeKey Dup +JHR:EmpType ,+JHR:Date ,+JHR:Time

Fields

Name Type Picture Description JHR:Guid STRING @s16 Internal System Identifier JHR:Site STRING @s4 JHR:EmpNumber STRING @s10 JHR:Date LONG @d6 JHR:Time LONG @t4 JHR:Quantity DECIMAL @n10.3 JHR:Company LONG @n-14 JHR:Branch LONG @n-14 JHR:Department LONG @n-14 JHR:WorkGroup LONG @n-14 JHR:CostCenter LONG @n-14 JHR:Category LONG @n-14 JHR:Scale LONG @n-14 JHR:EmpType LONG @n-14 JHR:Job STRING @s10 JHR:Hours LONG @n-13 JHR:Rate SHORT @n-6 JHR:User STRING @s12 JHR:Status STRING @s1 Add, Subtract, Override JHR:Type STRING @s1 Bulk, Process, Manual

RelationShips

Table Type This Key Foreign Key System MANY:1 JHR:Key SYS:SiteKey Employee MANY:1 JHR:Key EMP:Key Company MANY:1 JHR:CompanyKey COM:key Branch MANY:1 JHR:BranchKey BRA:key Department MANY:1 JHR:DepartmentKey DEP:key WorkGroup MANY:1 JHR:WorkGroupKey WOR:key Type MANY:1 JHR:EmpTypeKey Type:key Category MANY:1 JHR:CategoryKey CAT:key CostCenter MANY:1 JHR:CostCenterKey COS:key Scale MANY:1 JHR:ScaleKey SCA:key Job MANY:1 JHR:JobKey JOB:Key RateNames MANY:1 JHR:RateKey RAT:CodeKey