| # |
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 |
LIMIT_TABLE_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Limit Table Alias
Prompt Table:
PA_TBL_PG_ALS
|
| 4 |
REDUCTION_FACT1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Prior to 62 Reduction Factor 1
Prompt Table:
PA_FNC_RSLT_NMS
|
| 5 |
REDUCTION_FACT2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Prior age 62 Reduction Factor2
Prompt Table:
PA_FNC_RSLT_NMS
|
| 6 |
TENYR_PART_SVC_DFN |
Character(10) |
VARCHAR2(10) NOT NULL |
Ten Year Part Service Defn
Prompt Table:
PA_DFN_SVC_VW
|
| 7 |
TENYR_PART_USERCD |
Character(1) |
VARCHAR2(1) NOT NULL |
Ten Year Participation User Cd
Y/N Table Edit
Default Value: N
|
| 8 |
INCREASE_FACT1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Post SSRA Increase Factor 1
Prompt Table:
PA_FNC_RSLT_NMS
|
| 9 |
INCREASE_FACT2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Post SSRA Increase Factor 2
Prompt Table:
PA_FNC_RSLT_NMS
|
| 10 |
COLA_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
COLA Type
1=No Increase Past Event Date
2=Increase Up To Payment Date
3=Increase Beyond Event Date
Default Value: 1
|
| 11 |
COLA_TABLE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
COLA Table ID
Prompt Table:
PA_TBL_USE
|
| 12 |
FAE_DEFINITION_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
Result Name
Prompt Table:
PA_DFN_AVG_VW
|
| 13 |
FAE_USERCD |
Character(1) |
VARCHAR2(1) NOT NULL |
Fae User Code
Y/N Table Edit
Default Value: N
|
| 14 |
TENYR_RED_SVCDFN |
Character(10) |
VARCHAR2(10) NOT NULL |
Ten Year Svc Reduction Svc Dfn
Prompt Table:
PA_DFN_SVC_VW
|
| 15 |
TENYR_RED_USERCD |
Character(1) |
VARCHAR2(1) NOT NULL |
Ten year reduction user cd
Y/N Table Edit
Default Value: N
|
| 16 |
AMT_415E_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Amount 415(e) Indicator
1=DC Fraction
2=DB Limit
3=No 415e information
Default Value: 3
|
| 17 |
AMT_415E_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Amout 415e alias field
Prompt Table:
PA_ALIAS_USE
|
| 18 |
DBFRACT_WARNING |
Number(10,6) |
DECIMAL(9,6) NOT NULL |
Warn if DB Fraction Greater
|
| 19 |
REDUCTION_OPTIONS |
Character(1) |
VARCHAR2(1) NOT NULL |
Limit Reduction Options
1=Prorate
2=Precedence Order
3=User Code
Default Value: 1
|
| 20 |
BENEFIT_PLAN |
Character(6) |
VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table:
PA_PLAN_ORDER
|