RC_CS_SEARCH_VW (SQL View)	Index Back
Work record for Case Search Derived work record fields used by the generic case search component.

RC_CS_SEARCH_VW

(SQL View)

Work record for Case Search

Derived work record fields used by the generic case search component.

SELECT ' ' , 0 , ' ' , ' ' , ' ' ,' ' ,' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , %CurrentDateIn , %CurrentDateIn , %CurrentDateIn , %CurrentDateIn , %CurrentDateIn , ' ' , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , ' ' , ' ' , ' ' FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_RC_VR_NONVW

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.
Prompt Table: RC_CASE_NONVW

3 RC_TRACKING_NBR Character(30) VARCHAR2(30) NOT NULL Customer Tracking Number Field.

4 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
Prompt Table: RC_PIN_VW1

5 SIN Character(40) VARCHAR2(40) NOT NULL This field is used to represent the Site Identification Number
Prompt Table: RC_SIN_VW1

6 BO_NAME_4 Character(50) VARCHAR2(50) NOT NULL BO Name 4

7 BO_NAME_5 Character(50) VARCHAR2(50) NOT NULL BO Name 5

8 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

9 BO_NAME_AC Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

10 BO_NAME_2 Character(50) VARCHAR2(50) NOT NULL BO Name 2

11 BO_NAME_CONTACT_AC Character(50) VARCHAR2(50) NOT NULL Alt-Char Contact Name

12 BO_NAME_3 Character(50) VARCHAR2(50) NOT NULL BO Name 3

13 NAME_SEARCH Character(50) VARCHAR2(50) NOT NULL Name
Prompt Table: RC_CNTCT_HD_VW1

14 RBTACCTNO Character(20) VARCHAR2(20) NOT NULL Account No
Prompt Table: RCT_ACCOUNT_VW

15 RCTINSTPHONENO Character(11) VARCHAR2(11) NOT NULL RCTINSTPHONENO

16 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: RC_EMPLID_VW

17 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID

18 RC_DEPT_DESCR Character(30) VARCHAR2(30) NOT NULL Department Description to be displayed on HelpDesk page.
Prompt Table: RC_DEPT_VW

19 RC_LOC_DESCR Character(30) VARCHAR2(30) NOT NULL Descripton of the Location to be displayed in helpdesk page.

20 PHYSICAL_LOCATION Character(30) VARCHAR2(30) NOT NULL Physical Location (Free-Form)

21 RC_PHONE_CUST 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.
Prompt Table: RC_PHONE_VW4

22 EXTENSION_CUST Character(6) VARCHAR2(6) NOT NULL Customer Extension
Prompt Table: RC_EXT_VW4

23 EMAIL_ADDR_CUST Character(70) VARCHAR2(70) NOT NULL email address for the customer - used in case
Prompt Table: RC_EMAIL_VW4

24 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.
Prompt Table: RC_PHONE_VW3

25 EXTENSION Character(6) VARCHAR2(6) NOT NULL This field stores the Phone extension.
Prompt Table: RC_EXT_VW3

26 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email address to store the address of email.
Prompt Table: RC_EMAIL_VW3

27 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

28 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2

29 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3

30 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4

31 ADDRESS1_AC Character(55) VARCHAR2(55) NOT NULL ADDRESS1_AC

32 ADDRESS2_AC Character(55) VARCHAR2(55) NOT NULL ADDRESS2_AC

33 ADDRESS3_AC Character(55) VARCHAR2(55) NOT NULL ADDRESS3_AC

34 ADDRESS4_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 4.

35 CITY Character(30) VARCHAR2(30) NOT NULL City

36 CITY_AC Character(30) VARCHAR2(30) NOT NULL CITY_AC

37 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: STATE_TBL

38 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

39 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

40 RC_STATUS Character(5) VARCHAR2(5) NOT NULL Case Status
Prompt Table: RC_STATUS_TBL
Set Control Field: BUSINESS_UNIT

41 RC_SUMMARY Character(80) VARCHAR2(80) NOT NULL Typically a summary of a long field.

42 CASE_TYPE Character(5) VARCHAR2(5) NOT NULL Case Type
Prompt Table: RC_CASETYPE_TBL
Set Control Field: BUSINESS_UNIT

43 CASE_SUBTYPE Character(5) VARCHAR2(5) NOT NULL Field to capture the case subtype.
Prompt Table: RC_CASE_SUBTYPE
Set Control Field: BUSINESS_UNIT

44 RC_SEVERITY Character(5) VARCHAR2(5) NOT NULL Case severity
Prompt Table: RC_SEVERITY_TBL
Set Control Field: BUSINESS_UNIT

