RF_PER_CRIT7_VW(SQL View) |
Index Back |
---|---|
Person - Location CriteriaRetrieves the location criteria used to assign an agent to a Help Desk Case. The values listed here will be compared with location on the Case. |
SELECT PERSON_ID , %subrec(RF_CRITERIA_SBR, A) FROM PS_RB_PERSON_CRIT A WHERE A.CRITERIA_CODE_PER = '7' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
2 | CRITERIA_CODE_PER | Character(2) | VARCHAR2(2) NOT NULL |
This is a copy of CRITERIA_CODE without the translate value Competencies. This field will be used on the record for the person. Competencies are assigned elsewhere.
A code representing the type of criteria that will be used to match people with Service Orders or Call Center Cases.
If a translate value is added here, check to see if it needs to be added to CRITERIA_CODE as well.
1=Customer 10=Department 11=Security Role 12=Person Type 2=Region 3=Product 4=Product Group 7=Location |
3 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL |
Sequence
Default Value: 1 |
4 | SETID_WRK | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: %EDITTABLE2 |
5 | CRITERIA_VALUE | Character(50) | VARCHAR2(50) NOT NULL | A value for criteria code that will be used to match people with Service Orders or Call Center Cases. |
6 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
7 | ROLE_TYPE_ID_CUST | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the customer |
8 | SITE_ID | Character(15) | VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table: %EDITTABLE3 |
9 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL |
Product ID
Prompt Table: RF_CRITPROD_VW |
10 | PRODUCT_GROUP | Character(10) | VARCHAR2(10) NOT NULL |
PRoduct Group
Prompt Table: RF_CRITGROUP_VW |
11 | LOCATION | Character(15) | VARCHAR2(15) NOT NULL |
This field stores the Location Code.
Prompt Table: RF_CRITLOC_VW |
12 | REGION_ID | Character(15) | VARCHAR2(15) NOT NULL |
This field stores the region id value.
Prompt Table: RF_REGIONGEO_VW |
13 | PROFICIENCY | Character(1) | VARCHAR2(1) NOT NULL |
Proficiency Field. This Field is imported into CRM DB from Human Resources Database.
Prompt Table:
REVW_RATING_TBL
|
14 | DEPTID | Character(15) | VARCHAR2(15) NOT NULL |
Department
Prompt Table: RF_CRITDEPT_VW |
15 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table: RF_CRITROLE_VW |
16 | 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 |
17 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
18 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
19 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
20 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
21 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
22 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |