HomeSystem (SYS)

system-wide parameters #
Keys
Name Attributes Fields
SYS:GuidKey Case +SYS:Guid
SYS:SiteKey Dup,Nulls +SYS:Site
Fields
Name Type Picture Description
SYS:Guid STRING @s16 Internal System Identifier
SYS:Site STRING @s4
SYS:SiteDescription STRING @s255
SYS:SMTPServer STRING @s20
SYS:SMTPPort LONG @n_5
SYS:POPServer STRING @s20
SYS:POPPort LONG @n_5
SYS:POPUser STRING @s30
SYS:POPPassword STRING @s30
SYS:POPFrom STRING @s50
SYS:VarEmpDesc1 STRING @s20
SYS:CollectDevice LONG @n-13
SYS:VarEmpDesc2 STRING @s20
SYS:VarEmpDesc3 STRING @s20
SYS:VarEmpDesc4 STRING @s20
SYS:VarEmpDesc5 STRING @s20
SYS:VarEmpDesc6 STRING @s20
SYS:VarEmpDesc7 STRING @s20
SYS:VarEmpDesc8 STRING @s20
SYS:VarEmpDesc9 STRING @s20
SYS:VarEmpDesc10 STRING @s20
SYS:VarTrainDesc1 STRING @s20
SYS:VarTrainDesc2 STRING @s20
SYS:VarTrainDesc3 STRING @s20
SYS:VarTrainDesc4 STRING @s20
SYS:VarTrainDesc5 STRING @s20
SYS:VarDisciplineDesc1 STRING @s20
SYS:VarDisciplineDesc2 STRING @s20
SYS:VarDisciplineDesc3 STRING @s20
SYS:VarDisciplineDesc4 STRING @s20
SYS:VarDisciplineDesc5 STRING @s20
SYS:VarDependantDesc1 STRING @s20
SYS:VarDependantDesc2 STRING @s20
SYS:VarDependantDesc3 STRING @s20
SYS:VarDependantDesc4 STRING @s20
SYS:VarDependantDesc5 STRING @s20
SYS:VarHistoryDesc1 STRING @s20
SYS:VarHistoryDesc2 STRING @s20
SYS:VarHistoryDesc3 STRING @s20
SYS:VarHistoryDesc4 STRING @s20
SYS:VarHistoryDesc5 STRING @s20
SYS:UserErrorPollTime SHORT @n6 Time in secs for errors poll in TUSER
SYS:ComPort STRING @s4 Com Port used by hardware interface
SYS:SiteNumber STRING @s6 Site number attached to clockings
SYS:AutoDelClockings LONG @n-13
SYS:AutoDelDailyHours LONG @n-13
SYS:AutoDelWeeklyHours LONG @n-13
SYS:AutoDelExceptions LONG @n-13
SYS:AutoDelVisitors LONG @n-13
SYS:NoAutoDelStartTime LONG @t1
SYS:NoAutoDelEndTime LONG @t1
SYS:LastRunDate LONG @d6
SYS:ProcessorSpeed BYTE @n3
SYS:MaxStartProcessor LONG @t4
SYS:MaxEndProcessor LONG @t4
SYS:QuietTimeStart LONG @t1
SYS:QuietTimeEnd LONG @t1
SYS:ProgName STRING @s20
SYS:OfflinePollTime LONG @n-13
SYS:ProcessImediate BYTE @n3
SYS:ConfigurationBuildNumber ULONG @n13
SYS:AuditLogOn BYTE @n3
SYS:NoCollectStartTime LONG @t1
SYS:NoCollectEndTime LONG @t1
SYS:VisitorHalf BYTE @n3
SYS:VisitorTwice BYTE @n3
SYS:TemporaryHalf BYTE @n3
SYS:TemporaryTwice BYTE @n3
SYS:DayDate LONG @d6
SYS:DayTime LONG @t1
SYS:DayChange LONG @t1
SYS:DayDirection STRING @s9
SYS:SuppressWarning BYTE @n3
SYS:FeatureList BYTE @n3
SYS:SupportEmail STRING @s128
SYS:SupportWebSite STRING @s128
SYS:SupportPhone STRING @s40
SYS:SupportFax STRING @s40
SYS:ClockingReasonRequierd BYTE @n3
SYS:DailyHoursReasonRequired BYTE @n3
SYS:WeeklyHoursReasonRequired BYTE @n3
SYS:EmailNotify BYTE @n3
SYS:EmailNotifyTo STRING @s255
RelationShips
Table Type This Key Foreign Key
JobHours 1:MANY SYS:SiteKey JHR:Key
MoveDailyTime 1:MANY SYS:SiteKey MDA:Key
Blacklist 1:MANY SYS:SiteKey BLA:EmpKey
LogHistory 1:MANY SYS:SiteKey LHI:SiteKey
Schedule 1:MANY SYS:SiteKey SCH:Key
Log 1:MANY SYS:SiteKey LOG:SiteKey
ExpectedHours 1:MANY SYS:SiteKey EXP:EmpKey
EventLog 1:MANY SYS:SiteKey EVE:DateKey
Clockings 1:MANY SYS:SiteKey CLO:EmpKey
Criteria 1:MANY SYS:SiteKey CRI:key
Redirect 1:MANY SYS:SiteKey RED:CriteriaKey
AreaNames 1:MANY SYS:SiteKey ARN:AreaNameKey
Details 1:MANY SYS:SiteKey DET:key
Leave 1:MANY SYS:SiteKey LEA:key
Warnings 1:MANY SYS:SiteKey WAR:Key
WeeklyHours 1:MANY SYS:SiteKey WEE:key
DailyHours 1:MANY SYS:SiteKey DAI:Key
Running 1:MANY SYS:SiteKey RUN:empkey
Errors 1:MANY SYS:SiteKey ERR:EmpKey
History 1:MANY SYS:SiteKey HIS:EmpKey
Training 1:MANY SYS:SiteKey TRA:EmpKey
Disciplinary 1:MANY SYS:SiteKey DIS:EmpKey
Dependants 1:MANY SYS:SiteKey DPN:EmpKey
Areas 1:MANY SYS:SiteKey ARE:key
Access 1:MANY SYS:SiteKey ACC:Key
Visitors 1:MANY SYS:SiteKey VIS:Key
Visits 1:MANY SYS:SiteKey VIT:CardKey
Employee 1:MANY SYS:SiteKey EMP:Key
Cards 1:MANY SYS:SiteKey CAR:CardKey
MoveCategory 1:MANY SYS:SiteKey MCA:EmpKey
MoveBranch 1:MANY SYS:SiteKey MBR:EmpKey
MoveCostCenter 1:MANY SYS:SiteKey MCC:EmpKey
MoveCompany 1:MANY SYS:SiteKey MCO:EmpKey
MoveDepartment 1:MANY SYS:SiteKey MDE:EmpKey
MoveWorkGroup 1:MANY SYS:SiteKey MWO:EmpKey
MoveJob 1:MANY SYS:SiteKey MJO:EmpKey
Controllers 1:MANY SYS:SiteKey CON:key
Devices 1:MANY SYS:SiteKey DEV:key
MoveType 1:MANY SYS:SiteKey MTY:EmpKey
Overrides 1:MANY SYS:SiteKey OVE:EmpKey
MoveTime 1:MANY SYS:SiteKey MTI:EmpKey
MoveScale 1:MANY SYS:SiteKey MSC:EmpKey