This page (revision-6) was last changed on 26-Nov-2021 10:22 by JMyers

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
6 26-Nov-2021 10:22 1 KB JMyers to previous
5 26-Nov-2021 10:22 1 KB JMyers to previous | to last
4 26-Nov-2021 10:22 884 bytes JMyers to previous | to last
3 26-Nov-2021 10:22 754 bytes JMyers to previous | to last
2 26-Nov-2021 10:22 1 KB JMyers to previous | to last
1 26-Nov-2021 10:22 2 KB JMyers to last

Page References

Incoming links Outgoing links
IVSSC
IVSSC

Version management

Difference between version and

At line 1 changed 2 lines
[{TableOfContents }]
!!!SCALE INTERFACE FILE
!!!Alias:[IVSSC]
(INF_CV_SCALES)
At line 4 changed one line
The Scale Interface File screen is used to import salary scales and steps into the software data structures.
The INF_CV_SCALES table is used to import salary scales and steps into the software data structures. Wage scales, defined by unit, are the schedules of wage and salary rates for an organization. Scales have at least one and may have multiple steps. Wage scale steps define the increments within the wage scale and stepping sequence of the steps.
At line 6 changed one line
Scale Interface File data is maintained on the [INF_CV_SCALES] table.
Tables loaded:
*[P2K_SA_WAGE_SCALES] (first record for each scale only)
*[P2K_SA_WAGE_SCALE_STEPS] (first record for each step within a scale)
*[P2K_SA_WAGE_STEP_DETAILS] (first record and subsequent effective splits for each step)
!!Table Columns
\\
||Column name||Data Type / Size||Mand.||Notes
|[ID]|Number(10)| |Used internally to define a unique identification for the record. This field would not be loaded.
|[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)| |
At line 8 changed 15 lines
;[ID|ID]:This field identifies the scale record within the data base.
;[Entity|ENTITY_CODE]:Each scale must be associated with an entity which may be identify in this field.
;[Unit|UNIT_CODE]:Each scale must be associated with a unit which may be identified in this field.
;[Scale|SCALE_CODE]:This field holds the name of the scale.
;[Description|SCALE_DESCRIPTION]:This field provides a description of the scale.
;[Rate Matrix|RATE_MATRIX_CODE]:This field holds the rate matrix associated with a matrix cell with a step within the scale.
;[Wage Step Rule|WAGE_STEP_RULE_CODE]:The stepping rule for the wage scale is identified here.
;[Scale/Step|STEP_CODE]:This field will display the name of the scale step.
;[Seq #|STEP_SEQUENCE]:This field defines the sequential order of the wage steps.
;[Effective As Of|EFFECTIVE]:This field displays the date the wage is effective.
;[Expires On|EXPIRY]:This field displays the date the wage expires.
;[Change Reason|CHANGE_CODE]:This field displays the reason for the rate change.
;[Basis|RATE_BASIS]:This field shows the time basis the rate is expressed in and how often it is earned.
;[Scale Rate|SCALE_RATE]:This is the rate, based on the rate basis, defined for the step.
;[Cell Number|CELL_NUMBER]:Cells are a specific point on the Define Rate Matrices ([ISRM]) form. This cell number is placed on several different scales and but control its rate through the matrix.
[{If var='loginstatus' contains 'authenticated'
At line 25 changed 2 lines
![Notes|Edit:Internal.IVSSC]
[{InsertPage page='Internal.IVSSC' default='Click to create a new notes page'}]
![Discussion|Edit:Internal.IVSSC]
[{InsertPage page='Internal.IVSSC' default='Click to create a new discussion page'}]
At line 28 changed one line
}]
This page (revision-6) was last changed on 26-Nov-2021 10:22 by JMyersTop