RF_PER_CRIT7_VW

(SQL View)
Index Back

Person - Location Criteria

Retrieves 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
Set Control Field: DESCR

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