Data Dictionary

Admin Item LkUp

• Admin Item ID: Long *
• Admin Item: Text
• Admin Item Duration: Long

Application Assessments

• Application Assessment ID: Long *
• Application ID: Long
• Assessment Type ID: Long
• Assessment Score: Double
• SSMA_TimeStamp: Binary *

Application Considerations - Edit

• Application Consideration ID: Long
• Application ID: Long
• Job ID: Long
• Delete It: Boolean

Application Considerations

• Application Consideration ID: Long *
• Application ID: Long
• Job ID: Long
• SSMA_TimeStamp: Binary *

Application Stages

• Stage Number: Long *
• Application Stage: Text

Application Status History

• 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

• 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

• Application TI Question Response ID: Long *
• Application ID: Long
• Telephone Interview Question ID: Long
• Telephone Interview Response: Memo
• SSMA_TimeStamp: Binary *

Applications

• 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

• Assessment Type ID: Long *
• Assessment Type: Text

Badge

• Badge ID: Long *
• Badge (PK): Text *

Companies

• 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

• Country ID: Long *
• Country (PK): Text
• Country Code: Text
• Active: Boolean
• SSMA_TimeStamp: Binary *

CV Not Suitable Reasons

• CV Not Suitable Reason ID: Long *
• CV Not Suitable Reason: Text
• Sort Order: Long
• Active: Boolean
• SSMA_TimeStamp: Binary *

DatabaseUsersRuby

• User ID: Long *
• Username (PK): Text *
• 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

• Emailing List ID: Long *
• Emailing List: Text

Employment Equity Job Categories

• EE Job Category ID: Long *
• Employment Equity Job Category: Text

EmploymentStatusLkUp

• Employment Status ID: Long *
• Employment Status: Text

Feedback Elements

• Feedback Element ID: Long *
• Feedback Element: Text

General Ruby

• 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

• Grievance Process Outcome ID: Long *
• Grievance Process Outcome: Text

Hearing Process Outcome LkUp

• Hearing Process Outcome ID: Long *
• Hearing Process Outcome: Text

HowHeardLkUp

• How Heard ID: Long *
• How Heard: Text

Investigation Process Result LkUp

• Investigation Process Result ID: Long *
• Investigation Process Result: Text

Job Code Application Steps

• Job Code Application Step ID: Long *
• Job ID: Long
• Application Status ID: Long
• SSMA_TimeStamp: Binary *

Job Code Pre Appointment Documents

• Job Code Pre Appointment Document ID: Long *
• Job ID: Long
• Pre Appointment Document ID: Long
• SSMA_TimeStamp: Binary *

Job Code Regret Reasons

• Job Code Regret Reason ID: Long *
• Job ID: Long
• Regret Reason ID: Long
• SSMA_TimeStamp: Binary *

Job Code Telephone Interview Questions

• Job Code Telephone Interview Question ID: Long *
• Job ID: Long
• Telephone Interview Question ID: Long
• SSMA_TimeStamp: Binary *

Job Code Training Modules

• 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

• 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

• Job ID: Long *
• Job (PK): Text
• 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

• Key Performance Area ID: Long *
• Key Performance Area: Text

MonthLkUp

• Month Number: Long *
• Month Name: Text
• Last Day: Integer

On Boarding Form Recipients

• On Boarding Recipient ID: Long *
• On Boarding Recipient Email: Text
• On Boarding Recipient Type: Long

Organisational Codes

• 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

• Pay Point ID: Long *
• Pay Point: Text
• Active: Boolean
• SSMA_TimeStamp: Binary *

Payroll Item LkUp

• Payroll Item ID: Long *
• Payroll Item: Text

People Admin Information

• 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

• 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

• People Badge ID: Long *
• People ID: Long
• Badge ID: Long
• Date Assigned: DateTime

People Care Records

• 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

• 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

• 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

• 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

• 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

• 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

• People Emailing List ID: Long *
• People ID: Long
• Emailing List: Text
• SSMA_TimeStamp: Binary *

People Enrichment Training

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• People REMS Modules ID: Long *
• People ID: Long
• REMS Module: Text
• SSMA_TimeStamp: Binary *

People Share Drive Access

