RC_CASE_SRCH_VW(SQL View) |
Index Back |
|---|---|
Dummy View for Case SearchThis 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 , 0 , 0 , 0 , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , 0 , 0 , ' ' , ' ' , ' ' , ' ' , 0 , 0 , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , %CurrentDateOut , %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 | DISP_TMPL_ID | Character(30) | VARCHAR2(30) NOT NULL | Template identifier to define the display template. |
| 4 | RC_VERTICAL | Character(4) | VARCHAR2(4) NOT NULL |
Specifies the CallCenter type.
See translates for valid values.
HD=HelpDesk SW=Support |
| 5 | SETID_CUSTOMER | Character(5) | VARCHAR2(5) NOT NULL | Customer SetID |
| 6 | NAME1 | Character(50) | VARCHAR2(50) NOT NULL | Generic 50 character name field for storing names. |
| 7 | BO_ID_PARTNER | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID of Partner Company. |
| 8 | ROLE_TYPE_ID_PART | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the partner |
| 9 | BO_ID_PART_CONT | Signed Number(32,0) | DECIMAL(31) NOT NULL | This is the business object identifier for the partner contact. |
| 10 | ROLE_TYPE_ID_PARTC | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the partner contact |
| 11 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 12 | BO_ID_CONTACT | Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
| 13 | ROLE_TYPE_ID_CUST | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the customer |
| 14 | ROLE_TYPE_ID_CNTCT | Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the contact |
| 15 | BO_NAME | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 16 | BO_NAME_2 | Character(50) | VARCHAR2(50) NOT NULL | BO Name 2 |
| 17 | BO_NAME_3 | Character(50) | VARCHAR2(50) NOT NULL | BO Name 3 |
| 18 | BO_NAME_4 | Character(50) | VARCHAR2(50) NOT NULL | BO Name 4 |
| 19 | BO_NAME_5 | Character(50) | VARCHAR2(50) NOT NULL | BO Name 5 |
| 20 | ROLE_TYPE_DESCR | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 21 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 22 | BO_ID_SITE | Number(31,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 23 | ROLE_TYPE_ID_SITE | Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |
| 24 | 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. |
| 25 | 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 |
| 26 | SIN | Character(40) | VARCHAR2(40) NOT NULL | This field is used to represent the Site Identification Number |
| 27 | CASE_CONTACT | Character(15) | VARCHAR2(15) NOT NULL | Contact Identifier for Treasury Contacts |
| 28 | PROFILE_CM_SEQ | Number(31,0) | DECIMAL(31) NOT NULL | The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables. |
| 29 | CM_ID | Number(31,0) | DECIMAL(31) NOT NULL | Contact Method ID |
| 30 | RC_PURP_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Short Description |
| 31 | SETID_PRODUCT | Character(5) | VARCHAR2(5) NOT NULL | Product SetID |
| 32 | SETID_PROV_GRP | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 33 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 34 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department SetID |
| 35 | DEPTID | Character(15) | VARCHAR2(15) NOT NULL | Department |
| 36 | RC_DEPT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Department Description to be displayed on HelpDesk page. |
| 37 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location SetID |
| 38 | LOCATION | Character(15) | VARCHAR2(15) NOT NULL | This field stores the Location Code. |
| 39 | RC_LOC_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Descripton of the Location to be displayed in helpdesk page. |
| 40 | PHYSICAL_LOCATION | Character(30) | VARCHAR2(30) NOT NULL | Physical Location (Free-Form) |
| 41 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | This field stores the Telephone number. |
| 42 | EXTENSION | Character(6) | VARCHAR2(6) NOT NULL | This field stores the Phone extension. |
| 43 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email address to store the address of email. |
| 44 | RC_SUMMARY | Character(80) | VARCHAR2(80) NOT NULL | Typically a summary of a long field. |
| 45 | RC_STATUS | Character(5) | VARCHAR2(5) NOT NULL | Case Status |
| 46 | CASE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Case Type |
| 47 | RC_SOURCE | Character(5) | VARCHAR2(5) NOT NULL | Case Source How this case origianated |
| 48 | RC_PRIORITY | Character(5) | VARCHAR2(5) NOT NULL | Case Priority |
| 49 | RC_SEVERITY | Character(5) | VARCHAR2(5) NOT NULL | Case severity |
| 50 | CREATION_DATE | Date(10) | DATE | Creation date of the case. |
| 51 | CLOSED_DATE | Date(10) | DATE | Date Closed |
| 52 | RC_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | CallCenter Category. Used in HD. |
| 53 | RC_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Specialty type. Used on HD case. |
| 54 | RC_DETAIL | Character(5) | VARCHAR2(5) NOT NULL | Detail field on HD Case. Used in Quick Code. |
| 55 | INST_PROD_ID | Character(20) | VARCHAR2(20) NOT NULL | This field is used to represent the installed product ID (key field) |
| 56 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | This field is used to represent the Serial ID of an item or installed product |
| 57 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 58 | PROVIDER_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL | Identification number for the provider group. |
| 59 | ASSIGNED_TO | Character(15) | VARCHAR2(15) NOT NULL | This is a field to store assignment information. |
| 60 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 61 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 62 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 63 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 64 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 65 | BO_NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 66 | BO_NAME_CONTACT_AC | Character(50) | VARCHAR2(50) NOT NULL | Alt-Char Contact Name |
| 67 | BO_NAME_PARTCNT_AC | Character(50) | VARCHAR2(50) NOT NULL | Partner Contact Name in Alternate Characters. |
| 68 | BO_NAME_PARTNER_AC | Character(50) | VARCHAR2(50) NOT NULL | This field stores the Partner name in Alternate Character format. |
| 69 | BO_NAME_SITE_AC | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 70 | CASE_SUBTYPE | Character(5) | VARCHAR2(5) NOT NULL | Field to capture the case subtype. |
| 71 | CASE_VISIBILITY | Character(4) | VARCHAR2(4) NOT NULL |
Field to capture the case visibility.
EXCL=Internal, exclude Case Contact EXTL=External INTL=Internal |
| 72 | NAME_ASSIGNED_TO | Character(80) | VARCHAR2(80) NOT NULL | The name of the assigned agent. |
| 73 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 74 | PROBLEM_TYPE | Character(8) | VARCHAR2(8) NOT NULL | Problem Type for Support Cases |
| 75 | PROVIDER_GRP_NAME | Character(50) | VARCHAR2(50) NOT NULL | Provider Group Name |
| 76 | RC_PHONE | Character(24) | VARCHAR2(24) NOT NULL | This is the phone field used in case search. The reason is to have the ability to enter partial value for the phone and search on it. The standard PHONE field has a format mask associated with it, which does not permit entering partial values. |
| 77 | RC_TRACKING_NBR | Character(30) | VARCHAR2(30) NOT NULL | Customer Tracking Number Field. |
| 78 | REMOTE_CASE_ID | Character(18) | VARCHAR2(18) NOT NULL | Remote system case ID. Used to store case unique identify ID from 3rd party system. |
| 79 | TARGET_CLOSE_DATE | Date(10) | DATE | Target close date |
| 80 | RC_DESC_CASETYPE | Character(20) | VARCHAR2(20) NOT NULL | Used to display short description of Case Type in search results grid on case search page. |
| 81 | RC_DESC_PRIORITY | Character(20) | VARCHAR2(20) NOT NULL | Used to display short description of Case Priority in search results grid on case search page. |
| 82 | RC_DESC_PROBTYPE | Character(20) | VARCHAR2(20) NOT NULL | Used to display short description of Problem Type in search results grid on case search page. |
| 83 | RC_DESC_SEVERITY | Character(20) | VARCHAR2(20) NOT NULL | Used to display short description of Case Severity in search results grid on case search page. |
| 84 | RC_DESC_SOURCE | Character(20) | VARCHAR2(20) NOT NULL | Used to display short description of Case Source in search results grid on case search page. |
| 85 | RC_DESC_STATUS | Character(20) | VARCHAR2(20) NOT NULL | Used to display short description of Case Status in search results grid on case search page. |
| 86 | WO_ID | Character(10) | VARCHAR2(10) NOT NULL | This field contains the Work Order ID for the work order in FMS. |
| 87 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 88 | DISP_TMPL_FAM_CD | Character(30) | VARCHAR2(30) NOT NULL | Display Template Family Code |