CALC_NAMEEMPLIDBENEFIT_PLANPrompt Table: PA_PLAN_ORDER
N=Spouse is Ineligible
Y=Spouse Is Eligible
F=Female
M=Male
PA_CLC_PLN_BENE(SQL Table) |
Index Back |
|---|---|
Calculation Inputs by PlanThis is a parameter table containing Calc Input Parameters which are plan specific. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CALC_NAME |
Character(20) | VARCHAR2(20) NOT NULL | Calculation Name |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table: PA_PLAN_ORDER |
| 4 | PA_SS_ELIG | Character(1) | VARCHAR2(1) NOT NULL |
Surviving Spouse Eligibility
N=Spouse is Ineligible Y=Spouse Is Eligible |
| 5 | PA_BENEF_DOB | Date(10) | DATE | Beneficiary Birthdate |
| 6 | PA_BENEF_SEX | Character(1) | VARCHAR2(1) NOT NULL |
Beneficiary Gender
F=Female M=Male |
| 7 | PA_BENEF_NAME | Character(40) | VARCHAR2(40) NOT NULL | Beneficiary Name |