45 RC_PRIORITY Character(5) VARCHAR2(5) NOT NULL Case Priority
Prompt Table: RC_PRIORITY_TBL
Set Control Field: BUSINESS_UNIT

46 RC_SOURCE Character(5) VARCHAR2(5) NOT NULL Case Source How this case origianated
Prompt Table: RC_SOURCE_TBL
Set Control Field: BUSINESS_UNIT

47 RC_CATEGORY Character(5) VARCHAR2(5) NOT NULL CallCenter Category. Used in HD.
Prompt Table: RC_CTD_CAT_F_VW
Set Control Field: BUSINESS_UNIT

48 RC_TYPE Character(5) VARCHAR2(5) NOT NULL Specialty type. Used on HD case.
Prompt Table: RC_CTD_TYP_F_VW
Set Control Field: RC_CATEGORY

49 RC_DETAIL Character(5) VARCHAR2(5) NOT NULL Detail field on HD Case. Used in Quick Code.
Prompt Table: RC_CTD_DET_F_VW

50 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)
Prompt Table: RC_INSTPROD_VW3

51 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
Prompt Table: RC_PROD_VW1

52 PROBLEM_TYPE Character(8) VARCHAR2(8) NOT NULL Problem Type for Support Cases
Prompt Table: RC_PROBTYPE_TBL
Set Control Field: BUSINESS_UNIT

53 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency - this field is brought over from HRMS
Prompt Table: RC_PROD_COMP_VW

54 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.
Prompt Table: RC_GRP_MEM_VW6

55 ASSIGNED_TO Character(15) VARCHAR2(15) NOT NULL This is a field to store assignment information.
Prompt Table: RC_GRP_MEM_VW5

56 ISSUE_VISIBILITY Character(4) VARCHAR2(4) NOT NULL Issue subtype
EXTL=External
INTL=Internal

57 FIN_ACCOUNT_ID Character(20) VARCHAR2(20) NOT NULL Financial Account Number

58 COMPL_CAUSE Character(4) VARCHAR2(4) NOT NULL Complete Clause
ADVS=Advise / Information
ERRO=System Error
INC1=Incorrect Handling - FSI
INC2=Incorrect Handling - Other
INC3=Incorrect Entry - FSI
INC4=Incorrect Entry - Other
MISC=Miscellaneous
MIST=Mistake Made by Customer
POLC=Organization / Bank Policy
PROD=Product Characteristics
RTNG=Rating / Costs / Circulation
SERV=Service / Transaction by FSI

59 COMPL_CAUSE_ENTITY Character(4) VARCHAR2(4) NOT NULL Complete Clause entity
ADMN=Administration & Services
CALL=Call Center
HOFF=Head Office
MISC=Miscellaneous
NOCS=No Case
OFFC=Office
OPTN=Options Market
REGN=Regional Department(s)
STCK=Stock Exchange

60 CLAIM_SUBMITTED_BY Character(4) VARCHAR2(4) NOT NULL Claim Submitted by
CLNT=Client
OTHR=Other FSI
THRD=Third Party

61 COMPL_CLOSE_REASON Character(4) VARCHAR2(4) NOT NULL Complete Clause reason
ASS1=Assigned without Financial Fee
ASS2=Assigned with Paid Claim
DCL1=Declined
DCL2=Declined - No Case
DCL3=Declined - Withdrawn by Client

62 COMPL_RECEIVED_VIA Character(4) VARCHAR2(4) NOT NULL Compl recd via
BORD=The Board
CALL=Call Center
HOFF=Head Office
INET=Internet
OFFC=Office

63 CREATION_DATE Date(10) DATE Creation date of the case.

64 CLOSED_DATE Date(10) DATE Date Closed

65 TARGET_CLOSE_DATE Date(10) DATE Target close date

66 CLAIM_DATE Date(10) DATE Claim Date

67 CLAIM_PAID_DATE Date(10) DATE Claim Paid date

68 RC_VERTICAL Character(4) VARCHAR2(4) NOT NULL Specifies the CallCenter type. See translates for valid values.
HD=HelpDesk
SW=Support

69 SRCH_GROUP_ID_1 Number(6,0) INTEGER NOT NULL Search Group ID

70 SRCH_GROUP_ID_2 Number(6,0) INTEGER NOT NULL Search Group ID

71 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

72 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer

73 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.

74 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact

75 BO_ID_SITE Number(31,0) DECIMAL(31) NOT NULL Business Object ID

76 ROLE_TYPE_ID_SITE Number(12,0) DECIMAL(12) NOT NULL Role Type ID

77 RC_CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The name of the customer contact or the employee based on support/helpdesk.

