PA_DFN_VEST

(SQL Table)
Index Back

Vesting

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