| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BENEFIT_PROGRAM |
Character(3) |
VARCHAR2(3) NOT NULL |
Defines a collection of benefit plans and their associated rate and calculation rules.
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 6 |
PROGRAM_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Program Type
A=Automated
M=Manual
|
| 7 |
FSA_RUN_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Flexible Spending Acct Run ID
Prompt Table:
FSA_RUN_TBL
|
| 8 |
FSA_MAX_ANNL_PLDG |
Number(9,2) |
DECIMAL(8,2) NOT NULL |
FSA Maximum Annual Pledge
|
| 9 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 10 |
DFLT_EXPIRATION_DD |
Number(3,0) |
SMALLINT NOT NULL |
Number of Days Before Defaults
|
| 11 |
DFLT_CREDIT_RLLOVR |
Character(1) |
VARCHAR2(1) NOT NULL |
Field to Apply Excess Credits to
C=Cash
D=FSA - Dependent Care
F=Forfeit Excess Credits
H=FSA - Health Care
R=FSA-Retirement Counseling
S=Savings - 401(k)
Default Value: C
|
| 12 |
COBRA_SURCHARGE |
Number(2,0) |
SMALLINT NOT NULL |
COBRA Surcharge Percent
|
| 13 |
COBRA_DISABL_SURCG |
Number(2,0) |
SMALLINT NOT NULL |
COBRA Disabled Surcharge Percent
|
| 14 |
FMLA_PLAN_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Family Medical Leave Plan ID
Prompt Table:
FMLA_PLAN_TBL
|
| 15 |
SHOW_CREDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
This field tells the system whether or not to show credits on the enrollment form.
Y/N Table Edit
Default Value: Y
|
| 16 |
COST_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Freq on Enrollment Form
A=Annual Frequency
D=Deduction Frequency
Default Value: A
|
| 17 |
HANDBOOK_URL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
This field holds the ID of a URL object. The URL object points to the companies enrollment handbook.
Prompt Table:
PSURLDEFN
|
| 18 |
INCLD_CNSLSTX |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicator that designates whether to Include the Canadian Sales Tax on the enrollment form or not.
Y/N Table Edit
Default Value: N
|
| 19 |
BAS_SHOW_ER_COSTS |
Character(1) |
VARCHAR2(1) NOT NULL |
This field tells the system whether or not to show the employer's contributions ("costs") on the enrollment form.
Y/N Table Edit
Default Value: N
|
| 20 |
BAS_SHOW_TAX_IMPCT |
Character(1) |
VARCHAR2(1) NOT NULL |
This field tells the system whether or not to alert the employee to any potential tax impacts (due to the employer's contributions) on the enrollment form. Most typically, this would be if there is a T-Tax (imputed Income) component.
Y/N Table Edit
Default Value: N
|
| 21 |
COBRA_CONTACT_ID |
Number(3,0) |
SMALLINT NOT NULL |
Used to identify a contact name/address for COBRA Administration purposes. This is a reference to an existing entry on the BEN_CONTACT_TBL.
Prompt Table:
BEN_CONTACT_TBL
|