| # |
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
|
| 4 |
THRUDATE |
Date(10) |
DATE |
End Date
|
| 5 |
ASOFDATE |
Date(10) |
DATE |
As of Date
|
| 6 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERS_SRCH_GBL
|
| 7 |
EG_CASE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Case ID
Prompt Table:
EG_CASE_REVIEW
Set Control Field: EG_CASE_ID
|
| 8 |
EG_CASE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Case Status
A=Approved
D=Disapproved
I=In Appeal
O=Open
|
| 9 |
EG_GROUP |
Character(6) |
VARCHAR2(6) NOT NULL |
Service Calculation Group
Prompt Table:
%RECNAME_EDIT
Set Control Field: EG_GROUP
|
| 10 |
EG_TENURE_HOME |
Character(10) |
VARCHAR2(10) NOT NULL |
Tenure Home Organization
Prompt Table:
DEPT_TBL
|
| 11 |
TENURE_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Tenure Status
DEF=Tenure by de facto
DEN=Tenure Denied
NA=Not Applicable
NOT=Non Tenure Not On Track
NTK=Non Tenure On Track
OTH=Other
TEN=Tenure
|
| 12 |
FUNCTN_RESULT_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
Function Result Name
|
| 13 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPT_TBL
|
| 14 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
BUS_UNIT_TBL_HR
|
| 15 |
MIN_AMT |
Signed Number(14,5) |
DECIMAL(12,5) NOT NULL |
Minimum Amount
|
| 16 |
MAX_AMT |
Signed Number(14,5) |
DECIMAL(12,5) NOT NULL |
Maximum Amount
|
| 17 |
TIME_PERIOD_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Time Period
B=Biweekly
D=Day
H=Hour
M=Month
Q=Quarter
S=Semi-monthly
T=Ten-monthly
W=Week
Y=Year
|
| 18 |
SORT_A_D |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Ascending/Decending Parm
A=Ascending
D=Descending
|
| 19 |
EG_ROLLUP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rollup Flag
Y/N Table Edit
Default Value: Y
|
| 20 |
EG_PRINT_OPTIONS |
Character(1) |
VARCHAR2(1) NOT NULL |
Print details or summary
D=Print Details
S=Print Summary
Default Value: D
|
| 21 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 22 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SETID_TBL
|
| 23 |
EG_CALC_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Calculation Name
|