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 | DEFINITION_NAME | 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 |
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 |
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 |