erDiagram CONFIGURATIONSETTINGS { Id Guid AreGradesInUse Boolean } DRIVERDETAIL { FKPersonId Guid Id Guid RegistrationNumber String LicenceNumber String NameOnLicence String LicenceValidFromDate DateTimeOffset LicenceValidToDate DateTimeOffset IsCurrentlyDisqualified Boolean VerifiedDate DateTimeOffset InternationalDrivingPermitType String InternationalDrivingPermitExpiryDate DateTimeOffset InsuranceValidFromDate DateTimeOffset InsuranceValidToDate DateTimeOffset InsuranceVerifiedDate DateTimeOffset } DISABILITYINFORMATION { FKPersonId Guid Id Guid } DISABILITYINFORMATIONDISABILITYASSISTANCE { DisabilityInformationId Guid DisabilityAssistanceId Guid } DISABILITYINFORMATIONDISABILITYTYPE { DisabilityInformationId Guid DisabilityTypeId Guid } REASONFORLEAVING { FKEmploymentPeriodId Guid Id Guid } EMPLOYMENTPERIOD { FKPersonId Guid Id Guid StartDate DateTimeOffset EndDate DateTimeOffset ReckonableServiceDate DateTimeOffset } JOB { Id Guid ReferenceNumber String Name String StartDate DateTimeOffset EndDate DateTimeOffset } JOBUNITRELATIONSHIP { FKJobId Guid FKUnitId Guid Id Guid StartDate DateTimeOffset EndDate DateTimeOffset } PERSON { Id Guid PersonalReference String FirstName String LastName String KnownAs String } REFERENCEDATA { Id Guid Code String Type String } REFERENCEDATANAME { Id Guid Value String Culture String } SENSITIVEINFORMATION { FKPersonId Guid Id Guid DateOfBirth DateTimeOffset PreviousLastName String AddressLine1 String AddressLine2 String AddressLine3 String AddressLine4 String AddressLine5 String AddressLine6 String CompanyPhoneDialingCode String CompanyNumber String CompanyMobileDialingCode String CompanyMobile String PersonalPhoneDialingCode String PersonalPhone String PersonalMobileDialingCode String PersonalMobile String PersonalEmail String CompanyEmail String HasDisabilityInformation Boolean } TRANSFER { FKPersonId Guid Id Guid TransferDate DateTimeOffset LastDayAtSource DateTimeOffset } UNIT { Id Guid StructureReference String Name String FinanceReferenceNumber String StartDate DateTimeOffset EndDate DateTimeOffset } UNITRELATIONSHIP { FKChildId Guid FKParentId Guid Id Guid StartDate DateTimeOffset EndDate DateTimeOffset Distance Int32 PathIds String PathRefs String PathNames String } CONTACT { FKPersonId Guid Id Guid ContactName String AddressLine1 String AddressLine2 String AddressLine3 String AddressLine4 String AddressLine5 String AddressLine6 String ContactPhoneNumber String InternationalDialingCode String IsEmergencyContact Boolean IsPrimaryContact Boolean IsNextOfKin Boolean ContactDateOfBirth DateTimeOffset } SOCIALSECURITYINFORMATION { FKPersonId Guid Id Guid SocialSecurityNumber String } ORGANISATION { Id Guid Name String StartDate DateTimeOffset EndDate DateTimeOffset } LINEMANAGERAUTHORIZEDBUSINESSPROCESS { Id Guid ProcessName String UnitId Guid } VACANCY { FKJobId Guid Id Guid StartDate DateTimeOffset EndDate DateTimeOffset } ABSENCE { FKPersonId Guid Id Guid AbsenceStateId String AbsenceState String StartDate DateTimeOffset EndDate DateTimeOffset StartDateTypeId String EndDateTypeId String StartDateType String EndDateType String ExpectedEndDate DateTimeOffset Reason String Group String AbsenceDurationUnit String StartDateHoursAndMinutes String EndDateHoursAndMinutes String IsStartDateFullDay Boolean IsEndDateFullDay Boolean BookedDateTime DateTimeOffset TotalLostDays Decimal TotalExpectedWorkingTimeInHours Decimal TotalLostWorkingTimeInHours Decimal } ABSENCELOSTHOURS { FKAbsenceId Guid Id Guid Date DateTimeOffset ExpectedWorkingTimeInMinutes Decimal LostWorkingTimeInMinutes Decimal ExpectedWorkingTimeInHours Decimal LostWorkingTimeInHours Decimal LostDays Decimal } ABSENCETYPE { Id Guid Code String Name String AllowsOpenEnded Boolean RequiresApproval Boolean AbsenceDetailsType Int32 Active Boolean IsUserDefined Boolean IsReasonMandatory Boolean } DEPARTMENTHEADCOUNT { DepartmentId Guid Distance Int32 Headcount Int32 SnapshotDate DateTimeOffset } DEPARTMENTNEWHIRE { DepartmentId Guid PeriodEndDate DateTimeOffset Distance Int32 NewHires Int32 } DEPARTMENTTURNOVER { DepartmentId Guid PeriodReportStartDate DateTimeOffset Distance Int32 LeaverCount Int32 AvgHeadCount Decimal VoluntaryTurnover Decimal Turnover Decimal } DEPARTMENTSICKNESSRATE { DepartmentId Guid Distance Int32 PeriodStartDate DateTimeOffset WorkingHours Decimal LostWorkingTimeInHours Decimal SicknessRatePercentage Decimal } DEPARTMENTBRADFORDFACTOR { DepartmentId Guid Distance Int32 PeriodStartDate DateTimeOffset CountPeople Int32 TotalBradfordFactor Decimal BradfordFactor Decimal } DEPARTMENTSICKNESSEVENT { DepartmentId Guid Distance Int32 PeriodStartDate DateTimeOffset PeriodEndDate DateTimeOffset PeopleCount Int32 } DEPARTMENTLEAVER { FKDepartmentId Guid FKChildDepartmentId Guid FKOccupancyId Guid FKEmploymentPeriodId Guid LeavingDate DateTimeOffset LeavingReasonId Guid Distance Int32 } OCCUPANCY { FKEmploymentPeriodId Guid FKJobId Guid Id Guid StartDate DateTimeOffset EndDate DateTimeOffset ExpectedEndDate DateTimeOffset } OCCUPANCYABSENCE { FKOccupancyId Guid Id Guid AbsenceStateId String AbsenceState String StartDate DateTimeOffset EndDate DateTimeOffset StartDateTypeId String EndDateTypeId String StartDateType String EndDateType String ExpectedEndDate DateTimeOffset Reason String Group String AbsenceDurationUnit String StartDateHoursAndMinutes String EndDateHoursAndMinutes String IsStartDateFullDay Boolean IsEndDateFullDay Boolean BookedDateTime DateTimeOffset TotalLostDays Decimal TotalExpectedWorkingTimeInHours Decimal TotalLostWorkingTimeInHours Decimal PersonId Guid PersonalReference String PersonTranslatedTitle String PersonFirstName String PersonLastName String PersonKnownAs String ReportingManagerAtAbsenceStartDate String JobTitleAtAbsenceStartDate String DepartmentNameAtAbsenceStartDate String AcknowledgementState String AcknowledgementDateTime DateTimeOffset AcknowledgedBy String AcknowledgedById Guid IsExcludedFromBradfordFactor Boolean } OCCUPANCYABSENCELOSTHOURS { FKOccupancyAbsenceId Guid Id Guid Date DateTimeOffset ExpectedWorkingTimeInMinutes Decimal LostWorkingTimeInMinutes Decimal ExpectedWorkingTimeInHours Decimal LostWorkingTimeInHours Decimal LostDays Decimal } OCCUPANCYABSENCEDEPARTMENT { OccupancyAbsenceId Guid ParentDepartmentId Guid ChildDepartmentId Guid AbsenceStartDate DateTimeOffset AbsenceEndDate DateTimeOffset Distance Int32 AbsenceCategory String } PERSONEMPLOYMENTBASIS { FKPersonId Guid Id Guid StartDate DateTimeOffset EndDate DateTimeOffset } PERSONEMPLOYMENTCATEGORY { FKPersonId Guid Id Guid StartDate DateTimeOffset EndDate DateTimeOffset } PERSONEMPLOYMENTTYPE { FKPersonId Guid Id Guid StartDate DateTimeOffset EndDate DateTimeOffset } PERSONLOCATION { FKPersonId Guid Id Guid StartDate DateTimeOffset EndDate DateTimeOffset } PERSONCONTRACTUALHOUR { FKPersonId Guid Id Guid ContractualHours Decimal StartDate DateTimeOffset EndDate DateTimeOffset } PERSONANNUALWEEKSWORKED { FKPersonId Guid Id Guid AnnualWeeksWorked Decimal StartDate DateTimeOffset EndDate DateTimeOffset } PERSONANNUALWEEKSPAID { FKPersonId Guid Id Guid AnnualWeeksPaid Decimal StartDate DateTimeOffset EndDate DateTimeOffset } PERSONFTEHOUR { FKPersonId Guid Id Guid FteHours Decimal StartDate DateTimeOffset EndDate DateTimeOffset } PERSONREPORTINGMANAGER { FKPersonId Guid Id Guid ReportingManager String ReportingJob String ReportingJobReference String ReportingManagerPersonId Guid ReportingManagerPersonReference String ReportingUnit String StartDate DateTimeOffset EndDate DateTimeOffset } PERSONSALARY { FKPersonId Guid Id Guid RevisionStartDate DateTimeOffset RevisionEndDate DateTimeOffset FullTimeSalary Decimal } PERSONSALARYANDHOURS { FKPersonId Guid Id Guid RevisionStartDate DateTimeOffset RevisionEndDate DateTimeOffset FteValue Decimal AnnualHoursWorked Decimal ProRatedSalary Decimal HourlyRate Decimal HourlyRateDaily Decimal } PERSONRIGHTTOWORK { FKPersonId Guid Id Guid AlienNumber String I94Number String Type String NationalRegistrationIdentityCard String ForeignIdentityNumber String ForeignIdentityNumberExpiryDate DateTimeOffset TaxReferenceNumber String IncomeTaxReferenceNumber String AssignedTaxReferenceNumber String } PERSONRIGHTTOWORKDOCUMENTATION { FKPersonId Guid Id Guid DocumentType String DocumentNumberOrReference String StartDate DateTimeOffset ExpiryDate DateTimeOffset SponsorshipComments String SettlementStatusComments String IndefiniteLeave Boolean } PERSONPHOTO { FKPersonId Guid Id Guid ImageId Guid PhotoUrl String } PROBATIONARYPERIOD { FKOccupancyId Guid Id Guid ProbationaryPeriodStartDate DateTimeOffset ProbationaryPeriodEndDate DateTimeOffset Completed String } PERSONLENGTHOFSTANDARDDAY { FKPersonId Guid Id Guid LengthOfStandardDay Decimal StartDate DateTimeOffset EndDate DateTimeOffset } PERSONTERMTIMEONLY { FKPersonId Guid Id Guid TermTimeOnly Boolean StartDate DateTimeOffset EndDate DateTimeOffset } CORRESPONDENCE { FKPersonId Guid Id Guid JobTitle String JobReferenceNumber String EventType String Status String DateCreated DateTimeOffset LastUpdated DateTimeOffset } OCCUPANCYEMPLOYMENTBASIS { FKOccupancyId Guid Id Guid StartDate DateTimeOffset EndDate DateTimeOffset } OCCUPANCYEMPLOYMENTCATEGORY { FKOccupancyId Guid Id Guid StartDate DateTimeOffset EndDate DateTimeOffset } OCCUPANCYEMPLOYMENTTYPE { FKOccupancyId Guid Id Guid StartDate DateTimeOffset EndDate DateTimeOffset } OCCUPANCYCONTRACTUALHOUR { FKOccupancyId Guid Id Guid ContractualHours Decimal StartDate DateTimeOffset EndDate DateTimeOffset } OCCUPANCYANNUALWEEKSWORKED { FKOccupancyId Guid Id Guid AnnualWeeksWorked Decimal StartDate DateTimeOffset EndDate DateTimeOffset } OCCUPANCYFTEHOUR { FKOccupancyId Guid Id Guid FteHours Decimal StartDate DateTimeOffset EndDate DateTimeOffset } OCCUPANCYREPORTINGMANAGER { FKOccupancyId Guid Id Guid ReportingManager String ReportingJob String ReportingJobReference String ReportingManagerPersonId Guid ReportingManagerPersonReference String ReportingUnit String StartDate DateTimeOffset EndDate DateTimeOffset } OCCUPANCYSALARY { FKOccupancyId Guid Id Guid RevisionStartDate DateTimeOffset RevisionEndDate DateTimeOffset FullTimeSalary Decimal RateOfPayMin Decimal RateOfPayMax Decimal GradeId Guid GradeName String PayScaleId Guid PayScaleName String IsTUPE Boolean IsSalaryOverride Boolean NextIncrementalDate DateTimeOffset } OCCUPANCYSALARYANDHOURS { FKOccupancyId Guid Id Guid RevisionStartDate DateTimeOffset RevisionEndDate DateTimeOffset FteValue Decimal AnnualHoursWorked Decimal ProRatedSalary Decimal HourlyRate Decimal HourlyRateDaily Decimal } OCCUPANCYLENGTHOFSTANDARDDAY { FKOccupancyId Guid Id Guid LengthOfStandardDay Decimal StartDate DateTimeOffset EndDate DateTimeOffset } OCCUPANCYTERMTIMEONLY { FKOccupancyId Guid Id Guid TermTimeOnly Boolean StartDate DateTimeOffset EndDate DateTimeOffset } OCCUPANCYLOCATION { FKOccupancyId Guid Id Guid StartDate DateTimeOffset EndDate DateTimeOffset } OCCUPANCYSCHEMESANDBENEFITS { FKOccupancyId Guid Id Guid StartDate DateTimeOffset EndDate DateTimeOffset Item String Choice String } OCCUPANCYWORKINGPATTERN { FKOccupancyId Guid Id Guid StartDate DateTimeOffset EndDate DateTimeOffset WorkingPatternName String DaysInPattern Int32 StartDayOfPattern Int32 Pattern String } JOBLENGTHOFSTANDARDDAY { FKJobId Guid Id Guid LengthOfStandardDay Decimal StartDate DateTimeOffset EndDate DateTimeOffset } JOBEMPLOYMENTBASIS { FKJobId Guid Id Guid StartDate DateTimeOffset EndDate DateTimeOffset } JOBEMPLOYMENTCATEGORY { FKJobId Guid Id Guid StartDate DateTimeOffset EndDate DateTimeOffset } JOBEMPLOYMENTTYPE { FKJobId Guid Id Guid StartDate DateTimeOffset EndDate DateTimeOffset } JOBLOCATION { FKJobId Guid Id Guid StartDate DateTimeOffset EndDate DateTimeOffset } JOBCONTRACTUALHOUR { FKJobId Guid Id Guid ContractHours Decimal StartDate DateTimeOffset EndDate DateTimeOffset } JOBANNUALWEEKSWORKED { FKJobId Guid Id Guid AnnualWeeksWorked Decimal StartDate DateTimeOffset EndDate DateTimeOffset } JOBFTEHOUR { FKJobId Guid Id Guid FteHours Decimal StartDate DateTimeOffset EndDate DateTimeOffset } JOBREPORTINGMANAGER { FKJobId Guid Id Guid ReportingManager String ReportingJob String ReportingJobId Guid ReportingJobReference String ReportingManagerPhotoUrl String ReportingManagerPersonId Guid ReportingManagerPersonReference String ReportingUnit String StartDate DateTimeOffset EndDate DateTimeOffset } JOBSALARY { FKJobId Guid Id Guid FullTimeSalary Decimal StartDate DateTimeOffset EndDate DateTimeOffset } JOBNAMEHISTORY { FKJobId Guid Id Guid Name String StartDate DateTimeOffset EndDate DateTimeOffset } JOBTERMTIMEONLY { FKJobId Guid Id Guid TermTimeOnly Boolean StartDate DateTimeOffset EndDate DateTimeOffset } UNITAUTHORIZATION { Id Guid } ABSENCEAUTHORIZEDPERSON { Id Guid AuthorizedPersonId Guid OccupancyStartDate DateTimeOffset OccupancyEndDate DateTimeOffset UnitStartDate DateTimeOffset UnitEndDate DateTimeOffset ReportingJobStartDate DateTimeOffset ReportingJobEndDate DateTimeOffset } Resource_Paths { ConfigurationSettings URL DriverDetails URL DisabilityInformations URL DisabilityInformationDisabilityAssistances URL DisabilityInformationDisabilityTypes URL ReasonForLeavings URL EmploymentPeriods URL Jobs URL JobUnitRelationships URL People URL ReferenceDatas URL ReferenceDataNames URL SensitiveInformations URL Transfers URL Units URL UnitRelationships URL Contacts URL SocialSecurityNumbers URL Organisations URL AuthorizedBusinessProcesses URL Vacancies URL Absences URL AbsenceLostHours URL AbsenceTypes URL DepartmentHeadcounts URL DepartmentNewHires URL DepartmentTurnovers URL DepartmentSicknessRates URL DepartmentBradfordFactors URL DepartmentSicknessEvents URL DepartmentLeavers URL Occupancies URL OccupancyAbsences URL OccupancyAbsenceLostHours URL OccupancyAbsenceDepartments URL PersonEmploymentBases URL PersonEmploymentCategories URL PersonEmploymentTypes URL PersonLocations URL PersonContractualHours URL PersonAnnualWeeksWorked URL PersonAnnualWeeksPaid URL PersonFteHours URL PersonReportingManagers URL PersonSalaries URL PersonSalaryAndHours URL PersonRightToWork URL PersonRightToWorkDocumentation URL PersonPhotos URL ProbationaryPeriods URL PersonLengthOfStandardDay URL PersonTermTimeOnly URL Correspondences URL OccupancyEmploymentBases URL OccupancyEmploymentCategories URL OccupancyEmploymentTypes URL OccupancyContractualHours URL OccupancyAnnualWeeksWorked URL OccupancyFteHours URL OccupancyReportingManagers URL OccupancySalaries URL OccupancySalariesAndHours URL OccupancyLengthOfStandardDay URL OccupancyTermTimeOnly URL OccupancyLocations URL OccupancySchemesAndBenefit URL OccupancyWorkingPatterns URL JobLengthOfStandardDay URL JobEmploymentBases URL JobEmploymentCategories URL JobEmploymentTypes URL JobLocations URL JobContractualHours URL JobAnnualWeeksWorked URL JobFteHours URL JobReportingManagers URL JobSalaries URL JobNameHistory URL JobTermTimeOnly URL UnitAuthorizations URL } DRIVERDETAIL o{--|| PERSON : Person DRIVERDETAIL o{--|| REFERENCEDATA : LicenceIssuingCountry DISABILITYINFORMATION o{--|| PERSON : Person DISABILITYINFORMATIONDISABILITYASSISTANCE o{--|| DISABILITYINFORMATION : DisabilityInformation DISABILITYINFORMATIONDISABILITYASSISTANCE o{--|| REFERENCEDATA : DisabilityAssistance DISABILITYINFORMATIONDISABILITYTYPE o{--|| DISABILITYINFORMATION : DisabilityInformation DISABILITYINFORMATIONDISABILITYTYPE o{--|| REFERENCEDATA : DisabilityType REASONFORLEAVING o{--|| REFERENCEDATA : LeavingReason REASONFORLEAVING o{--|| EMPLOYMENTPERIOD : EmploymentPeriod EMPLOYMENTPERIOD o{--|| REASONFORLEAVING : ReasonForLeaving EMPLOYMENTPERIOD o{--|| PERSON : Person JOBUNITRELATIONSHIP o{--|| JOB : Job JOBUNITRELATIONSHIP o{--|| UNIT : Unit PERSON o{--|| REFERENCEDATA : Title PERSON o{--|| REFERENCEDATA : Pronouns PERSON o{--|| DISABILITYINFORMATION : DisabilityInformation PERSON o{--|| SENSITIVEINFORMATION : SensitiveInformation PERSON o{--|| PERSONPHOTO : PersonPhoto REFERENCEDATANAME o{--|| REFERENCEDATA : ReferenceData SENSITIVEINFORMATION o{--|| REFERENCEDATA : CountryOfCitizenship SENSITIVEINFORMATION o{--|| REFERENCEDATA : LegalGender SENSITIVEINFORMATION o{--|| REFERENCEDATA : Gender SENSITIVEINFORMATION o{--|| REFERENCEDATA : MaritalStatus SENSITIVEINFORMATION o{--|| REFERENCEDATA : Nationality SENSITIVEINFORMATION o{--|| REFERENCEDATA : Religion SENSITIVEINFORMATION o{--|| REFERENCEDATA : SexualOrientation SENSITIVEINFORMATION o{--|| REFERENCEDATA : EthnicOrigin SENSITIVEINFORMATION o{--|| REFERENCEDATA : VeteranStatus SENSITIVEINFORMATION o{--|| REFERENCEDATA : Country SENSITIVEINFORMATION o{--|| PERSON : Person TRANSFER o{--|| REFERENCEDATA : TransferReason TRANSFER o{--|| PERSON : Person TRANSFER o{--|| OCCUPANCY : SourceOccupancy TRANSFER o{--|| OCCUPANCY : DestinationOccupancy TRANSFER o{--|| UNIT : SourceUnit TRANSFER o{--|| UNIT : DestinationUnit UNITRELATIONSHIP o{--|| UNIT : Child UNITRELATIONSHIP o{--|| UNIT : Parent CONTACT o{--|| REFERENCEDATA : ContactCountry CONTACT o{--|| REFERENCEDATA : RelationshipType CONTACT o{--|| PERSON : Person SOCIALSECURITYINFORMATION o{--|| PERSON : Person SOCIALSECURITYINFORMATION o{--|| REFERENCEDATA : Jurisdiction VACANCY o{--|| JOB : Job VACANCY o{--|| OCCUPANCY : EndedByOccupancy ABSENCE o{--|| PERSON : Person ABSENCE o{--|| ABSENCETYPE : AbsenceType ABSENCE o{--|| REFERENCEDATA : SicknessReason ABSENCELOSTHOURS o{--|| ABSENCE : Absence ABSENCETYPE o{--|| REFERENCEDATA : AbsenceCategory DEPARTMENTLEAVER o{--|| UNIT : Unit DEPARTMENTLEAVER o{--|| UNIT : ChildUnit DEPARTMENTLEAVER o{--|| OCCUPANCY : Occupancy DEPARTMENTLEAVER o{--|| EMPLOYMENTPERIOD : EmploymentPeriod OCCUPANCY o{--|| EMPLOYMENTPERIOD : EmploymentPeriod OCCUPANCY o{--|| JOB : Job OCCUPANCY o{--|| TRANSFER : TransferAsSource OCCUPANCY o{--|| TRANSFER : TransferAsDestination OCCUPANCY o{--|| REFERENCEDATA : ExpectedEndReason OCCUPANCYABSENCE o{--|| OCCUPANCY : Occupancy OCCUPANCYABSENCE o{--|| ABSENCETYPE : AbsenceType OCCUPANCYABSENCE o{--|| REFERENCEDATA : SicknessReason OCCUPANCYABSENCELOSTHOURS o{--|| OCCUPANCYABSENCE : OccupancyAbsence OCCUPANCYABSENCEDEPARTMENT o{--|| OCCUPANCYABSENCE : OccupancyAbsence PERSONEMPLOYMENTBASIS o{--|| REFERENCEDATA : EmploymentBasis PERSONEMPLOYMENTBASIS o{--|| PERSON : Person PERSONEMPLOYMENTCATEGORY o{--|| REFERENCEDATA : EmploymentCategory PERSONEMPLOYMENTCATEGORY o{--|| PERSON : Person PERSONEMPLOYMENTTYPE o{--|| REFERENCEDATA : EmploymentType PERSONEMPLOYMENTTYPE o{--|| PERSON : Person PERSONLOCATION o{--|| REFERENCEDATA : Location PERSONLOCATION o{--|| PERSON : Person PERSONCONTRACTUALHOUR o{--|| PERSON : Person PERSONANNUALWEEKSWORKED o{--|| PERSON : Person PERSONANNUALWEEKSPAID o{--|| PERSON : Person PERSONFTEHOUR o{--|| PERSON : Person PERSONREPORTINGMANAGER o{--|| PERSON : Person PERSONSALARY o{--|| REFERENCEDATA : PayrollFrequency PERSONSALARY o{--|| REFERENCEDATA : Currency PERSONSALARY o{--|| PERSON : Person PERSONSALARY o{--|| REFERENCEDATA : PaymentFrequency PERSONSALARYANDHOURS o{--|| REFERENCEDATA : SalaryFrequency PERSONSALARYANDHOURS o{--|| REFERENCEDATA : Currency PERSONSALARYANDHOURS o{--|| PERSON : Person PERSONSALARYANDHOURS o{--|| REFERENCEDATA : PaymentFrequency PERSONRIGHTTOWORK o{--|| REFERENCEDATA : RightToWorkProcessingStatus PERSONRIGHTTOWORK o{--|| REFERENCEDATA : I9Status PERSONRIGHTTOWORK o{--|| REFERENCEDATA : USRightToWorkStatus PERSONRIGHTTOWORK o{--|| REFERENCEDATA : ResidencyType PERSONRIGHTTOWORK o{--|| PERSON : Person PERSONRIGHTTOWORKDOCUMENTATION o{--|| REFERENCEDATA : IssuingCountry PERSONRIGHTTOWORKDOCUMENTATION o{--|| REFERENCEDATA : ResidencyCategory PERSONRIGHTTOWORKDOCUMENTATION o{--|| REFERENCEDATA : WorkPermitType PERSONRIGHTTOWORKDOCUMENTATION o{--|| REFERENCEDATA : VisaType PERSONRIGHTTOWORKDOCUMENTATION o{--|| REFERENCEDATA : SettledType PERSONRIGHTTOWORKDOCUMENTATION o{--|| PERSON : Person PERSONPHOTO o{--|| PERSON : Person PROBATIONARYPERIOD o{--|| REFERENCEDATA : Reason PROBATIONARYPERIOD o{--|| OCCUPANCY : Occupancy PERSONLENGTHOFSTANDARDDAY o{--|| PERSON : Person PERSONTERMTIMEONLY o{--|| PERSON : Person CORRESPONDENCE o{--|| PERSON : Person OCCUPANCYEMPLOYMENTBASIS o{--|| REFERENCEDATA : EmploymentBasis OCCUPANCYEMPLOYMENTBASIS o{--|| OCCUPANCY : Occupancy OCCUPANCYEMPLOYMENTCATEGORY o{--|| REFERENCEDATA : EmploymentCategory OCCUPANCYEMPLOYMENTCATEGORY o{--|| OCCUPANCY : Occupancy OCCUPANCYEMPLOYMENTTYPE o{--|| REFERENCEDATA : EmploymentType OCCUPANCYEMPLOYMENTTYPE o{--|| OCCUPANCY : Occupancy OCCUPANCYCONTRACTUALHOUR o{--|| OCCUPANCY : Occupancy OCCUPANCYANNUALWEEKSWORKED o{--|| OCCUPANCY : Occupancy OCCUPANCYFTEHOUR o{--|| OCCUPANCY : Occupancy OCCUPANCYREPORTINGMANAGER o{--|| OCCUPANCY : Occupancy OCCUPANCYSALARY o{--|| REFERENCEDATA : PayrollFrequency OCCUPANCYSALARY o{--|| REFERENCEDATA : Currency OCCUPANCYSALARY o{--|| REFERENCEDATA : PaymentFrequency OCCUPANCYSALARY o{--|| OCCUPANCY : Occupancy OCCUPANCYSALARY o{--|| REFERENCEDATA : SalaryOverrideReason OCCUPANCYSALARYANDHOURS o{--|| REFERENCEDATA : SalaryFrequency OCCUPANCYSALARYANDHOURS o{--|| REFERENCEDATA : Currency OCCUPANCYSALARYANDHOURS o{--|| REFERENCEDATA : PaymentFrequency OCCUPANCYSALARYANDHOURS o{--|| OCCUPANCY : Occupancy OCCUPANCYLENGTHOFSTANDARDDAY o{--|| OCCUPANCY : Occupancy OCCUPANCYTERMTIMEONLY o{--|| OCCUPANCY : Occupancy OCCUPANCYLOCATION o{--|| REFERENCEDATA : Location OCCUPANCYLOCATION o{--|| OCCUPANCY : Occupancy OCCUPANCYSCHEMESANDBENEFITS o{--|| OCCUPANCY : Occupancy OCCUPANCYWORKINGPATTERN o{--|| OCCUPANCY : Occupancy JOBLENGTHOFSTANDARDDAY o{--|| JOB : Job JOBEMPLOYMENTBASIS o{--|| REFERENCEDATA : EmploymentBasis JOBEMPLOYMENTBASIS o{--|| JOB : Job JOBEMPLOYMENTCATEGORY o{--|| REFERENCEDATA : EmploymentCategory JOBEMPLOYMENTCATEGORY o{--|| JOB : Job JOBEMPLOYMENTTYPE o{--|| REFERENCEDATA : EmploymentType JOBEMPLOYMENTTYPE o{--|| JOB : Job JOBLOCATION o{--|| REFERENCEDATA : Location JOBLOCATION o{--|| JOB : Job JOBCONTRACTUALHOUR o{--|| JOB : Job JOBANNUALWEEKSWORKED o{--|| JOB : Job JOBFTEHOUR o{--|| JOB : Job JOBREPORTINGMANAGER o{--|| JOB : Job JOBSALARY o{--|| REFERENCEDATA : PayrollFrequency JOBSALARY o{--|| REFERENCEDATA : Currency JOBSALARY o{--|| JOB : Job JOBNAMEHISTORY o{--|| JOB : Job JOBTERMTIMEONLY o{--|| JOB : Job UNITAUTHORIZATION o{--|| UNIT : Unit ABSENCEAUTHORIZEDPERSON o{--|| UNIT : Unit