RBF_ISS_SRCH_VW(SQL View) |
Index Back |
|---|---|
Dummy View for Case SearchThis view contains all the fields from all the case search views ie RC_CASE_SW_VWNN (NN means 01 - 24) and RC_CASE_HD_VWNN (NN means 01 to 08). This is a dummy view to define the grid on the page in which only a subset of fields will be populated based on one of the views selected to retrieve the search results. |
| SELECT ' ' , 0 , ' ' , ' ' , ' ' , ' ' , 0 , 0 , 0 , 0 , ' ' , ' ' , ' ' , ' ' , 0 , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , %CurrentDateOut , %CurrentDateOut , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' FROM PS_INSTALLATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | CASE_ID | Number(15,0) | DECIMAL(15) NOT NULL | Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table. |
| 3 | RC_VERTICAL | Character(4) | VARCHAR2(4) NOT NULL |
Specifies the CallCenter type.
See translates for valid values.
HD=HelpDesk SW=Support |
| 4 | SETID_CUSTOMER | Character(5) | VARCHAR2(5) NOT NULL | Customer SetID |
| 5 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer ID |
| 6 | NAME1 | Character(50) | VARCHAR2(50) NOT NULL | Generic 50 character name field for storing names. |
| 7 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 8 | BO_ID_CONTACT | Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
| 9 | ROLE_TYPE_ID_CUST | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the customer |
| 10 | ROLE_TYPE_ID_CNTCT | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the contact |
| 11 | BO_NAME | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 12 | BO_NAME_2 | Character(50) | VARCHAR2(50) NOT NULL | BO Name 2 |
| 13 | ROLE_TYPE_DESCR | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 14 | ROLE_TYPE_DESCR_2 | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 15 | BO_ID_SITE | Number(31,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 16 | 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. |
| 17 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 18 | PERSON_PIN | Character(40) | VARCHAR2(40) NOT NULL | This field is used to store the Personal Identification Number of a person for use in agreements |
| 19 | SIN | Character(40) | VARCHAR2(40) NOT NULL | This field is used to represent the Site Identification Number |
| 20 | CASE_CONTACT | Character(15) | VARCHAR2(15) NOT NULL | Contact Identifier for Treasury Contacts |
| 21 | RC_CONTACT_NAME | Character(50) | VARCHAR2(50) NOT NULL | The name of the customer contact or the employee based on support/helpdesk. |
| 22 | SETID_ENTL | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 23 | SETID_PRODUCT | Character(5) | VARCHAR2(5) NOT NULL | Product SetID |
| 24 | SETID_PROV_GRP | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 25 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 26 | DEPTID | Character(15) | VARCHAR2(15) NOT NULL | Department |
| 27 | RC_DEPT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Department Description to be displayed on HelpDesk page. |
| 28 | LOCATION | Character(15) | VARCHAR2(15) NOT NULL | This field stores the Location Code. |
| 29 | RC_LOC_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Descripton of the Location to be displayed in helpdesk page. |
| 30 | PHYSICAL_LOCATION | Character(30) | VARCHAR2(30) NOT NULL | Physical Location (Free-Form) |
| 31 | PHONE_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
phone type field to store value of phone type.
BUSN=Business Phone CAMP=Campus CELL=Cellular Phone DFLT=Default DORM=Dormitory FAX=FAX HOME=Home Phone MAIN=Main OTR=Other PGR1=Pager 1 PGR2=Pager 2 TELX=Telex WORK=Work |
| 32 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | This field stores the Telephone number. |
| 33 | EXTENSION | Character(6) | VARCHAR2(6) NOT NULL | This field stores the Phone extension. |
| 34 | E_ADDR_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Address type field used in HD_360_RESPONSE_SYNC message.
BUSN=Business CAMP=Campus DORM=Dorm HOME=Home OTHR=Other |
| 35 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email address to store the address of email. |
| 36 | RC_SUMMARY | Character(80) | VARCHAR2(80) NOT NULL | Typically a summary of a long field. |
| 37 | RC_STATUS | Character(5) | VARCHAR2(5) NOT NULL | Case Status |
| 38 | RC_SHORT_DESCR | Character(20) | VARCHAR2(20) NOT NULL | Short Description. Used on may CallCenter set-up tables |
| 39 | CASE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Case Type |
| 40 | RC_SOURCE | Character(5) | VARCHAR2(5) NOT NULL | Case Source How this case origianated |
| 41 | RC_PRIORITY | Character(5) | VARCHAR2(5) NOT NULL | Case Priority |
| 42 | RC_SEVERITY | Character(5) | VARCHAR2(5) NOT NULL | Case severity |
| 43 | CREATION_DATE | Date(10) | DATE | Creation date of the case. |
| 44 | CLOSED_DATE | Date(10) | DATE | Date Closed |
| 45 | PROBLEM_TYPE | Character(8) | VARCHAR2(8) NOT NULL | Problem Type for Support Cases |
| 46 | RC_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | CallCenter Category. Used in HD. |
| 47 | RC_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Specialty type. Used on HD case. |
| 48 | RC_DETAIL | Character(5) | VARCHAR2(5) NOT NULL | Detail field on HD Case. Used in Quick Code. |
| 49 | INST_PROD_ID | Character(20) | VARCHAR2(20) NOT NULL | This field is used to represent the installed product ID (key field) |
| 50 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | This field is used to represent the Serial ID of an item or installed product |
| 51 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 52 | ASSETTAG | Character(40) | VARCHAR2(40) NOT NULL | Asset Tag |
| 53 | PROVIDER_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL | Identification number for the provider group. |
| 54 | ASSIGNED_TO | Character(15) | VARCHAR2(15) NOT NULL | This is a field to store assignment information. |