ruby - Technical Architecture
Data Model
Tables (112)
Admin Item LkUp
Primary Key: Admin
Fields: - Admin Item ID: Long - Admin Item: Text - Admin Item Duration: Long
Application Assessments
Primary Key: Application
Fields: - Application Assessment ID: Long - Application ID: Long - Assessment Type ID: Long - Assessment Score: Double - SSMA_TimeStamp: Binary
Application Considerations - Edit
Primary Key: Not defined
Fields: - Application Consideration ID: Long - Application ID: Long - Job ID: Long - Delete It: Boolean
Application Considerations
Primary Key: Application
Fields: - Application Consideration ID: Long - Application ID: Long - Job ID: Long - SSMA_TimeStamp: Binary
Application Stages
Primary Key: Stage
Fields: - Stage Number: Long - Application Stage: Text
Application Status History
Primary Key: Application
Fields: - Application Status History ID: Long - Application ID: Long - Application Status ID: Long - Application Status Notes: Text - Assessment Type ID: Long - Assessment Score: Double - Date Status Changed: DateTime - Status Modified By: Text - SSMA_TimeStamp: Binary
Application Status
Primary Key: Application
Fields: - Application Status ID: Long - Application Status: Text - Stage Number: Long - Sort Order: Long - Default Step: Boolean - Assessment Step: Boolean - Report Point: Boolean - Time Unit: Long - Active: Boolean - SSMA_TimeStamp: Binary
Application Telephone Interview Question Responses
Primary Key: Application
Fields: - Application TI Question Response ID: Long - Application ID: Long - Telephone Interview Question ID: Long - Telephone Interview Response: Memo - SSMA_TimeStamp: Binary
Applications
Primary Key: Application
Fields: - Application ID: Long - Import ID: Long - People ID: Long - Position ID: Long - Application Status ID: Long - Application Status Notes: Text - Date Status Changed: DateTime - Last Modified By: Text - Application Date: DateTime - How Heard About Position: Text - Application Notes: Text - Regret Reason ID: Long - CV Not Suitable Reason ID: Long - Telephone Interviewer: Text - Telephone Interview Date: DateTime - SSMA_TimeStamp: Binary
Assessment Types
Primary Key: Assessment
Fields: - Assessment Type ID: Long - Assessment Type: Text
Badge
Primary Key: Badge
Fields: - Badge ID: Long - Badge: Text (PK)
Companies
Primary Key: Company
Fields: - Company ID: Long - Company Name: Text - Employee Number Prefix: Text - Employee Number Length: Long - Export Company to Enguage: Boolean - Company Trading Name: Text - Company Registration Number: Text - VAT Number: Text - PAYE Reference Number: Text - COIDA Reference Number: Text - UIF Reference Number: Text - UIF Telephone Number: Text - UIF Contact Person: Text - SDL Number: Text - Physical Address 1: Text - Physical Address 2: Text - Physical Suburb: Text - Physical City: Text - Physical Postal Code: Text - Physical Province: Text - Physical Country: Text - Postal Address 1: Text - Postal Address 2: Text - Postal City: Text - Postal Code: Text - Postal Province: Text - Postal Country: Text - Active: Boolean - SSMA_TimeStamp: Binary
CountryLookup
Primary Key: Country
Fields: - Country ID: Long - Country: Text (PK) - Country Code: Text - Active: Boolean - SSMA_TimeStamp: Binary
CV Not Suitable Reasons
Primary Key: CV
Fields: - CV Not Suitable Reason ID: Long - CV Not Suitable Reason: Text - Sort Order: Long - Active: Boolean - SSMA_TimeStamp: Binary
DatabaseUsersRuby
Primary Key: Username
Fields: - User ID: Long - Username: Text (PK) - User Password: Text - LEVEL: Text - ForceChange: Boolean - Delivery Location ID: Long - Department: Text - Role: Text - First Name: Text - Surname: Text - Email: Text - Last Modified By: Text - Date Modified: DateTime - SSMA_TimeStamp: Binary
EmailingListsLkUp
Primary Key: Emailing
Fields: - Emailing List ID: Long - Emailing List: Text
Employment Equity Job Categories
Primary Key: EE
Fields: - EE Job Category ID: Long - Employment Equity Job Category: Text
EmploymentStatusLkUp
Primary Key: Employment
Fields: - Employment Status ID: Long - Employment Status: Text
Feedback Elements
Primary Key: Feedback
Fields: - Feedback Element ID: Long - Feedback Element: Text
General Ruby
Primary Key: Front
Fields: - Front End Version Number: Text - Employee File Name: Text - Job List File Name: Text - Org Structure File Name: Text - PDF File Path: Text
Grievance Process Outcome LkUp
Primary Key: Grievance
Fields: - Grievance Process Outcome ID: Long - Grievance Process Outcome: Text
Hearing Process Outcome LkUp
Primary Key: Hearing
Fields: - Hearing Process Outcome ID: Long - Hearing Process Outcome: Text
HowHeardLkUp
Primary Key: How
Fields: - How Heard ID: Long - How Heard: Text
Investigation Process Result LkUp
Primary Key: Investigation
Fields: - Investigation Process Result ID: Long - Investigation Process Result: Text
Job Code Application Steps
Primary Key: Job
Fields: - Job Code Application Step ID: Long - Job ID: Long - Application Status ID: Long - SSMA_TimeStamp: Binary
Job Code Pre Appointment Documents
Primary Key: Job
Fields: - Job Code Pre Appointment Document ID: Long - Job ID: Long - Pre Appointment Document ID: Long - SSMA_TimeStamp: Binary
Job Code Regret Reasons
Primary Key: Job
Fields: - Job Code Regret Reason ID: Long - Job ID: Long - Regret Reason ID: Long - SSMA_TimeStamp: Binary
Job Code Telephone Interview Questions
Primary Key: Job
Fields: - Job Code Telephone Interview Question ID: Long - Job ID: Long - Telephone Interview Question ID: Long - SSMA_TimeStamp: Binary
Job Code Training Modules
Primary Key: Job
Fields: - Job Code Training Module ID: Long - Job ID: Long - Training Type ID: Long - Training Course ID: Long - Training Module ID: Long - SSMA_TimeStamp: Binary - Sort Order: Long
Job Code Training Sessions
Primary Key: Job
Fields: - Job Code Training Session ID: Long - Job ID: Long - Training Type ID: Long - Training Course ID: Long - Training Session ID: Long - SSMA_TimeStamp: Binary
Job Codes
Primary Key: Job
Fields: - Job ID: Long - Job: Text (PK) - Job Code: Text - DESCRIPTION: Memo - Management: Boolean - EE Job Category ID: Long - Job Profile File Name: Text - Active: Boolean - SSMA_TimeStamp: Binary
Key Performance Areas
Primary Key: Key
Fields: - Key Performance Area ID: Long - Key Performance Area: Text
MonthLkUp
Primary Key: Month
Fields: - Month Number: Long - Month Name: Text - Last Day: Integer
On Boarding Form Recipients
Primary Key: On
Fields: - On Boarding Recipient ID: Long - On Boarding Recipient Email: Text - On Boarding Recipient Type: Long
Organisational Codes
Primary Key: Organisational
Fields: - Organisational ID: Long - Organisational Code: Text - Organisational Unit: Text - Key Item: Text - Organisational Unit Description: Text - Organisational Unit Parent: Text - Active: Boolean - SSMA_TimeStamp: Binary
Pay Points
Primary Key: Pay
Fields: - Pay Point ID: Long - Pay Point: Text - Active: Boolean - SSMA_TimeStamp: Binary
Payroll Item LkUp
Primary Key: Payroll
Fields: - Payroll Item ID: Long - Payroll Item: Text
People Admin Information
Primary Key: People
Fields: - People Admin Information ID: Long - People ID: Long - Date Captured: DateTime - Admin Item: Text - Notes: Text - Duration: Long - Captured By: Text - Completed: Long - SSMA_TimeStamp: Binary
People Awards
Primary Key: People
Fields: - People Awards ID: Long - People ID: Long - Date Captured: DateTime - Quarter: Text - Quarter Year: Long - Award Name: Text - Forum: Text - Award Value: Double - Notes: Text - SSMA_TimeStamp: Binary
People Badges
Primary Key: People
Fields: - People Badge ID: Long - People ID: Long - Badge ID: Long - Date Assigned: DateTime
People Care Records
Primary Key: People
Fields: - People Care Record ID: Long - People ID: Long - Date Captured: DateTime - Quarter: Text - Quarter Year: Long - Care Received: Text - Number Sessions: Long - Care Value: Double - Notes: Text - SSMA_TimeStamp: Binary
People Disciplinary Grievance Process
Primary Key: People
Fields: - People Disciplinary Grievance Process ID: Long - People ID: Long - Date Captured: DateTime - Captured By: Text - Reason Provided: Text - Lodged Against: Text - Record of Steps Taken: Memo - Record of Consultation Dates: Memo - Outcome: Text - SSMA_TimeStamp: Binary
People Disciplinary Hearing Process
Primary Key: People
Fields: - People Disciplinary Hearing Process ID: Long - People ID: Long - Date Captured: DateTime - Captured By: Text - Charges: Text - Hearing Date: DateTime - Chairperson: Text - Outcome: Text - Notes: Text - SSMA_TimeStamp: Binary
People Disciplinary Investigation Process Evidence
Primary Key: People
Fields: - People Disciplinary Investigation Process Evidence ID: Long - People Disciplinary Investigation Process ID: Long - Evidence: Text - Evidence Location: Text - SSMA_TimeStamp: Binary
People Disciplinary Investigation Process
Primary Key: People
Fields: - People Disciplinary Investigation Process ID: Long - People ID: Long - Date Started: DateTime - Started By: Text - Reason: Text - Notes: Text - Date Closed: DateTime - Result: Text - SSMA_TimeStamp: Binary
People Disciplinary Warning Letters
Primary Key: People
Fields: - People Disciplinary Warning Letter ID: Long - People ID: Long - Date Issued: DateTime - Issued By: Text - Reason: Text - Warning Level: Text - Validity: Text - Expiry Date: DateTime - SSMA_TimeStamp: Binary
People Emailing Lists
Primary Key: People
Fields: - People Emailing List ID: Long - People ID: Long - Emailing List: Text - SSMA_TimeStamp: Binary
People Enrichment Training
Primary Key: People
Fields: - People Enrichment Training ID: Long - People ID: Long - Course Name: Text - Start Date: DateTime - End Date: DateTime - Internal or External: Long - Training Cost: Double - Facilitator: Text - SETA Accredited: Long - NQF Level: Text - SSMA_TimeStamp: Binary
People MeGRAPH Scores
Primary Key: People
Fields: - People MeGRAPH ID: Long - People ID: Long - Date Captured: DateTime - Quarter: Text - Quarter Year: Long - Me Score: Long - G Score: Long - R Score: Long - A Score: Long - P Score: Long - H Score: Long - SSMA_TimeStamp: Binary
People Payroll Information
Primary Key: People
Fields: - People Payroll Information ID: Long - People ID: Long - Date Captured: DateTime - Payroll Item: Text - Payroll Period Month: Text - Payroll Period Year: Long - Notes: Text - Actioned: Long - SSMA_TimeStamp: Binary
People Poor Performance Action Items
Primary Key: People
Fields: - People Poor Performance Action Item ID: Long - People ID: Long - Date Recorded: DateTime - Action: Text - Reason: Text - Responsible Person: Text - By When: Text - SSMA_TimeStamp: Binary
People Poor Performance Checkin
Primary Key: People
Fields: - People Poor Performance Checkin ID: Long - People ID: Long - Checkin Date: DateTime - Progress Since Last Session: Text - Raizcorpuscle Performance: Text - Problematic Elements: Text - What Has Gone Well: Text - SSMA_TimeStamp: Binary
People Poor Work Performance
Primary Key: People
Fields: - People Poor Work Performance ID: Long - People ID: Long - Meeting A Date: DateTime - Aspects of Poor Performance: Text - Standards of Work Performance: Text - Understand the Allegations: Long - Able to Maintain Standard Expected: Long - Coaching Assistance Provided: Boolean - Training Assistance Provided: Boolean - Proposed Meeting B Date: DateTime - Meeting B Date: DateTime - Meeting B Performanced Improved: Long - Meeting B No Further Action Required: Long - Monitoring Weeks: Long - Proposed Meeting C Date: DateTime - Meeting B Transferred To Another Position: Long - Meeting B Changes to Job Specification: Text - Meeting B Employees Comments: Text - Meeting C Date: DateTime - Meeting C Performanced Improved: Long - Meeting C No Further Action Required: Boolean - Meeting C Transfer to Another Position: Boolean - Meeting C Job Specfication To Be Changed: Boolean - Meeting C Change Reasons: Text - Meeting C Employees Comments: Text - Meeting C Outcome of Performance Review: Long - SSMA_TimeStamp: Binary
People Probabtion Interview Question Responses
Primary Key: People
Fields: - People Probation Interview Question Response ID: Long - People Probation Interview ID: Long - Probation Interview Question: Memo - Probation Interview Detail: Memo - Probation Interview Answer: Text - SSMA_TimeStamp: Binary
People Probabtion Interview Settling In Responses
Primary Key: People
Fields: - People Probation Interview Settling In ID: Long - People Probation Interview ID: Long - Probation Interview Settling In Question: Memo - Probation Interview Settling In Detail: Memo - Probation Interview Settling In Answer: Text - SSMA_TimeStamp: Binary
People Probabtion Interviews
Primary Key: People
Fields: - People Probation Interview ID: Long - People ID: Long - Interview Type ID: Long - Date Interviewed: DateTime - Interviewed By: Text - Interviewer Comments: Text - Actions to be Taken: Text - Perfromance Evaluation Score: Long - Perfromance Evaluation Score Reasons: Text - SSMA_TimeStamp: Binary
People Probation Interview Action Items
Primary Key: People
Fields: - People Probation Action Item ID: Long - People ID: Long - Date Recorded: DateTime - Action: Text - Reason: Text - Responsible Person: Text - By When: Text - SSMA_TimeStamp: Binary
People Qualifications and Certifications
Primary Key: People
Fields: - People Qualification ID: Long - People ID: Long - Qualification: Text - Date Obtained: DateTime - Institution: Text - Qualification Cost: Double - Own or Company: Long - Expiry Date: DateTime - SSMA_TimeStamp: Binary
People REMS Modules
Primary Key: People
Fields: - People REMS Modules ID: Long - People ID: Long - REMS Module: Text - SSMA_TimeStamp: Binary
People Share Drive Access
Primary Key: People
Fields: - People Share Drive Access ID: Long - People ID: Long - Share Drive Access: Text - SSMA_TimeStamp: Binary
People Three Plus One Feedback
Primary Key: People
Fields: - People Feedback ID: Long - People Three Plus One ID: Long - Feedback Element: Text - Positive Feedback: Text - Needs Work: Text - SSMA_TimeStamp: Binary
People Three Plus One ISP Contract
Primary Key: People
Fields: - People ISP Contract ID: Long - People Three Plus One ID: Long - Key Performance Area: Text - KPA Weighting: Double - Key Performance Indicator: Text - KPI Weighting: Double - KPI Score: Double - SSMA_TimeStamp: Binary
People Three Plus One KPI Measurement Criteria
Primary Key: People
Fields: - People KPI Measurement ID: Long - People Three Plus One ID: Long - Focus Area: Text - KPI: Text - Strategic Objective: Text - OpCo Member: Text - Measurement: Text - Annual Target: Text - Quarter Target: Text - Tolerance Level: Text - SSMA_TimeStamp: Binary
People Three Plus One
Primary Key: People
Fields: - People Three Plus One ID: Long - People ID: Long - Date of Review: DateTime - Reviewed By: Text - Measurement Period From: DateTime - Measurement Period To: DateTime - Evidence to Adjust Score: Text - Adjust Percentage: Double - How Can Manager Serve Better: Text - High Leverage Development Target: Text - SSMA_TimeStamp: Binary - Three Plus One Notes: Memo
People Training Module Status
Primary Key: People
Fields: - People Training Module Status ID: Long - People Training Module Status: Text
People Training Modules
Primary Key: People
Fields: - People Training Module ID: Long - People ID: Long - Job Code Training Module ID: Long - Training Version: Text - Date Scheduled: DateTime - Date Completed: DateTime - Quiz Score: Long - Assessment Score: Long - SSMA_TimeStamp: Binary - People Training Module Status ID: Long
People Training Sessions
Primary Key: People
Fields: - People Training Session ID: Long - People ID: Long - Job Code Training Session ID: Long - Date Scheduled: DateTime - Date Completed: DateTime - Quiz Score: Long - SSMA_TimeStamp: Binary - People Training Module Status ID: Long
People
Primary Key: People
Fields: - People ID: Long - Import ID: Long - Pre-Qualification Score: Long - People Partner: Text - Employee Number: Text - Title: Text - Initials: Text - First Name: Text - Middle Name: Text - Last Name: Text - Private Email: Text - Email: Text - Cell Number: Text - Internal Extension: Text - Birth Date: DateTime - Gender: Text - Race: Text - ID Number: Text - Known As: Text - Group Join Date: DateTime - ISP Q1: Text - ISP Q2: Text - ISP Q3: Text - ISP Q4: Text - Phys Line 1: Text - Phys Line 2: Text - Phys Line 3: Text - Phys Postal Code: Text - Phys Street Number: Text - Phys Unit Number: Text - Phys Complex: Text - Phys Province: Text - Phys Country: Long - Postal Add 1: Text - Postal Add 2: Text - Postal Add 3: Text - Postal Code: Text - Postal Street Number: Text - Postal Unit Number: Text - Postal Complex: Text - Postal Province: Text - Postal Country: Long - Citizenship: Text - Foreign National: Text - Emergency Contact Name: Text - Emergency Contact Number: Text - Emergency Contact Address: Text - Emergency Contact Name 2: Text - Emergency Contact Number 2: Text - Emergency Contact Address 2: Text - Send Post To: Text - Date Blacklisted: DateTime - Reason Blacklisted: Text - Last Modified By: Text - Date Modified: DateTime - ID Document File Name: Text - Passport File Name: Text - Drivers License File Name: Text - Matric Qualification File Name: Text - Tertiary Qualification File Name: Text - MIE Results File Name: Text - CV File Name: Text - Contract File Name: Text - Cultural Compact File Name: Text - Dept Compact File Name: Text - Office Location: Text - Access Control: Long - Desk: Long - Chair: Long - Filing Cabinet: Long - Bookshelf: Long - Access Control Tag: Long - Telephone: Designated - Laptop Computer: Cable - Desktop Computer: Long - Telephone: Printer - Remote Desktop REMS: Long - VPN Access: Long - Signature Loaded: Long - Email Address: Long - Microsoft 365 Package: Long - Waive Probation Process: Long - SSMA_TimeStamp: Binary
Position Status
Primary Key: Position
Fields: - Position Status ID: Long - Position Status: Text - Sort Order: Long - Active: Boolean - Which Dashboard: Long - SSMA_TimeStamp: Binary
Positions
Primary Key: Position
Fields: - Position ID: Long - Import ID: Long - Position Status ID: Long - Position Effective Date: DateTime - Start Date: DateTime - Termination Date: DateTime - Date Eliminated: DateTime - Date Suspended: DateTime - Training Approver ID: Long - Second Training Approver ID: Long - Organisational ID: Long - Job ID: Long - Pay Point ID: Long - Company ID: Long - Reporting To ID: Long - Employment Status: Text - Last Modified By: Text - Date Modified: DateTime - SSMA_TimeStamp: Binary
Pre Appointment Document Categories
Primary Key: Pre
Fields: - Pre Appointment Document Category ID: Long - Pre Appointment Document Category: Text - Sort Order: Long
Pre Appointment Document Source LkUp
Primary Key: Pre
Fields: - Pre Appointment Document Source ID: Long - Pre Appointment Document Source: Text
Pre Appointment Documents
Primary Key: Pre
Fields: - Pre Appointment Document ID: Long - Pre Appointment Document Category ID: Long - Pre Appointment Document: Text - Source: Text - Version: Double - Quantity: Long - Document Type: Long - Cost: Double - Default Document: Boolean - Sort Order: Long - SSMA_TimeStamp: Binary
Probation Interview Questions
Primary Key: Probation
Fields: - Probation Interview ID: Long - Probation Interview Question: Memo - Probation Interview Detail: Memo - SSMA_TimeStamp: Binary
Probation Interview Settling In Questions
Primary Key: Probation
Fields: - Probation Interview Settling In ID: Long - Probation Interview Settling In Question: Text - Probation Interview Settling In Detail: Memo - SSMA_TimeStamp: Binary
Probation Interview Types
Primary Key: Interview
Fields: - Interview Type ID: Long - Interview Type: Text
ProvinceLkUp
Primary Key: Province
Fields: - Province ID: Long - Province: Text (PK)
RaceLkUp Ruby
Primary Key: Race
Fields: - Race ID: Long - Race: Text (PK)
Regret Reasons
Primary Key: Regret
Fields: - Regret Reason ID: Long - Regret Reason: Text - Always Include: Boolean - Sort Order: Long - Active: Boolean - SSMA_TimeStamp: Binary
REMSModulesLkUp
Primary Key: REMS
Fields: - REMS Module ID: Long - REMS Module: Text
SendPostToLkUp
Primary Key: Send
Fields: - Send Post To ID: Long - Send Post To: Text
ShareDriveAccessLkUp
Primary Key: Share
Fields: - Share Drive Access ID: Long - Share Drive Access: Text
Telephone Interview Question Categories
Primary Key: TI
Fields: - TI Question Category ID: Long - Telephone Interview Question Category: Text - Sort Order: Long
Telephone Interview Questions
Primary Key: Telephone
Fields: - Telephone Interview Question ID: Long - TI Question Category ID: Long - Telephone Interview Question: Memo - Telephone Interview Question Detail: Memo - Default Question: Boolean - Do Not Print This Question: Boolean - Sort Order: Long - SSMA_TimeStamp: Binary
Temp Delete Duplicate People ID
Primary Key: Not defined
Fields: - People ID: Long
Temp Investigation Process Evidence
Primary Key: ID
Fields: - ID: Long (PK) - People Disciplinary Investigation Process Evidence ID: Long - People Disciplinary Investigation Process ID: Long - Evidence: Text - Evidence Location: Text - Delete it: Boolean
Temp Job Code Pre Appointment Documents NOT in the List
Primary Key: Not defined
Fields: - Pre Appointment Document ID: Long - Pre Appointment Document Category ID: Long - Pre Appointment Document: Text - Add it: Boolean
Temp Job Code Telephone Interview Questions NOT in the List
Primary Key: Not defined
Fields: - Telephone Interview Question ID: Long - TI Question Category ID: Long - Telephone Interview Question: Memo - Telephone Interview Question Detail: Memo - Add it: Boolean
Temp Job Code Training Modules NOT in the List
Primary Key: Not defined
Fields: - Training Module ID: Long - Module: Text - Training Type ID: Long - Training Course ID: Long - Sort Order: Long - Add it: Boolean
Temp Job Code Training Sessions NOT in the List
Primary Key: Not defined
Fields: - Training Session ID: Long - Session: Text - Training Type ID: Long - Training Course ID: Long - Add it: Boolean
tmpChanges
Primary Key: Not defined
Fields: - From: Long - To: Long
Training Courses
Primary Key: Training
Fields: - Training Course ID: Long - Course: Text
Training Modules
Primary Key: Training
Fields: - Training Module ID: Long - Module: Text - Module Descriptor: Text - Module Objectives: Text - Module Duration: Text - Presentation Type: Long - Content Created: Long - Training Created: Long - Training Version: Text - Assessment: Long - Assessment Version: Text - Quiz: Long - Quiz Version: Text - Approved Trainer: Long - Trainers: Text - Engage Course Codes: Text - Default Module: Boolean - SSMA_TimeStamp: Binary - Module Cost: Double
Training Sessions
Primary Key: Training
Fields: - Training Session ID: Long - Session: Text - Session Descriptor: Text - Session Purpose: Text - Number of Sessions: Long - Quiz: Long - Quiz Version: Text - Session Cost: Double - SSMA_TimeStamp: Binary
Training Types
Primary Key: Training
Fields: - Training Type ID: Long - Training Type: Text - Training Type Detail: Long
USysRibbons
Primary Key: ID
Fields: - ID: Long (PK) - RibbonName: Text - RibbonXml: Memo
vwRubyDuplicateApplicationList
Primary Key: Not defined
Fields: - Duplicate Application People ID: Long
vwRubyDuplicatePeople
Primary Key: Not defined
Fields: - People ID: Long - Applicant: Memo - Birth Date: DateTime - ID Number: Text - Application Date: DateTime - Job: Text - Application Status: Text
vwRubyDuplicatePeopleIDList
Primary Key: Not defined
Fields: - Duplicate People ID: Long
vwRubyPreApplicationList
Primary Key: Not defined
Fields: - Application ID: Long - Position ID: Long - People ID: Long - Application Status ID: Long - Application Status: Text - Applicant: Memo - Application Date: DateTime - Sort Order: Long - Birth Date: DateTime - PQ Score: Long - Stage Number: Long
vwRubyPreApplicationListNotHired
Primary Key: Not defined
Fields: - Application ID: Long - Position ID: Long - People ID: Long - Application Status ID: Long - Application Status: Text - Applicant: Memo - Application Date: DateTime - Sort Order: Long - PQ Score: Long
vwRubyPreDuplicatePeople
Primary Key: Not defined
Fields: - First Name: Text - Last Name: Text - Cell Number: Text - People ID: Long - Birth Date: DateTime - ID Number: Text
vwRubyPreFilledPositionList
Primary Key: Not defined
Fields: - Application Status ID: Long - Position ID: Long - People ID: Long - Job ID: Long - Which Dashboard: Long - Job: Text - Org Unit: Text - Pay Point: Text - Position Status ID: Long - Position Status: Text - Employee: Memo - Start Date: DateTime - Termination Date: DateTime - Date Eliminated: DateTime - Date Suspended: DateTime - Company Name: Text - Person: Memo
vwRubyPreOnboardingApplicationList
Primary Key: Not defined
Fields: - Application ID: Long - Position ID: Long - People ID: Long - Job ID: Long - Application Status ID: Long - Applicant: Memo - Application Date: DateTime - Birth Date: DateTime - Job: Text - Reporting To: Memo - Position Status ID: Long
vwRubyPreOpenPositionApplicantList
Primary Key: Not defined
Fields: - Position ID: Long - Job ID: Long - Which Dashboard: Long - Job: Text - Org Unit: Text - Pay Point: Text - Position Status ID: Long - Position Status: Text - Reporting To: Memo - Applicant: Memo - Company Name: Text - Job Profile File Name: Text
vwRubyPreOpenPositionList
Primary Key: Not defined
Fields: - Position ID: Long - Job ID: Long - Which Dashboard: Long - Job: Text - Org Unit: Text - Pay Point: Text - Position Status ID: Long - Position Status: Text - Reporting To: Memo - Last Name: Text - Company Name: Text - Job Profile File Name: Text
vwRubyPreReportTeamActivityDetail
Primary Key: Not defined
Fields: - Date Status Changed: DateTime - Status Modified By: Text - Job: Text - Pay Point: Text - Position Effective Date: DateTime - Applicant: Memo - Application Status: Text - Sort Order: Long - Application Status History ID: Long - Time Unit: Long
Warning Letter Level LkUp
Primary Key: Warning
Fields: - Warning Letter Level ID: Long - Warning Letter Level: Text
Year LkUp
Primary Key: Year
Fields: - Year ID: Long - Year Number: Long
zstblODBC_db BrNDON
Primary Key: DBID
Fields: - DBID: Long (PK) - SelectDB: Boolean - DatabaseName: Text - ServerName: Text - DBName: Text - Authentication: Text - UID: Text - PWD: Text - Driver: Text - DateAdded: DateTime
zstblODBC_db
Primary Key: DBID
Fields: - DBID: Long (PK) - SelectDB: Boolean - DatabaseName: Text - ServerName: Text - DBName: Text - Authentication: Text - UID: Text - PWD: Text - Driver: Text - DateAdded: DateTime
zstblODBC_tables
Primary Key: TableID
Fields: - TableID: Long (PK) - Link: Boolean - Hidden: Boolean - DatabaseName: Text - TableName: Text - SourceTableName: Text - AfterDDL: Text - Comment: Text - DateAdded: DateTime
Code Components
Modules (144)
| Module | Type | Lines | Procedures |
|---|---|---|---|
| Form_Add and Edit Admin Item | Form | 57 | 3 |
| Form_Add and Edit Applicant | Form | 336 | 12 |
| Form_Add and Edit Application Onboarding Information | Form | 151 | 7 |
| Form_Add and Edit Application Stages | Form | 42 | 3 |
| Form_Add and Edit Application Status | Form | 35 | 2 |
| Form_Add and Edit Assessment Types | Form | 68 | 3 |
| Form_Add and Edit Company | Form | 24 | 3 |
| Form_Add and Edit Country | Form | 20 | 1 |
| Form_Add and Edit CV Not Suitable Reason | Form | 68 | 3 |
| Form_Add and Edit Employee | Form | 351 | 12 |
| Form_Add and Edit Employment Equity Job Category | Form | 68 | 3 |
| Form_Add and Edit Grievance Process Outcome | Form | 57 | 3 |
| Form_Add and Edit Hearing Process Outcome | Form | 57 | 3 |
| Form_Add and Edit How Heard Options | Form | 56 | 3 |
| Form_Add and Edit Investigation Process Result | Form | 57 | 3 |
| Form_Add and Edit Job Code | Form | 99 | 6 |
| Form_Add and Edit On Boarding Recipients | Form | 60 | 3 |
| Form_Add and Edit Onboarding Information | Form | 181 | 7 |
| Form_Add and Edit Organisational Code | Form | 70 | 3 |
| Form_Add and Edit Pay Point | Form | 68 | 3 |
| Form_Add and Edit Payroll Item | Form | 57 | 3 |
| Form_Add and Edit People Admin Information | Form | 70 | 4 |
| Form_Add and Edit People Awards Recognition | Form | 68 | 3 |
| Form_Add and Edit People Badges | Form | 60 | 3 |
| Form_Add and Edit People Care Record | Form | 68 | 3 |
| Form_Add and Edit People Disciplinary Grievance Process | Form | 68 | 3 |
| Form_Add and Edit People Disciplinary Hearing Process | Form | 68 | 3 |
| Form_Add and Edit People Disciplinary Investigation Process | Form | 120 | 3 |
| Form_Add and Edit People Disciplinary Warning Letter | Form | 66 | 3 |
| Form_Add and Edit People Enrichment Training | Form | 70 | 3 |
| Form_Add and Edit People MeGRAPH Scores | Form | 72 | 3 |
| Form_Add and Edit People Payroll Information | Form | 66 | 3 |
| Form_Add and Edit People Poor Performance Checkin Meeting | Form | 64 | 3 |
| Form_Add and Edit People Poor Performance Meeting A | Form | 71 | 3 |
| Form_Add and Edit People Poor Performance Meeting B | Form | 66 | 3 |
| Form_Add and Edit People Poor Performance Meeting C | Form | 57 | 3 |
| Form_Add and Edit People Qualifications and Certifications | Form | 66 | 3 |
| Form_Add and Edit People Training Module Status | Form | 68 | 3 |
| Form_Add and Edit People Training Modules and Sessions | Form | 229 | 7 |
| Form_Add and Edit Position Status | Form | 35 | 2 |
| Form_Add and Edit Position | Form | 191 | 5 |
| Form_Add and Edit Pre Appointment Document Category | Form | 68 | 3 |
| Form_Add and Edit Pre Appointment Documents | Form | 37 | 2 |
| Form_Add and Edit Race | Form | 60 | 3 |
| Form_Add and Edit Regret Reason | Form | 68 | 3 |
| Form_Add and Edit Telephone Interview Question Category | Form | 68 | 3 |
| Form_Add and Edit Telephone Interview Questions | Form | 41 | 3 |
| Form_Add and Edit Three Plus One Review Meeting | Form | 15 | 2 |
| Form_Add and Edit Training Courses | Form | 68 | 3 |
| Form_Add and Edit Training Modules and Sessions | Form | 310 | 5 |
| Form_Add and Edit Training Modules | Form | 174 | 4 |
| Form_Add and Edit Users | Form | 40 | 3 |
| Form_Add and Edit Warning Letter Level | Form | 57 | 3 |
| Form_Add Application | Form | 55 | 4 |
| Form_Add Badges | Form | 114 | 5 |
| Form_Add People Badges | Form | 66 | 3 |
| Form_Bagdes List | Form | 133 | 9 |
| Form_Change Password | Form | 138 | 5 |
| Form_Check Duplicates | Form | 96 | 7 |
| Form_Choose People List | Form | 118 | 10 |
| Form_Company List | Form | 33 | 4 |
| Form_Configure Job Application Steps | Form | 58 | 4 |
| Form_Configure Job Regret Reasons | Form | 58 | 4 |
| Form_Copy Applications Dialog | Form | 53 | 3 |
| Form_Create Open From Terminated | Form | 41 | 3 |
| Form_Edit Application Status | Form | 385 | 13 |
| Form_Edit Badges | Form | 110 | 5 |
| Form_Edit Job Code Pre Appointment Documents | Form | 72 | 3 |
| Form_Edit Job Code Telephone Interview Questions | Form | 72 | 3 |
| Form_Edit Job Code Training Modules | Form | 91 | 3 |
| Form_Edit Job Code Training Sessions | Form | 87 | 3 |
| Form_Edit Onboarding Applicant | Form | 247 | 9 |
| Form_Edit Probation Interview Question Responses | Form | 15 | 2 |
| Form_Edit Probation Settling In Responses | Form | 15 | 2 |
| Form_Edit Telephone Interview Question Responses | Form | 23 | 3 |
| Form_Edit Three Plus One Review | Form | 34 | 4 |
| Form_Filled Position Report Dialog | Form | 41 | 2 |
| Form_Job Code List | Form | 264 | 14 |
| Form_Maintenance Menu | Form | 148 | 33 |
| Form_Onboarding List | Form | 161 | 18 |
| Form_Opening Dialog | Form | 79 | 4 |
| Form_People Admin Information | Form | 93 | 5 |
| Form_People Disciplinary Information | Form | 265 | 15 |
| Form_People List | Form | 156 | 11 |
| Form_People Payroll Information | Form | 99 | 6 |
| Form_People Performance Information | Form | 549 | 20 |
| Form_People Training Information | Form | 327 | 17 |
| Form_People Vault List | Form | 242 | 19 |
| Form_People Vault Review Applications | Form | 21 | 1 |
| Form_Recruitment List | Form | 389 | 26 |
| Form_Remove Duplicates | Form | 40 | 2 |
| Form_Report Menu | Form | 166 | 26 |
| Form_Reports Awards and Recognition Dialog | Form | 55 | 3 |
| Form_Reports Care Dialog | Form | 54 | 3 |
| Form_Reports Company Dialog | Form | 50 | 2 |
| Form_Reports Date Dialog | Form | 49 | 3 |
| Form_Reports Development Journey Dialog | Form | 44 | 2 |
| Form_Reports Exits Dialog | Form | 54 | 3 |
| Form_Reports ISP Exception Dialog | Form | 53 | 3 |
| Form_Reports ISP Individual Dialog | Form | 56 | 3 |
| Form_Reports ISP Performance Dialog | Form | 49 | 3 |
| Form_Reports ISP Summary Dialog | Form | 54 | 2 |
| Form_Reports Measurment Period Dialog | Form | 52 | 3 |
| Form_Reports MeGRAPH Dialog | Form | 45 | 2 |
| Form_Reports MEGRAPH1 Dialog | Form | 54 | 2 |
| Form_Reports New Starts Dialog | Form | 55 | 3 |
| Form_Reports Probation Review Dialog | Form | 49 | 3 |
| Form_Reports Qualifications Dialog | Form | 54 | 4 |
| Form_Reports Single Date Dialog | Form | 47 | 3 |
| Form_Reports Time To Fill Dialog | Form | 53 | 2 |
| Form_Team Activity Report Dialog | Form | 77 | 3 |
| Form_Training Module and Session List | Form | 253 | 9 |
| Form_Training Module List | Form | 159 | 9 |
| Form_View Job Code Pre Appointment Documents | Form | 48 | 3 |
| Form_View Job Code Telephone Interview Questions | Form | 48 | 3 |
| Form_View Job Code Training Modules and Sessions | Form | 62 | 3 |
| Form_View Job Code Training Modules | Form | 49 | 3 |
| Form_View Other Applicants Filled Positions | Form | 24 | 2 |
| Form_View Telephone Interview Question Responses | Form | 14 | 2 |
| Form_SubFrm Application Assessments | Form | 18 | 1 |
| Form_SubFrm Application Considerations - Edit | Form | 9 | 1 |
| Form_SubFrm Application Considerations | Form | 18 | 1 |
| Form_SubFrm Job Code Pre Appointment Documents | Form | 31 | 1 |
| Form_SubFrm Job Code Telephone Interview Questions | Form | 31 | 1 |
| Form_SubFrm Job Code Training Modules NOT in List | Form | 31 | 1 |
| Form_SubFrm Job Code Training Modules | Form | 31 | 1 |
| Form_SubFrm Job Code Training Sessions NOT in List | Form | 31 | 1 |
| Form_SubFrm Job Code Training Sessions | Form | 31 | 1 |
| Form_SubFrm People Emailing Lists | Form | 18 | 1 |
| Form_SubFrm People Investigation Process Evidence | Form | 28 | 2 |
| Form_SubFrm People Poor Performance Action Items | Form | 31 | 2 |
| Form_SubFrm People Probation Interview Action Items | Form | 31 | 2 |
| Form_SubFrm People REMS Modules | Form | 18 | 1 |
| Form_SubFrm People Share Drive Access | Form | 18 | 1 |
| Form_SubFrm People Three Plus One Feedback | Form | 31 | 2 |
| Form_SubFrm People Three Plus One ISP Contract | Form | 31 | 2 |
| Form_SubFrm People Three Plus One KPI Measurement Criteria | Form | 31 | 2 |
| Form_SubFrm People Training Module Summary | Form | 31 | 2 |
| Form_SubFrm Pre Appointment Documents | Form | 55 | 2 |
| Form_SubFrm Telephone Interview Questions | Form | 55 | 2 |
| basRelink | Standard | 562 | 6 |
| Mod Export to Excel | Standard | 1901 | 13 |
| Mod Send Outlook Message | Standard | 53 | 1 |
| Mod Utilities | Standard | 97 | 6 |
Forms (147)
| Form | Record Source | Controls | Has Code |
|---|---|---|---|
| Dialog | Unbound | 8 | No |
| Dialog1 | Unbound | 8 | No |
| Add and Edit Admin Item | Admin Item LkUp | 13 | Yes |
| Add and Edit Applicant | People | 157 | Yes |
| Add and Edit Application Onboarding Information | People | 94 | Yes |
| Add and Edit Application Stages | Application Stages | 11 | Yes |
| Add and Edit Application Status | Application Status | 25 | Yes |
| Add and Edit Assessment Types | Assessment Types | 11 | Yes |
| Add and Edit Company | Companies | 65 | Yes |
| Add and Edit Country | CountryLookup | 14 | Yes |
| Add and Edit CV Not Suitable Reason | CV Not Suitable Reasons | 15 | Yes |
| Add and Edit Employee | People | 157 | Yes |
| Add and Edit Employment Equity Job Category | Employment Equity Job Categories | 11 | Yes |
| Add and Edit Grievance Process Outcome | Grievance Process Outcome LkUp | 11 | Yes |
| Add and Edit Hearing Process Outcome | Hearing Process Outcome LkUp | 11 | Yes |
| Add and Edit How Heard Options | HowHeardLkUp | 11 | Yes |
| Add and Edit Investigation Process Result | Investigation Process Result LkUp | 11 | Yes |
| Add and Edit Job Code | Job Codes | 26 | Yes |
| Add and Edit On Boarding Recipients | On Boarding Form Recipients | 17 | Yes |
| Add and Edit Onboarding Information | People | 94 | Yes |
| Add and Edit Organisational Code | Organisational Codes | 21 | Yes |
| Add and Edit Pay Point | Pay Points | 13 | Yes |
| Add and Edit Payroll Item | Payroll Item LkUp | 11 | Yes |
| Add and Edit People Admin Information | People Enrichment Training | 26 | Yes |
| Add and Edit People Awards Recognition | Unbound | 25 | Yes |
| Add and Edit People Badges | Badge | 17 | Yes |
| Add and Edit People Care Record | Unbound | 25 | Yes |
| Add and Edit People Disciplinary Grievance Process | Unbound | 25 | Yes |
| Add and Edit People Disciplinary Hearing Process | Unbound | 25 | Yes |
| Add and Edit People Disciplinary Investigation Process | Unbound | 24 | Yes |
| Add and Edit People Disciplinary Warning Letter | Unbound | 23 | Yes |
| Add and Edit People Enrichment Training | People Enrichment Training | 30 | Yes |
| Add and Edit People MeGRAPH Scores | Unbound | 29 | Yes |
| Add and Edit People Payroll Information | People Enrichment Training | 27 | Yes |
| Add and Edit People Poor Performance Checkin Meeting | People Enrichment Training | 34 | Yes |
| Add and Edit People Poor Performance Meeting A | People Enrichment Training | 35 | Yes |
| Add and Edit People Poor Performance Meeting B | People Enrichment Training | 49 | Yes |
| Add and Edit People Poor Performance Meeting C | People Enrichment Training | 42 | Yes |
| Add and Edit People Qualifications and Certifications | People Enrichment Training | 25 | Yes |
| Add and Edit People Training Module Status | People Training Module Status | 11 | Yes |
| Add and Edit People Training Modules and Sessions | Unbound | 40 | Yes |
| Add and Edit Position Status | Position Status | 14 | Yes |
| Add and Edit Position | Positions | 45 | Yes |
| Add and Edit Pre Appointment Document Category | Pre Appointment Document Categories | 13 | Yes |
| Add and Edit Pre Appointment Documents | Pre Appointment Document Categories | 12 | Yes |
| Add and Edit Race | RaceLkUp Ruby | 11 | Yes |
| Add and Edit Regret Reason | Regret Reasons | 18 | Yes |
| Add and Edit Telephone Interview Question Category | Telephone Interview Question Categories | 13 | Yes |
| Add and Edit Telephone Interview Questions | Telephone Interview Question Categories | 12 | Yes |
| Add and Edit Three Plus One Review Meeting | People Three Plus One | 27 | Yes |
| Add and Edit Training Courses | Training Courses | 11 | Yes |
| Add and Edit Training Modules and Sessions | Unbound | 71 | Yes |
| Add and Edit Training Modules | Unbound | 65 | Yes |
| Add and Edit Users | DatabaseUsersRuby | 25 | Yes |
| Add and Edit Warning Letter Level | Warning Letter Level LkUp | 11 | Yes |
| Add Application | Applications | 25 | Yes |
| Add Badges | Unbound | 13 | Yes |
| Add People Badges | Badge | 15 | Yes |
| Bagdes List | Unbound | 12 | Yes |
| Change Password | Unbound | 19 | Yes |
| Check Duplicates | Unbound | 13 | Yes |
| Choose People List | Unbound | 22 | Yes |
| Company List | Unbound | 12 | Yes |
| Configure Job Application Steps | Unbound | 14 | Yes |
| Configure Job Regret Reasons | Unbound | 14 | Yes |
| Copy Applications Dialog | Unbound | 13 | Yes |
| Create Open From Terminated | Unbound | 9 | Yes |
| Edit Application Status | Unbound | 30 | Yes |
| Edit Badges | Unbound | 13 | Yes |
| Edit Job Code Pre Appointment Documents | Pre Appointment Document Categories | 12 | Yes |
| Edit Job Code Telephone Interview Questions | Telephone Interview Question Categories | 12 | Yes |
| Edit Job Code Training Modules | Telephone Interview Question Categories | 8 | Yes |
| Edit Job Code Training Sessions | Telephone Interview Question Categories | 8 | Yes |
| Edit Onboarding Applicant | Unbound | 20 | Yes |
| Edit Probation Interview Question Responses | People Probabtion Interviews | 30 | Yes |
| Edit Probation Settling In Responses | People Probabtion Interviews | 17 | Yes |
| Edit Telephone Interview Question Responses | Qry Edit Telephone Interview Question Responses | 18 | Yes |
| Edit Three Plus One Review | People Three Plus One | 39 | Yes |
| Filled Position Report Dialog | Unbound | 9 | Yes |
| Job Code List | Unbound | 24 | Yes |
| Maintenance Menu | Unbound | 31 | Yes |
| Onboarding List | Unbound | 32 | Yes |
| Opening Dialog | Unbound | 14 | Yes |
| People Admin Information | People | 14 | Yes |
| People Disciplinary Information | People | 18 | Yes |
| People List | Unbound | 22 | Yes |
| People Payroll Information | People | 12 | Yes |
| People Performance Information | People | 29 | Yes |
| People Training Information | People | 22 | Yes |
| People Vault List | Unbound | 33 | Yes |
| People Vault Review Applications | Unbound | 10 | Yes |
| Recruitment List | Unbound | 55 | Yes |
| Remove Duplicates | Unbound | 8 | Yes |
| Report Menu | Unbound | 27 | Yes |
| Reports Awards and Recognition Dialog | Unbound | 8 | Yes |
| Reports Care Dialog | Unbound | 8 | Yes |
| Reports Company Dialog | Unbound | 5 | Yes |
| Reports Date Dialog | Unbound | 6 | Yes |
| Reports Development Journey Dialog | Unbound | 6 | Yes |
| Reports Exits Dialog | Unbound | 8 | Yes |
| Reports ISP Exception Dialog | Unbound | 9 | Yes |
| Reports ISP Individual Dialog | Unbound | 10 | Yes |
| Reports ISP Performance Dialog | Unbound | 5 | Yes |
| Reports ISP Summary Dialog | Unbound | 11 | Yes |
| Reports Measurment Period Dialog | Unbound | 7 | Yes |
| Reports MeGRAPH Dialog | Unbound | 6 | Yes |
| Reports MEGRAPH1 Dialog | Unbound | 11 | Yes |
| Reports New Starts Dialog | Unbound | 8 | Yes |
| Reports Probation Review Dialog | Unbound | 6 | Yes |
| Reports Qualifications Dialog | Unbound | 6 | Yes |
| Reports Single Date Dialog | Unbound | 6 | Yes |
| Reports Time To Fill Dialog | SELECT DISTINCT [Job Codes].[Job ID], [Job Codes].Job FROM [Job Codes]; | 10 | Yes |
| Team Activity Report Dialog | Unbound | 16 | Yes |
| Training Module and Session List | Unbound | 17 | Yes |
| Training Module List | Unbound | 12 | Yes |
| View Job Code Pre Appointment Documents | Qry Job Codes and Pre Appointment Document Categories List | 14 | Yes |
| View Job Code Telephone Interview Questions | Qry Job Codes and Telephone Interview Question Categories List | 14 | Yes |
| View Job Code Training Modules and Sessions | Qry Job Codes and Training Module and Session Types List | 14 | Yes |
| View Job Code Training Modules | Qry Job Codes and Training Module Types List | 13 | Yes |
| View Other Applicants Filled Positions | Unbound | 9 | Yes |
| View Telephone Interview Question Responses | Qry Edit Telephone Interview Question Responses | 19 | Yes |
| SubFrm Application Assessments | Application Assessments | 8 | Yes |
| SubFrm Application Considerations - Edit | Application Considerations - Edit | 8 | Yes |
| SubFrm Application Considerations | Application Considerations | 7 | Yes |
| SubFrm Application Status History | Application Status History | 12 | No |
| SubFrm Job Code Pre Appointment Documents NOT in List | Temp Job Code Pre Appointment Documents NOT in the List | 8 | No |
| SubFrm Job Code Pre Appointment Documents | Qry Job Code Pre Appointment Documents | 24 | Yes |
| SubFrm Job Code Telephone Interview Questions NOT in List | Temp Job Code Telephone Interview Questions NOT in the List | 10 | No |
| SubFrm Job Code Telephone Interview Questions | Qry Job Code Telephone Interview Questions | 10 | Yes |
| SubFrm Job Code Training Modules NOT in List | Temp Job Code Training Modules NOT in the List | 13 | Yes |
| SubFrm Job Code Training Modules | Qry Job Code Training Modules | 14 | Yes |
| SubFrm Job Code Training Sessions NOT in List | Temp Job Code Training Sessions NOT in the List | 11 | Yes |
| SubFrm Job Code Training Sessions | Qry Job Code Training Sessions | 12 | Yes |
| SubFrm People Emailing Lists | People Emailing Lists | 7 | Yes |
| SubFrm People Investigation Process Evidence | SELECT [Temp Investigation Process Evidence].ID, [Temp Investigation Process Evi | 9 | Yes |
| SubFrm People Poor Performance Action Items | People Poor Performance Action Items | 15 | Yes |
| SubFrm People Probabtion Interview Question Responses | People Probabtion Interview Question Responses | 11 | No |
| SubFrm People Probabtion Interview Settling In Responses | People Probabtion Interview Settling In Responses | 11 | No |
| SubFrm People Probation Interview Action Items | People Probation Interview Action Items | 15 | Yes |
| SubFrm People REMS Modules | People REMS Modules | 7 | Yes |
| SubFrm People Share Drive Access | People Share Drive Access | 7 | Yes |
| SubFrm People Three Plus One Feedback | People Three Plus One Feedback | 11 | Yes |
| SubFrm People Three Plus One ISP Contract | People Three Plus One ISP Contract | 18 | Yes |
| SubFrm People Three Plus One KPI Measurement Criteria | People Three Plus One KPI Measurement Criteria | 21 | Yes |
| SubFrm People Training Module Summary | Qry SubFrm People Training Module Summary | 16 | Yes |
| SubFrm Pre Appointment Documents | Pre Appointment Documents | 26 | Yes |
| SubFrm Telephone Interview Questions | Telephone Interview Questions | 16 | Yes |
Reports (38)
| Report | Record Source | Sections |
|---|---|---|
| Calibri | Qry Report Application Onboarding Form | 2 |
| Calibri | Qry Report Application Onboarding Form | 2 |
| Calibri | Qry Report Application Status Ratio | 2 |
| Calibri | Qry Report Blacklisted Applicants | 2 |
| Calibri | Qry Development Journey Training Information | 2 |
| Calibri | Qry Development Journey | 2 |
| Calibri | Unbound | 2 |
| Calibri | Unbound | 2 |
| Calibri | Qry ISP Exception | 2 |
| Calibri | Qry ISP Individual From Three Plus One Page | 2 |
| Calibri | Qry ISP Individual | 2 |
| Calibri | Qry ISP Summary | 2 |
| Calibri | Qry Report Job Code Pre Appointment Documents | 2 |
| Calibri | Qry MeGRAPH Exception | 2 |
| Calibri | Qry MeGRAPH | 2 |
| Calibri | Qry Report Number Applications by Job Code | 2 |
| Calibri | Qry Report Onboarding Form | 2 |
| Calibri | Qry Report Onboarding Form | 2 |
| Calibri | Qry SubFrm People Training Module Summary | 2 |
| Calibri | Qry Probation Review | 2 |
| Calibri | Qry Report Regretted CV Not Suitable Info by Position | 2 |
| Calibri | Qry Report Team Activity Detail | 2 |
| Calibri | Qry Report Team Activity Summary | 2 |
| Calibri | Qry Report Team Activity Super Summary | 2 |
| Calibri | Qry Report Team Activity Time Summary | 2 |
| Calibri | Qry Report Telephone Interview Question Responses | 2 |
| Calibri | Qry Warnings | 2 |
| Calibri | Qry SubRpt Executive Daily Summary Applications Recruit by Stage | 0 |
| Calibri | Qry SubRpt Executive Daily Summary New Applications by Position | 0 |
| Calibri | Qry SubRpt Executive Daily Summary New Applications | 0 |
| Calibri | Qry SubRpt Executive Daily Summary Status Changes Recruit by Pos | 0 |
| Calibri | Qry SubRpt Executive Daily Summary Status Prev Day by Pos | 0 |
| Calibri | Qry SubRpt Executive Daily Summary Tot Apps Recruit by Position | 0 |
| Calibri | Qry SubRpt How Heard Statistics Hired | 0 |
| Calibri | Qry SubRpt How Heard Statistics Regret CV | 0 |
| Calibri | People Emailing Lists | 0 |
| Calibri | People REMS Modules | 0 |
| Calibri | People Share Drive Access | 0 |
Queries (161)
| Query | Type | Tables |
|---|---|---|
| Find duplicates for Job Code Training Sessions | Select | Job Code Training Sessions, Job |
| Find duplicates for People Cell | Select | People |
| Find duplicates for People ID Nymber | Select | People |
| JB Emails to Move | Select | People |
| JB Qry Append Job Telephone Interview Questions to Application | Delete | Job, Job Code Telephone Interview Questions |
| JB Qry Initialise Default Interview Questions | Delete | Telephone Interview Questions, Job Codes |
| JB Qry Initialise UUID | Delete | vwRubyPreFilledPositionList |
| Qry Append Default Application Status Steps to Job Code | Delete | Application, Application Status |
| Qry Append Default Regret Reasons to Job Code | Delete | Regret Reasons, Regret |
| Qry Append Investigation Process Evidence | Delete | People, People Disciplinary Investigation Process Evidence |
| Qry Application List Not Hired | Select | vwRubyPreApplicationListNotHired |
| Qry Application List | Select | vwRubyDuplicatePeopleIDList, vwRubyDuplicateApplicationList |
| Qry Awards And Recognition | Select | Positions, People |
| Qry Badges | Select | People, Badge |
| Qry Care | Select | People Care Records, Positions |
| Qry Copy Application List | Select | vwRubyPreApplicationList |
| Qry Count All Application Status by Position | Select | Application Status, Applications |
| Qry Count CV Not Suitable Reasons by Position | Select | Applications, CV Not Suitable Reasons |
| Qry Count Number CV Not Suitable by Position | Select | Applications |
| Qry Count Number Employees by Company | Select | Applications, Positions |
| Qry Count Number Regretted by Position | Select | Applications |
| Qry Count Regret Reasons by Position | Select | Regret Reasons, Applications |
| Qry Count Scheduled and Completed Training Modules One Emp | Select | People Training Modules, Job |
| Qry Count Total Applications by Position | Select | Applications |
| Qry Count Training Modules One Job Code | Select | Job, Job Code Training Modules |
| Qry Development Journey Training Information | Select | People Training Modules, Positions |
| Qry Development Journey | Select | People Training Modules, Positions |
| Qry Duplicate People | Select | vwRubyDuplicatePeople |
| Qry Edit Telephone Interview Question Responses | Select | Telephone Interview Questions, Telephone Interview Question Categories |
| Qry Exits | Select | Position Status, Positions |
| Qry Export Employee Engage | Select | Positions, People |
| Qry Export Job List Engage | Select | Job Codes, Job |
| Qry Export Lead Summary Report Get Application Status | Select | Qry, Qry Export Lead Summary Report |
| Qry Export Lead Summary Report | Select | Positions, Applications |
| Qry Export Organisational Codes Engage | Select | Organisational Codes, Organisational |
| Qry Filled Position List | Select | vwRubyPreFilledPositionList |
| Qry Find Dulicate People for Merge | Select | People |
| Qry Get Line Manager | Select | People |
| Qry Get Max Employee Number by Company | Select | Companies, People |
| Qry Get People ID Numbers for Merge | Select | Qry, Qry Find Dulicate People for Merge |
| Qry Get People in Positions | Select | People, Job Codes |
| Qry Get People Poor Performance Checkins | Select | People Poor Performance Checkin, People |
| Qry Get People Poor Performance Meeting A | Select | People, People Poor Work Performance |
| Qry Get People Poor Performance Meeting B | Select | People, People Poor Work Performance |
| Qry Get People Poor Performance Meeting C | Select | People, People Poor Work Performance |
| Qry Get Reporting To Name and Job | Select | Job, Positions |
| Qry ISP Exception | Select | Companies, Positions |
| Qry ISP Individual From Three Plus One Page | Select | People Three Plus One ISP Contract, Positions |
| Qry ISP Individual | Select | People Three Plus One ISP Contract, Positions |
| Qry ISP Performance | Select | People Three Plus One ISP Contract, Companies |
| Qry ISP Summary | Select | People Three Plus One ISP Contract, Positions |
| Qry Job Code Application Step List | Select | Application Status, Job Code Application Steps |
| Qry Job Code Application Steps NOT in List | Select | SubQry Job Code Application Step NOT in List, Application |
| Qry Job Code List | Select | Job Codes, Job |
| Qry Job Code People List | Select | People, Job Codes |
| Qry Job Code Pre Appointment Documents NOT in the List | Delete | SubQry Job Code Pre Appointment Documents NOT in the List, SubQry |
| Qry Job Code Pre Appointment Documents | Select | Job Code Pre Appointment Documents, Job |
| Qry Job Code Regret Reason List | Select | Regret Reasons, Job Code Regret Reasons |
| Qry Job Code Regret Resons NOT in List | Select | Regret Reasons, SubQry |
| Qry Job Code Telephone Interview Questions NOT in the List | Delete | Telephone Interview Questions, SubQry Job Code Telephone Interview Questions NOT in the List |
| Qry Job Code Telephone Interview Questions | Select | Telephone Interview Questions, Job |
| Qry Job Code Training Modules NOT in the List | Delete | Training Modules, SubQry Job Code Training Modules NOT in the List |
| Qry Job Code Training Modules | Select | Job, Training Types |
| Qry Job Code Training Sessions NOT in the List | Select | |
| Qry Job Code Training Sessions | Select | Training, Training Sessions |
| Qry Job Codes and Pre Appointment Document Categories List | Select | Job Code Pre Appointment Documents, Job |
| Qry Job Codes and Telephone Interview Question Categories List | Select | Telephone Interview Questions, Telephone Interview Question Categories |
| Qry Job Codes and Training Module and Session Types List | Select | |
| Qry Job Codes and Training Module Types List | Select | Job, Job Code Training Modules |
| Qry MeGRAPH Exception | Select | Positions, People MeGRAPH Scores |
| Qry MeGRAPH | Select | People MeGRAPH Scores, Positions |
| Qry Merge Duplicate People Source | Select | Position Status, Positions |
| Qry New Starts | Select | Position Status, Positions |
| Qry Onboarding Application List | Select | vwRubyPreOnboardingApplicationList |
| Qry Open Position Applicant List | Select | vwRubyPreOpenPositionApplicantList |
| Qry Open Position List | Select | vwRubyPreOpenPositionList |
| Qry Past Application List | Select | Position Status, Positions |
| Qry People Admin Information List | Select | People, People Admin Information |
| Qry People Considerations List | Select | Application Considerations, People |
| Qry People Disciplinary Grievance Process List | Select | People, People Disciplinary Grievance Process |
| Qry People Disciplinary Hearing Process List | Select | People, People Disciplinary Hearing Process |
| Qry People Disciplinary Investigation Process List | Select | People, People Disciplinary Investigation Process |
| Qry People Disciplinary Warning Letter List | Select | People, People Disciplinary Warning Letters |
| Qry People Enrichment Training List | Select | |
| Qry People List | Select | People |
| Qry People Payroll Information List | Select | People, People Payroll Information |
| Qry People Poor Performance Meetings | Select | |
| Qry People Qualifications List | Select | People, People Qualifications and Certifications |
| Qry People Training Module and Session List | Select | |
| Qry People Training Module List | Select | People Training Modules, Training Types |
| Qry People Training Modules NOT in the List | Select | Training Types, Training Modules |
| Qry People Training Session List | Select | |
| Qry People Training Sessions NOT in the List | Select | Training, Training Sessions |
| Qry Probation Review | Select | People Probabtion Interviews, Probation Interview Types |
| Qry Qualifications | Select | Positions, People |
| Qry Report Application Onboarding Form | Select | Qry Get Line Manager, Positions |
| Qry Report Application Status Ratio | Select | Position Status, Qry Count Total Applications by Position |
| Qry Report Blacklisted Applicants | Select | Positions, People |
| Qry Report Hired and Terminated Employee List | Select | Positions, People |
| Qry Report Hired Employee List | Select | Positions, People |
| Qry Report Job Code Pre Appointment Documents | Select | Job, Pre Appointment Documents |
| Qry Report Number Applications by Job Code | Select | Job Codes, Applications |
| Qry Report Onboarding Form | Select | Qry Get Line Manager, Positions |
| Qry Report Opal Calculate Percentage by Gender | Select | Qry Report Opal Count Hired Employees by Gender, Qry Report Opal Count Total Hired Employees |
| Qry Report Opal Calculate Percentage by Management Race | Select | Qry Report Opal Count Hired Employees by Management Race, Qry Report Opal Count Total Hired Employees |
| Qry Report Opal Calculate Percentage by Manager | Select | Qry Report Opal Count Hired Employees by Manager, Qry Report Opal Count Total Hired Employees |
| Qry Report Opal Calculate Percentage by Org Unit | Select | Qry Report Opal Count Total Hired Employees, Qry |
| Qry Report Opal Calculate Percentage by Pay Point | Select | Qry Report Opal Count Total Hired Employees, Qry Report Opal Count Hired Employees by Pay Point |
| Qry Report Opal Calculate Percentage by Race Gender | Select | Qry Report Opal Count Total Hired Employees, Qry |
| Qry Report Opal Calculate Percentage by Race | Select | Qry Report Opal Count Total Hired Employees, Qry |
| Qry Report Opal Calculate Tenure by Gender | Select | 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 | Select | Qry, Qry Report Opal Count Hired and Terminated Employees by Org Unit |
| Qry Report Opal Count Hired and Terminated Employees by Gender | Select | Qry Report Hired and Terminated Employee List, Qry |
| Qry Report Opal Count Hired and Terminated Employees by Org Unit | Select | Qry Report Hired and Terminated Employee List, Qry |
| Qry Report Opal Count Hired Employees by Employment Status | Select | Qry Report Hired Employee List, Qry |
| Qry Report Opal Count Hired Employees by Gender | Select | Qry Report Hired Employee List, Qry |
| Qry Report Opal Count Hired Employees by Management Race | Select | Qry Report Hired Employee List, Qry |
| Qry Report Opal Count Hired Employees by Manager | Select | Qry Report Hired Employee List, Qry |
| Qry Report Opal Count Hired Employees by Org Unit | Select | Qry Report Hired Employee List, Qry |
| Qry Report Opal Count Hired Employees by Pay Point | Select | Qry Report Hired Employee List, Qry |
| Qry Report Opal Count Hired Employees by Race Gender | Select | Qry Report Hired Employee List, Qry |
| Qry Report Opal Count Hired Employees by Race | Select | Qry Report Hired Employee List, Qry |
| Qry Report Opal Count Total Hired Employees | Select | Qry Report Hired Employee List, Qry |
| Qry Report Opal Sum Length of Service by Gender | Select | Qry Report Hired and Terminated Employee List, Qry |
| Qry Report Opal Sum Length of Service by Org Unit | Select | Qry Report Hired and Terminated Employee List, Qry |
| Qry Report Regretted CV Not Suitable Info by Position | Select | Position Status, Qry Count Total Applications by Position |
| Qry Report Team Activity Detail | Select | vwRubyPreReportTeamActivityDetail |
| Qry Report Team Activity Summary | Select | Qry, Qry Report Team Activity Detail |
| Qry Report Team Activity Super Summary | Select | Qry, Qry Report Team Activity Detail |
| Qry Report Team Activity Time Summary | Select | Qry, Qry Report Team Activity Detail |
| Qry Report Telephone Interview Question Responses | Select | Telephone Interview Questions, Telephone Interview Question Categories |
| Qry SubFrm People Training Module Summary | Select | Qry Count Training Modules One Job Code, Qry Count Scheduled and Completed Training Modules One Emp |
| Qry SubRpt Executive Daily Summary Applications Recruit by Stage | Select | Application Status, Applications |
| Qry SubRpt Executive Daily Summary New Applications by Position | Select | Organisational Codes, Job Codes |
| Qry SubRpt Executive Daily Summary New Applications | Select | Applications |
| Qry SubRpt Executive Daily Summary Status Changes Recruit by Pos | Select | Application Status History, Positions |
| Qry SubRpt Executive Daily Summary Status Prev Day by Pos | Select | Application Status History, Positions |
| Qry SubRpt Executive Daily Summary Tot Apps Recruit by Position | Select | Organisational Codes, Job Codes |
| Qry SubRpt How Heard Statistics Hired | Select | SubQry Rpt How Heard Statistics Count Hired, SubQry |
| Qry SubRpt How Heard Statistics Regret CV | Select | SubQry Rpt How Heard Statistics Count Regret CV, SubQry |
| Qry Sum Total Application Status Times by Position | Select | Application Status, Applications |
| Qry Time To Fill | Select | Position Status, Positions |
| Qry Warnings | Select | Positions, People |
| qryLinkODBC | Select | |
| SubQry Duplicate People | Select | People |
| SubQry Job Code Application Step NOT in List | Select | Application Status, Job Code Application Steps |
| SubQry Job Code Pre Appointment Documents NOT in the List | Select | Job Code Pre Appointment Documents, Job |
| SubQry Job Code Regret Reasons NOT in List | Select | Regret Reasons, Job Code Regret Reasons |
| SubQry Job Code Telephone Interview Questions NOT in the List | Select | Job, Job Code Telephone Interview Questions |
| SubQry Job Code Training Modules NOT in the List | Select | Job, Job Code Training Modules |
| SubQry Job Code Training Sessions NOT in the List | Select | Job Code Training Sessions, Job |
| SubQry Job Codes and Training Module Types List | Select | Job, Job Code Training Modules |
| SubQry Job Codes and Training Session Types List | Select | Training, Job Code Training Sessions |
| SubQry People Job Training Summary Modules | Select | People Training Modules, Job |
| SubQry People Training Modules NOT in the List | Select | People Training Modules, People |
| SubQry People Training Sessions NOT in the List | Select | People, People Training Sessions |
| SubQry Rpt How Heard Statistics Count Hired by How Heard | Select | SubQry, SubQry Rpt How Heard Statistics Criteria |
| SubQry Rpt How Heard Statistics Count Hired | Select | SubQry, SubQry Rpt How Heard Statistics Criteria |
| SubQry Rpt How Heard Statistics Count Regret CV by How Heard | Select | SubQry, SubQry Rpt How Heard Statistics Criteria |
| SubQry Rpt How Heard Statistics Count Regret CV | Select | SubQry, SubQry Rpt How Heard Statistics Criteria |
| SubQry Rpt How Heard Statistics Criteria | Select | Applications, Positions |
Macros (9)
| Macro | Type | Actions | Forms |
|---|---|---|---|
| Mac RibOpenFormAdmin | UI | 1 | Frm People Admin Information, Frm People Vault List |
| Mac RibOpenFormDisciplinary | UI | 1 | Frm People Disciplinary Information, Frm People Vault List |
| Mac RibOpenFormOnboarding | UI | 1 | Frm Add and Edit Onboarding Information, Frm People Vault List |
| Mac RibOpenFormOnboardingOnboarding | UI | 1 | Frm Add and Edit Application Onboarding Information, Frm Add and Edit Applicant |
| Mac RibOpenFormOnboardingPersonal | UI | 2 | Frm Onboarding List, Frm Add and Edit Applicant |
| Mac RibOpenFormPayroll | UI | 1 | Frm People Vault List, Frm People Payroll Information |
| Mac RibOpenFormPerformance | UI | 1 | Frm People Performance Information, Frm People Vault List |
| Mac RibOpenFormPersonal | UI | 2 | Frm Add and Edit Employee, Frm People Vault List |
| Mac RibOpenFormTraining | UI | 1 | Frm People Training Information, Frm People Vault List |