[{TableOfContents }]
!!!SCALE INTERFACE FILE

The Scale Interface File screen is used to import salary scales and steps into the software data structures.

Scale Interface File data is maintained on the [INF_CV_SCALES] table.

;[ID|ID]:This field identifies the scale record within the data base.
|[ENTITY_CODE]|Varchar2(16)|Y|Validation: 	Must be a valid entity code defined on [P2K_CM_ENTITIES].
|[UNIT_CODE]|Varchar2(16)|Y|Validation:	Must be a valid unit code defined on [P2K_CM_UNITS].
|[SCALE_CODE]|Varchar2(16)|Y|Validation:	Must be a unique scale code for the unit specified.
|[SCALE_DESCRIPTION|DESCRIPTION]|Varchar2(50)| |
|[RATE_MATRIX_CODE]|Varchar2(16)| |
|[WAGE_STEP_RULE_CODE]|Varchar2(16)| |
|[STEP_CODE]|Varchar2(16)| |Validation:	Must be a unique step code for the scale specified.
|[STEP_SEQUENCE]|Number(5)| |
|[EFFECTIVE]|Date()| |Validation:	Must be a valid date format. Suggestion:	If you are not loading multiple date-effective records for the same scale/step code, then populate this field with a constant ‘01-Jan-0001’ which represents the beginning of time.
|[EXPIRY]|Date()| |Validation:	Must be a valid date format, with a date after the effective date. Suggestion:	If you are not loading multiple date-effective records for the same scale/step code, then populate this field with a constant ‘31-Dec-3999’ which represents the end of time.
|[CHANGE_CODE]|Varchar2(16)| |Validation:	The Change Code provided must be defined on [P2K_CM_CHANGE_REASONS]
|[RATE_BASIS]|Varchar2(30)| |Validation: 	If provided, must be one of the fixed lexicon values from [X_RATE_BASIS]
|[SCALE_RATE]|Number(18)| |
|[CELL_NUMBER]|Number(5)| |

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

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

}]