Predefined Source IDs and Result IDs for Configurable Matrices

Appendix: Predefined Source IDs and Result IDs for Configurable Matrices

This appendix contains a list of predefined source IDs and result IDs that are delivered with PeopleSoft Human Resources Manage Base Compensation.

Predefined Source IDs

This is a list of the predefined source IDs delivered as system data. Use these source IDS to define and maintain inputs used in configurable matrices.

SOURCE_ID	SOURCE_TYPE_ID	Label	Description
COUNTRY	ADDRESS	Country	Country of Business Address
SENIORITY_DATE	DATES	Seniority Date	Seniority Date
ANNUAL_RATE	EMPINFO	Annual Rate	Annual Comp Rate
APPOINTMENT_TYPE	EMPINFO	Appt type	Appointment Type
BARGAINING_UNIT	EMPINFO	Unit	Bargaining Unit
BEN_STATUS	EMPINFO	Benefit Status	Benefit Status
BENEFIT_SYSTEM	EMPINFO	Benefit System	Benefit System
BUSINESS_UNIT	EMPINFO	Business Unit	Business Unit
COMPANY	EMPINFO	Company	Company
COMPRATE	EMPINFO	Base Rate	Base Compensation Rate
DEPARTMENT	EMPINFO	Department	Department of Employee
EEO_CLASS	EMPINFO	EEO Class	EEO Classification
EMPL_CLASSIFICATION	EMPINFO	Empl Class	Employee Classification
EMPL_CTG	EMPINFO	Empl Category	Employee Category
EMPL_STATUS	EMPINFO	Payroll Status	Employee Payroll Status
EMPL_TYPE	EMPINFO	Employee Type	Employee Type
FLSA_STATUS	EMPINFO	FLSA Status	FLSA Status
GRADE	EMPINFO	Grade	Grade
JOBCODE	EMPINFO	Job Code	Job Code
LOCATION	EMPINFO	Location	Employee Location
PERSON_NAME	EMPINFO	Name	Person Name
SAL_ADMIN_PLAN	EMPINFO	Sal Admin Plan	Salary Administration Plan
STEP	EMPINFO	Sal Step	Salary Grade Step
UNION_CODE	EMPINFO	Union	Union Code
EMPL_GRD_MAXHRLY	EMPRELATED	GradeMaxHourly	Hourly Rate of Grade Maximum
MANAGER_LEVEL	EMPRELATED	Manager Level	Manager Level of Job
GEOGAREA	GEOGRAPHY	Geog Area	Geographical Area
POS_SUPV_LVL	POSITION	Pos Supr Level	Position Supervisor Level
PERFRATING	RATING	Perf Rating	Test Perf Rating
COMPA-RATIO	RATIOS	Compa-Ratio	Compa Ratio
JOB-RATIO	RATIOS	Job Ratio	Job Ratio
PERCENT-IN-RANGE	RATIOS	% in Range	Percent in Range
GRD1STEP1_HRLY	STEPRATE	Grd1Step1_Hrly	Hourly Rate of Grade 1 Step 1
COMPCODE	SUPPLIED	CompCode	Comp Code
CURRENCY	SUPPLIED	Currency	Currency Code
EMPLID	SUPPLIED	EmplID	Employee ID
SURVEY_JOB_CODE	SUPPLIED	Survey Job Code	Survey Job Code
SURVEY_PROVIDER	SUPPLIED	Survey Provider	Survey Provider
MONTHS_IN_COMPANY	TIMESPAN	MonthsofService	Months in Company

Predefined Result IDs

This is a list of the predefined result IDs delivered as system data. You can also create additional result IDs. Use these values to define outputs for configurable matrices.