78 NAME_ASSIGNED_TO Character(80) VARCHAR2(80) NOT NULL The name of the assigned agent.

79 REMOTE_CASE_ID Character(18) VARCHAR2(18) NOT NULL Remote system case ID. Used to store case unique identify ID from 3rd party system.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_RC_VR_NONVW
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. Prompt Table: RC_CASE_NONVW
3	RC_TRACKING_NBR	Character(30)	VARCHAR2(30) NOT NULL	Customer Tracking Number Field.
4	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 Prompt Table: RC_PIN_VW1
5	SIN	Character(40)	VARCHAR2(40) NOT NULL	This field is used to represent the Site Identification Number Prompt Table: RC_SIN_VW1
6	BO_NAME_4	Character(50)	VARCHAR2(50) NOT NULL	BO Name 4
7	BO_NAME_5	Character(50)	VARCHAR2(50) NOT NULL	BO Name 5
8	BO_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
9	BO_NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
10	BO_NAME_2	Character(50)	VARCHAR2(50) NOT NULL	BO Name 2
11	BO_NAME_CONTACT_AC	Character(50)	VARCHAR2(50) NOT NULL	Alt-Char Contact Name
12	BO_NAME_3	Character(50)	VARCHAR2(50) NOT NULL	BO Name 3
13	NAME_SEARCH	Character(50)	VARCHAR2(50) NOT NULL	Name Prompt Table: RC_CNTCT_HD_VW1
14	RBTACCTNO	Character(20)	VARCHAR2(20) NOT NULL	Account No Prompt Table: RCT_ACCOUNT_VW
15	RCTINSTPHONENO	Character(11)	VARCHAR2(11) NOT NULL	RCTINSTPHONENO
16	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: RC_EMPLID_VW
17	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
18	RC_DEPT_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Department Description to be displayed on HelpDesk page. Prompt Table: RC_DEPT_VW
19	RC_LOC_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Descripton of the Location to be displayed in helpdesk page.
20	PHYSICAL_LOCATION	Character(30)	VARCHAR2(30) NOT NULL	Physical Location (Free-Form)
21	RC_PHONE_CUST	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. Prompt Table: RC_PHONE_VW4
22	EXTENSION_CUST	Character(6)	VARCHAR2(6) NOT NULL	Customer Extension Prompt Table: RC_EXT_VW4
23	EMAIL_ADDR_CUST	Character(70)	VARCHAR2(70) NOT NULL	email address for the customer - used in case Prompt Table: RC_EMAIL_VW4
24	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. Prompt Table: RC_PHONE_VW3
25	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	This field stores the Phone extension. Prompt Table: RC_EXT_VW3
26	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email address to store the address of email. Prompt Table: RC_EMAIL_VW3
27	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
28	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
29	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
30	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
31	ADDRESS1_AC	Character(55)	VARCHAR2(55) NOT NULL	ADDRESS1_AC
32	ADDRESS2_AC	Character(55)	VARCHAR2(55) NOT NULL	ADDRESS2_AC
33	ADDRESS3_AC	Character(55)	VARCHAR2(55) NOT NULL	ADDRESS3_AC
34	ADDRESS4_AC	Character(55)	VARCHAR2(55) NOT NULL	Alternate Character Address 4.
35	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
36	CITY_AC	Character(30)	VARCHAR2(30) NOT NULL	CITY_AC
37	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
38	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
39	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
40	RC_STATUS	Character(5)	VARCHAR2(5) NOT NULL	Case Status Prompt Table: RC_STATUS_TBL Set Control Field: BUSINESS_UNIT
41	RC_SUMMARY	Character(80)	VARCHAR2(80) NOT NULL	Typically a summary of a long field.
42	CASE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Case Type Prompt Table: RC_CASETYPE_TBL Set Control Field: BUSINESS_UNIT
43	CASE_SUBTYPE	Character(5)	VARCHAR2(5) NOT NULL	Field to capture the case subtype. Prompt Table: RC_CASE_SUBTYPE Set Control Field: BUSINESS_UNIT
44	RC_SEVERITY	Character(5)	VARCHAR2(5) NOT NULL	Case severity Prompt Table: RC_SEVERITY_TBL Set Control Field: BUSINESS_UNIT
45	RC_PRIORITY	Character(5)	VARCHAR2(5) NOT NULL	Case Priority Prompt Table: RC_PRIORITY_TBL Set Control Field: BUSINESS_UNIT
46	RC_SOURCE	Character(5)	VARCHAR2(5) NOT NULL	Case Source How this case origianated Prompt Table: RC_SOURCE_TBL Set Control Field: BUSINESS_UNIT
47	RC_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	CallCenter Category. Used in HD. Prompt Table: RC_CTD_CAT_F_VW Set Control Field: BUSINESS_UNIT
48	RC_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Specialty type. Used on HD case. Prompt Table: RC_CTD_TYP_F_VW Set Control Field: RC_CATEGORY
49	RC_DETAIL	Character(5)	VARCHAR2(5) NOT NULL	Detail field on HD Case. Used in Quick Code. Prompt Table: RC_CTD_DET_F_VW
50	INST_PROD_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the installed product ID (key field) Prompt Table: RC_INSTPROD_VW3
51	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID Prompt Table: RC_PROD_VW1
52	PROBLEM_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Problem Type for Support Cases Prompt Table: RC_PROBTYPE_TBL Set Control Field: BUSINESS_UNIT
53	COMPETENCY	Character(8)	VARCHAR2(8) NOT NULL	Competency - this field is brought over from HRMS Prompt Table: RC_PROD_COMP_VW
54	PROVIDER_GRP_ID	Character(10)	VARCHAR2(10) NOT NULL	Identification number for the provider group. Prompt Table: RC_GRP_MEM_VW6
55	ASSIGNED_TO	Character(15)	VARCHAR2(15) NOT NULL	This is a field to store assignment information. Prompt Table: RC_GRP_MEM_VW5
56	ISSUE_VISIBILITY	Character(4)	VARCHAR2(4) NOT NULL	Issue subtype EXTL=External INTL=Internal
57	FIN_ACCOUNT_ID	Character(20)	VARCHAR2(20) NOT NULL	Financial Account Number
58	COMPL_CAUSE	Character(4)	VARCHAR2(4) NOT NULL	Complete Clause ADVS=Advise / Information ERRO=System Error INC1=Incorrect Handling - FSI INC2=Incorrect Handling - Other INC3=Incorrect Entry - FSI INC4=Incorrect Entry - Other MISC=Miscellaneous MIST=Mistake Made by Customer POLC=Organization / Bank Policy PROD=Product Characteristics RTNG=Rating / Costs / Circulation SERV=Service / Transaction by FSI
59	COMPL_CAUSE_ENTITY	Character(4)	VARCHAR2(4) NOT NULL	Complete Clause entity ADMN=Administration & Services CALL=Call Center HOFF=Head Office MISC=Miscellaneous NOCS=No Case OFFC=Office OPTN=Options Market REGN=Regional Department(s) STCK=Stock Exchange
60	CLAIM_SUBMITTED_BY	Character(4)	VARCHAR2(4) NOT NULL	Claim Submitted by CLNT=Client OTHR=Other FSI THRD=Third Party
61	COMPL_CLOSE_REASON	Character(4)	VARCHAR2(4) NOT NULL	Complete Clause reason ASS1=Assigned without Financial Fee ASS2=Assigned with Paid Claim DCL1=Declined DCL2=Declined - No Case DCL3=Declined - Withdrawn by Client
62	COMPL_RECEIVED_VIA	Character(4)	VARCHAR2(4) NOT NULL	Compl recd via BORD=The Board CALL=Call Center HOFF=Head Office INET=Internet OFFC=Office
63	CREATION_DATE	Date(10)	DATE	Creation date of the case.
64	CLOSED_DATE	Date(10)	DATE	Date Closed
65	TARGET_CLOSE_DATE	Date(10)	DATE	Target close date
66	CLAIM_DATE	Date(10)	DATE	Claim Date
67	CLAIM_PAID_DATE	Date(10)	DATE	Claim Paid date
68	RC_VERTICAL	Character(4)	VARCHAR2(4) NOT NULL	Specifies the CallCenter type. See translates for valid values. HD=HelpDesk SW=Support
69	SRCH_GROUP_ID_1	Number(6,0)	INTEGER NOT NULL	Search Group ID
70	SRCH_GROUP_ID_2	Number(6,0)	INTEGER NOT NULL	Search Group ID
71	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
72	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer
73	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
74	ROLE_TYPE_ID_CNTCT	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the contact
75	BO_ID_SITE	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID
76	ROLE_TYPE_ID_SITE	Number(12,0)	DECIMAL(12) NOT NULL	Role Type ID
77	RC_CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	The name of the customer contact or the employee based on support/helpdesk.
78	NAME_ASSIGNED_TO	Character(80)	VARCHAR2(80) NOT NULL	The name of the assigned agent.
79	REMOTE_CASE_ID	Character(18)	VARCHAR2(18) NOT NULL	Remote system case ID. Used to store case unique identify ID from 3rd party system.