| # |
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:
FSA_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 |
SRVC_DT_FROM |
Date(10) |
DATE |
FSA Service From Date
|
| 5 |
SRVC_DT_THRU |
Date(10) |
DATE |
FSA Service To Date
|
| 6 |
PLAN_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
FSA Plan Year
Prompt Table:
FSA_YEAR_VW
|
| 7 |
FSA_CLOSE |
Character(1) |
VARCHAR2(1) NOT NULL |
FSA Close
Y/N Table Edit
|
| 8 |
PAY_FREQUENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Pay Frequency
A=Annual
B=Biweekly
D=Daily
M=Monthly
Q=Quarterly
S=Semimonthly
W=Weekly
Default Value: M
Prompt Table:
BEN_FREQ_VW
|
| 9 |
EMPLR_CONTRBUTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Employer Contribution
1=Flat Amount
2=Percent of Employee Contrbutn
3=Special Calculation Routine
4=None
Default Value: 1
|
| 10 |
FLAT_CONTRB_AMT |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Flat Contribution Amount
|
| 11 |
PCT_EMPL_CONTRBUTN |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Percent of Employee Contributn
|
| 12 |
EMPLR_CONTRB_AMT |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Employer Contrib Limit Amt
|
| 13 |
EMPLR_CONTRB_PCT |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Employer Contribution Limit %
|
| 14 |
FUTURE_BORROWING |
Character(1) |
VARCHAR2(1) NOT NULL |
Future Borrowing?
Y/N Table Edit
|
| 15 |
CARRYFORWARD_ER |
Character(2) |
VARCHAR2(2) NOT NULL |
Employer Carry forward Choice
CL=Employer Selected Claim
CR=Employer Selected Credit
|
| 16 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SETID_TBL
|
| 17 |
BALANCE_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Balance ID
Prompt Table:
BALANCE_ID_TBL
|
| 18 |
PLAN_CONTRIBUTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Plan Contribution
N=Employer Only (No EE)
O=EE Contribution Optional
R=EE Contribution Required
Default Value: R
|
| 19 |
BN_SPEND_ACCT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
This is used to identify the type of Spending Account plan being defined, since different account types have different business and legislative requirements.
FSA=Flexible Spending Account
HSA=Health Savings Account
Default Value: FSA
|
| 20 |
FSA_MIN_CHECK_AMT |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
FSA Minimum Check Amount
|
| 21 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 22 |
IGNORE_MIN_CHK_AMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Ignore Min Check Amt at Close
Y/N Table Edit
|
| 23 |
MIN_ANNUAL_CONTRIB |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Minimum Annual Contribution
|
| 24 |
MAX_ANNUAL_CONTRIB |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Maximum Annual Contribution
|
| 25 |
FSA_CARRYOVER_LMT |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
The field will contain the carryover limit for health spending accounts
|
| 26 |
BN_HSA_CATCHUP_AMT |
Number(14,2) |
DECIMAL(13,2) NOT NULL |
This defines the additional amount which can be contributed to an HSA plan due to age-related limit extensions.
|
| 27 |
BN_HSA_CATCHUP_AGE |
Number(2,0) |
SMALLINT NOT NULL |
This defines the age upon which additional amounts can be contributed to an HSA plan due to age-related limit extensions.
|