Tables installed with Human Resources

Human Resources Application: Core plugin adds the following tables.
Table Description
HR Beneficiary

[sn_hr_core_beneficiary]

Subject tables (HR services).
HR Benefit

[sn_hr_core_benefit]

Subject tables (HR services).
HR Benefit Plan

[sn_hr_core_benefit_provider]

Providers for benefits.
HR Benefit Type

[sn_hr_core_benefit_type]

Types of benefits.
HR Case

[sn_hr_core_case]

Base table for HR cases. The details of a submitted HR case.
HR Condition

[sn_hr_core_condition]

Details of HR conditions used as filters for any HR table.
HR Conditions for Criteria

[sn_hr_core_m2m_condition_criteria]

Details of HR conditions used as filters for HR Criteria.
HR Contact

[sn_hr_core_contact]

Basic contact information for HR contacts (relating to an HR profile).
HR Criteria

[sn_hr_core_criteria]

Details of HR criteria used to define audiences for HR content.
HR Criteria for Links

[sn_hr_core_m2m_link_template]

M2M between HR links and template lookup.
HR Disability Benefit

[sn_hr_core_disability_benefit]

Subject table (disability benefit).
HR Disciplinary Issue Type

[sn_hr_core_disciplinary_issue_type]

Types of employee performance issues.
HR Disciplinary Warning Type

[sn_hr_core_disciplinary_warning_type]

Types of employee performance warnings.
HR Document Acknowledgement

[sn_hr_core_document_acknowledgement]

Stores document acknowledgement instances.
HR Document Template

[sn_hr_core_document_template]

Stores the PDF templates for services that generate letters.
HR Document Type

[sn_hr_core_document_type]

Details of document type for HR document templates.
  • Employment Verification Letter
HR Employee Relations Case

[sn_hr_core_case_relations]

Details of an employee relations case.
HR Health Benefit

[sn_hr_core_health_benefit]

Subject table (benefit).
HR Insurance Benefit

[sn_hr_core_insurance_benefit]

Subject table (insurance benefits).
HR Lifecycle Events Case

[sn_hr_le_case]

Details of a submitted Lifecycle event case.
  • Account Notification
  • Request Onboarding

    Extends the HR Case [sn_hr_core_case] table.

Lifecycle Event Type

[sn_hr_le_type]

Lifecycle Event Types are a way to organize activity sets and activities together. Lifecycle Event Types are used as a container for activity sets and activities. Lifecycle Event Types are also associated with an HR Service.
HR Operations Report

[sn_hr_core_op_report]

Subject table (reports).
HR Operations Report Frequency

[sn_hr_core_op_report_frequency]

HR operational report frequencies (monthly, weekly, and others).
HR Operations Report Type

[sn_hr_core_op_report_type]

Type of HR report requested.
HR Operations System

[sn_hr_core_op_system]

Operations system for a report (payroll, HR, and others).
HR Operations System to Report Type

[sn_hr_core_op_system_to_report_type]

Type of HR report by system.
HR Payroll Case

[sn_hr_core_case_payroll]

Payroll HR cases.
HR PDF Template

[sn_hr_core_pdf_template]

Details of HR .pdf document templates.
  • Employment verification letters
  • Offer letter
  • Sample education agreement

    Extends HR Document Template.

HR Portal Content

[sn_hr_core_link]

Details of content that displays on the HR Service Portal.
  • Holiday Calendars
  • Links to information about the company, executive team, product documentation, suggested reading, community, blogs, and more.
  • Videos, tutorials
HR Profile

[sn_hr_core_profile]

Subject table (profile).
HR Retirement Benefit

[sn_hr_core_retirement_benefit]

Subject table (retirement benefit).
HR Service

[sn_hr_core_service]

Details of HR Services offered to employees.
HR Service Approval Option

[sn_hr_core_service_approval_option]

HR Service Option

[sn_hr_core_service_option]

HR Talent Management Case

[sn_hr_core_case_talent_management]

Details of a submitted Talent Management case.
  • Candidate offer
  • Employee travel visa request
  • Request background check
  • Request drug screen
  • Work visa transfer request
HR Task

[sn_hr_core_task]

The base table for HR tasks. The details of a task associated with a particular HR case.
HR Template

[sn_hr_core_template]

Details of hr templates used to populate fields automatically for HR cases.

Extends Template table [sys_template].

HR Tier Escalation

