| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 DEFINITION_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
VARCHAR2(10) NOT NULL
|
| 2 |
SUB_ADJUSTMENT |
Character(10) |
VARCHAR2(10) NOT NULL |
Subadjustment
|
| 3 |
USES_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Uses Method
A=Actuarial Equivalence
C=Custom Statement
R=Arithmetic Rules
T=Table Lookup
U=User Code
Default Value: T
|
| 4 |
METHOD_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Table ID or Custom Statement
Prompt Table:
%ACT_METH_USE
|
| 5 |
APPLIES_TO |
Character(1) |
VARCHAR2(1) NOT NULL |
Applies to
B=Both
I=Increases Only
R=Reductions Only
Default Value: B
|
| 6 |
NUM_OF_DEC_PLACES |
Number(3,0) |
SMALLINT NOT NULL |
Number of Decimal Places
|
| 7 |
ACTUARIAL_ASSUM |
Character(10) |
VARCHAR2(10) NOT NULL |
Actuarial Assumption Set
Prompt Table:
PA_DFN_FACTOR
|
| 8 |
EE_AGE_ADJ_FROM |
Character(1) |
VARCHAR2(1) NOT NULL |
Age to Adjust From
A=Age Field
U=User Code
Default Value: A
|
| 9 |
EE_ADJ_FROM_AGE |
Number(10,6) |
DECIMAL(9,6) NOT NULL |
EE Adjustment From Age
|
| 10 |
EE_AGEFROM_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
EE From Age Alias Type
|
| 11 |
EE_AGE_ADJ_TO |
Character(1) |
VARCHAR2(1) NOT NULL |
Age to Adjust To
A=Age Field
U=User Code
Default Value: A
|
| 12 |
EE_ADJ_TO_AGE |
Number(10,6) |
DECIMAL(9,6) NOT NULL |
Empl Adjustment To Age
|
| 13 |
EE_AGETO_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
EE To Age Alias Type
|
| 14 |
ADJUST_LENGTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Subject to
M=Minimum
X=Maximum
Default Value: M
|
| 15 |
ADJUST_MIN_MAX |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjust to Minimum or Maximum
Y/N Table Edit
Default Value: N
|
| 16 |
PERIOD_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Number of Periods
|
| 17 |
ADJUST_LENGTH2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Period Type
A=Count Periods Between Ages
D=Count Periods Between Dates
U=User Code
Default Value: D
|
| 18 |
ADJUST_DATE1_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Date 1 Field Type
A=Alias Name
D=Date Constant
Default Value: D
|
| 19 |
ADJUST_DATE1 |
Date(10) |
DATE |
Date 1 Constant
|
| 20 |
ADJUST_DATE1_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Date 1 Alias Name
Prompt Table:
PA_DTDB_ALS_VW
|
| 21 |
ADJUST_DATE2_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Date 2 Field Type
A=Alias Name
D=Date Constant
Default Value: D
|
| 22 |
ADJUST_DATE2 |
Date(10) |
DATE |
Date 2 Constant
|
| 23 |
ADJUST_DATE2_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Date 2 Alias Name
Prompt Table:
PA_DTDB_ALS_VW
|
| 24 |
ADJUST_AGE1_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Age 1 Field Type
A=Age Field
N=Constant Age
Default Value: N
|
| 25 |
ADJUST_AGE1 |
Number(3,0) |
SMALLINT NOT NULL |
Constant Age
|
| 26 |
ADJUST_AGE1_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Age Duration Definition
Prompt Table:
PA_ALIAS_USE
|
| 27 |
ADJUST_AGE2_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Age 2 Field Type
A=Age Field
N=Constant Age
Default Value: N
|
| 28 |
ADJUST_AGE2 |
Number(3,0) |
SMALLINT NOT NULL |
Constant Age
|
| 29 |
ADJUST_AGE2_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Age Duration Definition
Prompt Table:
PA_ALIAS_USE
|
| 30 |
PERCENT_FRACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Percentages or Fractions
F=Fractions
P=Percentages
|
| 31 |
ADJ_AGE_DURATN |
Character(10) |
VARCHAR2(10) NOT NULL |
Using Duration Definition
M=Count Month Periods
Y=Count Year Periods
|
| 32 |
ADJ_DT_DURATN |
Character(10) |
VARCHAR2(10) NOT NULL |
Using Duration Definition
M=Count Month Periods
Y=Count Year Periods
|
| 33 |
ADJUST_DATE1_ALIAT |
Character(2) |
VARCHAR2(2) NOT NULL |
Adjust Date 1 Alias Type
|
| 34 |
ADJUST_DATE2_ALIAT |
Character(2) |
VARCHAR2(2) NOT NULL |
Adjust Date2 Alias Type
|
| 35 |
ADJUST_AGE1_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Adjust Age1 Alias Type
|
| 36 |
ADJUST_AGE2_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Adjust Age2 Alias Type
|
| 37 |
BN_AGE_ADJ_FROM |
Character(1) |
VARCHAR2(1) NOT NULL |
Age to Adjust From
A=Age Field
U=User Code
Default Value: A
|
| 38 |
BN_ADJ_FROM_AGE |
Number(10,6) |
DECIMAL(9,6) NOT NULL |
Beneficiary From Age
|
| 39 |
BN_AGEFROM_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Beneficiary From Age Alias Typ
|
| 40 |
BN_AGE_ADJ_TO |
Character(1) |
VARCHAR2(1) NOT NULL |
Age To Adjust To
A=Age Field
U=User Code
Default Value: A
|
| 41 |
BN_AGETO_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Beneficiary To Age Alias
Prompt Table:
PA_DURATION
|
| 42 |
EE_AGEFROM_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
EE AGEFROM TYPE
Default Value: N
|
| 43 |
EE_AGETO_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
EE AGE TO TYPE
Default Value: N
|
| 44 |
BN_ADJ_TO_AGE |
Number(10,6) |
DECIMAL(9,6) NOT NULL |
Beneficiary To Age
|
| 45 |
BN_NORMAL_FORM_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
Bene Normal Form Name
Prompt Table:
PA_BEN_FORM_VW
|
| 46 |
BN_AGEFROM_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
BN AGE FROM TYPE
Default Value: N
|
| 47 |
BN_AGETO_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
BN AGE TO TYPE
Default Value: N
|
| 48 |
EE_AGEFROM_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
EE AGE FROM ALIAS
Prompt Table:
PA_DURATION
|
| 49 |
EE_AGETO_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
EE AGE TO ALIAS
Prompt Table:
PA_DURATION
|
| 50 |
BN_AGEFROM_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
BN AGE FROM ALIAS
Prompt Table:
PA_DURATION
|
| 51 |
BN_AGETO_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
BN age to Alias Type
|