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

RC_CASE_SEARCH

(SQL View)

Work record for Case Search

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

SELECT ' ' , 0 , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , %CurrentDateOut , %CurrentDateOut , %CurrentDateOut , %CurrentDateOut , %CurrentDateOut , ' ' , 0 , 0 , 0 , 0 , 0 , 0 , 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: SP_CASEID_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 Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

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

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

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

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

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

12 BO_NAME_PARTCNT_AC Character(50) VARCHAR2(50) NOT NULL Partner Contact Name in Alternate Characters.

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

14 BO_NAME_PARTNER_AC Character(50) VARCHAR2(50) NOT NULL This field stores the Partner name in Alternate Character format.

15 BO_NAME_SITE_AC Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

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

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

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

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

20 EBS_EMPLID Character(30) VARCHAR2(30) NOT NULL EBS Employee Number used in the EBS - HR HelpDesk integration.
Prompt Table: RC_EBSEMPNAM_VW

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

22 DEPTID Character(15) VARCHAR2(15) NOT NULL Department

23 LOCATION Character(15) VARCHAR2(15) NOT NULL This field stores the Location Code.

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

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

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

27 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

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

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

30 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

50 URGENCY Character(5) VARCHAR2(5) NOT NULL Case Urgency
Prompt Table: RC_URGENCY_TBL
Set Control Field: BUSINESS_UNIT

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

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

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

54 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

55 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

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

57 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

58 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group

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

60 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the Serial ID of an item or installed product

61 ASSETTAG Character(40) VARCHAR2(40) NOT NULL Asset Tag

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

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

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

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

66 PRIOR_PRVDR_GRP_ID Character(10) VARCHAR2(10) NOT NULL PRIOR PROVIDER GROUP ID field is used to store prior value of the Provider Group.

67 PRIOR_ASSIGNED_TO Character(15) VARCHAR2(15) NOT NULL This is a field to store assignment information.

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

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

70 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

71 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

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

73 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

74 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

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

76 CLOSED_DATE Date(10) DATE Date Closed

77 TARGET_CLOSE_DATE Date(10) DATE Target close date

78 CLAIM_DATE Date(10) DATE Claim Date

79 CLAIM_PAID_DATE Date(10) DATE Claim Paid date

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

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

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

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

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

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

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

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

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

89 BO_ID_PARTNER Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID of Partner Company.

90 ROLE_TYPE_ID_PART Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the partner

91 BO_ID_PART_CONT Signed Number(32,0) DECIMAL(31) NOT NULL This is the business object identifier for the partner contact.

92 ROLE_TYPE_ID_PARTC Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the partner contact

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

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

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

96 DISP_TMPL_ID Character(30) VARCHAR2(30) NOT NULL Template identifier to define the display template.

97 CUST_ACCT_NBR Character(20) VARCHAR2(20) NOT NULL This is the Customer defined Account Number for a financial account

98 CASE_VISIBILITY Character(4) VARCHAR2(4) NOT NULL Field to capture the case visibility.
EXCL=Internal, exclude Case Contact
EXTL=External
INTL=Internal

99 PROVIDER_GRP_NAME Character(50) VARCHAR2(50) NOT NULL Provider Group Name

100 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.

101 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.

102 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.

103 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.

104 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.

105 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.

106 WO_ID Character(10) VARCHAR2(10) NOT NULL This field contains the Work Order ID for the work order in FMS.

107 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

108 SETID_CUSTOMER Character(5) VARCHAR2(5) NOT NULL Customer SetID

109 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.

110 ROLE_TYPE_DESCR Character(10) VARCHAR2(10) NOT NULL Short Description

111 DESCR Character(30) VARCHAR2(30) NOT NULL Description

112 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.

113 CASE_CONTACT Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

114 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.

115 CM_ID Number(31,0) DECIMAL(31) NOT NULL Contact Method ID

116 RC_PURP_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Short Description

117 SETID_PRODUCT Character(5) VARCHAR2(5) NOT NULL Product SetID

118 SETID_PROV_GRP Character(5) VARCHAR2(5) NOT NULL SetID

119 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID

120 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID

121 PHONE Character(24) VARCHAR2(24) NOT NULL This field stores the Telephone number.

122 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code

