| # |
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
|
| 3 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 4 |
EXCL_SVC_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Service Exclusion Indicator
|
| 5 |
EXCLUDE_PRIOR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Field Type for Exclude Prior
D=Date Constant
V=Vary by Employee
|
| 6 |
EXCL_SVC_B4_DT |
Date(10) |
DATE |
Exclude service before date
|
| 7 |
EXCL_SVC_B4_ALS |
Character(10) |
VARCHAR2(10) NOT NULL |
Exclude service b4 alias date
Prompt Table:
PA_ALIAS_USE
|
| 8 |
XCL_SVC_B4_ALS_TYP |
Character(2) |
VARCHAR2(2) NOT NULL |
Exclude service b4 alias type
|
| 9 |
EXCLUDE_AFTER_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Field Type for Exclude After
D=Date Constant
V=Vary by Employee
|
| 10 |
EXCL_SVC_AFT_DT |
Date(10) |
DATE |
Exclude service after date
|
| 11 |
EXCL_SVC_AFT_ALS |
Character(10) |
VARCHAR2(10) NOT NULL |
Exclude service after alias dt
Prompt Table:
PA_ALIAS_USE
|
| 12 |
X_SVC_AFT_ALS_TYP |
Character(2) |
VARCHAR2(2) NOT NULL |
Exclude svc after alias dt typ
|
| 13 |
SERVICE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Sevice type
1=Service Request
2=Service Reply
C=Hours Counting
E=Elapsed Time
H=Hours Equivalence
T=Hours and Time Dependent
|
| 14 |
COMPUTATION_PERIOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Computation Period
A=Anniversary Year
M=Calendar Month
P=Plan Year
Y=Calendar Year
Default Value: Y
|
| 15 |
INIT_COMP_ANNIVYR |
Character(1) |
VARCHAR2(1) NOT NULL |
First Period is Anniv Year
Y/N Table Edit
Default Value: N
|
| 16 |
HRS_CONSOLIDATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Hours Consolidation Name
Prompt Table:
PA_CONS_HRS_VW
|
| 17 |
CONTRIB_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
05/22/03 Lee - ICE 51596000 Correct spelling of Service
Y/N Table Edit
Default Value: N
|
| 18 |
CONTRIB_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Contrib History Name
Prompt Table:
PA_CONS_DED
|
| 19 |
DT_RND_ORD_NUM |
Number(1,0) |
SMALLINT NOT NULL |
Date round order number
|
| 20 |
ADD_TIME_ORD_NUM |
Number(1,0) |
SMALLINT NOT NULL |
Add time order number
|
| 21 |
FUT_ADJ_ORD_NUM |
Number(1,0) |
SMALLINT NOT NULL |
Future adjustment order number
|
| 22 |
CUR_FUT_PROJ_MTHD |
Character(10) |
VARCHAR2(10) NOT NULL |
Current/Future Projection Mthd
Prompt Table:
PA_PROJECTIONS
|
| 23 |
EQUIV_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Hours Equivalence Type
C=Custom Rule
D=DOL Standard
U=User Code
Default Value: D
|
| 24 |
HRS_TIM_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Hour/Time Requirement
H=Hours/Time - Hours Dependent
N=Hours/Time - No dependencies
T=Hours/Time - Time Dependent
|
| 25 |
HRS_RQRMT_AMT |
Number(4,0) |
SMALLINT NOT NULL |
Hours Required
|
| 26 |
TIME_RQRMT_AMT |
Number(3,0) |
SMALLINT NOT NULL |
Period Count
|
| 27 |
CONSEC_TIME_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Period Type
M=Consecutive Months
Y=Consecutive Years
|
| 28 |
DOL_STANDARD |
Character(1) |
VARCHAR2(1) NOT NULL |
DOL Standard Rules
F=45 Hours / Week
N=95 Hours / Semi-Month
O=190 Hours / Month
T=10 Hours / Day
Default Value: T
|
| 29 |
EQUIV_PERIOD_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Custom Equivalence Rule
D=Day
M=Month
S=Semi-Month
U=User Code
W=Week
Default Value: D
|
| 30 |
EQUIV_PERIOD |
Number(5,0) |
INTEGER NOT NULL |
Hour Count
|
| 31 |
DATE_OPTION |
Character(10) |
VARCHAR2(10) NOT NULL |
Duration Option
|
| 32 |
PRORATE_PREV_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Data to be Prorated
H=Hours
S=Service
U=User Code
Default Value: S
|
| 33 |
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
|
| 34 |
PRORATE_CUR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Data to be Prorated
H=Hours
S=Service
U=User Code
Default Value: S
|
| 35 |
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
|
| 36 |
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
|
| 37 |
ELAP_TIME_DU_OPT |
Character(10) |
VARCHAR2(10) NOT NULL |
Elapsed Time Duration Option
Prompt Table:
PA_DURATION_OPT
|
| 38 |
FNL_SVC_RSLT_UNIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Final Service Result Units
M=Months
Y=Years
|
| 39 |
FNL_RSLT_DU_OPT |
Character(10) |
VARCHAR2(10) NOT NULL |
Final Rslt Dec Cnvrsn Opt
Prompt Table:
PA_DURATION_OPT
|
| 40 |
FNL_ADD_SVC_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Final Add Service Type
|
| 41 |
FNL_ADD_SVC_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Add Service Amount
|
| 42 |
FNL_ADD_SVC_ALS_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
FINAL ADD SVC ALIAS NAME
Prompt Table:
PA_ALIAS_USE
|
| 43 |
FNL_ADD_SVC_ALS_TY |
Character(2) |
VARCHAR2(2) NOT NULL |
FINAL ADD SVC ALIAS TYPE
|
| 44 |
FNL_SUB_SVC_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Final Subtract Service Type
|
| 45 |
FNL_SUB_SVC_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Final Subtract Service Amount
|
| 46 |
FNL_SUB_SVC_ALS_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
FINAL SVC SUBTRACT ALIAS NAME
Prompt Table:
PA_ALIAS_USE
|
| 47 |
FNL_SUB_SVC_ALS_TY |
Character(2) |
VARCHAR2(2) NOT NULL |
FINAL SVC SUB ALIAS TYPE
|
| 48 |
FNL_MIN_SVC_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Final Minimum Service Type
|
| 49 |
FNL_MIN_SVC_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Final Limit
|
| 50 |
FNL_MIN_SVC_ALS_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
FINAL MIN SVC ALIAS NAME
Prompt Table:
PA_ALIAS_USE
|
| 51 |
FNL_MIN_SVC_ALS_TY |
Character(2) |
VARCHAR2(2) NOT NULL |
FINAL MIN SVC ALIAS TYPE
|
| 52 |
FNL_MAX_SVC_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Final Maximum Service Type
|
| 53 |
FNL_MAX_SVC_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Final Maximum Service Amount
|
| 54 |
FNL_MAX_SVC_ALS_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
FINAL MAX SERVICE AMT ALIAS NM
Prompt Table:
PA_ALIAS_USE
|
| 55 |
FNL_MAX_SVC_ALS_TY |
Character(2) |
VARCHAR2(2) NOT NULL |
FINAL MAX SVC ALIAS TYPE
|
| 56 |
BRK_1YR_WAIT_YN |
Character(1) |
VARCHAR2(1) NOT NULL |
One year wait code (y/n)
Y/N Table Edit
Default Value: N
|
| 57 |
BRK_SVC_RSTR_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Service restoration rule code
C=Count Breaks
L=Always Lose Service
R=Always Restore Service
U=User Code
Default Value: C
|
| 58 |
BRK_1YR_WAIT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
One year wait type
E=Elapsed Time
U=User Code
Default Value: E
|
| 59 |
BRK_1YR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Break Defined By
E=Elapsed Time
H=Hours Threshold
U=User Code
Default Value: E
|
| 60 |
BRK_1YR_HRS_NUM |
Number(4,0) |
SMALLINT NOT NULL |
1 yr break hours threshold
|
| 61 |
BRK_RQRMT_NUM |
Number(3,0) |
SMALLINT NOT NULL |
# Breaks Needed to Lose Svc
|
| 62 |
BRK_PRI_SVC_MIN_YN |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Rule of Parity
Y/N Table Edit
Default Value: N
|
| 63 |
BRK_RSTR_VSTD_YN |
Character(1) |
VARCHAR2(1) NOT NULL |
Restore Service if Vested
Y/N Table Edit
Default Value: N
|
| 64 |
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
|
| 65 |
BRK_WAIT_ASS_DAY |
Number(3,0) |
SMALLINT NOT NULL |
Number of Days
|
| 66 |
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
|
| 67 |
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
|
| 68 |
BRK_ELP_DU_OPT |
Character(10) |
VARCHAR2(10) NOT NULL |
Break ID for Elapsed Time
Prompt Table:
PA_DURATION_OPT
|
| 69 |
BRK_SVC_FR |
Character(10) |
VARCHAR2(10) NOT NULL |
Function Result
|