Using Excel, create a sample data dictionary for the employee function (minimum 15 data fields).

Create a data dictionary for one of the functions listed below and have 15 fields. Use the example below to help answer the question.

Thanks.

1

Develop a Data Dictionary List the functions that need to be tracked on the HRIS: Salary Administration Training & Development (T&D) Recruitment & Selection Time Management (TMS) Succession Planning Performance Management Job Evaluation . Benefits Skill Inventories Health & Safety Labour Relations Staffing Property Information Payroll The priority level of each function (ie., the functions of HR which must be managed through HRIS must be identified and prioritized). The data fields (or individual pieces of information) to be tracked on the system. Data fields refer to every minute piece of data the system must hold (imagine a screen for each HR function with each box on the screen being an individual data element). A definition for each data field. This involves documenting the characteristics required for each field of information. Examples include, the length of the field, the format (ie. text, number, currency, decimals, %, color coding, etc.). Documenting current information needs is most important; however, it is advisable to document highly possible future needs in a separate section. Here's a Data Dictionary example. Function Field Salary Administration Name Pay Definition 30 characters Alpha French option Hyphens 10 digits 3 decimal $, , 1 character Alpha 4 digits, % 8 characters Alpha-numeric Hyphen Pay Period Compa-Ratio Job ID