ORD_COMMPCT_TMP (SQL Table)	Index Back
Order Commsns Update Temp Tbl This temporary table is used during the background processing program which determines the appropriate commission percent per team member. The commission percentage is calculated off of the quota tables and is based on the activity to date of bookings and sales.

ORD_COMMPCT_TMP

(SQL Table)

Order Commsns Update Temp Tbl

This temporary table is used during the background processing program which determines the appropriate commission percent per team member. The commission percentage is calculated off of the quota tables and is based on the activity to date of bookings and sales.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 SUPPORT_TEAM_MBR Character(8) VARCHAR2(8) NOT NULL Team Member

3 DATE_FROM Date(10) DATE NOT NULL Date From

4 DATE_TO Date(10) DATE NOT NULL Date To

5 TOTAL_AMOUNT Signed Number(16,4) DECIMAL(14,4) NOT NULL Total Amount

6 COMM_PCT Number(6,2) DECIMAL(5,2) NOT NULL Commission %

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	SUPPORT_TEAM_MBR	Character(8)	VARCHAR2(8) NOT NULL	Team Member
3	DATE_FROM	Date(10)	DATE NOT NULL	Date From
4	DATE_TO	Date(10)	DATE NOT NULL	Date To
5	TOTAL_AMOUNT	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Total Amount
6	COMM_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Commission %