| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 DEFINITION_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
VARCHAR2(10) NOT NULL
|
| 2 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 3 |
HIGH_PERIODS |
Number(3,0) |
SMALLINT NOT NULL |
Find the Highest
|
| 4 |
CONSECUTIVE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Consecutive
Y/N Table Edit
Default Value: N
|
| 5 |
AVERAGE_FROM |
Character(1) |
VARCHAR2(1) NOT NULL |
Take the Average From
C=Career Earnings
D=Between Dates
L=The Last n Periods
Default Value: C
|
| 6 |
LAST_PERIODS |
Number(3,0) |
SMALLINT NOT NULL |
Number of Periods
|
| 7 |
PERIOD_START_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Start Date Field Type
A=Alias Name
D=Date Constant
Default Value: A
|
| 8 |
PERIOD_START_DATE |
Date(10) |
DATE |
Start Date
|
| 9 |
PERIOD_START_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Start Date
Prompt Table:
PA_ALIAS_USE
|
| 10 |
PERIOD_STOP_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Stop Date Field Type
A=Alias Name
D=Date Constant
Default Value: A
|
| 11 |
PERIOD_STOP_DATE |
Date(10) |
DATE |
Stop Date
|
| 12 |
PERIOD_STOP_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Stop Date
Prompt Table:
PA_ALIAS_USE
|
| 13 |
EARNINGS_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Use Consolidated Earnings
Prompt Table:
PA_CONS_EARN_VW
|
| 14 |
DETERMINE_PARTIAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Determine Partial Period
|
| 15 |
PARTIAL_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Period Options
A=Always Use
I=Always Ignore
K=Keep if Needed
T=Treat as Full
U=User Code
Default Value: A
|
| 16 |
PROJECT_METHOD |
Character(10) |
VARCHAR2(10) NOT NULL |
Projection Method Name
Prompt Table:
PA_PROJECTIONS
|
| 17 |
FINAL_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Final Period Options
A=Always Use
F=Use Only Full
H=Use if Higher Average
I=Always Ignore
K=Keep if Needed
T=Treat as Full
U=User Code
Default Value: A
|
| 18 |
ZERO_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Zero Options
I=Ignore
R=Replace with Look Back
S=Use
U=User Code
Default Value: R
|
| 19 |
LIMIT_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Limit Options
4=401(a)17
M=Maximum Table Wage Base
N=None
U=User Code Before Averaging
W=User Code While Averaging
Default Value: N
|
| 20 |
LIMIT_401A17_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
401(a)17 Limit Name
Prompt Table:
PA_401A17_PARMS
|
| 21 |
GENERATED_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Generated Earnings Options
L=High Look Back
N=None
U=User Code
Default Value: N
|
| 22 |
SHORT_SVC_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Short Service Options
D=Different FAE Definition
U=User Code
W=Use what you have
Default Value: W
|
| 23 |
SHORT_SVC_DEF |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Service Definition Name
Prompt Table:
PA_DFN_AVGEARN
|
| 24 |
PER_START_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
|
| 25 |
PERIOD_STOP_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
|
| 26 |
ANNUALIZE_FULL |
Character(1) |
VARCHAR2(1) NOT NULL |
Annualize Full Periods
N=Full Annualization off
Y=Full Annualization On
|
| 27 |
ANNUALIZE_PARTIAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Annualize Partial Periods
N=Partial Annualize Off
Y=Partial Annualize On
|
| 28 |
FAE_ANN_SVC_FR |
Character(10) |
VARCHAR2(10) NOT NULL |
Service Function Result
Prompt Table:
PA_SVC_FR_VW
|