RB_P_CRIT3CI_VW(SQL View) |
Index Back |
|---|---|
CI View for RB_PERSON_CRITThis view has the same structure as RB_PERSON_CRIT. As delivered, this view does not contain any PeopleCode and is used in Component Interface (CI) components only. Whenever the structure of the underlying record changes, this view must be modified accordingly. Stores the possible search criteria used to assign a technician to a Case or a Service Order. The values listed here will be compared with those on the Case/SO. The weight allows the individual to specify an order of preference. |
| SELECT A.PERSON_ID , %subrec(RF_CRIT_NPC3SBR, A) FROM PS_RB_PERSON_CRIT A WHERE CRITERIA_CODE_PER = '3' |
| # | 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 Default Value: 3 |
| 3 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 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: RF_COMPSITE2_VW |
| 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 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 15 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 16 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 17 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 18 | 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. |
| 19 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |