Skip to main content
Skip table of contents

PYHR - DERVx

Salary Index Default Logic
Code Category: PYHR
Code Value: DERVx — It can be followed with x (x being any other characters including a blank).
Short Description: Not used.
Medium Description: Not Used.
Long Description: Not Used.
Associated Numeric Values
1-5: Reserved for future use.
Associated Codes
1: This field controls how the first part of the salary index will be created. Enter one of the salary index creation code options listed below.
2: This field controls how the second part of the salary index will be created. Enter one of the salary index creation code options listed below.
3: This field controls how the third part of the salary index will be created. Enter one of the salary index creation code options listed below.
4: This field controls how the fourth part of the salary index will be created (if a 4-part salary index is used). Enter one of the salary index creation code options listed below.
5: This field is used to store a user defined selection criteria value for determining active records to process from EXPRINFO, EDUCINFO, and CRSEUNIT. A default code of "SLRY" is also supported.
Salary Index Code Options:

  • If the Associated Code value equals "JOB-SCHED," the index key part is defined as the schedule code from the Job Codes table based on the Job Code from the PCNTBLE entry for the pay assignment's PCN/Position combination.
  • If the Associated Code value equals "JOB-RANGE," the index key part is defined as the range code from the Job Codes table based on the PCNTBLE entry for the pay assignment's PCN/Position combination.
  • If the Associated Code value equals "PCN-SCHED," the index key part is defined as the schedule from the PCNTBLE entry for the pay assignment's PCN/Position combination.
  • If the Associated Code value equals "PCN-RANGE," the index key part is defined as the range from the PCNTBLE entry for the pay assignment's PCN/Position combination.
  • If the Associated Code value equals "PCN-STEP," the index key part is defined as the step from the PCNTBLE entry for the pay assignment's PCN/Position combination.
  • If the Associated Code value equals "DEGREE" and a common code entry for "PYHR" "DEGREE" is undefined, return the index key part value as "NoDgreCCode."
  • If the Associated Code value = "DEGREE" and a common code entry for "PYHR" "DEGREE" is defined, derive the index key part in the following manner.
  • For each Associated Code and Description Field, if it is not blank or empty (contains a degree code), use its value in attempting to find a match in the EDUCINFO table for the employee where the degree is like the CC's value and one of the EDUCINFO entry misc fields (1 thru 5) = either "SLRY" or a misc value previously defined in Associated Code #5 field of the CC entry which defines the index key." Look at each of the CC entry values until a match is found or no more fields exist. If a match is found, return the maximum degree as the index key part. If no match is found - Return index key part as "NoDegreFnd."
  • If the Associated Code value is like "IN-HOUSE," derive the index key part in the following manner: Select the sum of the "In House" values from the EXPRINFO table for the employee where Misc Code 1 or 2 = "SLRY" or a previously defined value from the Associated Code #5 field of the "PYHR" "DERV* " CC entry which defines the index key. The sum is truncated to a non-decimal value. If no records exist for the employee - 0 is returned.
  • If the Associated Code value is like "PRE-EMPL," derive the index key part in the following manner:Select the sum of the "Pre-Employment" values from the EXPRINFO table for the employee where Misc Code 1 or 2 = "SLRY" or a previously defined value from the Associated Code #5 field of the "PYHR" "DERV*" CC entry which defines the index key. The sum is truncated to a non-decimal value. If no records exist for the employee - 0 is returned.
  • If the Associated Code value is like "EXPR-SUM," derive the index key part in the following manner:Select the sum of the "In House" values from the EXPRINFO table for the employee where Misc Code 1 or 2 = "SLRY" or a previously defined value from the Associated Code #5 field of the "PYHR" "DERV*" CC entry which defines the index key. .Select the sum of the "Pre-Employment" values from the EXPRINFO table for the employee where Misc Code 1 or 2 = "SLRY" or a previously defined value from the Associated Code #5 field of the "PYHR" DERV*" CC entry which defines the index key. .Add both sums together to form the index key part. The sum is truncated to a non-decimal value. If no records exist for the employee - 0 is returned.
  • If the Associated Code value is like "ACCPTED1," derive the index key part in the following manner:Select the sum of the "Accepted 1" values from the CRSEUNIT table for the employee where Misc Code 1 or 2 = "SLRY" or a previously defined value from the Associated Code #5 field of the "PYHR" "DERV*" CC entry which defines the index key." The sum is truncated to a non-decimal value and returned as the index key part. If no records exist for the employee - 0 is returned.
  • If the Associated Code value is like "ACCPTED2," derive the index key part in the following manner:Select the sum of the "Accepted 2" values from the CRSEUNIT table for the employee where Misc Code 1 or 2 = "SLRY" or a previously defined value from the Associated Code #5 field of the "PYHR" "DERV*" CC entry which defines the index key." The sum is truncated to a non-decimal value and returned as the index key part. If no records exist for the employee - 0 is returned
  • If the Associated Code value is like "CRSE-SUM," derive the index key part in the following manner:Select the sum of the "Accepted 1" values from the CRSEUNIT table for the employee where Misc Code 1 or 2 = "SLRY" or a previously defined value from Associated Code #5 field of the "PYHR" "DERV" CC entry which defines the index key." Return the sum as the index key part. Select the sum of the "Accepted 2" values from the CRSEUNIT) table for the employee where Misc Code 1 or 2 = "SLRY" or a previously defined value from the Associated Code #5 field of the "PYHR" "DERV" CC entry which defines the index key." Return the sum as the index key part. Add both sums together to form the index key part. The sum is truncated to a non-decimal value and returned as the index key part. If no records exist for the employee - 0 is returned.
  • For any numeric value that is returned as an index key part (i.e., IN-HOUSE), if the definition contains a PAD1, PAD2 or PAD3 in it, left pad the numeric value with zeros to the appropriate position (i.e., PAD2 means 11 => 0011). The padding will not exceed a total length of four for the numeric n-value.

Associated Descriptions
1-5: Reserved for future use.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.

Contact Support Close