| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 DEFINITION_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
VARCHAR2(10) NOT NULL
|
| 2 |
SVC_DFN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
For future use
B=Break Definition
S=Service Definition Type
Default Value: S
|
| 3 |
EG_SERVICE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Service Type
E=Elapsed Time
Default Value: E
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
Prompt Table:
EG_CAL_DEFN_TBL
|
| 6 |
EG_PERIOD_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Computational Period
M=Month
Q=Quarter
S=Semester
T=Term
Y=Computational Year
|
| 7 |
EG_PRORATE_MTHD |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate By
F=FTE
N=None
Default Value: N
|
| 8 |
FTE_EQUIV |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
Pro-rate if below
Default Value: 0
|
| 9 |
DT_RND_ORD_NUM |
Number(1,0) |
SMALLINT NOT NULL |
Date round order number
|
| 10 |
ADD_TIME_ORD_NUM |
Number(1,0) |
SMALLINT NOT NULL |
Add time order number
|
| 11 |
FUT_ADJ_ORD_NUM |
Number(1,0) |
SMALLINT NOT NULL |
Future adjustment order number
|
| 12 |
DATE_OPTION |
Character(10) |
VARCHAR2(10) NOT NULL |
Duration Option
Prompt Table:
EG_DATE_CNV_OPT
|
| 13 |
PRORATE_PREV_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Data to be Prorated
H=Hours
S=Service
U=User Code
Default Value: S
|
| 14 |
PRORATE_PREV_UNIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Counting Units for Proration
D=Days
E=Equivalent Periods
M=Months
U=User Code
W=Weeks
Default Value: D
|
| 15 |
PRORATE_CUR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Data to be Prorated
H=Hours
S=Service
U=User Code
Default Value: S
|
| 16 |
PRORATE_CUR_UNIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Counting Units for Proration
D=Days
E=Equivalent Periods
M=Months
U=User Code
W=Weeks
Default Value: D
|
| 17 |
ELAPSED_TIME_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Time of Elapsed Time Service
D=Decimal Date Subtraction
P=Count Periods
R=Raw Date Subtraction
|
| 18 |
ELAP_TIME_DU_OPT |
Character(10) |
VARCHAR2(10) NOT NULL |
Elapsed Time Duration Option
Prompt Table:
EG_DURATION_OPT
|
| 19 |
EG_FNL_SVC_RSLT_UN |
Character(1) |
VARCHAR2(1) NOT NULL |
Final Service Result Unit Code
Y=Years
Default Value: Y
|
| 20 |
EG_PROJ_DT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Project Service Date
Y/N Table Edit
Default Value: N
|
| 21 |
FNL_RSLT_DU_OPT |
Character(10) |
VARCHAR2(10) NOT NULL |
Final Rslt Dec Cnvrsn Opt
Prompt Table:
EG_DURATION_OPT
|
| 22 |
FNL_ADD_SVC_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Final Add Service Type
|
| 23 |
EG_FNL_ADD_SVC_NUM |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Final Add Service Amount
|
| 24 |
FNL_ADD_SVC_ALS_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
FINAL ADD SVC ALIAS NAME
Prompt Table:
EG_ALIAS_USE
|
| 25 |
FNL_ADD_SVC_ALS_TY |
Character(2) |
VARCHAR2(2) NOT NULL |
FINAL ADD SVC ALIAS TYPE
|
| 26 |
FNL_SUB_SVC_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Final Subtract Service Type
|
| 27 |
EG_FNL_SUB_SVC_NUM |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Final Sub Service Amount
|
| 28 |
FNL_SUB_SVC_ALS_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
FINAL SVC SUBTRACT ALIAS NAME
Prompt Table:
EG_ALIAS_USE
|
| 29 |
FNL_SUB_SVC_ALS_TY |
Character(2) |
VARCHAR2(2) NOT NULL |
FINAL SVC SUB ALIAS TYPE
|
| 30 |
FNL_MIN_SVC_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Final Minimum Service Type
|
| 31 |
EG_FNL_MIN_SVC_NUM |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Final Minimum Service Amount
|
| 32 |
FNL_MIN_SVC_ALS_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
FINAL MIN SVC ALIAS NAME
Prompt Table:
EG_ALIAS_USE
|
| 33 |
FNL_MIN_SVC_ALS_TY |
Character(2) |
VARCHAR2(2) NOT NULL |
FINAL MIN SVC ALIAS TYPE
|
| 34 |
FNL_MAX_SVC_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Final Maximum Service Type
|
| 35 |
EG_FNL_MAX_SVC_NUM |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Final Maximum Service Amount
|
| 36 |
FNL_MAX_SVC_ALS_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
FINAL MAX SERVICE AMT ALIAS NM
Prompt Table:
EG_ALIAS_USE
|
| 37 |
FNL_MAX_SVC_ALS_TY |
Character(2) |
VARCHAR2(2) NOT NULL |
FINAL MAX SVC ALIAS TYPE
|
| 38 |
BRK_RQRMT_NUM |
Number(3,0) |
SMALLINT NOT NULL |
# Breaks Needed to Lose Svc
|
| 39 |
BRK_WAIT_ELAP_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Elapsed time wait unit code
D=Days per Year
M=Months
U=User Code
Default Value: M
|
| 40 |
BRK_WAIT_ASS_DAY |
Number(3,0) |
SMALLINT NOT NULL |
# days/yr
|
| 41 |
BRK_ELAP_PRD_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Elapsed time year
C=Calendar Year
H=Hire Anniversary Year
P=Plan Year
T=Term Anniversary Year
Default Value: H
|
| 42 |
BRK_ELAP_UNIT_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Elapsed time counting period
D=Days per Year
M=Months
U=User Code
Default Value: M
|
| 43 |
BRK_ELP_DU_OPT |
Character(10) |
VARCHAR2(10) NOT NULL |
Break Id for Elapsed Time
Prompt Table:
EG_DURATION_OPT
|
| 44 |
EG_DT_RND_OPT_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Date Rounding Option Name
Prompt Table:
EG_DATE_RND_OPT
|
| 45 |
EG_PROJ_MAX_SVC |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Maximum Service Amount
|