Result_ID	RESULT_TYPE_ID	Label	Description
AWARD	SIMPLECHAR	Award	Variable Comp Award
CURRENCY	SIMPLECHAR	Currency	Currency
PROVIDER	SIMPLECHAR	Provider	Survey Provider
PROVIDER_DESCRIPTION	SIMPLECHAR	Provider Desc	Survey Provider Description
SALARY_SURVEY_DEFAULT	SIMPLECHAR	Survey Defaul	Salary Survey Default
SOURCE_REFERENCE	SIMPLECHAR	Source Ref	Source Reference
SURVEY_JOBCODE	SIMPLECHAR	Survey Job Code	Survey Job Code
10_PERC	SIMPLENUM	10th Perc	10th Percentile
100_PERC	SIMPLENUM	100th Percentil	100th Percentile
15_PERC	SIMPLENUM	15 Perc	15th Percentile
16_6PERC	SIMPLENUM	16.6 Prcntile	16.6th Percentile
20_PERC	SIMPLENUM	20th Perc	20th Percentile
25_PERC	SIMPLENUM	25th Percentile	25th Percentile
30_PERC	SIMPLENUM	30th Percentile	30th Percentile
33_3PERC	SIMPLENUM	33.3rd Prcntile	33.3rd Percentile
35_PERC	SIMPLENUM	35th Percentile	35th Percentile
40_PERC	SIMPLENUM	40th Percentile	40th Percentile
45_PERC	SIMPLENUM	45th Percentile	45th Percentile
5_PERC	SIMPLENUM	5th Perc	5th Percentile
50_PERC	SIMPLENUM	50th Percentile	50th Percentile
55_PERC	SIMPLENUM	55th Percentil	55th Percentile
60_PERC	SIMPLENUM	60th Percentile	60th Percentile
65_PERC	SIMPLENUM	65th Percentile	65th Percentile
66_6PERC	SIMPLENUM	66.6th Percntile	66.6th Percentile
70_PERC	SIMPLENUM	70th Percentile	70th Percentile
75_PERC	SIMPLENUM	75th Percentile	75th Percentile
80_PERC	SIMPLENUM	80th Percentile	80th Percentile
83_3PERC	SIMPLENUM	83.3rd Prcntile	83.3rd Percentile
85_PERC	SIMPLENUM	85th Percentile	85th Percentile
90_PERC	SIMPLENUM	90th Percentile	90th Percentile
95_PERC	SIMPLENUM	95th Percentile	95th Percentile
AMOUNT	SIMPLENUM	Amount	Compensation Amount
BASE	SIMPLENUM	Base	Base Compensation
BASE_MAXIMUM	SIMPLENUM	Base Maximum	Base Maximum
BASE_MEAN	SIMPLENUM	Base Mean	Base Mean
BASE_MEDIAN	SIMPLENUM	Base Median	Bease Median
BASE_MINIMUM	SIMPLENUM	Base Minimum	Base Minimum
BASE_MKT_REFERENCE	SIMPLENUM	Base Mkt Ref	Base Market Reference
BONUS_PERCENT	SIMPLENUM	Bonus Percent	Bonus Percentage
DEFAULT_AMOUNT	SIMPLENUM	Default Amount	Default Comp Amount
DEFAULT_PERCENTAGE	SIMPLENUM	Default Percent	Default Percentage
DEFAULT_POINTS	SIMPLENUM	Default Points	Default Points
MAXIMUM_AMOUNT	SIMPLENUM	Max Amount	Maximum Amount
MAXIMUM_PERCENTAGE	SIMPLENUM	Max Percentage	Maximum Percentage
MAXIMUM_POINTS	SIMPLENUM	Max Points	Maximum Points
MEAN_BASE_RATE	SIMPLENUM	Mean Base Rate	Mean Base Rate
MEAN_TOTAL_COMPENSATION	SIMPLENUM	Mean Total Comp	Mean Total Compensation
MEDIAN_BASE_RATE	SIMPLENUM	Median Base Rat	Median Base Rate
MEDIAN_TOTAL_COMPENSATION	SIMPLENUM	Med Total Comp	Median Total Compensation
MIDPOINT_RATE	SIMPLENUM	Midpoint Rate	Midpoint Rate - Base Comp
MINIMUM_AMOUNT	SIMPLENUM	Min Amount	Minimum Amount
MINIMUM_PERCENTAGE	SIMPLENUM	Min Percent	Minimum Percentage
MINIMUM_POINTS	SIMPLENUM	Min Points	Minimum Points
MKT_SOURCE_REFERENCE	SIMPLENUM	Mkt Source Ref	Market Source Reference
NEW_AMOUNT	SIMPLENUM	New Rate	New Compensation Rate Amount
NEW_POINTS	SIMPLENUM	Points	Compensation Rate Points
PERCENTAGE	SIMPLENUM	Percentage	Compensation Percentage
ROUNDING_THRESHOLD	SIMPLENUM	Rounding Thresh	Rounding Threshold
SURVEY_SALARY	SIMPLENUM	Survey Salary	Survey Salary
TOTAL_COMPENSATION	SIMPLENUM	Total Comp	Total Compensation
TOTAL_COMPENSATION_REF	SIMPLENUM	Total Comp Ref	Total Compensation Reference
VARIABLE_MARKET_REFERENCE	SIMPLENUM	Variable MktRef	Variable Market Reference
VARIABLE_MAXIMUM	SIMPLENUM	Variable Maximum	Variable Maximum
VARIABLE_MEAN	SIMPLENUM	Variable Mean	Variable Mean
VARIABLE_MEDIAN	SIMPLENUM	Variable Median	Variable Median
VARIABLE_MINIMUM	SIMPLENUM	Variable Minimum	Variable Minimum
VARIABLE_TARGET_PCT_REFERENCE	SIMPLENUM	Var Tgt Pct Ref	Variable Target Pct Reference
VARIABLE_TARGET_PERCENT	SIMPLENUM	Variable TgtPct	Variable Target Percent
SURVEY_DATE	SIMPLEDATE	Survey Date	Survey Date
INCREMENT_AMOUNT	INCRBYAMT	Incr Amount	Increment Amount
INCREMENT_PERCENT	INCRBYAMT	Incr Percent	Increment Percent
PERCENT_TO_APPLY	PCNTOFBASE	Pct to Apply	Percent to Apply
ANNUAL_RATE_SOURCE	SOURCE	Annual Rate Src	Annual Compensation Rate
EMPL_GRD_MAXHRLY	SOURCE	Annual Rate Src	Annual Compensation Rate
THRESHOLD	THRESHOLD	Threshold	Threshold