Loading Salary Grade Detail Lines

  To load salary grade details:

1. Review the member and entry names for these Smart Lists, and ensure that the salary steps or sequences to load are defined:

   Table 27. Grade Step and Sequence Smart Lists

   Smart List	Associated Member Names	Entry Names
   Grade_Steps	Grade Step	Step1, Step2, and so on
   Grade_Sequence	Grade Sequence (for rate-based grades)	Sequence1, Sequence2, and so on

2. Create a file in a tool such as Microsoft Excel. Note: Although you can use a text editor, it is best to use a spreadsheet program to customize the sample code, because some text editors may not maintain the necessary line breaks.

3. Copy and paste this code to the file:

   Budget Item,Data Load Cube Name,Point-of-View,Salary Grade Type Input,Grade Salary Basis Input,Allow Value Change Input,Element Start Date,Element End Date
   <LINEITEM("Element Changes")>,HCP,"BegBalance,Local,Grade 1,Budget,Stage 1,Unspecified Entity,No Year,Vacancy,Default Position",S_2,3000,01-01-2012,12-31-2012
   

4. Replace S_2 with the name of the grade step to load.

5. Specify the value of the grade in the Option Value column, and specify the dates during which the grade is effective.

   Example: To load a fourth grade step (S4) with an option value of $65,000 to be effective on April 1, 2011, specify:

   <LINEITEM("Element Changes")>,HCP,"BegBalance,Local,Grade 4,Budget,Stage 1,Unspecified Entity,Unspecified Element,FY12,Default Position",S4,65000,04-01-2011,

6. Save the file in CSV format.

7. Perform a test run of the CSV file. See Testing Load Files.

8. In the application, ensure the correctly salary data displays. See Verifying Data Loads.

9. After confirming that the file loads data properly, run it in the production environment. See Running Load Files .