ruby - Implementation Details

VBA Modules

Form_Add and Edit Admin Item (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Admin Item.txt Lines: 57

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit Applicant (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Applicant.txt Lines: 336

Procedures

Public Sub CalculateDateOfBirth() - ⚠️ Contains GoTo statements; High branching (8 If statements)

Public Function PopulateFileName(PathAndFile As String) As String

Private Sub BrowseForFile_Click()

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements; High branching (11 If statements)

Private Sub CopyStreetAddress_Click()

Private Sub ExitNoSave_Click()

Private Sub Form_Activate()

Private Sub Form_BeforeUpdate(Cancel As Integer)

Private Sub Form_Close()

Private Sub Form_Open(Cancel As Integer) - ⚠️ High branching (10 If statements)

Private Sub ID_Number_AfterUpdate()

Private Sub OpenFile_Click() - ⚠️ Contains GoTo statements; High branching (11 If statements)

Form_Add and Edit Application Onboarding Information (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Application Onboarding Information.txt Lines: 151

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DistributeOnboardingForm_Click() - ⚠️ High branching (21 If statements)

Private Sub ExitNoSave_Click()

Private Sub Form_Activate()

Private Sub Form_BeforeUpdate(Cancel As Integer)

Private Sub Form_Close()

Private Sub Form_Open(Cancel As Integer)

Form_Add and Edit Application Stages (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Application Stages.txt Lines: 42

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Private Sub Stage_Number_BeforeUpdate(Cancel As Integer) - ⚠️ Uses SendKeys

Form_Add and Edit Application Status (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Application Status.txt Lines: 35

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit Assessment Types (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Assessment Types.txt Lines: 68

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit Company (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Company.txt Lines: 24

Procedures

Private Sub CloseForm_Click()

Private Sub CopyStreetAddress_Click()

Private Sub Form_Close()

Form_Add and Edit Country (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Country.txt Lines: 20

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit CV Not Suitable Reason (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit CV Not Suitable Reason.txt Lines: 68

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit Employee (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Employee.txt Lines: 351

Procedures

Public Sub CalculateDateOfBirth() - ⚠️ Contains GoTo statements; High branching (8 If statements)

Public Function PopulateFileName(PathAndFile As String) As String

Private Sub BrowseForFile_Click()

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements; High branching (11 If statements)

Private Sub CopyStreetAddress_Click()

Private Sub ExitNoSave_Click() - ⚠️ High branching (6 If statements)

Private Sub Form_Activate()

Private Sub Form_BeforeUpdate(Cancel As Integer)

Private Sub Form_Close()

Private Sub Form_Open(Cancel As Integer) - ⚠️ High branching (10 If statements)

Private Sub ID_Number_AfterUpdate()

Private Sub OpenFile_Click() - ⚠️ Contains GoTo statements; High branching (11 If statements)

Form_Add and Edit Employment Equity Job Category (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Employment Equity Job Category.txt Lines: 68

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit Grievance Process Outcome (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Grievance Process Outcome.txt Lines: 57

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit Hearing Process Outcome (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Hearing Process Outcome.txt Lines: 57

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit How Heard Options (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit How Heard Options.txt Lines: 56

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit Investigation Process Result (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Investigation Process Result.txt Lines: 57

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit Job Code (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Job Code.txt Lines: 99

Procedures

Public Sub PopulateFileName(PathAndFile As String)

Private Sub BrowseForFile_Click()

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub Form_Open(Cancel As Integer)

Private Sub OpenFile_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit On Boarding Recipients (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit On Boarding Recipients.txt Lines: 60

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit Onboarding Information (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Onboarding Information.txt Lines: 181

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements; High branching (6 If statements)

Private Sub DistributeOnboardingForm_Click() - ⚠️ High branching (21 If statements)

Private Sub ExitNoSave_Click() - ⚠️ High branching (6 If statements)

Private Sub Form_Activate()

Private Sub Form_BeforeUpdate(Cancel As Integer)

Private Sub Form_Close()

Private Sub Form_Open(Cancel As Integer)

Form_Add and Edit Organisational Code (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Organisational Code.txt Lines: 70

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit Pay Point (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Pay Point.txt Lines: 68

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit Payroll Item (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Payroll Item.txt Lines: 57

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit People Admin Information (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit People Admin Information.txt Lines: 70

Procedures

Private Sub Admin_Item_AfterUpdate()

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub SaveAndExit_Click()

Form_Add and Edit People Awards Recognition (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit People Awards Recognition.txt Lines: 68

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub SaveAndExit_Click()

Form_Add and Edit People Badges (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit People Badges.txt Lines: 60

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub SaveAndExit_Click()

Form_Add and Edit People Care Record (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit People Care Record.txt Lines: 68

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub SaveAndExit_Click()

Form_Add and Edit People Disciplinary Grievance Process (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit People Disciplinary Grievance Process.txt Lines: 68

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub SaveAndExit_Click()

Form_Add and Edit People Disciplinary Hearing Process (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit People Disciplinary Hearing Process.txt Lines: 68

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub SaveAndExit_Click()

Form_Add and Edit People Disciplinary Investigation Process (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit People Disciplinary Investigation Process.txt Lines: 120

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub SaveAndExit_Click() - ⚠️ High branching (6 If statements)

Form_Add and Edit People Disciplinary Warning Letter (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit People Disciplinary Warning Letter.txt Lines: 66

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub SaveAndExit_Click()

Form_Add and Edit People Enrichment Training (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit People Enrichment Training.txt Lines: 70

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub SaveAndExit_Click()

Form_Add and Edit People MeGRAPH Scores (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit People MeGRAPH Scores.txt Lines: 72

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub SaveAndExit_Click()

Form_Add and Edit People Payroll Information (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit People Payroll Information.txt Lines: 66

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub SaveAndExit_Click()

Form_Add and Edit People Poor Performance Checkin Meeting (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit People Poor Performance Checkin Meeting.txt Lines: 64

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub SaveAndExit_Click()

Form_Add and Edit People Poor Performance Meeting A (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit People Poor Performance Meeting A.txt Lines: 71

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub SaveAndExit_Click()

Form_Add and Edit People Poor Performance Meeting B (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit People Poor Performance Meeting B.txt Lines: 66

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub SaveAndExit_Click()

Form_Add and Edit People Poor Performance Meeting C (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit People Poor Performance Meeting C.txt Lines: 57

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub SaveAndExit_Click()

Form_Add and Edit People Qualifications and Certifications (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit People Qualifications and Certifications.txt Lines: 66

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub SaveAndExit_Click()

Form_Add and Edit People Training Module Status (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit People Training Module Status.txt Lines: 68

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit People Training Modules and Sessions (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit People Training Modules and Sessions.txt Lines: 229

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub Job_Code_Training_Module_ID_AfterUpdate()

Private Sub Job_Code_Training_Session_ID_AfterUpdate()

Private Sub SaveAndAdd_Click()

Private Sub SaveAndExit_Click() - ⚠️ High branching (7 If statements)

Private Sub TrainingType_AfterUpdate()

Form_Add and Edit Position Status (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Position Status.txt Lines: 35

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit Position (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Position.txt Lines: 191

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements; High branching (20 If statements); Large procedure (101 lines)

Private Sub Form_BeforeUpdate(Cancel As Integer)

Private Sub Form_Close()

Private Sub Form_Open(Cancel As Integer)

Private Sub Position_Status_ID_AfterUpdate() - ⚠️ Uses SendKeys

Form_Add and Edit Pre Appointment Document Category (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Pre Appointment Document Category.txt Lines: 68

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit Pre Appointment Documents (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Pre Appointment Documents.txt Lines: 37

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DocumentCategoryList_AfterUpdate()

Form_Add and Edit Race (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Race.txt Lines: 60

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit Regret Reason (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Regret Reason.txt Lines: 68

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit Telephone Interview Question Category (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Telephone Interview Question Category.txt Lines: 68

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit Telephone Interview Questions (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Telephone Interview Questions.txt Lines: 41

Procedures

Private Sub AddPerson_Click()

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub QuestionCategoryList_AfterUpdate()

Form_Add and Edit Three Plus One Review Meeting (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Three Plus One Review Meeting.txt Lines: 15

Procedures

Private Sub CloseForm_Click()

Private Sub Form_Close()

Form_Add and Edit Training Courses (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Training Courses.txt Lines: 68

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit Training Modules and Sessions (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Training Modules and Sessions.txt Lines: 310

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub SaveAndAdd_Click()

Private Sub SaveAndExit_Click() - ⚠️ High branching (7 If statements); Large procedure (152 lines)

Private Sub TrainingType_AfterUpdate()

Form_Add and Edit Training Modules (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Training Modules.txt Lines: 174

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub SaveAndAdd_Click()

Private Sub SaveAndExit_Click()

Form_Add and Edit Users (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Users.txt Lines: 40

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_BeforeUpdate(Cancel As Integer)

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add and Edit Warning Letter Level (Form)

File: ms_access_files\ruby\Forms\Frm Add and Edit Warning Letter Level.txt Lines: 57

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_Add Application (Form)

File: ms_access_files\ruby\Forms\Frm Add Application.txt Lines: 55

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub EditApplicant_Click()

Private Sub Form_BeforeInsert(Cancel As Integer)

Private Sub Form_Close()

Form_Add Badges (Form)

File: ms_access_files\ruby\Forms\Frm Add Badges.txt Lines: 114

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub SaveAndAdd_Click()

Private Sub SaveAndExit_Click()

Private Sub TrainingType_AfterUpdate()

Form_Add People Badges (Form)

File: ms_access_files\ruby\Forms\Frm Add People Badges.txt Lines: 66

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub SaveAndExit_Click()

Form_Bagdes List (Form)

File: ms_access_files\ruby\Forms\Frm Bagdes List.txt Lines: 133

Procedures

Public Sub UpdateList()

Private Sub AddBadge_Click()

Private Sub ClearFilter_Click()

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DisplayBy_AfterUpdate()

Private Sub Form_Open(Cancel As Integer)

Private Sub ModuleList_DblClick(Cancel As Integer)

Private Sub ModuleList_KeyDown(KeyCode As Integer, Shift As Integer)

Private Sub StrCriteria1_AfterUpdate()

Form_Change Password (Form)

File: ms_access_files\ruby\Forms\Frm Change Password.txt Lines: 138

Procedures

Private Sub CancelButton_Click()

Private Sub CurrentPassword_AfterUpdate()

Private Sub Form_Open(Cancel As Integer)

Private Sub NewPassword_AfterUpdate()

Private Sub OKButton_Click()

Form_Check Duplicates (Form)

File: ms_access_files\ruby\Forms\Frm Check Duplicates.txt Lines: 96

Procedures

Public Sub UpdateList()

Public Sub UpdateNumber()

Private Sub ApplicantList_DblClick(Cancel As Integer)

Private Sub ApplicantList_KeyDown(KeyCode As Integer, Shift As Integer)

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Open(Cancel As Integer)

Private Sub StrCriteria1_AfterUpdate()

Form_Choose People List (Form)

File: ms_access_files\ruby\Forms\Frm Choose People List.txt Lines: 118

Procedures

Public Sub UpdateList()

Private Sub AddPerson_Click()

Private Sub AddSelectedPerson_Click()

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub FilterBy_AfterUpdate()

Private Sub Form_Open(Cancel As Integer)

Private Sub JobList_AfterUpdate()

Private Sub PeopleList_AfterUpdate()

Private Sub PeopleList_DblClick(Cancel As Integer)

Private Sub StrCriteria1_AfterUpdate()

Form_Company List (Form)

File: ms_access_files\ruby\Forms\Frm Company List.txt Lines: 33

Procedures

Private Sub AddCompany_Click()

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub CompanyList_AfterUpdate()

Private Sub CompanyList_DblClick(Cancel As Integer)

Form_Configure Job Application Steps (Form)

File: ms_access_files\ruby\Forms\Frm Configure Job Application Steps.txt Lines: 58

Procedures

Private Sub AddToList_Click()

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub InTheList_KeyDown(KeyCode As Integer, Shift As Integer)

Form_Configure Job Regret Reasons (Form)

File: ms_access_files\ruby\Forms\Frm Configure Job Regret Reasons.txt Lines: 58

Procedures

Private Sub AddToList_Click()

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub InTheList_KeyDown(KeyCode As Integer, Shift As Integer)

Form_Copy Applications Dialog (Form)

File: ms_access_files\ruby\Forms\Frm Copy Applications Dialog.txt Lines: 53

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DoTheCopy_Click()

Private Sub Form_Close()

Form_Create Open From Terminated (Form)

File: ms_access_files\ruby\Forms\Frm Create Open From Terminated.txt Lines: 41

Procedures

Private Sub CancelButton_Click()

Private Sub Form_Close()

Private Sub OKButton_Click()

Form_Edit Application Status (Form)

File: ms_access_files\ruby\Forms\Frm Edit Application Status.txt Lines: 385

Procedures

Public Sub SaveTheChanges() - ⚠️ High branching (14 If statements); Large procedure (163 lines)

Private Sub Application_Notes_AfterUpdate()

Private Sub Application_Status_ID_AfterUpdate()

Private Sub Application_Status_Notes_AfterUpdate()

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements; High branching (7 If statements)

Private Sub CV_Not_Suitable_Reason_ID_AfterUpdate()

Private Sub EditApplicant_Click()

Private Sub Form_Open(Cancel As Integer)

Private Sub How_Heard_About_Position_AfterUpdate()

Private Sub Regret_Reason_ID_AfterUpdate()

Private Sub SaveIt_Click()

Private Sub Start_Date_AfterUpdate()

Private Sub SubFrm_Application_Considerations___Edit_Enter()

Form_Edit Badges (Form)

File: ms_access_files\ruby\Forms\Frm Edit Badges.txt Lines: 110

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub SaveAndAdd_Click()

Private Sub SaveAndExit_Click()

Private Sub TrainingType_AfterUpdate()

Form_Edit Job Code Pre Appointment Documents (Form)

File: ms_access_files\ruby\Forms\Frm Edit Job Code Pre Appointment Documents.txt Lines: 72

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DocumentCategoryList_AfterUpdate()

Private Sub Form_Close()

Form_Edit Job Code Telephone Interview Questions (Form)

File: ms_access_files\ruby\Forms\Frm Edit Job Code Telephone Interview Questions.txt Lines: 72

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub QuestionCategoryList_AfterUpdate()

Form_Edit Job Code Training Modules (Form)

File: ms_access_files\ruby\Forms\Frm Edit Job Code Training Modules.txt Lines: 91

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub QuestionCategoryList_AfterUpdate()

Form_Edit Job Code Training Sessions (Form)

File: ms_access_files\ruby\Forms\Frm Edit Job Code Training Sessions.txt Lines: 87

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Close()

Private Sub QuestionCategoryList_AfterUpdate()

Form_Edit Onboarding Applicant (Form)

File: ms_access_files\ruby\Forms\Frm Edit Onboarding Applicant.txt Lines: 247

Procedures

Public Sub SaveTheChanges() - ⚠️ High branching (10 If statements); Large procedure (122 lines)

Private Sub Application_Notes_AfterUpdate()

Private Sub Application_Status_ID_AfterUpdate()

Private Sub Application_Status_Notes_AfterUpdate()

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub EditApplicant_Click()

Private Sub Form_Open(Cancel As Integer)

Private Sub SaveIt_Click()

Private Sub Start_Date_AfterUpdate()

Form_Edit Probation Interview Question Responses (Form)

File: ms_access_files\ruby\Forms\Frm Edit Probation Interview Question Responses.txt Lines: 15

Procedures

Private Sub CloseForm_Click()

Private Sub Form_Close()

Form_Edit Probation Settling In Responses (Form)

File: ms_access_files\ruby\Forms\Frm Edit Probation Settling In Responses.txt Lines: 15

Procedures

Private Sub CloseForm_Click()

Private Sub Form_Close()

Form_Edit Telephone Interview Question Responses (Form)

File: ms_access_files\ruby\Forms\Frm Edit Telephone Interview Question Responses.txt Lines: 23

Procedures

Private Sub CloseForm_Click()

Private Sub Form_AfterUpdate()

Private Sub PrintInterview_Click()

Form_Edit Three Plus One Review (Form)

File: ms_access_files\ruby\Forms\Frm Edit Three Plus One Review.txt Lines: 34

Procedures

Private Sub CloseForm_Click()

Private Sub Form_Close()

Private Sub Form_Load()

Private Sub PrintInterview_Click()

Form_Filled Position Report Dialog (Form)

File: ms_access_files\ruby\Forms\Frm Filled Position Report Dialog.txt Lines: 41

Procedures

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Job Code List (Form)

File: ms_access_files\ruby\Forms\Frm Job Code List.txt Lines: 264

Procedures

Public Sub UpdateList()

Private Sub AddJob_Click()

Private Sub ClearFilters_Click()

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub EditApplicationSteps_Click()

Private Sub EditRegretReasons_Click()

Private Sub Form_Open(Cancel As Integer)

Private Sub JobCodeList_AfterUpdate()

Private Sub JobCodeList_DblClick(Cancel As Integer)

Private Sub OpenJobProfile_Click() - ⚠️ Contains GoTo statements

Private Sub StrCriteria1_AfterUpdate()

Private Sub ViewPreAppointmentDocuments_Click()

Private Sub ViewTelephoneInterviewQuestions_Click()

Private Sub ViewTrainingModules_Click()

Form_Maintenance Menu (Form)

File: ms_access_files\ruby\Forms\Frm Maintenance Menu.txt Lines: 148

Procedures

Private Sub ApplicationStages_Click()

Private Sub AdminItems_Click()

Private Sub ApplicationStatus_Click()

Private Sub AssessmentTypes_Click()

Private Sub Badges_Click()

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Companies_Click()

Private Sub Countries_Click()

Private Sub CVNotSuitableReasons_Click()

Private Sub DatabaseUsers_Click()

Private Sub EEJobCategories_Click()

Private Sub GrievanceProcessOutcomes_Click()

Private Sub HearingProcessOutcomes_Click()

Private Sub HowHeardOptions_Click()

Private Sub InvestigationProcessResults_Click()

Private Sub JobCodes_Click()

Private Sub OnBoardingRecipients_Click()

Private Sub OrganisationalCodes_Click()

Private Sub PayPoints_Click()

Private Sub PayrollItems_Click()

Private Sub PeopleInformation_Click()

Private Sub PositionStatus_Click()

Private Sub PeopleTrainingModuleStatus_Click()

Private Sub PreAppointmentDocumentCategories_Click()

Private Sub PreAppointmentDocuments_Click()

Private Sub Race_Click()

Private Sub RegretReasons_Click()

Private Sub Users_Click()

Private Sub TelephoneInterviewQuestionCategories_Click()

Private Sub TelephoneInterviewQuestions_Click()

Private Sub TrainingCourses_Click()

Private Sub TrainingModulesSessions_Click()

Private Sub WarningLetterLevels_Click()

Form_Onboarding List (Form)

File: ms_access_files\ruby\Forms\Frm Onboarding List.txt Lines: 161

Procedures

Public Sub UpdateList()

Private Sub ApplicantList_DblClick(Cancel As Integer)

Private Sub ApplicantList_KeyDown(KeyCode As Integer, Shift As Integer)

Private Sub ApplicationStatus_AfterUpdate()

Private Sub ClearFilters_Click()

Private Sub CloseForm_Click()

Private Sub CriteriaCombo1_AfterUpdate()

Private Sub Dashboards_AfterUpdate() - ⚠️ High branching (6 If statements)

Private Sub DuplicateFunction_Click()

Private Sub EditEmployee_Click()

Private Sub Filter1_AfterUpdate()

Private Sub Form_Activate()

Private Sub Form_Open(Cancel As Integer)

Private Sub MaintenanceFunction_Click()

Private Sub PeopleInformation_Click()

Private Sub PrintPreAppointmentPack_Click()

Private Sub ReportMenu_Click()

Private Sub StrCriteria1_AfterUpdate()

Form_Opening Dialog (Form)

File: ms_access_files\ruby\Forms\Frm Opening Dialog.txt Lines: 79

Procedures

Private Sub CancelButton_Click()

Private Sub Form_Load()

Private Sub Form_Open(Cancel As Integer)

Private Sub Password_AfterUpdate()

Form_People Admin Information (Form)

File: ms_access_files\ruby\Forms\Frm People Admin Information.txt Lines: 93

Procedures

Private Sub AddAdminInformation_Click()

Private Sub AdminInformationList_DblClick(Cancel As Integer)

Private Sub AdminInformationList_KeyDown(KeyCode As Integer, Shift As Integer)

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements; High branching (6 If statements)

Private Sub Form_Open(Cancel As Integer)

Form_People Disciplinary Information (Form)

File: ms_access_files\ruby\Forms\Frm People Disciplinary Information.txt Lines: 265

Procedures

Private Sub AddGrievanceProcess_Click()

Private Sub AddHearingProcess_Click()

Private Sub AddInvestigationProcess_Click()

Private Sub AddWarningLetter_Click()

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements; High branching (6 If statements)

Private Sub Form_Activate()

Private Sub Form_Open(Cancel As Integer)

Private Sub GrievanceProcessList_DblClick(Cancel As Integer)

Private Sub GrievanceProcessList_KeyDown(KeyCode As Integer, Shift As Integer)

Private Sub HearingProcessList_DblClick(Cancel As Integer)

Private Sub HearingProcessList_KeyDown(KeyCode As Integer, Shift As Integer)

Private Sub InvestigationProcessList_DblClick(Cancel As Integer)

Private Sub InvestigationProcessList_KeyDown(KeyCode As Integer, Shift As Integer)

Private Sub WarningLetterList_DblClick(Cancel As Integer)

Private Sub WarningLetterList_KeyDown(KeyCode As Integer, Shift As Integer)

Form_People List (Form)

File: ms_access_files\ruby\Forms\Frm People List.txt Lines: 156

Procedures

Public Sub UpdateList()

Private Sub AddPerson_Click()

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub FilterBy_AfterUpdate()

Private Sub Form_Open(Cancel As Integer)

Private Sub JobList_AfterUpdate()

Private Sub PeopleList_AfterUpdate()

Private Sub PeopleList_DblClick(Cancel As Integer)

Private Sub PeopleList_KeyDown(KeyCode As Integer, Shift As Integer) - ⚠️ High branching (7 If statements)

Private Sub StrCriteria1_AfterUpdate()

Private Sub ViewTelephoneInterview_Click()

Form_People Payroll Information (Form)

File: ms_access_files\ruby\Forms\Frm People Payroll Information.txt Lines: 99

Procedures

Private Sub AddPayrollInformation_Click()

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements; High branching (6 If statements)

Private Sub Form_Activate()

Private Sub Form_Open(Cancel As Integer)

Private Sub PayrollInformationList_DblClick(Cancel As Integer)

Private Sub PayrollInformationList_KeyDown(KeyCode As Integer, Shift As Integer)

Form_People Performance Information (Form)

File: ms_access_files\ruby\Forms\Frm People Performance Information.txt Lines: 549

Procedures

Private Sub AddAwardRecognition_Click()

Private Sub AddCareRecord_Click()

Private Sub AddCheckinMeeting_Click()

Private Sub AddMeGRAPHScores_Click()

Private Sub AddPerformanceReviewMeeting_Click()

Private Sub AddProbationReview_Click()

Private Sub AddThreePlusOneReview_Click()

Private Sub AwardRecognitionList_DblClick(Cancel As Integer)

Private Sub AwardRecognitionList_KeyDown(KeyCode As Integer, Shift As Integer)

Private Sub CareRecordList_DblClick(Cancel As Integer)

Private Sub CareRecordList_KeyDown(KeyCode As Integer, Shift As Integer)

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements; High branching (6 If statements)

Private Sub Form_Activate()

Private Sub Form_Open(Cancel As Integer)

Private Sub MeGRAPHList_DblClick(Cancel As Integer)

Private Sub MeGRAPHList_KeyDown(KeyCode As Integer, Shift As Integer)

Private Sub PerformanceReviewList_DblClick(Cancel As Integer) - ⚠️ High branching (14 If statements); Large procedure (142 lines)

Private Sub ProbationReviewList_DblClick(Cancel As Integer)

Private Sub ProbationReviewList_KeyDown(KeyCode As Integer, Shift As Integer)

Private Sub ThreePlusOneReviewList_DblClick(Cancel As Integer)

Form_People Training Information (Form)

File: ms_access_files\ruby\Forms\Frm People Training Information.txt Lines: 327

Procedures

Private Sub AddBadge_Click()

Private Sub AddEnrichmentTraining_Click()

Private Sub AddQualificationCertification_Click()

Private Sub AddTrainingModule_Click()

Private Sub BadgesList_KeyDown(KeyCode As Integer, Shift As Integer)

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements; High branching (6 If statements)

Private Sub EnrichmentTrainingList_DblClick(Cancel As Integer)

Private Sub EnrichmentTrainingList_KeyDown(KeyCode As Integer, Shift As Integer)

Private Sub Form_Activate()

Private Sub Form_Load()

Private Sub Form_Open(Cancel As Integer)

Private Sub PrintDevelopmentJourney_Click()

Private Sub PrintSummary_Click()

Private Sub QualificationsCertificationsList_DblClick(Cancel As Integer)

Private Sub QualificationsCertificationsList_KeyDown(KeyCode As Integer, Shift As Integer)

Private Sub TrainingModuleList_DblClick(Cancel As Integer) - ⚠️ High branching (8 If statements); Large procedure (102 lines)

Private Sub TrainingModuleList_KeyDown(KeyCode As Integer, Shift As Integer)

Form_People Vault List (Form)

File: ms_access_files\ruby\Forms\Frm People Vault List.txt Lines: 242

Procedures

Public Sub UpdateList() - ⚠️ High branching (10 If statements)

Private Sub ClearFilters_Click()

Private Sub CloseForm_Click()

Private Sub CopyApplications_Click()

Private Sub CriteriaCombo1_AfterUpdate()

Private Sub Dashboards_AfterUpdate() - ⚠️ High branching (6 If statements)

Private Sub DuplicateFunction_Click()

Private Sub EditPosiiton_Click()

Private Sub Filter1_AfterUpdate()

Private Sub Form_Activate()

Private Sub Form_Open(Cancel As Integer)

Private Sub MaintenanceFunction_Click()

Private Sub PeopleInformation_Click()

Private Sub PositionList_DblClick(Cancel As Integer)

Private Sub PositionList_KeyDown(KeyCode As Integer, Shift As Integer) - ⚠️ High branching (6 If statements)

Private Sub PositionStatus_AfterUpdate()

Private Sub ReportMenu_Click()

Private Sub StrCriteria1_AfterUpdate()

Private Sub ViewOtherApplicants_Click()

Form_People Vault Review Applications (Form)

File: ms_access_files\ruby\Forms\Frm People Vault Review Applications.txt Lines: 21

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Form_Recruitment List (Form)

File: ms_access_files\ruby\Forms\Frm Recruitment List.txt Lines: 389

Procedures

Public Sub UpdateList() - ⚠️ High branching (10 If statements)

Private Sub AddApplicant_Click()

Private Sub AddPosition_Click()

Private Sub ApplicationList_DblClick(Cancel As Integer)

Private Sub ApplicationList_KeyDown(KeyCode As Integer, Shift As Integer)

Private Sub ApplicationSortBy_AfterUpdate() - ⚠️ High branching (15 If statements)

Private Sub ApplicationSortIn_AfterUpdate()

Private Sub ClearFilters_Click()

Private Sub CloseForm_Click()

Private Sub CopyApplications_Click()

Private Sub CriteriaCombo1_AfterUpdate()

Private Sub Dashboards_AfterUpdate() - ⚠️ High branching (6 If statements)

Private Sub DuplicateFunction_Click()

Private Sub Filter1_AfterUpdate()

Private Sub Form_Activate()

Private Sub Form_Open(Cancel As Integer)

Private Sub MaintenanceFunction_Click()

Private Sub OpenJobProfile_Click() - ⚠️ Contains GoTo statements

Private Sub PeopleInformation_Click()

Private Sub PositionList_AfterUpdate()

Private Sub PositionList_DblClick(Cancel As Integer)

Private Sub PositionList_KeyDown(KeyCode As Integer, Shift As Integer) - ⚠️ High branching (6 If statements)

Private Sub PositionStatus_AfterUpdate()

Private Sub ReportMenu_Click()

Private Sub StrCriteria1_AfterUpdate()

Private Sub TelephoneInterview_Click()

Form_Remove Duplicates (Form)

File: ms_access_files\ruby\Forms\Frm Remove Duplicates.txt Lines: 40

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub MergeDuplicates_Click()

Form_Report Menu (Form)

File: ms_access_files\ruby\Forms\Frm Report Menu.txt Lines: 166

Procedures

Private Sub ApplicationStatusRatiobyPosition_Click()

Private Sub AwardsAndRecognitionReport_Click()

Private Sub BlacklistedReport_Click()

Private Sub CareReporttoExcel_Click()

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DevelopmentJourneyReport_Click()

Private Sub ExecutiveLeadsSummaryReport_Click()

Private Sub ExitsReport_Click()

Private Sub ExportEmployeeListToExcel_Click()

Private Sub ExportOpalReports_Click()

Private Sub HowHeardStatistics_Click()

Private Sub ISPIndividualReport_Click()

Private Sub ISPPerformanceReporttoExcel_Click()

Private Sub ISPSummaryReport_Click()

Private Sub ISPExceptionReport_Click()

Private Sub LeadsSummaryReport_Click()

Private Sub MeGRAPHExeptionReport_Click()

Private Sub MeGRAPHReporttoExcel_Click()

Private Sub NewStartsReport_Click()

Private Sub NumberApplicationsReport_Click()

Private Sub ProbationReviewReport_Click()

Private Sub QualificationsReporttoExcel_Click()

Private Sub RegretCVNotSuitableRatiosbyPosition_Click()

Private Sub TeamActivityReports_Click()

Private Sub TTFReporttoExcel_Click()

Private Sub WarningsReport_Click()

Form_Reports Awards and Recognition Dialog (Form)

File: ms_access_files\ruby\Forms\Frm Reports Awards and Recognition Dialog.txt Lines: 55

Procedures

Private Sub Form_Current()

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Reports Care Dialog (Form)

File: ms_access_files\ruby\Forms\Frm Reports Care Dialog.txt Lines: 54

Procedures

Private Sub Form_Current()

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Reports Company Dialog (Form)

File: ms_access_files\ruby\Forms\Frm Reports Company Dialog.txt Lines: 50

Procedures

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Reports Date Dialog (Form)

File: ms_access_files\ruby\Forms\Frm Reports Date Dialog.txt Lines: 49

Procedures

Private Sub Form_Current()

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Reports Development Journey Dialog (Form)

File: ms_access_files\ruby\Forms\Frm Reports Development Journey Dialog.txt Lines: 44

Procedures

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Reports Exits Dialog (Form)

File: ms_access_files\ruby\Forms\Frm Reports Exits Dialog.txt Lines: 54

Procedures

Private Sub Form_Current()

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Reports ISP Exception Dialog (Form)

File: ms_access_files\ruby\Forms\Frm Reports ISP Exception Dialog.txt Lines: 53

Procedures

Private Sub Form_Current()

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Reports ISP Individual Dialog (Form)

File: ms_access_files\ruby\Forms\Frm Reports ISP Individual Dialog.txt Lines: 56

Procedures

Private Sub Detail_Click()

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Reports ISP Performance Dialog (Form)

File: ms_access_files\ruby\Forms\Frm Reports ISP Performance Dialog.txt Lines: 49

Procedures

Private Sub Form_Current()

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Reports ISP Summary Dialog (Form)

File: ms_access_files\ruby\Forms\Frm Reports ISP Summary Dialog.txt Lines: 54

Procedures

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Reports Measurment Period Dialog (Form)

File: ms_access_files\ruby\Forms\Frm Reports Measurment Period Dialog.txt Lines: 52

Procedures

Private Sub Form_Current()

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Reports MeGRAPH Dialog (Form)

File: ms_access_files\ruby\Forms\Frm Reports MeGRAPH Dialog.txt Lines: 45

Procedures

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Reports MEGRAPH1 Dialog (Form)

File: ms_access_files\ruby\Forms\Frm Reports MEGRAPH1 Dialog.txt Lines: 54

Procedures

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Reports New Starts Dialog (Form)

File: ms_access_files\ruby\Forms\Frm Reports New Starts Dialog.txt Lines: 55

Procedures

Private Sub Form_Current()

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Reports Probation Review Dialog (Form)

File: ms_access_files\ruby\Forms\Frm Reports Probation Review Dialog.txt Lines: 49

Procedures

Private Sub Form_Current()

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Reports Qualifications Dialog (Form)

File: ms_access_files\ruby\Forms\Frm Reports Qualifications Dialog.txt Lines: 54

Procedures

Private Sub Detail_Click()

Private Sub Form_Current()

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Reports Single Date Dialog (Form)

File: ms_access_files\ruby\Forms\Frm Reports Single Date Dialog.txt Lines: 47

Procedures

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Private Sub PrevDate_Click()

Form_Reports Time To Fill Dialog (Form)

File: ms_access_files\ruby\Forms\Frm Reports Time To Fill Dialog.txt Lines: 53

Procedures

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Form_Team Activity Report Dialog (Form)

File: ms_access_files\ruby\Forms\Frm Team Activity Report Dialog.txt Lines: 77

Procedures

Private Sub OKButton_Click() - ⚠️ Contains GoTo statements; High branching (8 If statements)

Private Sub CancelButton_Click() - ⚠️ Contains GoTo statements

Private Sub ReportType_AfterUpdate()

Form_Training Module and Session List (Form)

File: ms_access_files\ruby\Forms\Frm Training Module and Session List.txt Lines: 253

Procedures

Public Sub UpdateList()

Private Sub AddModuleSession_Click()

Private Sub ClearFilter_Click()

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DisplayBy_AfterUpdate()

Private Sub Form_Open(Cancel As Integer)

Private Sub ModuleSessionList_DblClick(Cancel As Integer)

Private Sub ModuleSessionList_KeyDown(KeyCode As Integer, Shift As Integer) - ⚠️ High branching (8 If statements)

Private Sub StrCriteria1_AfterUpdate()

Form_Training Module List (Form)

File: ms_access_files\ruby\Forms\Frm Training Module List.txt Lines: 159

Procedures

Public Sub UpdateList()

Private Sub AddModule_Click()

Private Sub ClearFilter_Click()

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DisplayBy_AfterUpdate()

Private Sub Form_Open(Cancel As Integer)

Private Sub ModuleList_DblClick(Cancel As Integer)

Private Sub ModuleList_KeyDown(KeyCode As Integer, Shift As Integer)

Private Sub StrCriteria1_AfterUpdate()

Form_View Job Code Pre Appointment Documents (Form)

File: ms_access_files\ruby\Forms\Frm View Job Code Pre Appointment Documents.txt Lines: 48

Procedures

Private Sub AddPreAppointmentDocuments_Click()

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub DocumentCategoryList_AfterUpdate()

Form_View Job Code Telephone Interview Questions (Form)

File: ms_access_files\ruby\Forms\Frm View Job Code Telephone Interview Questions.txt Lines: 48

Procedures

Private Sub AddTelephoneInterviewQuestions_Click()

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub QuestionCategoryList_AfterUpdate()

Form_View Job Code Training Modules and Sessions (Form)

File: ms_access_files\ruby\Forms\Frm View Job Code Training Modules and Sessions.txt Lines: 62

Procedures

Private Sub AddTrainingModulesorSessions_Click()

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub TrainingTypeList_AfterUpdate()

Form_View Job Code Training Modules (Form)

File: ms_access_files\ruby\Forms\Frm View Job Code Training Modules.txt Lines: 49

Procedures

Private Sub AddTrainingModulesor_Click()

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub TrainingTypeList_AfterUpdate()

Form_View Other Applicants Filled Positions (Form)

File: ms_access_files\ruby\Forms\Frm View Other Applicants Filled Positions.txt Lines: 24

Procedures

Private Sub CloseForm_Click() - ⚠️ Contains GoTo statements

Private Sub Form_Open(Cancel As Integer)

Form_View Telephone Interview Question Responses (Form)

File: ms_access_files\ruby\Forms\Frm View Telephone Interview Question Responses.txt Lines: 14

Procedures

Private Sub CloseForm_Click()

Private Sub PrintInterview_Click()

Form_SubFrm Application Assessments (Form)

File: ms_access_files\ruby\Forms\SubFrm Application Assessments.txt Lines: 18

Procedures

Private Sub DeleteRec_Click()

Form_SubFrm Application Considerations - Edit (Form)

File: ms_access_files\ruby\Forms\SubFrm Application Considerations - Edit.txt Lines: 9

Procedures

Private Sub Form_BeforeInsert(Cancel As Integer)

Form_SubFrm Application Considerations (Form)

File: ms_access_files\ruby\Forms\SubFrm Application Considerations.txt Lines: 18

Procedures

Private Sub DeleteRec_Click()

Form_SubFrm Job Code Pre Appointment Documents (Form)

File: ms_access_files\ruby\Forms\SubFrm Job Code Pre Appointment Documents.txt Lines: 31

Procedures

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Form_SubFrm Job Code Telephone Interview Questions (Form)

File: ms_access_files\ruby\Forms\SubFrm Job Code Telephone Interview Questions.txt Lines: 31

Procedures

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Form_SubFrm Job Code Training Modules NOT in List (Form)

File: ms_access_files\ruby\Forms\SubFrm Job Code Training Modules NOT in List.txt Lines: 31

Procedures

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Form_SubFrm Job Code Training Modules (Form)

File: ms_access_files\ruby\Forms\SubFrm Job Code Training Modules.txt Lines: 31

Procedures

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Form_SubFrm Job Code Training Sessions NOT in List (Form)

File: ms_access_files\ruby\Forms\SubFrm Job Code Training Sessions NOT in List.txt Lines: 31

Procedures

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Form_SubFrm Job Code Training Sessions (Form)

File: ms_access_files\ruby\Forms\SubFrm Job Code Training Sessions.txt Lines: 31

Procedures

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Form_SubFrm People Emailing Lists (Form)

File: ms_access_files\ruby\Forms\SubFrm People Emailing Lists.txt Lines: 18

Procedures

Private Sub DeleteRec_Click()

Form_SubFrm People Investigation Process Evidence (Form)

File: ms_access_files\ruby\Forms\SubFrm People Investigation Process Evidence.txt Lines: 28

Procedures

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub Form_BeforeInsert(Cancel As Integer)

Form_SubFrm People Poor Performance Action Items (Form)

File: ms_access_files\ruby\Forms\SubFrm People Poor Performance Action Items.txt Lines: 31

Procedures

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub Form_BeforeInsert(Cancel As Integer)

Form_SubFrm People Probation Interview Action Items (Form)

File: ms_access_files\ruby\Forms\SubFrm People Probation Interview Action Items.txt Lines: 31

Procedures

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub Form_BeforeInsert(Cancel As Integer)

Form_SubFrm People REMS Modules (Form)

File: ms_access_files\ruby\Forms\SubFrm People REMS Modules.txt Lines: 18

Procedures

Private Sub DeleteRec_Click()

Form_SubFrm People Share Drive Access (Form)

File: ms_access_files\ruby\Forms\SubFrm People Share Drive Access.txt Lines: 18

Procedures

Private Sub DeleteRec_Click()

Form_SubFrm People Three Plus One Feedback (Form)

File: ms_access_files\ruby\Forms\SubFrm People Three Plus One Feedback.txt Lines: 31

Procedures

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub Form_BeforeInsert(Cancel As Integer)

Form_SubFrm People Three Plus One ISP Contract (Form)

File: ms_access_files\ruby\Forms\SubFrm People Three Plus One ISP Contract.txt Lines: 31

Procedures

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub Form_BeforeInsert(Cancel As Integer)

Form_SubFrm People Three Plus One KPI Measurement Criteria (Form)

File: ms_access_files\ruby\Forms\SubFrm People Three Plus One KPI Measurement Criteria.txt Lines: 31

Procedures

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub Form_BeforeInsert(Cancel As Integer)

Form_SubFrm People Training Module Summary (Form)

File: ms_access_files\ruby\Forms\SubFrm People Training Module Summary.txt Lines: 31

Procedures

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub Form_BeforeInsert(Cancel As Integer)

Form_SubFrm Pre Appointment Documents (Form)

File: ms_access_files\ruby\Forms\SubFrm Pre Appointment Documents.txt Lines: 55

Procedures

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

Form_SubFrm Telephone Interview Questions (Form)

File: ms_access_files\ruby\Forms\SubFrm Telephone Interview Questions.txt Lines: 55

Procedures

Private Sub DeleteRec_Click() - ⚠️ Contains GoTo statements

Private Sub NewRecord_Click() - ⚠️ Contains GoTo statements

basRelink (Standard)

File: ms_access_files\ruby\Modules\basRelink.bas Lines: 562

Procedures

Public Function RelinkODBC() As Boolean - ⚠️ Contains GoTo statements; High branching (8 If statements); Large procedure (148 lines)

Public Function Update_zstblODBC() As Boolean - ⚠️ Contains GoTo statements

Public Function RelinkTablesLocal() As Boolean - ⚠️ Contains GoTo statements

Public Function CompactTablesMain() As Boolean - ⚠️ Contains GoTo statements

Public Function CompactTablesLocal() As Boolean - ⚠️ Contains GoTo statements

Public Function TableExists(ByVal pstrTableName As String) As Boolean - ⚠️ Uses On Error Resume Next

Mod Export to Excel (Standard)

File: ms_access_files\ruby\Modules\Mod Export to Excel.bas Lines: 1901

Procedures

Public Sub ExportTheEmployeeListToExcel() - ⚠️ Contains GoTo statements; Large procedure (126 lines)

Public Sub ExportOpalReportsToExcel() - ⚠️ Contains GoTo statements; High branching (12 If statements); Large procedure (622 lines)

Public Sub ExportLeadSummaryToExcel(FromAuto As Boolean, Optional TheFileName As String) - ⚠️ Contains GoTo statements; Large procedure (128 lines)

Public Sub ExportTheISPExceptionToExcel() - ⚠️ Contains GoTo statements

Public Sub ExportTheISPSummaryToExcel() - ⚠️ Contains GoTo statements

Public Sub ExportTheISPPerformanceReporttoExcel() - ⚠️ Contains GoTo statements

Public Sub ExportTheQualificationsReporttoExcel() - ⚠️ Contains GoTo statements

Public Sub ExportTheMeGRAPHReporttoExcel() - ⚠️ Contains GoTo statements; Large procedure (113 lines)

Public Sub ExportTheCareReporttoExcel() - ⚠️ Contains GoTo statements; Large procedure (109 lines)

Public Sub ExportTheAwardsAndRecognitionReporttoExcel() - ⚠️ Contains GoTo statements; Large procedure (109 lines)

Public Sub ExportTheNewStartsReporttoExcel() - ⚠️ Contains GoTo statements; Large procedure (101 lines)

Public Sub ExportTheExitsReporttoExcel() - ⚠️ Contains GoTo statements

Public Sub ExportTheTimeToFillReporttoExcel() - ⚠️ Contains GoTo statements; Large procedure (115 lines)

Mod Send Outlook Message (Standard)

File: ms_access_files\ruby\Modules\Mod Send Outlook Message.bas Lines: 53

Procedures

Public Sub SendOutlookMessage(Recip As String, Optional fileName As String, Optional SubText As String, Optional BodyText As String, Optional CCText As String)

Mod Utilities (Standard)

File: ms_access_files\ruby\Modules\Mod Utilities.bas Lines: 97

Procedures

Public Function IsLoaded(ByVal strFormName As String) As Boolean

Public Function StringsSameCase(x As String, y As String) As Boolean

Public Function CheckForUpper(CheckString As String)

Public Function CheckForSpecial(CheckString As String)

Public Function CheckForNumber(CheckString As String)

Public Sub OpenTheFile(TheFileName As String)

SQL Queries

Find duplicates for Job Code Training Sessions

Type: Select

SELECT [Job Code Training Sessions].[Job ID], [Job Code Training Sessions].[Training Session ID], [Job Code Training Sessions].[Job Code Training Session ID] FROM [Job Code Training Sessions] WHERE ((([Job Code Training Sessions].[Job ID]) In (SELECT [Job ID] FROM [Job Code Tra

Find duplicates for People Cell

Type: Select

SELECT People.[First Name], People.[Last Name], People.[Cell Number], People.[People ID] FROM [People] WHERE (((People.[First Name]) In (SELECT [First Name] FROM [People] As Tmp GROUP BY [F

Find duplicates for People ID Nymber

Type: Select

SELECT People.[ID Number], People.[People ID], People.[First Name], People.[Last Name] FROM [People] WHERE (((People.[ID Number]) In (SELECT [ID Number] FROM [People] As Tmp GROUP BY [ID 

JB Emails to Move

Type: Select

SELECT People.Email, People.[First Name], People.[Last Name] FROM [People] WHERE (((People.Email) Like \"*raizcorp*\"))

JB Qry Append Job Telephone Interview Questions to Application

Type: Delete

SELECT [Job Code Telephone Interview Questions].[Telephone Interview Question ID], 31480 FROM [Job Code Telephone Interview Questions] WHERE ((([Job Code Telephone Interview Questions].[Telephone Interview Question ID])>6

JB Qry Initialise Default Interview Questions

Type: Delete

SELECT [Job Codes].[Job ID], [Telephone Interview Questions].[Telephone Interview Question ID] FROM [Job Codes], [Telephone Interview Questions] WHERE ((([Telephone Interview Questions].[Default Question])=True) AND (([Job Codes].A

JB Qry Initialise UUID

Type: Delete

SELECT vwRubyPreFilledPositionList.[People ID], \, \ FROM [vwRubyPreFilledPositionList]

Qry Append Default Application Status Steps to Job Code

Type: Delete

SELECT [Application Status].[Application Status ID], [Forms]![Frm Add and Edit Job Code]![Job ID] FROM [Application Status] WHERE ((([Application Status].[Default Step])=True))

Qry Append Default Regret Reasons to Job Code

Type: Delete

SELECT [Regret Reasons].[Regret Reason ID], [Forms]![Frm Add and Edit Job Code]![Job ID] FROM [Regret Reasons] WHERE ((([Regret Reasons].[Always Include])=True))

Qry Append Investigation Process Evidence

Type: Delete

SELECT [People Disciplinary Investigation Process Evidence].[People Disciplinary Invest, [People Disciplinary Investigation Process Evidence].[People Disciplinary Invest, [People Disciplinary Investigation Process Evidence].Evidence, [People Disciplinary Investigation Process Evidence].[Evidence Location] FROM [People Disciplinary Investigation Process Evidence] WHERE ((([People Disciplinary Investigation Process Evidence].[People Disciplinary Inv

Qry Application List Not Hired

Type: Select

SELECT vwRubyPreApplicationListNotHired.[Application ID], vwRubyPreApplicationListNotHired.[Position ID], vwRubyPreApplicationListNotHired.[People ID], vwRubyPreApplicationListNotHired.[Application Status ID], vwRubyPreApplicationListNotHired.[Application Status], vwRubyPreApplicationListNotHired.Applicant, vwRubyPreApplicationListNotHired.[Application Date], vwRubyPreApplicationListNotHired.[Sort Order], vwRubyPreApplicationListNotHired.[PQ Score] FROM [vwRubyPreApplicationListNotHired]

Qry Application List

Type: Select

SELECT vwRubyPreApplicationList.[Application ID], vwRubyPreApplicationList.[Position ID], vwRubyPreApplicationList.[People ID], vwRubyDuplicatePeopleIDList.[Duplicate People ID], vwRubyPreApplicationList.[Application Status ID], vwRubyPreApplicationList.[Application Status], IIf(Not IsNull([Duplicate People ID]),\, IIf(Not IsNull([Duplicate Application People ID]),\, vwRubyPreApplicationList.Applicant, vwRubyPreApplicationList.[Application Date], vwRubyPreApplicationList.[Sort Order], Int(DateDiff(\, vwRubyPreApplicationList.[PQ Score] FROM [vwRubyPreApplicationList], [vwRubyDuplicatePeopleIDList], [vwRubyDuplicateApplicationList]

Qry Awards And Recognition

Type: Select

SELECT Companies.[Company ID], Companies.[Company Name], [Organisational Codes].[Organisational Unit], People.[First Name] & \, [People Awards].[Date Captured], [People Awards].Quarter, [People Awards].[Quarter Year], [People Awards].[Award Name], [People Awards].Forum, [People Awards].[Award Value], [People Awards].Notes FROM [Companies], [Organisational Codes], [People Awards], [People], [Applications], [Positions] WHERE (((Companies.[Company ID])=Forms![Frm Reports Awards and Recognition Dialog]![Co

Qry Badges

Type: Select

SELECT People.[People ID], Badge.[Badge ID], Badge.Badge, [People Badges].[Date Assigned] FROM [People], [Badge], [People Badges]

Qry Care

Type: Select

SELECT Companies.[Company ID], Companies.[Company Name], [Organisational Codes].[Organisational Unit], People.[First Name] & \, [People Care Records].[Date Captured], [People Care Records].Quarter, [People Care Records].[Quarter Year], [People Care Records].[Care Received], [People Care Records].[Number Sessions], [People Care Records].[Care Value], [People Care Records].Notes FROM [Positions], [People Care Records], [People], [Applications], [Companies], [Organisational Codes] WHERE (((Companies.[Company ID])=[Forms]![Frm Reports Care Dialog]![Company ID]) AND (

Qry Copy Application List

Type: Select

SELECT vwRubyPreApplicationList.[Stage Number], vwRubyPreApplicationList.[Application ID], vwRubyPreApplicationList.[Position ID], vwRubyPreApplicationList.[People ID], vwRubyPreApplicationList.[Application Status ID], vwRubyPreApplicationList.[Application Status], vwRubyPreApplicationList.Applicant, vwRubyPreApplicationList.[Application Date], vwRubyPreApplicationList.[Sort Order], Int(DateDiff(\, vwRubyPreApplicationList.[PQ Score] FROM [vwRubyPreApplicationList] WHERE (((vwRubyPreApplicationList.[Stage Number])<>7 And (vwRubyPreApplicationList.[St

Qry Count All Application Status by Position

Type: Select

SELECT Applications.[Position ID], [Application Status].[Report Point], [Application Status].[Application Status], [Application Status].[Sort Order], Count(Applications.[Application ID]) FROM [Applications], [Application Status]

Qry Count CV Not Suitable Reasons by Position

Type: Select

SELECT Applications.[Position ID], Applications.[CV Not Suitable Reason ID], [CV Not Suitable Reasons].[CV Not Suitable Reason], [CV Not Suitable Reasons].[Sort Order], Count(Applications.[Application ID]) FROM [Applications], [CV Not Suitable Reasons] WHERE (((Applications.[Application Status ID])=30))

Qry Count Number CV Not Suitable by Position

Type: Select

SELECT Applications.[Position ID], Count(Applications.[Application ID]) FROM [Applications] WHERE (((Applications.[Application Status ID])=30))

Qry Count Number Employees by Company

Type: Select

SELECT Positions.[Company ID], Positions.[Employment Status], Count(Positions.[Position ID]) FROM [Positions], [Applications] WHERE (((Positions.[Position Status ID])=4) AND ((Applications.[Application Status ID]

Qry Count Number Regretted by Position

Type: Select

SELECT Applications.[Position ID], Count(Applications.[Application ID]) FROM [Applications] WHERE (((Applications.[Application Status ID])=28))

Qry Count Regret Reasons by Position

Type: Select

SELECT Applications.[Position ID], Applications.[Regret Reason ID], [Regret Reasons].[Regret Reason], [Regret Reasons].[Sort Order], Count(Applications.[Application ID]) FROM [Applications], [Regret Reasons] WHERE (((Applications.[Application Status ID])=28))

Qry Count Scheduled and Completed Training Modules One Emp

Type: Select

SELECT [Job Code Training Modules].[Job ID], [People Training Modules].[People ID], Count([People Training Modules].[Date Scheduled]), Count([People Training Modules].[Date Completed]), Count([People Training Modules].[Quiz Score]), Sum([People Training Modules].[Quiz Score]), Count([People Training Modules].[Assessment Score]), Sum([People Training Modules].[Assessment Score]) FROM [Job Code Training Modules], [People Training Modules]

Qry Count Total Applications by Position

Type: Select

SELECT Applications.[Position ID], Count(Applications.[Application ID]) FROM [Applications]

Qry Count Training Modules One Job Code

Type: Select

SELECT [Job Code Training Modules].[Job ID], Count([Job Code Training Modules].[Job Code Training Module ID]) FROM [Job Code Training Modules]

Qry Development Journey Training Information

Type: Select

SELECT [People].[First Name] & \, [Job Codes].Job, [Training Types].[Training Type], [Training Courses].Course, [Training Modules].Module, [People Training Module Status].[People Training Module Status], [People Training Modules].[Date Scheduled], [People Training Modules].[Date Completed], [People Training Modules].[Training Version], [People Training Modules].[Quiz Score], [People Training Modules].[Assessment Score], [People_1].[First Name] & \ FROM [People], [Training Modules], [Training Courses], [Training Types], [People Training Modules], [Job Code Training Modules], [People], [People Training Module Status], [Job Codes], [Positions]

Qry Development Journey

Type: Select

SELECT [People].[First Name] & \, [Job Codes].Job, [Training Types].[Training Type], [Training Courses].Course, [Training Modules].Module, [People Training Module Status].[People Training Module Status], [People Training Modules].[Date Scheduled], [People Training Modules].[Date Completed], [People Training Modules].[Training Version], [People Training Modules].[Quiz Score], [People Training Modules].[Assessment Score], [People_1].[First Name] & \, People.[People ID] FROM [People], [Training Modules], [Training Courses], [Training Types], [People Training Modules], [Job Code Training Modules], [People], [People Training Module Status], [Job Codes], [Positions]

Qry Duplicate People

Type: Select

SELECT vwRubyDuplicatePeople.[People ID], vwRubyDuplicatePeople.Applicant, vwRubyDuplicatePeople.[Birth Date], vwRubyDuplicatePeople.[ID Number], vwRubyDuplicatePeople.[Application Date], vwRubyDuplicatePeople.Job, vwRubyDuplicatePeople.[Application Status] FROM [vwRubyDuplicatePeople]

Qry Edit Telephone Interview Question Responses

Type: Select

SELECT [Telephone Interview Question Categories].[Sort Order], [Telephone Interview Questions].[Sort Order], [Application Telephone Interview Question Responses].[Application ID], [Job Codes].Job, [Pay Points].[Pay Point], [First Name] & \, Applications.[Telephone Interviewer], Applications.[Telephone Interview Date], [Telephone Interview Question Categories].[Telephone Interview Question Category, [Telephone Interview Questions].[Telephone Interview Question], [Telephone Interview Questions].[Telephone Interview Question Detail], [Application Telephone Interview Question Responses].[Telephone Interview Respon FROM [Application Telephone Interview Question Responses], [Telephone Interview Questions], [Telephone Interview Question Categories], [Applications], [Positions], [Job Codes], [People], [Pay Points]

Qry Exits

Type: Select

SELECT Companies.[Company Name], [Organisational Codes].[Organisational Unit], [People].[First Name] & \, [Position Status].[Position Status], Positions.[Start Date], [Pay Points].[Pay Point], [People_1].[First Name] & \ FROM [People], [Positions], [Position Status], [People], [Applications], [Pay Points], [Companies], [Organisational Codes] WHERE (((Positions.[Start Date])>=[Forms]![Frm Reports Exits Dialog]![Start Date] And 

Qry Export Employee Engage

Type: Select

SELECT Applications.[Application Status ID], Positions.[Position Status ID], People.[People ID], People.[Employee Number], People.Initials, People.[First Name], People.[Last Name], People.Email, People.[Cell Number], People.[Birth Date], People.Gender, People.Race, People.[ID Number], People.[Group Join Date], Positions.[Termination Date], People.[ISP Q1], People.[ISP Q2], People.[ISP Q3], People.[ISP Q4], Positions.[Training Approver ID], Positions.[Second Training Approver ID], [Organisational Codes].[Organisational Code], [Job Codes].[Job Code], People.[Phys Line 1], People.[Phys Line 2], People.[Phys Line 3], People.[Phys Postal Code], People.[Phys Street Number], People.[Phys Unit Number], People.[Phys Complex], People.[Phys Province], People.[Phys Country], People.[Send Post To], People.[Postal Add 1], People.[Postal Add 2], People.[Postal Add 3], People.[Postal Code], People.[Postal Street Number], People.[Postal Unit Number], People.[Postal Complex], People.[Postal Province], People.[Postal Country], [Organisational Codes].[Organisational Unit], [Job Codes].Job, Positions.[Position Effective Date], [Pay Points].[Pay Point], [People_1].[Employee Number] & \, People.Title, People.[Middle Name], Positions.[Employment Status], People.[Foreign National], People.[Home Number], People.Citizenship, People.[Emergency Contact Name], People.[Emergency Contact Number], People.[Emergency Contact Address] FROM [People], [Applications], [Positions], [Organisational Codes], [Job Codes], [Pay Points], [People] WHERE (((Applications.[Application Status ID])=27) AND ((Positions.[Position Status ID

Qry Export Job List Engage

Type: Select

SELECT [Job Codes].[Job ID], [Job Codes].[Job Code], [Job Codes].Job, [Job Codes].DESCRIPTION FROM [Job Codes] WHERE ((([Job Codes].[Job Code]) Is Not Null))

Qry Export Lead Summary Report Get Application Status

Type: Select

SELECT [Qry Export Lead Summary Report].[Sort Order], [Qry Export Lead Summary Report].[Application Status] FROM [Qry Export Lead Summary Report]

Qry Export Lead Summary Report

Type: Select

SELECT [Job Codes].Job, Positions.[Position ID], [Organisational Codes].[Organisational Unit], Positions.[Position Status ID], [Application Status].[Application Status], Count(Applications.[Application ID]), [Application Status].[Sort Order] FROM [Applications], [Positions], [Application Status], [Job Codes], [Organisational Codes]

Qry Export Organisational Codes Engage

Type: Select

SELECT [Organisational Codes].[Organisational ID], [Organisational Codes].[Organisational Code], [Organisational Codes].[Organisational Unit], [Organisational Codes].[Organisational Unit Description], [Organisational Codes].[Organisational Unit Parent] FROM [Organisational Codes] WHERE ((([Organisational Codes].[Organisational Code]) Is Not Null))

Qry Filled Position List

Type: Select

SELECT vwRubyPreFilledPositionList.[Application Status ID], vwRubyPreFilledPositionList.[Position ID], vwRubyPreFilledPositionList.[People ID], vwRubyPreFilledPositionList.[Job ID], vwRubyPreFilledPositionList.[Which Dashboard], vwRubyPreFilledPositionList.Job, vwRubyPreFilledPositionList.[Org Unit], vwRubyPreFilledPositionList.[Pay Point], vwRubyPreFilledPositionList.[Position Status ID], vwRubyPreFilledPositionList.[Position Status], vwRubyPreFilledPositionList.Employee, vwRubyPreFilledPositionList.Person, vwRubyPreFilledPositionList.[Start Date], vwRubyPreFilledPositionList.[Termination Date], vwRubyPreFilledPositionList.[Date Eliminated], vwRubyPreFilledPositionList.[Date Suspended], vwRubyPreFilledPositionList.[Company Name] FROM [vwRubyPreFilledPositionList]

Qry Find Dulicate People for Merge

Type: Select

SELECT People.[First Name], People.[Last Name], People.[ID Number], People.[People ID], People.[Import ID] FROM [People] WHERE (((People.[First Name]) In (SELECT [First Name] FROM [People] As Tmp GROUP BY [F

Qry Get Line Manager

Type: Select

SELECT People.[People ID], [First Name] & \, People.Email FROM [People]

Qry Get Max Employee Number by Company

Type: Select

SELECT Left([Employee Number],Len([Employee Number Prefix])), Max(Val(IIf(IsNumeric(Mid([Employee Number],Len([Employee Number Prefix])+1,Len( FROM [People], [Applications], [Positions], [Companies] WHERE (((People.[Employee Number]) Is Not Null))

Qry Get People ID Numbers for Merge

Type: Select

SELECT [Qry Find Dulicate People for Merge].[ID Number] FROM [Qry Find Dulicate People for Merge]

Qry Get People in Positions

Type: Select

SELECT Positions.[Position ID], People.[People ID], [First Name] & \, [Job Codes].Job, People.Email, People.[ID Number], Positions.[Position Status ID], Applications.[Application Status ID] FROM [People], [Applications], [Positions], [Job Codes] WHERE (((Positions.[Position Status ID])=4) AND ((Applications.[Application Status ID]

Qry Get People Poor Performance Checkins

Type: Select

SELECT [People Poor Performance Checkin].[People Poor Performance Checkin ID], [People Poor Performance Checkin].[People ID], [People Poor Performance Checkin].[Checkin Date], \ FROM [People Poor Performance Checkin] WHERE ((([People Poor Performance Checkin].[Checkin Date]) Is Not Null))

Qry Get People Poor Performance Meeting A

Type: Select

SELECT [People Poor Work Performance].[People Poor Work Performance ID], [People Poor Work Performance].[People ID], [People Poor Work Performance].[Meeting A Date], \ FROM [People Poor Work Performance] WHERE ((([People Poor Work Performance].[Meeting A Date]) Is Not Null))

Qry Get People Poor Performance Meeting B

Type: Select

SELECT [People Poor Work Performance].[People Poor Work Performance ID], [People Poor Work Performance].[People ID], [People Poor Work Performance].[Meeting B Date], \ FROM [People Poor Work Performance] WHERE ((([People Poor Work Performance].[Meeting B Date]) Is Not Null))

Qry Get People Poor Performance Meeting C

Type: Select

SELECT [People Poor Work Performance].[People Poor Work Performance ID], [People Poor Work Performance].[People ID], [People Poor Work Performance].[Meeting C Date], \ FROM [People Poor Work Performance] WHERE ((([People Poor Work Performance].[Meeting C Date]) Is Not Null))

Qry Get Reporting To Name and Job

Type: Select

SELECT People.[People ID], Applications.[Application Status ID], Positions.[Position Status ID], [Job Codes].Job, [First Name] & \ FROM [Job Codes], [Positions], [Applications], [People] WHERE (((Applications.[Application Status ID])=27) AND ((Positions.[Position Status ID

Qry ISP Exception

Type: Select

SELECT Companies.[Company Name], [Organisational Codes].[Organisational Unit], [People].[First Name] & \, [Job Codes].Job, [People_1].[First Name] & \ FROM [People], [Organisational Codes], [People], [People Three Plus One], [Applications], [Positions], [Companies], [Job Codes]

Qry ISP Individual From Three Plus One Page

Type: Select

SELECT [People].[First Name] & \, [People Three Plus One].[Reviewed By], [People Three Plus One].[Date of Review], [People Three Plus One ISP Contract].[Key Performance Area], [People Three Plus One ISP Contract].[KPA Weighting], [People Three Plus One ISP Contract].[Key Performance Indicator], [People Three Plus One ISP Contract].[KPI Score], [People Three Plus One].[Adjust Percentage], [People Three Plus One].[Evidence to Adjust Score], [Organisational Codes].[Organisational Unit], [Job Codes].Job, [People Three Plus One ISP Contract].[KPI Score]/100*[KPI Weighting], [People_1].[First Name] & \, [People Three Plus One ISP Contract].[KPI Weighting], People.[People ID] FROM [People], [Positions], [People], [People Three Plus One], [People Three Plus One ISP Contract], [Applications], [Job Codes], [Organisational Codes]

Qry ISP Individual

Type: Select

SELECT [People].[First Name] & \, [People Three Plus One].[Reviewed By], [People Three Plus One].[Date of Review], [People Three Plus One ISP Contract].[Key Performance Area], [People Three Plus One ISP Contract].[KPA Weighting], [People Three Plus One ISP Contract].[Key Performance Indicator], [People Three Plus One ISP Contract].[KPI Score], [People Three Plus One].[Adjust Percentage], [People Three Plus One].[Evidence to Adjust Score], [Organisational Codes].[Organisational Unit], [Job Codes].Job, [People Three Plus One ISP Contract].[KPI Score]/100*[KPI Weighting], [People_1].[First Name] & \, [People Three Plus One ISP Contract].[KPI Weighting], People.[People ID] FROM [People], [Positions], [People], [People Three Plus One], [People Three Plus One ISP Contract], [Applications], [Job Codes], [Organisational Codes]

Qry ISP Performance

Type: Select

SELECT [Organisational Codes].[Organisational Unit], Count(People.[People ID]), Count([People Three Plus One].[Measurement Period From]), [ISP Incomplete]-[ISP Complete], [ISP Difference]/[ISP Incomplete], [ISP Complete]/[ISP Incomplete] FROM [People], [People Three Plus One], [Applications], [Positions], [Organisational Codes], [Companies], [People Three Plus One ISP Contract]

Qry ISP Summary

Type: Select

SELECT [People].[Last Name] & \, [Job Codes].Job, [Organisational Codes].[Organisational Unit], [Pay Points].[Pay Point], [KPI Score]/100*[KPI Weighting] FROM [People], [Job Codes], [Positions], [Applications], [People], [Organisational Codes], [Pay Points], [People Three Plus One], [People Three Plus One ISP Contract] WHERE ((([Organisational Codes].[Organisational ID])=Forms![Frm Reports ISP Summary Di

Qry Job Code Application Step List

Type: Select

SELECT [Job Code Application Steps].[Job Code Application Step ID], [Job Code Application Steps].[Job ID], [Job Code Application Steps].[Application Status ID], [Application Status].[Application Status], [Application Status].[Assessment Step], [Application Status].[Sort Order], [Application Status].Active, [Application Status].[Stage Number] FROM [Job Code Application Steps], [Application Status]

Qry Job Code Application Steps NOT in List

Type: Select

SELECT [Application Status].[Application Status ID], [Application Status].[Application Status], [Application Status].[Sort Order], [Application Status].Active FROM [Application Status], [SubQry Job Code Application Step NOT in List] WHERE ((([SubQry Job Code Application Step NOT in List].[Application Status ID]) Is Nu

Qry Job Code List

Type: Select

SELECT [Job Codes].[Job ID], [Job Codes].Job, [Job Codes].[Job Profile File Name] FROM [Job Codes]

Qry Job Code People List

Type: Select

SELECT [Job Codes].[Job ID], Applications.[Application Status ID], Positions.[Position Status ID], [Last Name] & \, Positions.[Start Date] FROM [People], [Applications], [Positions], [Job Codes] WHERE (((Applications.[Application Status ID])=27) AND ((Positions.[Position Status ID

Qry Job Code Pre Appointment Documents NOT in the List

Type: Delete

SELECT [Pre Appointment Documents].[Pre Appointment Document ID], [Pre Appointment Documents].[Pre Appointment Document Category ID], [Pre Appointment Documents].[Pre Appointment Document] FROM [SubQry Job Code Pre Appointment Documents NOT in the List], [Pre Appointment Documents] WHERE ((([SubQry Job Code Pre Appointment Documents NOT in the List].[Pre Appointment 

Qry Job Code Pre Appointment Documents

Type: Select

SELECT [Pre Appointment Documents].[Sort Order], [Job Code Pre Appointment Documents].[Job Code Pre Appointment Document ID], [Job Code Pre Appointment Documents].[Job ID], [Pre Appointment Documents].[Pre Appointment Document Category ID], [Pre Appointment Documents].[Pre Appointment Document], [Pre Appointment Documents].Source, [Pre Appointment Documents].Version, [Pre Appointment Documents].Quantity, [Pre Appointment Documents].Cost, [Pre Appointment Documents].[Document Type] FROM [Job Code Pre Appointment Documents], [Pre Appointment Documents]

Qry Job Code Regret Reason List

Type: Select

SELECT [Job Code Regret Reasons].[Job Code Regret Reason ID], [Job Code Regret Reasons].[Job ID], [Job Code Regret Reasons].[Regret Reason ID], [Regret Reasons].[Regret Reason], [Regret Reasons].[Sort Order], [Regret Reasons].Active FROM [Regret Reasons], [Job Code Regret Reasons]

Qry Job Code Regret Resons NOT in List

Type: Select

SELECT [Regret Reasons].[Regret Reason ID], [Regret Reasons].[Regret Reason], [Regret Reasons].[Sort Order], [Regret Reasons].Active FROM [SubQry Job Code Regret Reasons NOT in List], [Regret Reasons] WHERE ((([Regret Reasons].Active)=True) AND (([SubQry Job Code Regret Reasons NOT in L

Qry Job Code Telephone Interview Questions NOT in the List

Type: Delete

SELECT [Telephone Interview Questions].[Telephone Interview Question ID], [Telephone Interview Questions].[TI Question Category ID], [Telephone Interview Questions].[Telephone Interview Question], [Telephone Interview Questions].[Telephone Interview Question Detail] FROM [SubQry Job Code Telephone Interview Questions NOT in the List], [Telephone Interview Questions] WHERE ((([SubQry Job Code Telephone Interview Questions NOT in the List].[Telephone In

Qry Job Code Telephone Interview Questions

Type: Select

SELECT [Telephone Interview Questions].[Sort Order], [Job Code Telephone Interview Questions].[Job Code Telephone Interview Question , [Job Code Telephone Interview Questions].[Job ID], [Telephone Interview Questions].[TI Question Category ID], [Telephone Interview Questions].[Telephone Interview Question], [Telephone Interview Questions].[Telephone Interview Question Detail] FROM [Job Code Telephone Interview Questions], [Telephone Interview Questions]

Qry Job Code Training Modules NOT in the List

Type: Delete

SELECT [Training Modules].[Training Module ID], [Training Modules].Module, [SubQry Job Code Training Modules NOT in the List].[Sort Order] FROM [SubQry Job Code Training Modules NOT in the List], [Training Modules] WHERE ((([SubQry Job Code Training Modules NOT in the List].[Training Module ID]) Is N

Qry Job Code Training Modules

Type: Select

SELECT [Job Code Training Modules].[Sort Order], [Job Code Training Modules].[Job Code Training Module ID], [Job Code Training Modules].[Job ID], [Job Code Training Modules].[Training Type ID], [Training Types].[Training Type], [Training Courses].Course, [Training Modules].Module, [Training Modules].[Training Version], [Training Modules].Assessment, [Training Modules].Quiz FROM [Job Code Training Modules], [Training Types], [Training Courses], [Training Modules]

Qry Job Code Training Sessions NOT in the List

Type: Select

-- Unable to parse query definition

Qry Job Code Training Sessions

Type: Select

SELECT [Job Code Training Sessions].[Job Code Training Session ID], [Job Code Training Sessions].[Job ID], [Job Code Training Sessions].[Training Type ID], [Training Types].[Training Type], [Training Courses].Course, [Training Sessions].Session, [Training Sessions].Quiz FROM [Training Courses], [Training Types], [Job Code Training Sessions], [Training Sessions]

Qry Job Codes and Pre Appointment Document Categories List

Type: Select

SELECT [Pre Appointment Document Categories].[Sort Order], [Job Code Pre Appointment Documents].[Job ID], [Pre Appointment Documents].[Pre Appointment Document Category ID], [Pre Appointment Document Categories].[Pre Appointment Document Category] FROM [Job Code Pre Appointment Documents], [Pre Appointment Documents], [Pre Appointment Document Categories]

Qry Job Codes and Telephone Interview Question Categories List

Type: Select

SELECT [Telephone Interview Question Categories].[Sort Order], [Job Code Telephone Interview Questions].[Job ID], [Telephone Interview Questions].[TI Question Category ID], [Telephone Interview Question Categories].[Telephone Interview Question Category FROM [Job Code Telephone Interview Questions], [Telephone Interview Questions], [Telephone Interview Question Categories]

Qry Job Codes and Training Module and Session Types List

Type: Select

-- Unable to parse query definition

Qry Job Codes and Training Module Types List

Type: Select

SELECT [Training Types].[Training Type], [Job Code Training Modules].[Training Type ID], [Job Code Training Modules].[Job ID] FROM [Job Code Training Modules], [Training Types]

Qry MeGRAPH Exception

Type: Select

SELECT Companies.[Company ID], Companies.[Company Name], [Organisational Codes].[Organisational Unit], [People].[First Name] & \, [People_1].[First Name] & \ FROM [People], [People], [People MeGRAPH Scores], [Applications], [Positions], [Companies], [Organisational Codes] WHERE (((Companies.[Company ID])=Forms![Frm Reports Company Dialog]![Company ID]) And 

Qry MeGRAPH

Type: Select

SELECT [Organisational Codes].[Organisational Unit], [Pay Points].[Pay Point], [First Name] & \, [People MeGRAPH Scores].[Date Captured], [People MeGRAPH Scores].Quarter, [People MeGRAPH Scores].[Quarter Year], [People MeGRAPH Scores].[Me Score], [People MeGRAPH Scores].[G Score], [People MeGRAPH Scores].[R Score], [People MeGRAPH Scores].[A Score], [People MeGRAPH Scores].[P Score], [People MeGRAPH Scores].[H Score], [Pay Points].[Pay Point ID] FROM [Organisational Codes], [Positions], [People MeGRAPH Scores], [People], [Applications], [Pay Points]

Qry Merge Duplicate People Source

Type: Select

SELECT [Qry Find Dulicate People for Merge].[First Name], [Qry Find Dulicate People for Merge].[Last Name], [Qry Find Dulicate People for Merge].[ID Number], Applications.[People ID], Applications.[Application ID], [Application Status].[Application Status], [Position Status].[Position Status], [Job Codes].Job FROM [Qry Find Dulicate People for Merge], [Applications], [Positions], [Job Codes], [Application Status], [Position Status]

Qry New Starts

Type: Select

SELECT Companies.[Company Name], [Organisational Codes].[Organisational Unit], [People].[First Name] & \, [Application Status].[Application Status], [Position Status].[Position Status], Positions.[Start Date], [Pay Points].[Pay Point], [People_1].[First Name] & \ FROM [People], [Positions], [Position Status], [People], [Applications], [Pay Points], [Companies], [Organisational Codes], [Application Status] WHERE (((Companies.[Company ID])=Forms![Frm Reports New Starts Dialog]![Company ID]) A

Qry Onboarding Application List

Type: Select

SELECT vwRubyPreOnboardingApplicationList.[Position Status ID], vwRubyPreOnboardingApplicationList.[Application ID], vwRubyPreOnboardingApplicationList.[Position ID], vwRubyPreOnboardingApplicationList.[People ID], vwRubyPreOnboardingApplicationList.[Job ID], vwRubyPreOnboardingApplicationList.[Application Status ID], vwRubyPreOnboardingApplicationList.Applicant, vwRubyPreOnboardingApplicationList.[Application Date], Int(DateDiff(\, vwRubyPreOnboardingApplicationList.Job, vwRubyPreOnboardingApplicationList.[Reporting To] FROM [vwRubyPreOnboardingApplicationList] WHERE (((vwRubyPreOnboardingApplicationList.[Position Status ID])=3))

Qry Open Position Applicant List

Type: Select

SELECT vwRubyPreOpenPositionApplicantList.[Position ID], vwRubyPreOpenPositionApplicantList.[Job ID], vwRubyPreOpenPositionApplicantList.[Which Dashboard], vwRubyPreOpenPositionApplicantList.Job, vwRubyPreOpenPositionApplicantList.[Org Unit], vwRubyPreOpenPositionApplicantList.[Pay Point], vwRubyPreOpenPositionApplicantList.[Position Status ID], vwRubyPreOpenPositionApplicantList.[Position Status], vwRubyPreOpenPositionApplicantList.[Reporting To], vwRubyPreOpenPositionApplicantList.Applicant, vwRubyPreOpenPositionApplicantList.[Company Name], vwRubyPreOpenPositionApplicantList.[Job Profile File Name] FROM [vwRubyPreOpenPositionApplicantList]

Qry Open Position List

Type: Select

SELECT vwRubyPreOpenPositionList.[Position ID], vwRubyPreOpenPositionList.[Job ID], vwRubyPreOpenPositionList.[Which Dashboard], vwRubyPreOpenPositionList.Job, vwRubyPreOpenPositionList.[Org Unit], vwRubyPreOpenPositionList.[Pay Point], vwRubyPreOpenPositionList.[Position Status ID], vwRubyPreOpenPositionList.[Position Status], vwRubyPreOpenPositionList.[Reporting To], vwRubyPreOpenPositionList.[Company Name], vwRubyPreOpenPositionList.[Job Profile File Name] FROM [vwRubyPreOpenPositionList]

Qry Past Application List

Type: Select

SELECT Applications.[People ID], Applications.[Application ID], [Job Codes].Job, Applications.[Application Date], [Application Status].[Application Status], IIf(IsNull([Date Blacklisted]) Or [Date Blacklisted]=\ FROM [People], [Applications], [Application Status], [Positions], [Position Status], [Job Codes]

Qry People Admin Information List

Type: Select

SELECT [People Admin Information].[People Admin Information ID], [People Admin Information].[People ID], [People Admin Information].[Date Captured], [People Admin Information].[Admin Item], [People Admin Information].Notes, [People Admin Information].Duration, [People Admin Information].[Captured By], IIf([Completed]=1,\ FROM [People Admin Information]

Qry People Considerations List

Type: Select

SELECT People.[People ID], [Last Name] & \, [Application Considerations].[Job ID] FROM [People], [Applications], [Application Considerations]

Qry People Disciplinary Grievance Process List

Type: Select

SELECT [People Disciplinary Grievance Process].[People Disciplinary Grievance Process I, [People Disciplinary Grievance Process].[People ID], [People Disciplinary Grievance Process].[Date Captured], [People Disciplinary Grievance Process].[Captured By], [People Disciplinary Grievance Process].[Reason Provided], [People Disciplinary Grievance Process].[Lodged Against], [People Disciplinary Grievance Process].[Record of Steps Taken], [People Disciplinary Grievance Process].[Record of Consultation Dates], [People Disciplinary Grievance Process].Outcome FROM [People Disciplinary Grievance Process]

Qry People Disciplinary Hearing Process List

Type: Select

SELECT [People Disciplinary Hearing Process].[People Disciplinary Hearing Process ID], [People Disciplinary Hearing Process].[People ID], [People Disciplinary Hearing Process].[Date Captured], [People Disciplinary Hearing Process].[Captured By], [People Disciplinary Hearing Process].Charges, [People Disciplinary Hearing Process].[Hearing Date], [People Disciplinary Hearing Process].Chairperson, [People Disciplinary Hearing Process].Outcome, [People Disciplinary Hearing Process].Notes FROM [People Disciplinary Hearing Process]

Qry People Disciplinary Investigation Process List

Type: Select

SELECT [People Disciplinary Investigation Process].[People Disciplinary Investigation P, [People Disciplinary Investigation Process].[People ID], [People Disciplinary Investigation Process].[Date Started], [People Disciplinary Investigation Process].[Started By], [People Disciplinary Investigation Process].Reason, [People Disciplinary Investigation Process].Notes, [People Disciplinary Investigation Process].[Date Closed], [People Disciplinary Investigation Process].Result FROM [People Disciplinary Investigation Process]

Qry People Disciplinary Warning Letter List

Type: Select

SELECT [People Disciplinary Warning Letters].[People Disciplinary Warning Letter ID], [People Disciplinary Warning Letters].[People ID], [People Disciplinary Warning Letters].[Date Issued], [People Disciplinary Warning Letters].[Issued By], [People Disciplinary Warning Letters].Reason, [People Disciplinary Warning Letters].[Warning Level], [People Disciplinary Warning Letters].Validity, [People Disciplinary Warning Letters].[Expiry Date] FROM [People Disciplinary Warning Letters]

Qry People Enrichment Training List

Type: Select

-- Unable to parse query definition

Qry People List

Type: Select

SELECT People.[People ID], [Last Name] & \ FROM [People]

Qry People Payroll Information List

Type: Select

SELECT [People Payroll Information].[People Payroll Information ID], [People Payroll Information].[People ID], [People Payroll Information].[Date Captured], [People Payroll Information].[Payroll Item], [Payroll Period Month] & \, [People Payroll Information].Notes, IIf([Actioned]=1,\ FROM [People Payroll Information]

Qry People Poor Performance Meetings

Type: Select

-- Unable to parse query definition

Qry People Qualifications List

Type: Select

SELECT [People Qualifications and Certifications].[People Qualification ID], [People Qualifications and Certifications].[People ID], [People Qualifications and Certifications].Qualification, [People Qualifications and Certifications].[Date Obtained], [People Qualifications and Certifications].Institution, [People Qualifications and Certifications].[Qualification Cost], IIf([Own or Company]=1,\, [People Qualifications and Certifications].[Expiry Date] FROM [People Qualifications and Certifications]

Qry People Training Module and Session List

Type: Select

-- Unable to parse query definition

Qry People Training Module List

Type: Select

SELECT [People Training Modules].[People Training Module ID], [People Training Modules].[People ID], [Job Code Training Modules].[Training Type ID], [Job Codes].Job, [Training Types].[Training Type], [Training Courses].Course, [Training Modules].Module, [People Training Modules].[Training Version], [People Training Modules].[Date Scheduled], [People Training Modules].[Date Completed], [People Training Modules].[Quiz Score], [People Training Modules].[Assessment Score], [People Training Module Status].[People Training Module Status], [Training Types].[Training Type Detail] FROM [People Training Modules], [Job Code Training Modules], [Job Codes], [Training Courses], [Training Modules], [Training Types], [People Training Module Status]

Qry People Training Modules NOT in the List

Type: Select

SELECT [Job Code Training Modules].[Job Code Training Module ID], [Job Code Training Modules].[Job ID], [Training Types].[Training Type], [Training Courses].Course, [Training Modules].Module, [Training Modules].[Training Version], [Training Modules].Assessment, [Training Modules].Quiz, [Job Code Training Modules].[Sort Order] FROM [SubQry People Training Modules NOT in the List], [Job Code Training Modules], [Training Types], [Training Courses], [Training Modules] WHERE ((([Job Code Training Modules].[Job ID])=Forms![Frm People Training Information]

Qry People Training Session List

Type: Select

-- Unable to parse query definition

Qry People Training Sessions NOT in the List

Type: Select

SELECT [Job Code Training Sessions].[Job Code Training Session ID], [Job Code Training Sessions].[Job ID], [Training Types].[Training Type], [Training Courses].Course, [Training Sessions].Session, [Training Sessions].Quiz FROM [Training Courses], [Training Types], [Job Code Training Sessions], [Training Sessions], [SubQry People Training Sessions NOT in the List] WHERE ((([SubQry People Training Sessions NOT in the List].[Job Code Training Session 

Qry Probation Review

Type: Select

SELECT [Probation Interview Types].[Interview Type], [People Probabtion Interviews].[Interviewed By], [People Probabtion Interviews].[Interviewer Comments], [People Probabtion Interviews].[Actions to be Taken], [People Probabtion Interviews].[Perfromance Evaluation Score Reasons], [People Probabtion Interviews].[Perfromance Evaluation Score], [People].[First Name] & \, Positions.[Position Status ID], [People_1].[First Name] & \, [People Probabtion Interviews].[People ID], [Job Codes].Job FROM [People], [People Probabtion Interviews], [Probation Interview Types], [People], [Applications], [Positions], [Job Codes] WHERE (((Positions.[Position Status ID])=4) And (([People Probabtion Interviews].[Peop

Qry Qualifications

Type: Select

SELECT Companies.[Company Name], [Organisational Codes].[Organisational Unit], People.[First Name] & \, [People Qualifications and Certifications].Qualification, [People Qualifications and Certifications].[Date Obtained], [People Qualifications and Certifications].Institution, [People Qualifications and Certifications].[Qualification Cost], Positions.[Position Status ID], [Pay Points].[Pay Point] FROM [Companies], [Organisational Codes], [Positions], [People], [People Qualifications and Certifications], [Applications], [Pay Points]

Qry Report Application Onboarding Form

Type: Select

SELECT Applications.[Application ID], Applications.[People ID], [Pay Points].[Pay Point], [Qry Get Line Manager].[Line Manager], [Qry Get Line Manager].[Line Manager Email], People.[Last Modified By], DatabaseUsersRuby.Email, People.Title, [People].[First Name] & \, People.[Known As], People.[ID Number], People.[Birth Date], People.[Cell Number], People.[Internal Extension], People.[Private Email], People.Email, [Job Codes].Job, Positions.[Start Date], [Organisational Codes].[Organisational Unit], People.[Office Location], IIf([Access Control]=1,\, IIf([Desk]=1,\, IIf([Chair]=1,\, IIf([Filing Cabinet]=1,\, IIf([Bookshelf]=1,\, IIf([Access Control Tag]=1,\, IIf([Telephone - Designated Line]=1,\, IIf([Laptop Computer - Cable lock]=1,\, IIf([Desktop Computer]=1,\, IIf([Telephone - Printer - Scanner]=1,\, IIf([Remote Desktop REMS]=1,\, IIf([VPN Access]=1,\, IIf([Signature Loaded]=1,\, IIf([Email Address]=1,\, IIf([Microsoft 365 Package]=1,\ FROM [People], [Positions], [Applications], [Pay Points], [Organisational Codes], [DatabaseUsersRuby], [Job Codes], [Qry Get Line Manager] WHERE (((Applications.[People ID])=[Forms]![Frm Add and Edit Application Onboarding In

Qry Report Application Status Ratio

Type: Select

SELECT Positions.[Position ID], [Job Codes].Job, [Pay Points].[Pay Point], [Qry Count Total Applications by Position].[Total Applications], [Qry Count All Application Status by Position].[Application Status], [Qry Count All Application Status by Position].[Sort Order], [Qry Count All Application Status by Position].[Number of Applications], Round([Total Minutes Spent]/60,2) FROM [Positions], [Position Status], [Qry Count Total Applications by Position], [Job Codes], [Pay Points], [Qry Count All Application Status by Position], [Qry Sum Total Application Status Times by Position] WHERE (((Positions.[Position ID])=[Forms]![Frm Filled Position Report Dialog]![Positio

Qry Report Blacklisted Applicants

Type: Select

SELECT [Last Name] & \, People.[Date Blacklisted], People.[Reason Blacklisted], [Job Codes].Job, Applications.[Application Date], [Application Status].[Application Status] FROM [People], [Applications], [Positions], [Application Status], [Job Codes] WHERE (((People.[Date Blacklisted]) Is Not Null))

Qry Report Hired and Terminated Employee List

Type: Select

SELECT Positions.[Position ID], Positions.[Company ID], Positions.[Position Status ID], Applications.[Application Status ID], People.Gender, [Organisational Codes].[Organisational Unit], IIf([Position Status ID]=4,Int(DateDiff(\, People.[Group Join Date] FROM [Positions], [People], [Applications], [Organisational Codes] WHERE (((Positions.[Company ID])=Forms![Frm Reports Company Dialog]![Company ID]) And 

Qry Report Hired Employee List

Type: Select

SELECT Positions.[Position ID], Positions.[Company ID], Positions.[Position Status ID], Applications.[Application Status ID], Companies.[Company Name], [People].[Last Name] & \, People.[Employee Number], People.Gender, Positions.[Employment Status], People.Race, People.Citizenship, IIf([Management]=True,\, [Organisational Codes].[Organisational Unit], [Job Codes].Job, [Pay Points].[Pay Point], Int(DateDiff(\, Int(DateDiff(\, [People_1].[First Name] & \, People_1.[Employee Number] FROM [Positions], [Job Codes], [People], [Applications], [Pay Points], [Companies], [Organisational Codes], [People] WHERE (((Positions.[Company ID])=Forms![Frm Reports Company Dialog]![Company ID]) And 

Qry Report Job Code Pre Appointment Documents

Type: Select

SELECT [Job Codes].Job, [Job Code Pre Appointment Documents].[Job ID], [Pre Appointment Document Categories].[Pre Appointment Document Category], [Pre Appointment Document Categories].[Sort Order], [Pre Appointment Documents].[Pre Appointment Document], [Pre Appointment Documents].Source, [Pre Appointment Documents].Version, [Pre Appointment Documents].Quantity, [Pre Appointment Documents].[Sort Order] FROM [Job Codes], [Job Code Pre Appointment Documents], [Pre Appointment Documents], [Pre Appointment Document Categories]

Qry Report Number Applications by Job Code

Type: Select

SELECT [Job Codes].[Job ID], [Job Codes].Job, Count(Applications.[Application ID]) FROM [Applications], [Positions], [Job Codes] WHERE (((Applications.[Application Date])>=[Forms]![Frm Reports Date Dialog]![StartDat

Qry Report Onboarding Form

Type: Select

SELECT Applications.[Application ID], Applications.[People ID], [Pay Points].[Pay Point], [Qry Get Line Manager].[Line Manager], [Qry Get Line Manager].[Line Manager Email], People.[Last Modified By], DatabaseUsersRuby.Email, People.Title, [People].[First Name] & \, People.[Known As], People.[ID Number], People.[Birth Date], People.[Cell Number], People.[Internal Extension], People.[Private Email], People.Email, [Job Codes].Job, Positions.[Start Date], [Organisational Codes].[Organisational Unit], People.[Office Location], IIf([Access Control]=1,\, IIf([Desk]=1,\, IIf([Chair]=1,\, IIf([Filing Cabinet]=1,\, IIf([Bookshelf]=1,\, IIf([Access Control Tag]=1,\, IIf([Telephone - Designated Line]=1,\, IIf([Laptop Computer - Cable lock]=1,\, IIf([Desktop Computer]=1,\, IIf([Telephone - Printer - Scanner]=1,\, IIf([Remote Desktop REMS]=1,\, IIf([VPN Access]=1,\, IIf([Signature Loaded]=1,\, IIf([Email Address]=1,\, IIf([Microsoft 365 Package]=1,\ FROM [People], [Positions], [Applications], [Pay Points], [Organisational Codes], [DatabaseUsersRuby], [Job Codes], [Qry Get Line Manager] WHERE (((Applications.[People ID])=[Forms]![Frm Add and Edit Onboarding Information]![

Qry Report Opal Calculate Percentage by Gender

Type: Select

SELECT [Qry Report Opal Count Hired Employees by Gender].Gender, [Qry Report Opal Count Hired Employees by Gender].[Gender Number], [Gender Number]/[Total Employees] FROM [Qry Report Opal Count Hired Employees by Gender], [Qry Report Opal Count Total Hired Employees]

Qry Report Opal Calculate Percentage by Management Race

Type: Select

SELECT [Qry Report Opal Count Hired Employees by Management Race].[Is Management], [Qry Report Opal Count Hired Employees by Management Race].Race, [Qry Report Opal Count Hired Employees by Management Race].[Management Race Numb, [Management Race Number]/[Total Employees] FROM [Qry Report Opal Count Hired Employees by Management Race], [Qry Report Opal Count Total Hired Employees]

Qry Report Opal Calculate Percentage by Manager

Type: Select

SELECT [Qry Report Opal Count Hired Employees by Manager].[Reporting To], [Qry Report Opal Count Hired Employees by Manager].[Manager Number], [Manager Number]/[Total Employees] FROM [Qry Report Opal Count Hired Employees by Manager], [Qry Report Opal Count Total Hired Employees]

Qry Report Opal Calculate Percentage by Org Unit

Type: Select

SELECT [Qry Report Opal Count Hired Employees by Org Unit].[Organisational Unit], [Qry Report Opal Count Hired Employees by Org Unit].[Org Unit Number], [Org Unit Number]/[Total Employees] FROM [Qry Report Opal Count Hired Employees by Org Unit], [Qry Report Opal Count Total Hired Employees]

Qry Report Opal Calculate Percentage by Pay Point

Type: Select

SELECT [Qry Report Opal Count Hired Employees by Pay Point].[Pay Point], [Qry Report Opal Count Hired Employees by Pay Point].[Pay Point Number], [Pay Point Number]/[Total Employees] FROM [Qry Report Opal Count Hired Employees by Pay Point], [Qry Report Opal Count Total Hired Employees]

Qry Report Opal Calculate Percentage by Race Gender

Type: Select

SELECT [Qry Report Opal Count Hired Employees by Race Gender].Race, [Qry Report Opal Count Hired Employees by Race Gender].Gender, [Qry Report Opal Count Hired Employees by Race Gender].[Race Gender Number], [Race Gender Number]/[Total Employees] FROM [Qry Report Opal Count Hired Employees by Race Gender], [Qry Report Opal Count Total Hired Employees]

Qry Report Opal Calculate Percentage by Race

Type: Select

SELECT [Qry Report Opal Count Hired Employees by Race].Race, [Qry Report Opal Count Hired Employees by Race].[Race Number], [Race Number]/[Total Employees] FROM [Qry Report Opal Count Hired Employees by Race], [Qry Report Opal Count Total Hired Employees]

Qry Report Opal Calculate Tenure by Gender

Type: Select

SELECT [Qry Report Opal Sum Length of Service by Gender].Gender, [Gender Total Tenure]/[Gender Number] FROM [Qry Report Opal Sum Length of Service by Gender], [Qry Report Opal Count Hired and Terminated Employees by Gender]

Qry Report Opal Calculate Tenure by Org Unit

Type: Select

SELECT [Qry Report Opal Sum Length of Service by Org Unit].[Organisational Unit], [Org Unit Total Tenure]/[Org Unit Number] FROM [Qry Report Opal Sum Length of Service by Org Unit], [Qry Report Opal Count Hired and Terminated Employees by Org Unit]

Qry Report Opal Count Hired and Terminated Employees by Gender

Type: Select

SELECT [Qry Report Hired and Terminated Employee List].[Company ID], [Qry Report Hired and Terminated Employee List].Gender, Count([Qry Report Hired and Terminated Employee List].[Position Status ID]) FROM [Qry Report Hired and Terminated Employee List]

Qry Report Opal Count Hired and Terminated Employees by Org Unit

Type: Select

SELECT [Qry Report Hired and Terminated Employee List].[Company ID], [Qry Report Hired and Terminated Employee List].[Organisational Unit], Count([Qry Report Hired and Terminated Employee List].[Position Status ID]) FROM [Qry Report Hired and Terminated Employee List]

Qry Report Opal Count Hired Employees by Employment Status

Type: Select

SELECT [Qry Report Hired Employee List].[Company ID], [Qry Report Hired Employee List].[Employment Status], Count([Qry Report Hired Employee List].[Position Status ID]) FROM [Qry Report Hired Employee List]

Qry Report Opal Count Hired Employees by Gender

Type: Select

SELECT [Qry Report Hired Employee List].[Company ID], [Qry Report Hired Employee List].Gender, Count([Qry Report Hired Employee List].[Position Status ID]) FROM [Qry Report Hired Employee List]

Qry Report Opal Count Hired Employees by Management Race

Type: Select

SELECT [Qry Report Hired Employee List].[Company ID], [Qry Report Hired Employee List].[Is Management], [Qry Report Hired Employee List].Race, Count([Qry Report Hired Employee List].[Position Status ID]) FROM [Qry Report Hired Employee List]

Qry Report Opal Count Hired Employees by Manager

Type: Select

SELECT [Qry Report Hired Employee List].[Company ID], [Qry Report Hired Employee List].[Reporting To], Count([Qry Report Hired Employee List].[Position Status ID]) FROM [Qry Report Hired Employee List]

Qry Report Opal Count Hired Employees by Org Unit

Type: Select

SELECT [Qry Report Hired Employee List].[Company ID], [Qry Report Hired Employee List].[Organisational Unit], Count([Qry Report Hired Employee List].[Position Status ID]) FROM [Qry Report Hired Employee List]

Qry Report Opal Count Hired Employees by Pay Point

Type: Select

SELECT [Qry Report Hired Employee List].[Company ID], [Qry Report Hired Employee List].[Pay Point], Count([Qry Report Hired Employee List].[Position Status ID]) FROM [Qry Report Hired Employee List]

Qry Report Opal Count Hired Employees by Race Gender

Type: Select

SELECT [Qry Report Hired Employee List].[Company ID], [Qry Report Hired Employee List].Race, [Qry Report Hired Employee List].Gender, Count([Qry Report Hired Employee List].[Position Status ID]) FROM [Qry Report Hired Employee List]

Qry Report Opal Count Hired Employees by Race

Type: Select

SELECT [Qry Report Hired Employee List].[Company ID], [Qry Report Hired Employee List].Race, Count([Qry Report Hired Employee List].[Position Status ID]) FROM [Qry Report Hired Employee List]

Qry Report Opal Count Total Hired Employees

Type: Select

SELECT Count([Qry Report Hired Employee List].[Position Status ID]) FROM [Qry Report Hired Employee List]

Qry Report Opal Sum Length of Service by Gender

Type: Select

SELECT [Qry Report Hired and Terminated Employee List].[Company ID], [Qry Report Hired and Terminated Employee List].Gender, Sum([Qry Report Hired and Terminated Employee List].[Length of Service]) FROM [Qry Report Hired and Terminated Employee List]

Qry Report Opal Sum Length of Service by Org Unit

Type: Select

SELECT [Qry Report Hired and Terminated Employee List].[Company ID], [Qry Report Hired and Terminated Employee List].[Organisational Unit], Sum([Qry Report Hired and Terminated Employee List].[Length of Service]) FROM [Qry Report Hired and Terminated Employee List]

Qry Report Regretted CV Not Suitable Info by Position

Type: Select

SELECT Positions.[Position Effective Date], [Job Codes].Job, [Pay Points].[Pay Point], [Position Status].[Position Status], IIf(IsNull([Total Applications]),0,[Total Applications]), IIf(IsNull([Number Regretted]),0,[Number Regretted]), IIf(IsNull([Number CV Not Suitable]),0,[Number CV Not Suitable]), IIf([Tot App]=0,0,[# Regretted]/[Tot App]), IIf([Tot App]=0,0,[# CV Not Suitable]/[Tot App]) FROM [Positions], [Job Codes], [Pay Points], [Qry Count Total Applications by Position], [Qry Count Number CV Not Suitable by Position], [Qry Count Number Regretted by Position], [Position Status] WHERE (((Positions.[Position Effective Date])>=[Forms]![Frm Reports Date Dialog]![Star

Qry Report Team Activity Detail

Type: Select

SELECT vwRubyPreReportTeamActivityDetail.[Date Status Changed], vwRubyPreReportTeamActivityDetail.[Status Modified By], vwRubyPreReportTeamActivityDetail.Job, vwRubyPreReportTeamActivityDetail.[Pay Point], vwRubyPreReportTeamActivityDetail.[Position Effective Date], vwRubyPreReportTeamActivityDetail.Applicant, vwRubyPreReportTeamActivityDetail.[Application Status], vwRubyPreReportTeamActivityDetail.[Sort Order], vwRubyPreReportTeamActivityDetail.[Application Status History ID], vwRubyPreReportTeamActivityDetail.[Time Unit] FROM [vwRubyPreReportTeamActivityDetail] WHERE (((vwRubyPreReportTeamActivityDetail.[Date Status Changed])>=[Forms]![Frm Team A

Qry Report Team Activity Summary

Type: Select

SELECT [Qry Report Team Activity Detail].[Status Modified By], [Qry Report Team Activity Detail].Job, [Qry Report Team Activity Detail].[Pay Point], [Qry Report Team Activity Detail].[Position Effective Date], [Qry Report Team Activity Detail].[Application Status], [Qry Report Team Activity Detail].[Sort Order], Count([Qry Report Team Activity Detail].[Application Status History ID]), Sum([Qry Report Team Activity Detail].[Time Unit]) FROM [Qry Report Team Activity Detail]

Qry Report Team Activity Super Summary

Type: Select

SELECT [Qry Report Team Activity Detail].[Application Status], [Qry Report Team Activity Detail].[Sort Order], Count([Qry Report Team Activity Detail].[Application Status History ID]), Sum([Qry Report Team Activity Detail].[Time Unit]) FROM [Qry Report Team Activity Detail]

Qry Report Team Activity Time Summary

Type: Select

SELECT [Qry Report Team Activity Detail].[Status Modified By], [Qry Report Team Activity Detail].[Application Status], [Qry Report Team Activity Detail].[Sort Order], Count([Qry Report Team Activity Detail].[Application Status History ID]), Sum([Qry Report Team Activity Detail].[Time Unit]) FROM [Qry Report Team Activity Detail]

Qry Report Telephone Interview Question Responses

Type: Select

SELECT [Application Telephone Interview Question Responses].[Application ID], [Telephone Interview Questions].[Do Not Print This Question], [Job Codes].Job, [People].[First Name] & \, People.[Cell Number], [Qry Get Reporting To Name and Job].[Reporting To Job], Applications.[Telephone Interviewer], Applications.[Telephone Interview Date], [Telephone Interview Question Categories].[Telephone Interview Question Category, [Telephone Interview Question Categories].[Sort Order], [Telephone Interview Questions].[Telephone Interview Question], [Telephone Interview Questions].[Telephone Interview Question Detail], [Telephone Interview Questions].[Sort Order], [Application Telephone Interview Question Responses].[Telephone Interview Respon FROM [Application Telephone Interview Question Responses], [Applications], [People], [Positions], [Job Codes], [Telephone Interview Questions], [Telephone Interview Question Categories], [Qry Get Reporting To Name and Job] WHERE ((([Telephone Interview Questions].[Do Not Print This Question])=No))

Qry SubFrm People Training Module Summary

Type: Select

SELECT [Qry Count Training Modules One Job Code].[Total Training Modules per Job], IIf(IsNull([Number Scheduled]),0,[Number Scheduled]), IIf(IsNull([Total Training Modules per Job]),0,IIf(IsNull([Number Scheduled]),0,, IIf(IsNull([Number Completed]),0,[Number Completed]), IIf(IsNull([Number Scheduled]),0,IIf(IsNull([Number Completed]),0,IIf([Number Sc, IIf(IsNull([Number Quizes]),0,IIf(IsNull([Total Quiz Score]),0,[Total Quiz Score, IIf(IsNull([Number Assessments]),0,IIf(IsNull([Total Assessment Score]),0,[Total FROM [Qry Count Scheduled and Completed Training Modules One Emp], [Qry Count Training Modules One Job Code]

Qry SubRpt Executive Daily Summary Applications Recruit by Stage

Type: Select

SELECT [Application Stages].[Stage Number], [Application Stages].[Application Stage], Count(Applications.[Application ID]) FROM [Applications], [Application Status], [Application Stages], [Positions] WHERE (((Positions.[Position Status ID])=3))

Qry SubRpt Executive Daily Summary New Applications by Position

Type: Select

SELECT [Job Codes].Job, [Organisational Codes].[Organisational Unit], Count(Applications.[Application ID]) FROM [Applications], [Positions], [Job Codes], [Organisational Codes] WHERE (((Applications.[Application Date])=[Forms]![Frm Reports Single Date Dialog]![St

Qry SubRpt Executive Daily Summary New Applications

Type: Select

SELECT Count(Applications.[Application ID]) FROM [Applications] WHERE (((Applications.[Application Date])=[Forms]![Frm Reports Single Date Dialog]![St

Qry SubRpt Executive Daily Summary Status Changes Recruit by Pos

Type: Select

SELECT [Job Codes].Job, [Organisational Codes].[Organisational Unit], Count([Application Status History].[Application Status History ID]) FROM [Applications], [Positions], [Job Codes], [Organisational Codes], [Application Status History] WHERE (((Positions.[Position Status ID])=3))

Qry SubRpt Executive Daily Summary Status Prev Day by Pos

Type: Select

SELECT [Job Codes].Job, [Organisational Codes].[Organisational Unit], Count([Application Status History].[Application Status History ID]) FROM [Applications], [Positions], [Job Codes], [Organisational Codes], [Application Status History] WHERE ((([Application Status History].[Date Status Changed])=[Forms]![Frm Reports Sing

Qry SubRpt Executive Daily Summary Tot Apps Recruit by Position

Type: Select

SELECT [Job Codes].Job, [Organisational Codes].[Organisational Unit], Count(Applications.[Application ID]) FROM [Applications], [Positions], [Job Codes], [Organisational Codes] WHERE (((Positions.[Position Status ID])=3))

Qry SubRpt How Heard Statistics Hired

Type: Select

SELECT [SubQry Rpt How Heard Statistics Count Hired by How Heard].[How Heard About Posi, [SubQry Rpt How Heard Statistics Count Hired by How Heard].[Number Hired], [SubQry Rpt How Heard Statistics Count Hired].[Total Hired], [Number Hired]/[Total Hired] FROM [SubQry Rpt How Heard Statistics Count Hired], [SubQry Rpt How Heard Statistics Count Hired by How Heard]

Qry SubRpt How Heard Statistics Regret CV

Type: Select

SELECT [SubQry Rpt How Heard Statistics Count Regret CV by How Heard].[How Heard About , [SubQry Rpt How Heard Statistics Count Regret CV by How Heard].[Number Regret CV, [SubQry Rpt How Heard Statistics Count Regret CV].[Total Regret CV], [Number Regret CV]/[Total Regret CV] FROM [SubQry Rpt How Heard Statistics Count Regret CV], [SubQry Rpt How Heard Statistics Count Regret CV by How Heard]

Qry Sum Total Application Status Times by Position

Type: Select

SELECT Applications.[Position ID], Sum([Application Status].[Time Unit]) FROM [Applications], [Application Status]

Qry Time To Fill

Type: Select

SELECT Companies.[Company Name], [Organisational Codes].[Organisational Unit], [People].[First Name] & \, [Job Codes].Job, [Position Status].[Position Status], Positions.[Position Effective Date], Positions.[Start Date], Positions.[Termination Date], DateDiff(\, [Pay Points].[Pay Point], [People_1].[First Name] & \, [Pay Points].[Pay Point], Positions.[Position Status ID], Applications.[Application Status ID] FROM [People], [Positions], [Position Status], [People], [Applications], [Pay Points], [Companies], [Organisational Codes], [Job Codes] WHERE (((Positions.[Start Date])>=Forms![Frm Reports Time To Fill Dialog]![Start Date]

Qry Warnings

Type: Select

SELECT Companies.[Company Name], People.[First Name] & \, [People Disciplinary Warning Letters].[Date Issued], [People Disciplinary Warning Letters].[Issued By], [People Disciplinary Warning Letters].Reason, [People Disciplinary Warning Letters].[Warning Level], [People Disciplinary Warning Letters].Validity, [People Disciplinary Warning Letters].[Expiry Date] FROM [Companies], [Positions], [People], [People Disciplinary Warning Letters], [Applications] WHERE (((Companies.[Company ID])=[Forms]![Frm Reports Company Dialog]![Company ID]))

qryLinkODBC

Type: Select

-- Unable to parse query definition

SubQry Duplicate People

Type: Select

SELECT People.[First Name], People.[Last Name], People.[Cell Number], People.[People ID], People.[Birth Date], People.[ID Number] FROM [People] WHERE (((People.[First Name]) In (SELECT [First Name] FROM [People] As Tmp GROUP BY [F

SubQry Job Code Application Step NOT in List

Type: Select

SELECT [Job Code Application Steps].[Job Code Application Step ID], [Job Code Application Steps].[Job ID], [Job Code Application Steps].[Application Status ID], [Application Status].[Application Status], [Application Status].[Sort Order], [Application Status].Active FROM [Job Code Application Steps], [Application Status] WHERE ((([Job Code Application Steps].[Job ID])=[Forms]![Frm Configure Job Application

SubQry Job Code Pre Appointment Documents NOT in the List

Type: Select

SELECT [Job Code Pre Appointment Documents].[Job Code Pre Appointment Document ID], [Job Code Pre Appointment Documents].[Job ID], [Job Code Pre Appointment Documents].[Pre Appointment Document ID] FROM [Job Code Pre Appointment Documents] WHERE ((([Job Code Pre Appointment Documents].[Job ID])=[Forms]![Frm View Job Code Pre

SubQry Job Code Regret Reasons NOT in List

Type: Select

SELECT [Job Code Regret Reasons].[Job Code Regret Reason ID], [Job Code Regret Reasons].[Job ID], [Job Code Regret Reasons].[Regret Reason ID], [Regret Reasons].[Regret Reason], [Regret Reasons].[Sort Order], [Regret Reasons].Active FROM [Job Code Regret Reasons], [Regret Reasons] WHERE ((([Job Code Regret Reasons].[Job ID])=[Forms]![Frm Configure Job Regret Reasons

SubQry Job Code Telephone Interview Questions NOT in the List

Type: Select

SELECT [Job Code Telephone Interview Questions].[Job Code Telephone Interview Question , [Job Code Telephone Interview Questions].[Job ID], [Job Code Telephone Interview Questions].[Telephone Interview Question ID] FROM [Job Code Telephone Interview Questions] WHERE ((([Job Code Telephone Interview Questions].[Job ID])=[Forms]![Frm View Job Code

SubQry Job Code Training Modules NOT in the List

Type: Select

SELECT [Job Code Training Modules].[Job Code Training Module ID], [Job Code Training Modules].[Job ID], [Job Code Training Modules].[Training Module ID], [Job Code Training Modules].[Sort Order] FROM [Job Code Training Modules] WHERE ((([Job Code Training Modules].[Job ID])=[Forms]![Frm View Job Code Training Mod

SubQry Job Code Training Sessions NOT in the List

Type: Select

SELECT [Job Code Training Sessions].[Job Code Training Session ID], [Job Code Training Sessions].[Job ID], [Job Code Training Sessions].[Training Session ID] FROM [Job Code Training Sessions] WHERE ((([Job Code Training Sessions].[Job ID])=[Forms]![Frm View Job Code Training Mo

SubQry Job Codes and Training Module Types List

Type: Select

SELECT [Training Types].[Training Type], [Job Code Training Modules].[Training Type ID], [Job Code Training Modules].[Job ID] FROM [Job Code Training Modules], [Training Types]

SubQry Job Codes and Training Session Types List

Type: Select

SELECT [Training Types].[Training Type], [Job Code Training Sessions].[Training Type ID], [Job Code Training Sessions].[Job ID] FROM [Training Types], [Job Code Training Sessions]

SubQry People Job Training Summary Modules

Type: Select

SELECT [Job Code Training Modules].[Job ID], [Job Code Training Modules].[Training Module ID], [People Training Modules].[Date Scheduled], [People Training Modules].[Date Completed], [People Training Modules].[Quiz Score], [People Training Modules].[Assessment Score] FROM [Job Code Training Modules], [People Training Modules] WHERE ((([Job Code Training Modules].[Job ID])=[Forms]![Frm People Training Informatio

SubQry People Training Modules NOT in the List

Type: Select

SELECT [People Training Modules].[People Training Module ID], [People Training Modules].[People ID], [People Training Modules].[Job Code Training Module ID] FROM [People Training Modules] WHERE ((([People Training Modules].[People ID])=[Forms]![Frm People Training Informati

SubQry People Training Sessions NOT in the List

Type: Select

SELECT [People Training Sessions].[People Training Session ID], [People Training Sessions].[People ID], [People Training Sessions].[Job Code Training Session ID] FROM [People Training Sessions] WHERE ((([People Training Sessions].[People ID])=[Forms]![Frm People Training Informat

SubQry Rpt How Heard Statistics Count Hired by How Heard

Type: Select

SELECT [SubQry Rpt How Heard Statistics Criteria].[How Heard About Position], Count([SubQry Rpt How Heard Statistics Criteria].[Application ID]) FROM [SubQry Rpt How Heard Statistics Criteria] WHERE ((([SubQry Rpt How Heard Statistics Criteria].[Application Status ID])=27))

SubQry Rpt How Heard Statistics Count Hired

Type: Select

SELECT Count([SubQry Rpt How Heard Statistics Criteria].[Application ID]) FROM [SubQry Rpt How Heard Statistics Criteria] WHERE ((([SubQry Rpt How Heard Statistics Criteria].[Application Status ID])=27))

SubQry Rpt How Heard Statistics Count Regret CV by How Heard

Type: Select

SELECT [SubQry Rpt How Heard Statistics Criteria].[How Heard About Position], Count([SubQry Rpt How Heard Statistics Criteria].[Application ID]) FROM [SubQry Rpt How Heard Statistics Criteria] WHERE ((([SubQry Rpt How Heard Statistics Criteria].[Application Status ID])=30 Or ([S

SubQry Rpt How Heard Statistics Count Regret CV

Type: Select

SELECT Count([SubQry Rpt How Heard Statistics Criteria].[Application ID]) FROM [SubQry Rpt How Heard Statistics Criteria] WHERE ((([SubQry Rpt How Heard Statistics Criteria].[Application Status ID])=30 Or ([S

SubQry Rpt How Heard Statistics Criteria

Type: Select

SELECT Positions.[Position Effective Date], Applications.[Application Status ID], Applications.[How Heard About Position], Applications.[Application ID] FROM [Positions], [Applications] WHERE (((Positions.[Position Effective Date])>=[Forms]![Frm Reports Date Dialog]![Star