| # |
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
Prompt Table:
SAL_PLAN_TBL
|
| 3 |
GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Grade
|
| 4 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 5 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 6 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 7 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 8 |
SALARY_MATRIX_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Salary Matrix Code
Prompt Table:
SAL_MATRIX_TBL
|
| 9 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 10 |
MIN_RT_HOURLY |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Minimum Pay Rate-Hourly
|
| 11 |
MID_RT_HOURLY |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Midpoint Pay Rate-Hourly
|
| 12 |
MAX_RT_HOURLY |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Maximum Pay Rate-Hourly
|
| 13 |
MIN_RT_MONTHLY |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Minimum Pay Rate-Monthly
|
| 14 |
MID_RT_MONTHLY |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Midpoint Pay Rate-Monthly
|
| 15 |
MAX_RT_MONTHLY |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Maximum Pay Rate-Monthly
|
| 16 |
MIN_RT_ANNUAL |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Minimum Pay Rate-Annual
|
| 17 |
MID_RT_ANNUAL |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Midpoint Pay Rate-Annual
|
| 18 |
MAX_RT_ANNUAL |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Maximum Pay Rate-Annual
|
| 19 |
STEP_INCREM_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Step Increment Type
D=Date Based Increment Type
E=Either Hours or Date Based
H=Hours Based Increment Type
M=Manual Based Increment Type
W=Weeks Based Increment Type
|
| 20 |
STEP_INCREM_ACCUM |
Character(3) |
VARCHAR2(3) NOT NULL |
Spec Accum for Step Increments
Prompt Table:
SPCL_EARNS_TBL
|
| 21 |
MIN_RT_DAILY |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Minimum Pay rate-Daily
|
| 22 |
MID_RT_DAILY |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Midpoint Pay rate-Daily
|
| 23 |
MAX_RT_DAILY |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Maximum Pay rate-Daily
|
| 24 |
LABOR_AGREEMENT |
Character(6) |
VARCHAR2(6) NOT NULL |
Labor Agreement
Prompt Table:
EMPL_CTG
|
| 25 |
EMPL_CTG |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Category
Prompt Table:
EMPL_CTG_L1
|
| 26 |
EMPL_CTG_L1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Subcategory
Prompt Table:
EMPL_CTG_L2
|
| 27 |
EMPL_CTG_L2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Subcategory 2
Prompt Table:
EMPL_CTG_L3
|
| 28 |
GVT_MAX_RT_BIWK |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Maximum Pay Rate - BiWeekly
|
| 29 |
GVT_MID_RT_BIWK |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Midpoint Pay Rate - BiWeekly
|
| 30 |
GVT_MIN_RT_BIWK |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Minimum Pay Rate - BiWeekly
|
| 31 |
AUDIT_ACTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
|
| 32 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|