RF_ASGN_WKD_TMP(SQL Table) |
Index Back |
|---|---|
Assignment Engine WorkerThis table stores a row for each hit on the assignment engine search for each worker. This list of candidates will then be placed in RF_ASGN_WKD_OUT to be displayed to the user. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 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 | SCORE | Number(7,2) | DECIMAL(6,2) NOT NULL | Test Score |
| 4 | SCORE_TOTAL | Number(7,2) | DECIMAL(6,2) NOT NULL | Total Score |
| 5 | COMPETENCY | Character(8) | VARCHAR2(8) NOT NULL | Competency - this field is brought over from HRMS |
| 6 | ACTIVITY_CODE | Character(8) | VARCHAR2(8) NOT NULL | Activity Code which identifies the specific Activities which will be performed as part of Service Orders. |
| 7 | PRODUCT_GROUP | Character(10) | VARCHAR2(10) NOT NULL | PRoduct Group |
| 8 | REGION_ID | Character(15) | VARCHAR2(15) NOT NULL | This field stores the region id value. |
| 9 | AVAILABILITY_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate that someone or something is available.
Y/N Table Edit |
| 10 | RC_CASE_COUNT | Number(7,0) | INTEGER NOT NULL | Case Count |
| 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 |