| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
FROMDATE |
Date(10) |
DATE |
From Date
Prompt Table:
%EDITTABLE
|
| 4 |
THRUDATE |
Date(10) |
DATE |
End Date
Prompt Table:
%EDITTABLE2
|
| 5 |
GB_GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table:
%EDITTABLE2
|
| 6 |
REVIEW_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Review Type
A=Self Assesssment
B=Both
E=Employee Feedback
I=Initial Rating
M=Interim Rating
O=Official Rating
P=Performance
R=Adjustment Result
S=Salary
|
| 7 |
BUDGET_START_DT |
Date(10) |
DATE |
Budget Period Start Date
Prompt Table:
RUN_BUDGET1_VW
|
| 8 |
FROM_DT |
Date(10) |
DATE |
From Date
|
| 9 |
THRU_DATE |
Date(10) |
DATE |
Thru Date
|
| 10 |
BUDGET_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Budget ID
Prompt Table:
BUDGET_COMP1_VW
|
| 11 |
EP_REVIEW_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Review type
Prompt Table:
%EDITTABLE3
|
| 12 |
SP_FROM_DATE |
Date(10) |
DATE |
From Date - used in Salary Planning
Prompt Table:
%EDITTABLE4
|
| 13 |
SP_TO_DATE |
Date(10) |
DATE |
To Date - used in Salary Planning
Prompt Table:
%EDITTABLE5
|
| 14 |
ASOFDATE |
Date(10) |
DATE |
As of Date
|
| 15 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
Default Value: PAY
Prompt Table:
ACTION_TBL
|
| 16 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
Default Value: MER
Prompt Table:
ACTN_REASON_TBL
|
| 17 |
UPD_FUTURE_ROW_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Future Rows
N=No
Y=Yes
Y/N Table Edit
|
| 18 |
CMP_DONT_ABSORB |
Character(1) |
VARCHAR2(1) NOT NULL |
Don't Absorb Changes
N=No
Y=Yes
Y/N Table Edit
|
| 19 |
SP_INCREM_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Plan Salaries, increment type
D=Date Based
E=Hours and Date Based
H=Hours Based
|