RF_ASSIGN_WT_PG (SQL Table)	Index Back
Assign Opt Weighting Prov Grp Stores the weighting value for each option for a provider group that is used when running the Assignment Engine to assign people to a service order/case.

RF_ASSIGN_WT_PG

(SQL Table)

Assign Opt Weighting Prov Grp

Stores the weighting value for each option for a provider group that is used when running the Assignment Engine to assign people to a service order/case.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_RB.SETID
Prompt Table: SP_SETID_NONVW

2 CRITERIA_CODE Character(2) VARCHAR2(2) NOT NULL A code representing the type of criteria that will be used to match people with Service Orders or Call Center Cases. If a new translate value is added or deleted, then change &NumFactors in People Code. If a translate value is added/changed/deleted here, check to see if it needs to be added to CRITERIA_CODE_PER as well.
1=Customer
10=Department
11=Security Role
12=Person Type
2=Region
3=Product
4=Product Group
5=Site
6=Competency - Service
7=Location
8=Competency - CTD
9=Competency - Problem Type

3 CRITERIA_WEIGHT Number(2,0) SMALLINT NOT NULL Competency Weight

4 MARKET Character(3) VARCHAR2(3) NOT NULL Market

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW
2	CRITERIA_CODE	Character(2)	VARCHAR2(2) NOT NULL	A code representing the type of criteria that will be used to match people with Service Orders or Call Center Cases. If a new translate value is added or deleted, then change &NumFactors in People Code. If a translate value is added/changed/deleted here, check to see if it needs to be added to CRITERIA_CODE_PER as well. 1=Customer 10=Department 11=Security Role 12=Person Type 2=Region 3=Product 4=Product Group 5=Site 6=Competency - Service 7=Location 8=Competency - CTD 9=Competency - Problem Type
3	CRITERIA_WEIGHT	Number(2,0)	SMALLINT NOT NULL	Competency Weight
4	MARKET	Character(3)	VARCHAR2(3) NOT NULL	Market