| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID
Prompt Table:
SET_VLD_HR_05
|
| 2 |
SAL_ADMIN_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Salary Administration Plan
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
HR_WP_PROG_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Wage Progression Increment Type
D=Elapsed Months
H=Hours Worked
W=Elapsed Weeks
Default Value: H
|
| 5 |
HR_WP_RT_CAL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Wage Progression Rate Calculation Type
1 = % of Max
2 = % Increase
3 = Amount Increase
4= % of Min
5= User Defined
1=% Grade Max
2=% Increase
3=Amt Increase
4=% Grade Min
5=User Defined
Default Value: 1
|
| 6 |
COMP_RATECD |
Character(6) |
VARCHAR2(6) NOT NULL |
Comp Rate Code
Prompt Table:
%EDITTABLE
|
| 7 |
HR_WP_RT_CAL_LMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Round to Max of Grade Within
Y/N Table Edit
Default Value: N
|
| 8 |
HR_WP_ALLW_EXD_MAX |
Character(1) |
VARCHAR2(1) NOT NULL |
Exceed maximum for Grade
Y/N Table Edit
Default Value: N
|
| 9 |
HR_WP_TOL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Tolerance Type
1 Percent(%)
2 Amount
1=Percent
2=Flat Amount
|
| 10 |
HR_WP_TOL_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Tolerance Amount
|
| 11 |
HR_WP_TOL_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Tolerance Percent
|
| 12 |
ERNCD_SPCL |
Character(3) |
VARCHAR2(3) NOT NULL |
Special Accumulator Code
Prompt Table:
SPCL_EARNS_TBL
|
| 13 |
HR_WP_ERNCD_SPL_LV |
Character(3) |
VARCHAR2(3) NOT NULL |
Leave Accumulator
Prompt Table:
SPCL_EARNS_TBL
|
| 14 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
Prompt Table:
ACTION_TBL
|
| 15 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table:
ACTN_REASON_TBL
|
| 16 |
HR_WP_APRVL_REQRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Advancement Approval Required
Y/N Table Edit
|
| 17 |
HR_WP_DAYS_WITHIN |
Number(6,0) |
INTEGER NOT NULL |
Days Within
|
| 18 |
HR_WP_HRS_WITHIN |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Hours Within
|