STMT_PARALLEL (SQL Table)	Index Back
PS/AR Parallel Control table Used to store partioned data by correspondence setid/custid for Statements.

STMT_PARALLEL

(SQL Table)

PS/AR Parallel Control table

Used to store partioned data by correspondence setid/custid for Statements.

# 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 CRSPD_SETID Character(5) VARCHAR2(5) NOT NULL SetID

4 CRSPD_CUST_ID Character(15) VARCHAR2(15) NOT NULL Correspondence Customer

5 PARTITION1 Number(2,0) SMALLINT NOT NULL Parallel processing partition

6 CONTROL_CNT Number(6,0) INTEGER NOT NULL Represents the number of pending items in a control group. Receivables compares the control count to the actual entry count and calculates the difference in order to help verify that all entries have been made correctly

#	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	CRSPD_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
4	CRSPD_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Correspondence Customer
5	PARTITION1	Number(2,0)	SMALLINT NOT NULL	Parallel processing partition
6	CONTROL_CNT	Number(6,0)	INTEGER NOT NULL	Represents the number of pending items in a control group. Receivables compares the control count to the actual entry count and calculates the difference in order to help verify that all entries have been made correctly