RF_ASGN_PGD_TMP (SQL Table)	Index Back
Assignment Engine Detail This table stores a row for each hit on the assignment engine search for each Provider Group. This list of candidates will then be placed in RF_ASGN_PGD_OUT to be displayed to the user.

RF_ASGN_PGD_TMP

(SQL Table)

Assignment Engine Detail

This table stores a row for each hit on the assignment engine search for each Provider Group. This list of candidates will then be placed in RF_ASGN_PGD_OUT to be displayed to the user.

# 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.

2 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.

3 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

4 SCORE Number(7,2) DECIMAL(6,2) NOT NULL Test Score

5 SCORE_TOTAL Number(7,2) DECIMAL(6,2) NOT NULL Total Score

6 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency - this field is brought over from HRMS

7 ACTIVITY_CODE Character(8) VARCHAR2(8) NOT NULL Activity Code which identifies the specific Activities which will be performed as part of Service Orders.

8 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group

9 REGION_ID Character(15) VARCHAR2(15) NOT NULL This field stores the region id value.

10 AVAILABILITY_FLAG Character(1) VARCHAR2(1) NOT NULL Flag to indicate that someone or something is available.
Y/N Table Edit

11 PERSON_ROLE Character(2) VARCHAR2(2) NOT NULL This field is used to store the Role Type for the worker.
86=Employee
87=Contingent Worker
88=Person of Interest

#	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.
2	PROVIDER_GRP_ID	Character(10)	VARCHAR2(10) NOT NULL	Identification number for the provider group.
3	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
4	SCORE	Number(7,2)	DECIMAL(6,2) NOT NULL	Test Score
5	SCORE_TOTAL	Number(7,2)	DECIMAL(6,2) NOT NULL	Total Score
6	COMPETENCY	Character(8)	VARCHAR2(8) NOT NULL	Competency - this field is brought over from HRMS
7	ACTIVITY_CODE	Character(8)	VARCHAR2(8) NOT NULL	Activity Code which identifies the specific Activities which will be performed as part of Service Orders.
8	PRODUCT_GROUP	Character(10)	VARCHAR2(10) NOT NULL	PRoduct Group
9	REGION_ID	Character(15)	VARCHAR2(15) NOT NULL	This field stores the region id value.
10	AVAILABILITY_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate that someone or something is available. Y/N Table Edit
11	PERSON_ROLE	Character(2)	VARCHAR2(2) NOT NULL	This field is used to store the Role Type for the worker. 86=Employee 87=Contingent Worker 88=Person of Interest