FSA_YEAR_VW(SQL View) |
Index Back |
---|---|
FSA Plan YearThe FSA_YEAR_VW is used to get the Balance Years from the Balance_ID Table to validate the entry of valid years for the FSA Closure Process. |
SELECT DISTINCT A.BALANCE_YEAR FROM PS_BALANCE_ID_DEF A |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BALANCE_YEAR | Number(4,0) | SMALLINT NOT NULL |
Balances for Year
Prompt Table: FSA_YEAR_VW |