[{TableOfContents }]
!!!MATRICES INTERFACE FILE

The Matrices Interface File screen is used to import salary review matrices into the software data structures.

Matrices Interface File data is maintained on the [INF_CV_MATRICES] table.

;[ID|ID]:This field identifies the salary review matrix record within the data base.
;[Entity|ENTITY_CODE]:The entity that the matrix is associated with will be displayed in this field.
;[Salary Matrix|MATRIX_CODE]:This field identifies the name of the matrix.
;[Start Date|MATRIX_START_DATE]/[End Date|MATRIX_END_DATE]:If the matrix is time sensitive, these fields provide the dates the matrix is in effect.
;[Description|DESCRIPTION]:This field provides a description of the matrix.
;[Overall Rating|OVERALL_RATING]:This is the rating that is being tracked for this record in the matrix.
;[Low Comparison Ratio|LOW_COMPA_RATIO]:This field shows the lowest level of compa-ratio that is being defined in this record.
;[High Comparison Ratio|HIGH_COMPA_RATIO]:This field holds the applicable high level of compa-ratio being defined in this record.
;[Minimum %|MINIMUM_PERCENT]:For each rating/approval record, this field defines the minimum percent (of the range rule applicable) that is allowed for an employee with this approval rating and compa-ratio.
;[Maximum %|MAXIMUM_PERCENT]:For each rating/approval record, this field defines the maximum percent (of the range rule applicable) that will be allowed for an employee with this approval rating and compa-ratio.
;[Recommended %|RECOMMENDED_PERCENT]:For each rating/approval record, this field defines the company-recommended percentage (of the range rule applicable) that should be awarded to an employee with this approval rating and compa-ratio.
;[Compa Ratio Limit|COMPA_RATIO_LIMIT]:This field allows you to specify the maximum salary range that an employee at this overall rating/compa ratio level is allowed to earn.
;[Auto Approval|AUTO_APPROVAL]:
;[Maximum Points|MAXIMUM_POINTS]:
;[Minimum Points|MINIMUM_POINTS]:

[{If var='loginstatus' contains 'authenticated'

----
![Discussion|Edit:Internal.IVSMX] 	
[{InsertPage page='Internal.IVSMX' default='Click to create a new discussion page'}] 	

}]


;[Matrix|MATRIX_CODE]:This is the name of the matrix that is being created. It is not necessary to include the name of the unit, or the range rule that this matrix is used for, in the matrix name. 

;[Entity|ENTITY_CODE]:Salary matrices must be associated with an entity.  

;[Start Date|MATRIX_START_DATE]:Over time, the values of the compa-ratios, and the percentages of wages that apply, may change.  This field allows you to define the dates during which the matrix is applicable. 

;[End Date|MATRIX_END_DATE]:This field shows the date after which the matrix will no longer be valid/applicable.  There is no restriction made by the system on how long a matrix may be valid. 

;[Description|DESCRIPTION]:This field allows you to enter a description of the matrix code created. 

;[Overall Rating|OVERALL_RATING]:This is the rating that is being tracked for this record in the matrix. Overall_Rating is a required, user-defined lexicon ([X_OVERALL_RATING]), which you may choose from the list of values.\\ \\For each matrix code there may be many records based on the number of rating levels being used by the company. After one record is defined, use the Add icon to add a 2nd, 3rd, etc. record. Once more than one record has been saved, use the up/down arrow buttons on the horizontal toolbar to move amongst the records.

;[Low Compa-Ratio|LOW_COMPA_RATIO]:This field shows the lowest level of compa-ratio that is being defined in this record.  For each Overall Rating entry record there will be both a low and high compa-ratio. 

;[High Compa-Ratio|HIGH_COMPA_RATIO]:This field holds the applicable high level of compa-ratio being defined in this record.  Users will enter multiple records for each Overall Rating entry, and each will have a low and high compa-ratio. \ \\The low and high compa-ratios may not overlap. Please see the example, below.\\ \\Example: Matrix Code:  Salary-Clerical, etc.

||__Record #__||__Overall Rating__||__Low Compa-Ratio__||__High Compa-Ratio__
|1|Meets Expectations|0.0|0.49
|2|Meets Expectations|0.5|0.79
|3|Meets Expectations|0.8|1.19
|4|Meets Expectations|1.2|9.99
|5|Exceeds Expectations|0.0|0.49
|6|Exceeds Expectations|0.5|0.79

The Percentage Area is used to hold the recommended salary level that should be awarded to employees with various overall ratings and current compa-ratios. For each combination of level/compa-ratio, companies define a recommended percentage and a minimum and maximum point that will control the salary changes that may be made.

;[Minimum Percent|MINIMUM_PERCENT]:For each rating/approval record, this field defines the minimum percent (of the range rule applicable) that is allowed for an employee with this approval rating and compa-ratio.  

;[Maximum Percent|MAXIMUM_PERCENT]:For each rating/approval record, this field defines the maximum percent (of the range rule applicable) that will be allowed for an employee with this approval rating and compa-ratio.  

;[Recommended Percent|RECOMMENDED_PERCENT]:For each rating/approval record, this field defines the company-recommended percentage (of the range rule applicable) that should be awarded to an employee with this approval rating and compa-ratio. This percentage may be used by programs to create a pending personnel action form. Managers would then have the capability of raising or lowering the salary within the recommended minimum and maximum percent ratings, above. 

;[Compa-Ratio Limit|COMPA_RATIO_LIMIT]:This field allows you to specify the maximum salary range that an employee at this overall rating/compa ratio level is allowed to earn.  For example, if an employee is at a high level of salary, the current salary percent increase may take him/her to a salary level (compa-ratio) that is over the company limit. This field is used to maximize the compa-ratio that will result from the percentage increase, and therefore is used to maximize the salary an employee can earn. 

;[Auto Approval|AUTO_APPROVAL]:If personnel action forms are to be created as pre-approved for this overall rating/compa ratio level, this flag may be turned on.  If left off (blank), personnel action forms resulting from this level will not be automatically approved.