[sn_hr_core_tier_definition]

Details of the HR groups used for case escalation.
HR Total Rewards Case

[sn_hr_core_case_total_rewards]

Total Rewards/Benefits based HR cases.
HR Visa Category

[sn_hr_core_visa_category]

Type of travel visa. The base system provides business and work visa categories.
HR Workday Department Interface

[sn_hr_wday_cmn_department_int]

Workday interface table for departments.
HR Workday DS Interface

[sn_hr_wday_data_import]

Workday interface for worker data.
HR Workday ID Cross Reference

[sn_hr_wday_id_cross_reference]

Maps Workday and ServiceNow primary keys.
HR Workday Job Profiles Interface

[sn_hr_wday_job_profile_int]

Workday interface table for job profile.
HR Workday Job Tracker

[sn_hr_wday_job_tracker]

Tracks the workday sync jobs. When a run starts, a record is inserted in this table and updated at the end of the sync. The update includes the last run date and time and sync end date and time.
HR Workday Locations Interface

[sn_hr_wday_cmn_location_int]

Workday interface table for location.
HR Workforce Administration Case

[sn_hr_core_case_workforce_admin]

Details of Workforce Administration case such as personal information change requests, employment verification letter requests, onboarding tasks, and offboarding tasks.
HRIT Operations Case

[sn_hr_core_case_operations]

Details of a submitted Operation and HRIT cases.
  • HR Account Access Request
  • HR Accounts Inquiry
  • HR Portal Support Request
  • Password Reset
  • Report Inquiry
  • Report Request
  • Setup New Hire HR Profile

    Extends the HR Case [sn_hr_core_case] table.

Bank Account

[sn_hr_core_profile_bank_account]

Details of bank account for direct deposit.
Activity Set

[sn_hr_le_activity set]

Details of activity sets and activities that make up Lifecycle Events.
Activity

[sn_hr_le_activity]

Details of activities that are part of an activity set and together make up a Lifecycle Event.
Activity Field Mapping

[sn_hr_le_activity_field_mapping]

Details of an activity field mappings that pass information from the parent lifecycle event case to an activity.
Activity Status

[sn_hr_le_activity_status]

Activity Set Context

[sn_hr_le_activity_set_context]

Client Role Rule

[sn_hr_core_client_role_rule]

Details of mapping conditions to client roles.
CMDB HR Case Product Model

[cmdb_hr_case_product_model]

The product models used for HR case record producers.
Compensation

[sn_hr_core_compensation]

Details on compensation for an employee.
Compensation Bonus

[sn_hr_core_bonus]

Details on the type, percentage, and amount of bonus for an employee.

Extends the Compensation [sn_hr_core_compensation] table.

Compensation Salary

[sn_hr_core_salary]

Details of the salary and currency for an employee.

Extends Compensation [sn_hr_core_compensation] table.

Compensation Stocks

[sn_hr_core_stocks]

Details on amount, vesting schedule and dates, and quantity of stock for an employee.
Direct Deposit

[sn_hr_core_direct_deposit]

Direct deposit information for an employee.
Fulfiller Activity Configuration

[sn_hr_le_fulfiller_activity_config]

Details on Lifecycle Event Activities assigned and completed by a fulfiller.
Fulfiller Activity Configuration Mapping

[sn_hr_le_fulfiller_activity_config_mapping]

Details on information from Lifecycle Events Case Table passed to another table.
Job Profile

[sn_hr_core_job_profile]

Job profile description.
Lifecycle Event Type

[sn_hr_le_type]

Details of Lifecycle Event Types that are used to contain bundles and activities.
Matching Roles

[sn_hr_core_matching_roles]

Ordered Task

[sn_hr_core_service_template]

PDF Template Mapping

[sn_hr_core_pdf_template_mapping]

Position

[sn_hr_core_position]

Job position information.
Relationship

[sn_hr_core_relationship]

Signature Image

[signature_image]

Contains images of captured signatures.
Topic Category

[sn_hr_core_topic_category]

Details of topic categories used primarily to group common HR services and topic details for reporting purposes.
Topic Detail

[sn_hr_core_topic_detail]

Details of topic details that provide a more granular level of categorization for reporting purposes.
Tuition Reimbursement

[sn_hr_core_tuition_reimbursement]

Subject table (tuition reimbursement)
Who is covered

[sn_hr_core_who_is_covered]

Collects information on people covered by benefits of an employee.