Alias:IVSSC#

(INF_CV_SCALES)

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.

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	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)
CREATE_DATE	Date()		This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CREATE_USER	Varchar2(30)		This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_DATE	Date()		This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_USER	Varchar2(30)		This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.

---

Notes #

Click to create a new notes page