RF_ASGN_PGD_OUT(SQL Table) |
Index Back |
|---|---|
Assignment Engine DetailThis table is used to display a detail list of candidates as a result of the assignment engine search for a Provider Group. |
| # | 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 |