| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PLAN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
Prompt Table:
LEAVE_PLAN_VW
|
| 2 |
BENEFIT_PLAN |
Character(6) |
VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table:
BENEF_PLAN_TBL
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
ACCRUAL_PROC_DT |
Date(10) |
DATE |
Accrual Process Date
|
| 5 |
ACCRUAL_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Accrual Rate Units
H=Hours per Hour
M=Hours per Month
P=Hours per Pay Period
W=Hours per Week
Y=Hours per Year
Default Value: M
|
| 6 |
SERVICE_INTERVAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Service Units
H=Hours
M=Months
P=Pay Period
Y=Years
Default Value: M
|
| 7 |
SPECIAL_CALCULATN |
Character(1) |
VARCHAR2(1) NOT NULL |
Special Calculation Routine
Y/N Table Edit
Default Value: N
|
| 8 |
YEAR_BEGIN_CALC |
Character(1) |
VARCHAR2(1) NOT NULL |
Service Calc at Year Begin
Y/N Table Edit
Default Value: N
|
| 9 |
MAXIMUM_LEAVE_BAL |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Max Leave Balance
Default Value: 99999
|
| 10 |
MAXIMUM_CARRYOVER |
Number(9,3) |
DECIMAL(8,3) NOT NULL |
Max Leave Carryover
|
| 11 |
PAY_AT_TERMINATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay at Termination
Y/N Table Edit
Default Value: N
|
| 12 |
PAY_TERM_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Pay at Termination Percent
|
| 13 |
PAY_VS_LEAVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay in Lieu of Time Off
Y/N Table Edit
Default Value: N
|
| 14 |
HRS_GO_NEGATIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Accrued Balance Go Negative
Y/N Table Edit
Default Value: N
|
| 15 |
MAX_NEG_HRS |
Number(4,0) |
SMALLINT NOT NULL |
This Field is used to Define Maximum Positive Hours Allowed for a Compensatory Time Off Plan and for Leave Plan
|
| 16 |
GVT_RLV_INTERVAL |
Number(3,0) |
SMALLINT NOT NULL |
Months Until Expiration
|
| 17 |
GVT_RLV_EOY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Extend Expiration to Year End
Y/N Table Edit
Default Value: N
|
| 18 |
BALANCE_VISIBLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Determines if the leave plan should be made visible to the employee.
Y/N Table Edit
Default Value: Y
|