RC_FMLI_CO (SQL Table)	Index Back
Run Control for SQR Report Process Scheduler report parameter record utilized by TAX815CO

RC_FMLI_CO

(SQL Table)

Run Control for SQR Report

Process Scheduler report parameter record utilized by TAX815CO

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 AMEND_RET_CO Character(1) VARCHAR2(1) NOT NULL Stores the value for the Amended or Original Return flag.
A=Amended
O=Original
Default Value: O

4 PY_FILE_FORMAT Character(1) VARCHAR2(1) NOT NULL Stores the file format to report the data to the corresponding revenue office.
A=Fewer Than 15,000 Employees
C=CSV Format
E=Employer Submission
G=15,000 Or More Employees
I=ICESA Format
M=More Than One Company Per File
O=One Company Per File
T=Agent Submission
Default Value: M

5 PY_TPA_IND Character(1) VARCHAR2(1) NOT NULL This field is use to set if Preparer is a TPA.
N=Single Filer
Y=TPA / Preparer
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	AMEND_RET_CO	Character(1)	VARCHAR2(1) NOT NULL	Stores the value for the Amended or Original Return flag. A=Amended O=Original Default Value: O
4	PY_FILE_FORMAT	Character(1)	VARCHAR2(1) NOT NULL	Stores the file format to report the data to the corresponding revenue office. A=Fewer Than 15,000 Employees C=CSV Format E=Employer Submission G=15,000 Or More Employees I=ICESA Format M=More Than One Company Per File O=One Company Per File T=Agent Submission Default Value: M
5	PY_TPA_IND	Character(1)	VARCHAR2(1) NOT NULL	This field is use to set if Preparer is a TPA. N=Single Filer Y=TPA / Preparer Default Value: N