Federal plugin reference

  • Release version: Washingtondc
  • Updated March 15, 2024
  • 4 minutes to read

    • Reference topics provide additional information about tables in Federal plugin.

    Components installed with Federal plugin

    Several types of components are installed with activation of the Federal (Additional tables for Federal Agencies) plugin, including tables.

    Tables installed

    Table 1. Tables installed with Federal plugin
    Table HCBRM subfunction
    Tenure

    [sn_fedtables_tenure]

    A1-2 Workforce Planning

    A2-6 New Hire In-Processing and Onboarding
    Computer Position

    [sn_fedtables_computer_position]

    		 A1-3 Position Classification and Position Management
    Cybersecurity Category/speciality Area

    [sn_fedtables_cybersecurity_category]

    		 A1-3 Position Classification and Position Management
    Functional Classification

    [sn_fedtables_functional_classification]

    		 A1-3 Position Classification and Position Management
    Occupation

    [sn_fedtables_occupation]

    		 A1-3 Position Classification and Position Management
    Occupational Category

    [sn_fedtables_occupational_category]

    		 A1-3 Position Classification and Position Management
    Position Sensitivity And Risk

    [sn_fedtables_position_sensitivity_and_risk]

    		 A1-3 Position Classification and Position Management
    Supervisory Status

    [sn_fedtables_supervisory_status]

    		 A1-3 Position Classification and Position Management
    Position Occupied

    [sn_fedtables_position_occupied]

    A1-3 Position Classification and Position Management

    A2-6 New Hire In-Processing and Onboarding

    A6-2 Retirement Planning and Processing
    Flsa Category

    [sn_fedtables_flsa_category]

    A1-3 Position Classification and Position Management

    A5-1 Compensation Management
    Language Identification

    [sn_fedtables_language_identification]

    		 A2-3 Candidate Assessment and Selection
    Listening Proficiency

    [sn_fedtables_listening_proficiency]

    		 A2-3 Candidate Assessment and Selection
    Speaking Proficiency

    [sn_fedtables_speaking_proficiency]

    		 A2-3 Candidate Assessment and Selection
    US Citizenship

    [sn_fedtables_us_citizenship]

    		 A2-3 Candidate Assessment and Selection
    Instructional Program

    [sn_fedtables_instructional_program]

    A2-3 Candidate Assessment and Selection

    A2-6 New Hire In-Processing and Onboarding
    Education Level

    [sn_fedtables_education_level]

    A2-3 Candidate Assessment and Selection

    A2-6 New Hire In-Processing and Onboarding

    A3-3 Learning Administration
    Veterans Preference

    [sn_fedtables_veterans_preference]

    A2-3 Candidate Assessment and Selection

    A2-6 New Hire In-Processing and Onboarding

    A6-2 Retirement Planning and Processing
    Security Clearance Level

    [sn_fedtables_security_clearance_level]

    A2-4 Applicant Screening, Reciprocity, and Investigation Request

    A2-6 New Hire In-Processing and Onboarding
    Current Appointment Authority

    [sn_fedtables_current_appointment_authority]

    		 A2-6 New Hire In-Processing and Onboarding
    Ethnicity And Race Identification

    [sn_fedtables_ethnicity_and_race_identification]

    		 A2-6 New Hire In-Processing and Onboarding
    Race Or National Origin

    [sn_fedtables_race_or_national_origin]

    		 A2-6 New Hire In-Processing and Onboarding
    Veterans Status (Active Military Service)

    [sn_fedtables_veterans_status]

    		 A2-6 New Hire In-Processing and Onboarding
    Service Obligation Type Code

    [sn_fedtables_service_obligation_type_code]

    A2-6 New Hire In-Processing and Onboarding

    A3-3 Learning Administration
    Type Of Appointment

    [sn_fedtables_type_of_appointment]

    A2-6 New Hire In-Processing and Onboarding

    A3-3 Learning Administration
    Annuitant Indicator

    [sn_fedtables_annuitant_indicator]

    A2-6 New Hire In-Processing and Onboarding

    A5-1 Compensation Management

    A5-3 Benefits Management

    A6-2 Retirement Planning and Processing
    Sex

    [sn_fedtables_sex]

    A2-6 New Hire In-Processing and Onboarding

    A5-3 Benefits Management
    Disability

    [sn_fedtables_disability]

    A2-6 New Hire In-Processing and Onboarding

    A5-3 Benefits Management

    A6-2 Retirement Planning and Processing
    Training Accreditation Indicator

    [sn_fedtables_training_accreditation_indicator]

    		 A3-3 Learning Administration
    Training Credit Designation Type Code

    [sn_fedtables_training_credit_designation_type_code]

    		 A3-3 Learning Administration
    Training Credit Type Code

    [sn_fedtables_training_credit_type_code]

    		 A3-3 Learning Administration
    Training Delivery Type Code

    [sn_fedtables_training_delivery_type_code]

    		 A3-3 Learning Administration
    Training Purpose Type Code

    [sn_fedtables_training_purpose_type_code]

    		 A3-3 Learning Administration
    Training Source Type Code

    [sn_fedtables_training_source_type_code]

    		 A3-3 Learning Administration
    Training Type Code

    [sn_fedtables_training_type_code]

    		 A3-3 Learning Administration
    Training Type Sub Code

    [sn_fedtables_training_type_sub_code]

    		 A3-3 Learning Administration
    Rating Of Record (Pattern)

    [sn_fedtables_rating_of_record_pattern]

    A4-1 Employee Performance Management

    A2-6 New Hire In-Processing and Onboarding

    A6-2 Retirement Planning and Processing
    Rating Of Record (Level)

    [sn_fedtables_rating_of_record_level]

    A4-1 Employee Performance Management

    A4-3 Performance Appraisal System Certification for SES and SL/ST
    Special Pay Table Identifier

    [sn_fedtables_special_pay_table_identifier]

    		 A5-1 Compensation Management
    Duty Station

    [sn_fedtables_duty_station]

    A5-1 Compensation Management

    A1-3 Position Classification and Position Management

    A2-6 New Hire In-Processing and Onboarding

    A5-3 Benefits Management
    Pay Rate Determinant

    [sn_fedtables_pay_rate_determinant]

    A5-1 Compensation Management

    A2-6 New Hire In-Processing and Onboarding
    Pay Basis

    [sn_fedtables_pay_basis]

    A5-1 Compensation Management

    A2-6 New Hire In-Processing and Onboarding

    A6-2 Retirement Planning and Processing
    Pay Status

    [sn_fedtables_pay_status]

    A5-1 Compensation Management

    A2-6 New Hire In-Processing and Onboarding

    A6-2 Retirement Planning and Processing
    Work Schedule

    [sn_fedtables_work_schedule]

    A5-2 Work Schedule and Leave Management

    A2-6 New Hire In-Processing and Onboarding

    A6-1 Separation Counseling

    A6-2 Retirement Planning and Processing
    Alternate Work Schedule Code

    [sn_fedtables_alternate_work_schedule_code]

    A5-2 Work Schedule and Leave Management

    A5-1 Compensation Management
    Benefits Continuation Federal Employees Group Life Insurance Fegli Indicator

    [sn_fedtables_benefits_continuation_fed_emp_group_life_insurance_fegli_flag]

    		 A5-3 Benefits Management
    Benefits Continuation Federal Employee Health Benefits Fehb Indicator

    [sn_fedtables_benefits_continuation_fed_emp_health_benefits_fehb_flag]

    		 A5-3 Benefits Management
    Benefits Continuation Retirement Indicator

    [sn_fedtables_benefits_continuation_retirement_indicator]

    		 A5-3 Benefits Management
    Benefits Continuation Termination Insufficient Pay Payment Type Code

    [sn_fedtables_benefits_payment_type_code]

    		 A5-3 Benefits Management
    Designation Of Fegli Beneficiaries Indicator

    [sn_fedtables_designation_of_fegli_beneficiaries_indicator]

    		 A5-3 Benefits Management
    Federal Employees Group Life Insurance

    [sn_fedtables_federal_employees_group_life_insurance]

    		 A5-3 Benefits Management
    Federal Employees Group Life Insurance Fegli Life Change Code

    [sn_fedtables_federal_employees_group_life_insurance_fegli_life_change_code]

    		 A5-3 Benefits Management
    Federal Employees Health Benefits Plan

    [sn_fedtables_federal_employees_health_benefits_plan]

    		 A5-3 Benefits Management
    Court Orders For Fegli Purposes Indicator

    [sn_fedtables_court_orders_for_fegli_purposes_indicator]

    A5-3 Benefits Management

    A6-2 Retirement Planning and Processing
    Eligibility To Participate In Telework Indicator

    [sn_fedtables_eligibility_to_participate_in_telework_indicator]

    		 A5-4 Work-Life Wellness / Employee Assistance Programming
    Retirement Plan

    [sn_fedtables_retirement_plan]

    		 A6-2 Retirement Planning and Processing
    Retirement Previous Coverage Indicator

    [sn_fedtables_retirement_previous_coverage_indicator]

    		 A6-2 Retirement Planning and Processing
    Fers Coverage

    [sn_fedtables_fers_coverage]

    A6-2 Retirement Planning and Processing

    A2-6 New Hire In-Processing and Onboarding

    A5-3 Benefits Management
    Agency/subelement

    [sn_fedtables_agency]

    		 ALL
    Grade Level Class Rank Or Pay Band

    [sn_fedtables_grade_level_class_rank_or_pay_band]

    		 ALL
    Legal Authority

    [sn_fedtables_legal_authority]

    		 ALL
    Nature Of Action

    [sn_fedtables_nature_of_action]

    		 ALL
    Pay Plan

    [sn_fedtables_pay_plan]

    		 ALL
    Personnel Office Identifier

    [sn_fedtables_personnel_office_identifier]

    		 ALL
    Record Action

    [sn_fedtables_record_action]

    		 ALL
    Remarks

    [sn_fedtables_remarks]

    		 ALL
    Citizenship Country Code

    [sn_fedtables_citizenship_country_code]
    Continued Service Agreement Required Indicator

    [sn_fedtables_continued_service_agreement_required_indicator]
    Reading Proficiency

    [sn_fedtables_reading_proficiency]
    Special Population Code

    [sn_fedtables_special_population_code]
    Writing Proficiency

    [sn_fedtables_writing_proficiency]
    Agency Personnel Action Data 1

    [sn_fedtables_agency_personnel_action_data]

    		 All
    Agency Subelement Name

    [sn_fedtables_agency_subelement_name]

    		 All
    Region Code

    [sn_fedtables_country_state_city_code]

    		 All
    City Code

    [sn_fedtables_country_state_city_code]

    		 All
    State Code

    [sn_fedtables_country_state_city_code]

    		 All
    County Code

    [sn_fedtables_country_state_city_code]

    		 All
    Fiscal Year Begin Date

    [sn_fedtables_fiscal_year_begin_end_dates]

    		 All
    Fiscal Year End Date

    [sn_fedtables_fiscal_year_begin_end_dates]

    		 All
    Fiscal Year Code

    sn_fedtables_fiscal_year_begin_end_dates

    		 All
    Nature of Action Legal Authority 1 Description

    [sn_fedtables_nature_action_legal_authority_desc]

    		 All
    Nature of Action Legal Authority 2 Description

    [sn_fedtables_nature_action_legal_authority_desc]

    		 All
    Nature of Action Agency Extension Code

    [sn_fedtables_nature_action_legal_authority_desc]

    		 All
    Nature of Action Legal Authority 2 Code

    [sn_fedtables_nature_of_action_legal_authority_code2]

    		 All
    Agency Division

    [sn_fedtables_organization_code]

    		 All
    Organization Name

    [sn_fedtables_organization_code]

    		 All
    Organization Code

    [sn_fedtables_organization_code]

    		 All
    Organization Code Line 1

    [sn_fedtables_organization_code]

    		 All
    Organization Code Line 2

    [sn_fedtables_organization_code]

    		 All
    Organization Code Line 3

    [sn_fedtables_organization_code]

    		 All
    Organization Code Line 4

    [sn_fedtables_organization_code]

    		 All
    Organization Code Line 5

    [sn_fedtables_organization_code]

    		 All
    Organization Code Line 6

    [sn_fedtables_organization_code]

    		 All
    Organization Code Line 7

    [sn_fedtables_organization_code]

    		 All
    Organization Code Line 8

    [sn_fedtables_organization_code]

    		 All
    Organization Description Line 1

    [sn_fedtables_organization_code]

    		 All
    Organization Description Line 2

    [sn_fedtables_organization_code]

    		 All
    Organization Description Line 3

    [sn_fedtables_organization_code]

    		 All
    Organization Description Line 4

    [sn_fedtables_organization_code]

    		 All
    Organization Description Line 5

    [sn_fedtables_organization_code]

    		 All
    Organization Description Line 6

    [sn_fedtables_organization_code]

    		 All
    Organization Description Line 7

    [sn_fedtables_organization_code]

    		 All
    Organization Description Line 8

    [sn_fedtables_organization_code]

    		 All
    Agency Personnel Action Data 1

    [sn_fedtables_agency_personnel_action_data]

    		 All
    Agency Personnel Action Data 2

    [sn_fedtables_agency_personnel_action_data]

    		 All
    Agency Personnel Action Data 3

    [sn_fedtables_agency_personnel_action_data]

    		 All
    Agency Personnel Action Data 4

    [sn_fedtables_agency_personnel_action_data]

    		 All
    Agency Personnel Action Data 5

    [sn_fedtables_agency_personnel_action_data]

    		 All