This appendix contains a list of predefined source IDs and result IDs that are delivered with PeopleSoft HR Manage Base Compensation.
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 |
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 Default |
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 |
Base 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 |