| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 DEFINITION_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
VARCHAR2(10) NOT NULL
|
| 2 |
FORM_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Form Code
CO=Certain Only Installment
JS=Joint & Survivor Annuity
LIFE=Life Annuity
LIO=Level Income Option
LTS=Last to Survive Annuity
LUMP=Lump Sum
POP=Pop Up Annuity
REV=Reversionary Annuity
SPJS=Spouse Demonstration JS
|
| 3 |
GUARANTEED_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Guaranteed Payments Type
A=Alias Name
N=Numeric Constant
Default Value: N
|
| 4 |
GUARANTEED_PAYMENT |
Number(3,0) |
SMALLINT NOT NULL |
Guaranteed Payments
|
| 5 |
GUARANTEED_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Guaranteed Payments Alias Name
Prompt Table:
PA_ALIAS_USE
|
| 6 |
PCT_CONTINUE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Percent Continued Field Type
A=Alias Name
N=Numeric Constant
Default Value: N
|
| 7 |
PCT_CONTINUED |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Percent Continued to Survivor
|
| 8 |
PCT_CONTINUE_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Percent Continued Alias Name
Prompt Table:
PA_ALIAS_USE
|
| 9 |
FORM_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Form Calc Method
A=Custom Statement
C=Constant
R=Actuarial
T=Table Use
U=User Code
Default Value: R
|
| 10 |
ACTUARIAL_ASSUME |
Character(10) |
VARCHAR2(10) NOT NULL |
Actuarial Assumption Set
Prompt Table:
PA_DFN_FACTOR
|
| 11 |
ARITHMETIC_STMT |
Character(10) |
VARCHAR2(10) NOT NULL |
Arithmetic Method Custom Stmt
Prompt Table:
PA_CUSTOM
|
| 12 |
TABLE_USE_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Table Use Name
Prompt Table:
PA_TBL_ALS_SRCH
|
| 13 |
CONSTANT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Constant Field Type
A=Alias Name
N=Numeric Constant
Default Value: N
|
| 14 |
CONSTANT_AMT |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Constant Amount
|
| 15 |
CONSTANT_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Constant Alias Name
Prompt Table:
PA_ALIAS_USE
|
| 16 |
QJSA_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Qualified Joint && Survivor
N=
Y=Qualified Joint and Survivor
Y/N Table Edit
|
| 17 |
SPOUSAL_CONSENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Spousal Consent
Y/N Table Edit
|
| 18 |
DEFAULT_SINGLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Form (Single)
Y/N Table Edit
|
| 19 |
DEFAULT_MARRIED |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Form (Joint)
Y/N Table Edit
|
| 20 |
ALT_ASSUMPTION_SET |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Alternate Assumption Set
Y/N Table Edit
|
| 21 |
ALT_SET_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Assumption Set Name
Prompt Table:
PA_DFN_FACTOR
|
| 22 |
ALT_SET_CONDITIONS |
Character(1) |
VARCHAR2(1) NOT NULL |
Alt Assumption Set Conditions
L=if Lump Sum is More Than
U=User Code
Default Value: L
|
| 23 |
ALT_SET_MAX_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Lumpsum More Than Amt Type
A=Alias Name
N=Numeric Constant
Default Value: N
|
| 24 |
ALT_SET_MAXIMUM |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Lump Sum More Than Amount
|
| 25 |
ALT_SET_MAX_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Lump Sum More Than Alias Name
Prompt Table:
PA_ALIAS_USE
|
| 26 |
ALT_SET_MIN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Subject to Minimum of
Y/N Table Edit
|
| 27 |
ALT_SET_MIN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Alt Assumption Set Min Type
A=Alias Name
N=Numeric Constant
Default Value: N
|
| 28 |
ALT_SET_MINIMUM |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Alt Assumption Set Minimum
|
| 29 |
ALT_SET_MIN_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Alt Assumption Set Min Alias
Prompt Table:
PA_ALIAS_USE
|
| 30 |
LUMPSUM_NA |
Character(1) |
VARCHAR2(1) NOT NULL |
Lump Sum Not Available
Y/N Table Edit
|
| 31 |
LUMP_NA_CONDITIONS |
Character(1) |
VARCHAR2(1) NOT NULL |
Lump Sum N/A Conditions
L=if Lump Sum is More Than
U=User Code
|
| 32 |
LUMP_NA_MAX_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Lump Sum N/A More Than Type
A=Alias Name
N=Numeric Constant
Default Value: N
|
| 33 |
LUMP_NA_MAXIMUM |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Lump Sum N/A More Than Amt
|
| 34 |
LUMP_NA_MAX_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Lump Sum N/A More Than Alias
Prompt Table:
PA_ALIAS_USE
|
| 35 |
LUMP_MAXIMUM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Maximum Lump Sum Amount
Y/N Table Edit
|
| 36 |
LUMP_MAXIMUM_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Maximum Lump Sum Field Type
A=Alias Name
N=Numeric Constant
Default Value: N
|
| 37 |
LUMP_MAXIMUM |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Maximum Lump Sum
|
| 38 |
LUMP_MAXIMUM_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Maximum Lump Sum Alias Name
Prompt Table:
PA_ALIAS_USE
|
| 39 |
LUMP_MINIMUM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Minimum Lump Sum Amount
Y/N Table Edit
|
| 40 |
LUMP_MINIMUM_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Minimum Lump Sum Field Type
A=Alias Name
N=Numeric Constant
Default Value: N
|
| 41 |
LUMP_MINIMUM |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
Minimum Lump Sum
|
| 42 |
LUMP_MINIMUM_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Minimum Lump Sum Alias Name
Prompt Table:
PA_ALIAS_USE
|
| 43 |
PIA_FUNCTION_RESLT |
Character(10) |
VARCHAR2(10) NOT NULL |
Social Security PIA Name
Prompt Table:
PA_SSPIA_FR_VW
|
| 44 |
LIO_AGE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Threshold Age Field Type
A=Alias Name
N=Numeric Constant
Default Value: N
|
| 45 |
LIO_AGE |
Number(3,0) |
SMALLINT NOT NULL |
Threshold Age
|
| 46 |
LIO_AGE_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Threshold Age Alias Name
Prompt Table:
PA_ALIAS_USE
|
| 47 |
ACCOUNT_BAL_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Account Balance Result Name
Prompt Table:
PA_ACTBAL_FR_VW
|
| 48 |
DEATH_PAYMENT_FORM |
Character(1) |
VARCHAR2(1) NOT NULL |
Insurance is Paid as
A=Continued Annuity
S=Single Sum
Default Value: S
|
| 49 |
GUARANTEED_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Guaranteed Alias Type
|
| 50 |
PCT_CONTINU_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Pct Continued Alias Type
|
| 51 |
CONSTANT_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Constant Alias Type
|
| 52 |
ALT_SET_MAX_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Lump Sum More Than Alias Type
|
| 53 |
ALT_SET_MIN_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Alt Assumption Set Min Alias T
|
| 54 |
LUMP_NA_MAX_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Lum Sum N/A More Than Alias Ty
|
| 55 |
LUMP_MAXIMU_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Maximum Lump Sum Alias Type
|
| 56 |
LUMP_MINIMU_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Minimum Lump Sum Alias Type
|
| 57 |
LIO_AGE_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Threshold Age Alias Type
|
| 58 |
SMALL_BNFT_CASHOUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Small Benefit Cashout
|
| 59 |
FOR_415_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
For 415 only
Y/N Table Edit
Default Value: N
|
| 60 |
LUMP_BENE_FORMULA |
Character(10) |
VARCHAR2(10) NOT NULL |
Benefit Formula at NRD Name
Prompt Table:
PA_BENCALCFR_VW
|
| 61 |
EE_PAY_AGE_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Employee Cashout Age Alias
Prompt Table:
PA_DURATION
|
| 62 |
EE_PAY_AGE_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Employee Cashout Age Alias Typ
|
| 63 |
BN_PAY_AGE_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Beneficiary Cashout Age Alias
Prompt Table:
PA_DURATION
|
| 64 |
BN_PAY_AGE_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Beneficiary Cashout Age Aliast
|
| 65 |
CASHOUT_THRESHOLD |
Number(16,6) |
DECIMAL(15,6) NOT NULL |
Small Beneft Cashout Threshold
|
| 66 |
USER_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type Of User Input
B=Amount, Factor, and Frequency
F=Factor and Frequency
Default Value: F
|
| 67 |
LIO_USER_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
User Code (Beneficiary $)
Y/N Table Edit
Default Value: N
|
| 68 |
SP_BCD_AGE_ALIAS |
Character(10) |
VARCHAR2(10) NOT NULL |
Spouse Age
Prompt Table:
PA_DURATION
|
| 69 |
SP_BCD_AGE_ALIAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Spouse Age at BCD Alias T
|