FSA_RUNCTL (SQL Table)	Index Back
FSA Run Controls FSA_RUNCTL is a temporary record that holds the parameters for processing the next FSA cycle. It is entered online using the Benefits window and is updated once the FSA process begins. Multiple run IDs for different calendar years in the same payment processing cycle can be entered but each combination of calendar year and run ID must be unique. FSA001 and FSA005 update the run report and quarterly flags.

FSA_RUNCTL

(SQL Table)

FSA Run Controls

FSA_RUNCTL is a temporary record that holds the parameters for processing the next FSA cycle. It is entered online using the Benefits window and is updated once the FSA process begins. Multiple run IDs for different calendar years in the same payment processing cycle can be entered but each combination of calendar year and run ID must be unique. FSA001 and FSA005 update the run report and quarterly flags.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year

2 FSA_RUN_ID Character(3) VARCHAR2(3) NOT NULL Flexible Spending Acct Run ID
Prompt Table: FSA_RUN_TBL

3 CALENDAR_END_DT Date(10) DATE NOT NULL Calendar End Date

4 FORM_ID Character(6) VARCHAR2(6) NOT NULL Form Identification
Prompt Table: PAY_FORM_TBL

5 CHECK_DT Date(10) DATE NOT NULL Check date.

6 FSA_RUN_STATUS Character(1) VARCHAR2(1) NOT NULL FSA Run Status
C=Calculated
F=Finished
R=Ready
Default Value: R

7 FSA_QTRLY_RPT_RUN Character(1) VARCHAR2(1) NOT NULL Quarterly Report Run
F=Finished
R=Ready
Default Value: R

8 SYSTEM_DATE Date(10) DATE System Date
Default Value: %Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CALENDAR_YEAR	Number(4,0)	SMALLINT NOT NULL	Calendar Year
2	FSA_RUN_ID	Character(3)	VARCHAR2(3) NOT NULL	Flexible Spending Acct Run ID Prompt Table: FSA_RUN_TBL
3	CALENDAR_END_DT	Date(10)	DATE NOT NULL	Calendar End Date
4	FORM_ID	Character(6)	VARCHAR2(6) NOT NULL	Form Identification Prompt Table: PAY_FORM_TBL
5	CHECK_DT	Date(10)	DATE NOT NULL	Check date.
6	FSA_RUN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	FSA Run Status C=Calculated F=Finished R=Ready Default Value: R
7	FSA_QTRLY_RPT_RUN	Character(1)	VARCHAR2(1) NOT NULL	Quarterly Report Run F=Finished R=Ready Default Value: R
8	SYSTEM_DATE	Date(10)	DATE	System Date Default Value: %Date