RUN_CNTL_FSS

#	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	REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Request ID
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	PROCESS_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Process Frequency A=Always Process N=Don't Run O=Process Once Default Value: N
6	PROCESS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Process Status A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now X=No Success
7	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
8	JOBNAME	Character(8)	VARCHAR2(8) NOT NULL	Process Scheduler Job Name
9	DTTM_STAMP_SEC	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
10	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
11	SELECT_CUSTOMER	Character(1)	VARCHAR2(1) NOT NULL	Select Customers Y/N Table Edit Default Value: Y
12	ALL_SETID	Character(1)	VARCHAR2(1) NOT NULL	All Item SetIDs Y/N Table Edit Default Value: Y
13	SL_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: FSS_SETID_VW
14	TO_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: FSS_SETID_VW
15	SL_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer ID selection Prompt Table: FSS_CUSTOMER_VW
16	TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer ID Prompt Table: FSS_CUSTOMER_VW
17	SELECT_ORDERS	Character(1)	VARCHAR2(1) NOT NULL	Select Orders Y/N Table Edit Default Value: Y
18	ALL_OM_BU	Character(1)	VARCHAR2(1) NOT NULL	All Business Units Y/N Table Edit Default Value: Y
19	SL_OM_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: FSS_BU_OM_VW
20	TO_OM_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: FSS_BU_OM_VW
21	SL_OM_ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Order Number Prompt Table: FSS_ORDER_VW
22	TO_OM_ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Order Number Prompt Table: FSS_ORDER_VW
23	SELECT_MSR	Character(1)	VARCHAR2(1) NOT NULL	Select Stock Requests Y/N Table Edit Default Value: Y
24	ALL_BU	Character(1)	VARCHAR2(1) NOT NULL	All Business Units N=Specific Business Unit Y=All Business Units Y/N Table Edit Default Value: Y
25	SL_BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit selection field Prompt Table: FSS_BU_IN_VW
26	TO_BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit selection field Prompt Table: FSS_BU_IN_VW
27	SL_ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Order Number selection Prompt Table: FSS_MSR_VW
28	TO_ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Order Number selection Prompt Table: FSS_MSR_VW
29	SELECT_INVOICE	Character(1)	VARCHAR2(1) NOT NULL	Select Invoices Y/N Table Edit Default Value: Y
30	ALL_BI_BU	Character(1)	VARCHAR2(1) NOT NULL	All Business Units Y/N Table Edit Default Value: Y
31	SL_BI_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BI_BU_FSS_VW
32	TO_BI_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BI_BU_FSS_VW
33	SL_INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice Prompt Table: FSS_INVOICE_VW
34	TO_INVOICE	Character(30)	VARCHAR2(30) NOT NULL	To Invoice Prompt Table: FSS_INVOICE_VW
35	FSS_SELECT_ALL	Character(1)	VARCHAR2(1) NOT NULL	Select All 1=Process All 2=Process Selected Default Value: 1
36	FSS_ORD_ADDR_OVR	Character(1)	VARCHAR2(1) NOT NULL	Only Screen Address Overrides Y/N Table Edit Default Value: N
37	FSS_MSR_ADDR_OVR	Character(1)	VARCHAR2(1) NOT NULL	Only Screen Address Overrides Y/N Table Edit Default Value: N
38	FSS_INV_ADDR_OVR	Character(1)	VARCHAR2(1) NOT NULL	Only Screen Address Overrides Y/N Table Edit Default Value: N
39	FSS_RESCREEN	Character(1)	VARCHAR2(1) NOT NULL	Re-Screen Y/N Table Edit Default Value: N