• People Share Drive Access ID: Long *
• People ID: Long
• Share Drive Access: Text
• SSMA_TimeStamp: Binary *

People Three Plus One Feedback

• 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

• 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

• 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

• 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

• People Training Module Status ID: Long *
• People Training Module Status: Text

People Training Modules

• 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

• 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

• 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

• Position Status ID: Long *
• Position Status: Text
• Sort Order: Long
• Active: Boolean
• Which Dashboard: Long
• SSMA_TimeStamp: Binary *

Positions

• 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

• Pre Appointment Document Category ID: Long *
• Pre Appointment Document Category: Text
• Sort Order: Long

Pre Appointment Document Source LkUp

• Pre Appointment Document Source ID: Long *
• Pre Appointment Document Source: Text

Pre Appointment Documents

• 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

• Probation Interview ID: Long *
• Probation Interview Question: Memo
• Probation Interview Detail: Memo
• SSMA_TimeStamp: Binary *

Probation Interview Settling In Questions

• Probation Interview Settling In ID: Long *
• Probation Interview Settling In Question: Text
• Probation Interview Settling In Detail: Memo
• SSMA_TimeStamp: Binary *

Probation Interview Types

• Interview Type ID: Long *
• Interview Type: Text

ProvinceLkUp

• Province ID: Long *
• Province (PK): Text

RaceLkUp Ruby

• Race ID: Long *
• Race (PK): Text

Regret Reasons

• Regret Reason ID: Long *
• Regret Reason: Text
• Always Include: Boolean
• Sort Order: Long
• Active: Boolean
• SSMA_TimeStamp: Binary *

REMSModulesLkUp

• REMS Module ID: Long *
• REMS Module: Text

SendPostToLkUp

• Send Post To ID: Long *
• Send Post To: Text

ShareDriveAccessLkUp

• Share Drive Access ID: Long *
• Share Drive Access: Text

Telephone Interview Question Categories

• TI Question Category ID: Long *
• Telephone Interview Question Category: Text
• Sort Order: Long

Telephone Interview Questions

• 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

• People ID: Long

Temp Investigation Process Evidence

• ID (PK): Long
• 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

• 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

• 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

• 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

• Training Session ID: Long
• Session: Text
• Training Type ID: Long
• Training Course ID: Long
• Add it: Boolean

tmpChanges

• From: Long
• To: Long

Training Courses

• Training Course ID: Long *
• Course: Text

Training Modules

• 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

• 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

• Training Type ID: Long *
• Training Type: Text
• Training Type Detail: Long

USysRibbons

• ID (PK): Long
• RibbonName: Text
• RibbonXml: Memo

vwRubyDuplicateApplicationList

• Duplicate Application People ID: Long

vwRubyDuplicatePeople

• People ID: Long *
• Applicant: Memo *
• Birth Date: DateTime
• ID Number: Text
• Application Date: DateTime
• Job: Text
• Application Status: Text

vwRubyDuplicatePeopleIDList

• Duplicate People ID: Long *

vwRubyPreApplicationList

• 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

• 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

• First Name: Text
• Last Name: Text
• Cell Number: Text
• People ID: Long *
• Birth Date: DateTime
• ID Number: Text

vwRubyPreFilledPositionList

• 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

• 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

• 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

• 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

• 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

• Warning Letter Level ID: Long *
• Warning Letter Level: Text

Year LkUp

• Year ID: Long *
• Year Number: Long

zstblODBC_db BrNDON

• DBID (PK): Long
• SelectDB: Boolean
• DatabaseName: Text
• ServerName: Text *
• DBName: Text *
• Authentication: Text *
• UID: Text
• PWD: Text
• Driver: Text *
• DateAdded: DateTime *

zstblODBC_db

• DBID (PK): Long
• SelectDB: Boolean
• DatabaseName: Text
• ServerName: Text *
• DBName: Text *
• Authentication: Text *
• UID: Text
• PWD: Text
• Driver: Text *
• DateAdded: DateTime *

zstblODBC_tables

• TableID (PK): Long
• Link: Boolean
• Hidden: Boolean
• DatabaseName: Text
• TableName: Text
• SourceTableName: Text
• AfterDDL: Text
• Comment: Text
• DateAdded: DateTime *