FSA_CARRY_ADJST

(SQL Table)
Index Back

FSA Carryover adjustment

Carryover adjustment

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

2 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.
3 BALANCE_YEAR Number(4,0) SMALLINT NOT NULL Balances for Year
4 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
5 FSA_CARRYOVER_AMT Signed Number(10,2) DECIMAL(8,2) NOT NULL employee annual carryover amount which cannot exceed the FSA carryover limit. This amount is display only on the ee Spending account page.
6 FSA_ADJUST_AMT Signed Number(10,2) DECIMAL(8,2) NOT NULL FSA adjustment to the carryover amount
7 FSA_CARRYOVER_CALC Signed Number(10,2) DECIMAL(8,2) NOT NULL This is the calculated carryover amount. The calculation is done in the current year and the value becomes (minus carryover amount already used fsa_carry_used) carryover amount for the new year.
8 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

Default Value: %datetime

9 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
10 FSA_COMMENTS Character(50) VARCHAR2(50) NOT NULL Comments for the FSA carryover adjustment