#	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: SP_CASEID_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	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
7	BO_NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
8	BO_NAME_2	Character(50)	VARCHAR2(50) NOT NULL	BO Name 2
9	BO_NAME_CONTACT_AC	Character(50)	VARCHAR2(50) NOT NULL	Alt-Char Contact Name
10	BO_NAME_3	Character(50)	VARCHAR2(50) NOT NULL	BO Name 3
11	BO_NAME_4	Character(50)	VARCHAR2(50) NOT NULL	BO Name 4
12	BO_NAME_PARTCNT_AC	Character(50)	VARCHAR2(50) NOT NULL	Partner Contact Name in Alternate Characters.
13	BO_NAME_5	Character(50)	VARCHAR2(50) NOT NULL	BO Name 5
14	BO_NAME_PARTNER_AC	Character(50)	VARCHAR2(50) NOT NULL	This field stores the Partner name in Alternate Character format.
15	BO_NAME_SITE_AC	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
16	NAME_SEARCH	Character(50)	VARCHAR2(50) NOT NULL	Name Prompt Table: RC_CNTCT_HD_VW1
17	RBTACCTNO	Character(20)	VARCHAR2(20) NOT NULL	Account No Prompt Table: RCT_ACCOUNT_VW
18	RCTINSTPHONENO	Character(11)	VARCHAR2(11) NOT NULL	RCTINSTPHONENO
19	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: RC_EMPLID_VW
20	EBS_EMPLID	Character(30)	VARCHAR2(30) NOT NULL	EBS Employee Number used in the EBS - HR HelpDesk integration. Prompt Table: RC_EBSEMPNAM_VW
21	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
22	DEPTID	Character(15)	VARCHAR2(15) NOT NULL	Department
23	LOCATION	Character(15)	VARCHAR2(15) NOT NULL	This field stores the Location Code.
24	RC_DEPT_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Department Description to be displayed on HelpDesk page. Prompt Table: RC_DEPT_VW
25	RC_LOC_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Descripton of the Location to be displayed in helpdesk page.
26	PHYSICAL_LOCATION	Character(30)	VARCHAR2(30) NOT NULL	Physical Location (Free-Form)
27	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
28	EXTENSION_CUST	Character(6)	VARCHAR2(6) NOT NULL	Customer Extension Prompt Table: RC_EXT_VW4
29	EMAIL_ADDR_CUST	Character(70)	VARCHAR2(70) NOT NULL	email address for the customer - used in case Prompt Table: RC_EMAIL_VW4
30	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
31	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	This field stores the Phone extension. Prompt Table: RC_EXT_VW3
32	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email address to store the address of email. Prompt Table: RC_EMAIL_VW3
33	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
34	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
35	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
36	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
37	ADDRESS1_AC	Character(55)	VARCHAR2(55) NOT NULL	ADDRESS1_AC
38	ADDRESS2_AC	Character(55)	VARCHAR2(55) NOT NULL	ADDRESS2_AC
39	ADDRESS3_AC	Character(55)	VARCHAR2(55) NOT NULL	ADDRESS3_AC
40	ADDRESS4_AC	Character(55)	VARCHAR2(55) NOT NULL	Alternate Character Address 4.
41	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
42	CITY_AC	Character(30)	VARCHAR2(30) NOT NULL	CITY_AC
43	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
44	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
45	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
46	RC_STATUS	Character(5)	VARCHAR2(5) NOT NULL	Case Status Prompt Table: RC_STATUS_TBL Set Control Field: BUSINESS_UNIT
47	RC_SUMMARY	Character(80)	VARCHAR2(80) NOT NULL	Typically a summary of a long field.
48	CASE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Case Type Prompt Table: RC_CASETYPE_TBL Set Control Field: BUSINESS_UNIT
49	CASE_SUBTYPE	Character(5)	VARCHAR2(5) NOT NULL	Field to capture the case subtype. Prompt Table: RC_CASE_SUBTYPE Set Control Field: BUSINESS_UNIT
50	URGENCY	Character(5)	VARCHAR2(5) NOT NULL	Case Urgency Prompt Table: RC_URGENCY_TBL Set Control Field: BUSINESS_UNIT
51	RC_SEVERITY	Character(5)	VARCHAR2(5) NOT NULL	Case severity Prompt Table: RC_SEVERITY_TBL Set Control Field: BUSINESS_UNIT
52	RC_PRIORITY	Character(5)	VARCHAR2(5) NOT NULL	Case Priority Prompt Table: RC_PRIORITY_TBL Set Control Field: BUSINESS_UNIT
53	RC_SOURCE	Character(5)	VARCHAR2(5) NOT NULL	Case Source How this case origianated Prompt Table: RC_SOURCE_TBL Set Control Field: BUSINESS_UNIT
54	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
55	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
56	RC_DETAIL	Character(5)	VARCHAR2(5) NOT NULL	Detail field on HD Case. Used in Quick Code. Prompt Table: RC_CTD_DET_F_VW
57	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
58	PRODUCT_GROUP	Character(10)	VARCHAR2(10) NOT NULL	PRoduct Group
59	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID Prompt Table: RC_PROD_VW1
60	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the Serial ID of an item or installed product
61	ASSETTAG	Character(40)	VARCHAR2(40) NOT NULL	Asset Tag
62	PROBLEM_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Problem Type for Support Cases Prompt Table: RC_PROBTYPE_TBL Set Control Field: BUSINESS_UNIT
63	COMPETENCY	Character(8)	VARCHAR2(8) NOT NULL	Competency - this field is brought over from HRMS Prompt Table: RC_PROD_COMP_VW
64	PROVIDER_GRP_ID	Character(10)	VARCHAR2(10) NOT NULL	Identification number for the provider group. Prompt Table: RC_GRP_MEM_VW6
65	ASSIGNED_TO	Character(15)	VARCHAR2(15) NOT NULL	This is a field to store assignment information. Prompt Table: RC_GRP_MEM_VW5
66	PRIOR_PRVDR_GRP_ID	Character(10)	VARCHAR2(10) NOT NULL	PRIOR PROVIDER GROUP ID field is used to store prior value of the Provider Group.
67	PRIOR_ASSIGNED_TO	Character(15)	VARCHAR2(15) NOT NULL	This is a field to store assignment information.
68	ISSUE_VISIBILITY	Character(4)	VARCHAR2(4) NOT NULL	Issue subtype EXTL=External INTL=Internal
69	FIN_ACCOUNT_ID	Character(20)	VARCHAR2(20) NOT NULL	Financial Account Number
70	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
71	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
72	CLAIM_SUBMITTED_BY	Character(4)	VARCHAR2(4) NOT NULL	Claim Submitted by CLNT=Client OTHR=Other FSI THRD=Third Party
73	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
74	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
75	CREATION_DATE	Date(10)	DATE	Creation date of the case.
76	CLOSED_DATE	Date(10)	DATE	Date Closed
77	TARGET_CLOSE_DATE	Date(10)	DATE	Target close date
78	CLAIM_DATE	Date(10)	DATE	Claim Date
79	CLAIM_PAID_DATE	Date(10)	DATE	Claim Paid date
80	RC_VERTICAL	Character(4)	VARCHAR2(4) NOT NULL	Specifies the CallCenter type. See translates for valid values. HD=HelpDesk SW=Support
81	SRCH_GROUP_ID_1	Number(6,0)	INTEGER NOT NULL	Search Group ID
82	SRCH_GROUP_ID_2	Number(6,0)	INTEGER NOT NULL	Search Group ID
83	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
84	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer
85	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
86	ROLE_TYPE_ID_CNTCT	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the contact
87	BO_ID_SITE	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID
88	ROLE_TYPE_ID_SITE	Number(12,0)	DECIMAL(12) NOT NULL	Role Type ID
89	BO_ID_PARTNER	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID of Partner Company.
90	ROLE_TYPE_ID_PART	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the partner
91	BO_ID_PART_CONT	Signed Number(32,0)	DECIMAL(31) NOT NULL	This is the business object identifier for the partner contact.
92	ROLE_TYPE_ID_PARTC	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the partner contact
93	RC_CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	The name of the customer contact or the employee based on support/helpdesk.
94	NAME_ASSIGNED_TO	Character(80)	VARCHAR2(80) NOT NULL	The name of the assigned agent.
95	REMOTE_CASE_ID	Character(18)	VARCHAR2(18) NOT NULL	Remote system case ID. Used to store case unique identify ID from 3rd party system.
96	DISP_TMPL_ID	Character(30)	VARCHAR2(30) NOT NULL	Template identifier to define the display template.
97	CUST_ACCT_NBR	Character(20)	VARCHAR2(20) NOT NULL	This is the Customer defined Account Number for a financial account
98	CASE_VISIBILITY	Character(4)	VARCHAR2(4) NOT NULL	Field to capture the case visibility. EXCL=Internal, exclude Case Contact EXTL=External INTL=Internal
99	PROVIDER_GRP_NAME	Character(50)	VARCHAR2(50) NOT NULL	Provider Group Name
100	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.
101	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.
102	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.
103	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.
104	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.
105	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.
106	WO_ID	Character(10)	VARCHAR2(10) NOT NULL	This field contains the Work Order ID for the work order in FMS.
107	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
108	SETID_CUSTOMER	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
109	NAME1	Character(50)	VARCHAR2(50) NOT NULL	Generic 50 character name field for storing names.
110	ROLE_TYPE_DESCR	Character(10)	VARCHAR2(10) NOT NULL	Short Description
111	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
112	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.
113	CASE_CONTACT	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
114	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.
115	CM_ID	Number(31,0)	DECIMAL(31) NOT NULL	Contact Method ID
116	RC_PURP_TYPE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Short Description
117	SETID_PRODUCT	Character(5)	VARCHAR2(5) NOT NULL	Product SetID
118	SETID_PROV_GRP	Character(5)	VARCHAR2(5) NOT NULL	SetID
119	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID
120	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location SetID
121	PHONE	Character(24)	VARCHAR2(24) NOT NULL	This field stores the Telephone number.
122	DISP_TMPL_FAM_CD	Character(30)	VARCHAR2(30) NOT NULL	Display Template Family Code