FSA_CARRY_ADJST(SQL Table) |
Index Back |
---|---|
FSA Carryover adjustmentCarryover 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 |