PA_DFN_OPT_SET(SQL Table) |
Index Back |
|---|---|
Optional FormsThis is a setup table containing Optional Forms parameters. |
| # | 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 | BENEFIT_FORMULA | Character(10) | VARCHAR2(10) NOT NULL |
Benefit Formula Name
Prompt Table: PA_BENCALCFR_VW |
| 4 | EE_AGE_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Employee Age Option
B=Use Benefit Commencement Age L=Use Lump Sum Age O=Use Other Age Default Value: B |
| 5 | EE_AGE_ALIAS | Character(10) | VARCHAR2(10) NOT NULL |
Employee Age Alias
Prompt Table: PA_DURATION |
| 6 | EE_AGE_ALIAST | Character(2) | VARCHAR2(2) NOT NULL | Employee Age Alias Type |
| 7 | BN_BCD_AGE_ALIAS | Character(10) | VARCHAR2(10) NOT NULL |
Beneficiary Age
Prompt Table: PA_DURATION |
| 8 | BN_BCD_AGE_ALIAST | Character(2) | VARCHAR2(2) NOT NULL | Beneficiary Age at BCD Alias T |
| 9 | BYPASS_FORM_SET | Character(1) | VARCHAR2(1) NOT NULL |
Bypass This Set If
Y/N Table Edit |
| 10 | BYPASS_CUSTOM_STMT | Character(10) | VARCHAR2(10) NOT NULL |
Custom Statement is True
Prompt Table: PA_CUSTOM |
| 11 | USE_IN_415 | Character(1) | VARCHAR2(1) NOT NULL |
Use Formset in 415 Processing
N=DO NOT USE THIS SET IN 415 Y=USE THIS SET IN 415 |
| 12 | TAX_USER_CODE | Character(1) | VARCHAR2(1) NOT NULL |
User code for Tax handling
N=No Nontaxable Ben Calc S=Simplified Nontaxable Ben Calc Y=User Code for Nontaxable Ben. Default Value: S |
| 13 | PA_CB_CONT_SW | Character(1) | VARCHAR2(1) NOT NULL |
Allow Contingent Beneficiaries
Y/N Table Edit Default Value: N |