Skip to main content

Census Data Fields

The Census Data file template column headers are color-coded to help you identify required fields, optional fields and fields for Admin use only.

Required Fields (Green) 

In the Census Data file, these are required fields: 

  • Employee ID 

  • Employee Name 

  • Company Department 

  • Company Job Title 

  • Date of Hire 

  • Manager ID*

  • Country 

  • Work Location

  • Currency 

  • Base Salary 

  • Pay Basis 

  • Employment Type

  • Employment Status 

We only require the Work Hours per Week field to be filled out if you have PT employees. 

*Manager ID is optional, unless Manager Name is included (if a Manager Name is entered, Manager ID is required).

Optional Fields

In the Census Data file, these fields are optional and may or may not apply to your company: 

Manager Name

Performance Rating

Exemption Status 

Total # of Shares Granted

Gender 

Total # of Unvested Shares

Target Bonus (Amount) 

New Hire Grant Amount

Target Bonus (%) 

Date of Last Grant

Target Commission (Amount) 

Last Grant Amount

Total Commission (%) 

Type of Last Grant Amount

Last Date of Increase 

Other Kamsa Fields

In the Census Data file, the header for these fields are shaded in gray, and can be left blank. However, Admin users can choose to enter data for any of these other optional fields, and Kamsa will incorporate them accordingly.

Business Title

Kamsa Job Level

Kamsa Job Code

Market Data Cut

Note: The available Kamsa Job Codes and Market Data Cut to choose from are listed in the Kamsa Jobs & Data Cuts tab for reference.