This page (revision-7) 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
7 26-Nov-2021 10:22 2 KB jmyers to previous AUTO_APPROVAL ==> AUTO_APPROVAL(Field)
6 26-Nov-2021 10:22 2 KB JMyers to previous | to last
5 26-Nov-2021 10:22 2 KB JMyers to previous | to last
4 26-Nov-2021 10:22 6 KB JMyers to previous | to last
3 26-Nov-2021 10:22 1 KB JMyers to previous | to last
2 26-Nov-2021 10:22 844 bytes JMyers to previous | to last
1 26-Nov-2021 10:22 1 KB JMyers to last

Page References

Incoming links Outgoing links
IVSMX
IVSMX

Version management

Difference between version and

At line 1 changed 2 lines
!!!Alias: [IVSMX]
(INF_CV_MATRICES)
[{TableOfContents }]
!!!MATRICES INTERFACE FILE
At line 4 changed one line
The INF_CV_MATRICES table is used to import salary review matrices into the software data structures.
The Matrices Interface File screen is used to import salary review matrices into the software data structures.
At line 6 changed 22 lines
Tables loaded:
*[P2K_SA_SALARY_MATRICES]
*[P2K_SA_SALARY_MATRIX_DETAILS]
!!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 already defined on [P2K_CM_ENTITIES].
|[MATRIX_CODE]|Varchar2(16)|Y|
|[MATRIX_START_DATE]|Date()|Y|Validation: Must be a valid date
|[MATRIX_END_DATE]|Date()| |Validation: Must be a valid date
|[DESCRIPTION]|Varchar2(50)| |
|[OVERALL_RATING]|Varchar2(30)|Y|Validation: Must be one of the fixed lexicon values from [X_OVERALL_RATING]
|[LOW_COMPA_RATIO]|Number(5)|Y|
|[HIGH_COMPA_RATIO]|Number(5)|Y|
|[MINIMUM_PERCENT]|Number(5)| |
|[MAXIMUM_PERCENT]|Number(5)| |
|[RECOMMENDED_PERCENT]|Number(5)| |
|[COMPA_RATIO_LIMIT]|Number(5)| |
|[AUTO_APPROVAL]|Varchar2(4)| |Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N” , “NO” or “0”. All other values will translate to True.
|[MAXIMUM_POINTS]|Number(5)| |
|[MINIMUM_POINTS]|Number(5)| |
Matrices Interface File data is maintained on the [INF_CV_MATRICES] table.
At line 8 added 14 lines
;[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(Field)]: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.
;[Maximum Points|MAXIMUM_POINTS]/[Minimum Points|MINIMUM_POINTS]:These fields will show the maximum and minimum points a candidate may obtain for an assessment.
At line 30 removed 2 lines
[{If var='loginstatus' contains 'authenticated'
At line 33 changed 2 lines
![Discussion|Edit:Internal.IVSMX]
[{InsertPage page='Internal.IVSMX' default='Click to create a new discussion page'}]
![Notes|Edit:Internal.IVSMX]
[{InsertPage page='Internal.IVSMX' default='Click to create a new notes page'}]
At line 36 changed one line
}]
This page (revision-7) was last changed on 26-Nov-2021 10:22 by jmyersTop