| # |
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 |
CALC_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Calculation Name
|
| 4 |
PRCSTYPE |
Character(30) |
VARCHAR2(30) NOT NULL |
Process Type
Prompt Table:
PRCSTYPE_VW
|
| 5 |
PRCSNAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Process Name
|
| 6 |
CALC_SEQ_NUM |
Number(9,0) |
DECIMAL(9) NOT NULL |
Calc Seq Num
|
| 7 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON_NAME
|
| 8 |
REPORT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Type
D=Detailed
N=Non Detailed
|
| 9 |
RUN_CNTL_WRK |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Control Work
|
| 10 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 11 |
AS_OF_DATE |
Date(10) |
DATE |
As of Date
|
| 12 |
SVC_FUNCTN_RESULT |
Character(10) |
VARCHAR2(10) NOT NULL |
Benefit Service Functn Result
|
| 13 |
EG_PERIODIC_CYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Periodic Cycle
A=Annual Cycle
M=Monthly Cycle
Q=Quarterly Cycle
S=Semester Cycle
T=By Term
|
| 14 |
CALC_ALL_PLANS_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate All Plans
Y/N Table Edit
Default Value: N
|
| 15 |
EG_GROUP |
Character(6) |
VARCHAR2(6) NOT NULL |
Service Calculation Group
Prompt Table:
%RECNAME_EDIT
|
| 16 |
SERVICE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Service
Y/N Table Edit
Default Value: Y
|
| 17 |
SERVICE_IND2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Commit to History
Y/N Table Edit
Default Value: N
|
| 18 |
DELETE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Delete Indicator is used to indicate whether a row has been logically deleted.
Y/N Table Edit
Default Value: N
|
| 19 |
FUNCTN_RESULT_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
Function Result Name
Prompt Table:
EG_FLX_FUNC_VW
|
| 20 |
PROCESS_MODE_EG |
Character(1) |
VARCHAR2(1) NOT NULL |
Periodic Processing Mode - E&G
N=Normal Run
P=Update to History
Z=Delete & Rebuild History
|
| 21 |
VALIDATION_RUN_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Validation Run
Y/N Table Edit
Default Value: Y
|
| 22 |
EG_POPULATION_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Population code
A=All Employees
G=Calculation Group
I=Individual
|
| 23 |
EG_SVC_FUNC_INDC |
Character(3) |
VARCHAR2(3) NOT NULL |
Service Calc Function Indic.
FLX=Flexible Service Calculation
TEN=Tenure Service Calculation
|
| 24 |
EG_CLC_ALL_SVC_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a one digit Y/N code indicating whether all available service dates are to be calculated in a given calculation run. If no, then a single service date calculation is performed.
N=Calculate one date only
Y=Calculate All service dates
|