PA_DFN_VEST(SQL Table) |
Index Back |
|---|---|
VestingThis is a setup table containing Vesting parameters. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(10) | VARCHAR2(10) NOT NULL | VARCHAR2(10) NOT NULL | |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | IMMEDIATE_VESTING | Character(1) | VARCHAR2(1) NOT NULL |
Immediate Vesting
Y/N Table Edit Default Value: N |
| 4 | CONTRIB_WITHDRAWAL | Character(1) | VARCHAR2(1) NOT NULL |
Withdrawal of Contributions
Y/N Table Edit Default Value: N |
| 5 | FORFEIT_CUSTOM | Character(1) | VARCHAR2(1) NOT NULL |
Custom Statement
Y/N Table Edit Default Value: N |
| 6 | FORFEIT_STMT | Character(10) | VARCHAR2(10) NOT NULL |
Custom Statement Name
Prompt Table: PA_CUSTOM |
| 7 | DEATH_NO_SPOUSE | Character(1) | VARCHAR2(1) NOT NULL |
Death with No Beneficiary
Y/N Table Edit Default Value: N |
| 8 | FORFEIT_USER_CODE | Character(1) | VARCHAR2(1) NOT NULL |
User Code
Y/N Table Edit Default Value: N |
| 9 | COND_DISABILITY | Character(1) | VARCHAR2(1) NOT NULL |
Become Disabled
Y/N Table Edit Default Value: N |
| 10 | COND_DEATH | Character(1) | VARCHAR2(1) NOT NULL |
Death
Y/N Table Edit Default Value: N |
| 11 | COND_CUSTOM | Character(1) | VARCHAR2(1) NOT NULL |
Custom Statement
Y/N Table Edit Default Value: N |
| 12 | COND_STMT | Character(10) | VARCHAR2(10) NOT NULL |
Custom Statement Name
Prompt Table: PA_CUSTOM |
| 13 | COND_USER_CODE | Character(1) | VARCHAR2(1) NOT NULL |
User Code
Y/N Table Edit Default Value: N |
| 14 | MIN_VEST_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Minimum Vesting Percentage
A=Alias Name N=Numeric Constant Default Value: N |
| 15 | MIN_VEST | Number(10,6) | DECIMAL(9,6) NOT NULL | Minimum Vesting Percentage |
| 16 | MIN_VEST_ALIAS | Character(10) | VARCHAR2(10) NOT NULL |
Minimum Vesting Percentage
Prompt Table: PA_ALIAS_USE |
| 17 | VEST_RETIRE_TYPES | Character(1) | VARCHAR2(1) NOT NULL |
Retirement Types
Y/N Table Edit Default Value: N |