PA_DFN_VESTSCHD(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 | SCHED_NAME |
Character(10) | VARCHAR2(10) NOT NULL | Work Schedule Name |
| 3 | CLIFF_SVC_RSLT | Character(10) | VARCHAR2(10) NOT NULL |
Cliff Service Result
Prompt Table: PA_DFN_SVC_VW |
| 4 | STEP_SVC_RSLT | Character(10) | VARCHAR2(10) NOT NULL |
Step Service Result
Prompt Table: PA_DFN_SVC_VW |
| 5 | AGE_RSLT | Character(10) | VARCHAR2(10) NOT NULL |
Age Result
Prompt Table: PA_DURATION |
| 6 | SCHED_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Schedule Type
A=Age C=Cliff S=Step Vesting T=User Table U=User Code Default Value: C |
| 7 | TABLE_USE_NAME | Character(10) | VARCHAR2(10) NOT NULL |
Table Use Name
Prompt Table: PA_TBL_LOOKUP |
| 8 | CLIFF_SCHED_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
100% Vested After Field Type
A=Alias Name N=Numeric Constant Default Value: N |
| 9 | CLIFF_SCHED | Number(3,0) | SMALLINT NOT NULL | 100% Vested After |
| 10 | CLIFF_SCHED_ALIAS | Character(10) | VARCHAR2(10) NOT NULL |
100% Vested After
Prompt Table: PA_ALIAS_USE |
| 11 | INTERPOLATE_VST | Character(1) | VARCHAR2(1) NOT NULL |
05/22/03 Lee ICE 51587000 - Change Shortname = Interpolate
Y/N Table Edit Default Value: N |
| 12 | CLIFF_SCHED_ALIAST | Character(2) | VARCHAR2(2) NOT NULL | Cliff Sched Alias type |