RC_CASE_UPD_VW (SQL View)	Index Back
Call Center Case Main Case Record for CRM Call Center product.

RC_CASE_UPD_VW

(SQL View)

Call Center Case

Main Case Record for CRM Call Center product.

SELECT CASE_ID , BUSINESS_UNIT , DISP_TMPL_FAM_CD , RC_VERTICAL , MARKET , CASE_TYPE , PERSON_PIN , SIN , CASE_CONTACT , BO_ID_CUST , ROLE_TYPE_ID_CUST , ROLE_TYPE_ID_CNTCT , BO_ID_SITE , ROLE_TYPE_ID_SITE , BO_ID_CONTACT , BO_ID_ALT_CNCT , AGREEMENT_CODE , AGR_RENEWAL_NUM , AGREEMENT_LINE , WARRANTY_NAME , RC_PAY_FOR_SVC_FLG , INST_PROD_ID , PRODUCT_ID , SERIAL_ID , ASSETTAG , RC_SOURCE , RC_CONTACT_METHOD , RC_CONTACT_INFO , CM_TYPE_ID , CM_ID , RB_LOCATION_DETAIL , PROFILE_CM_SEQ_ADD , PROFILE_CM_SEQ_PHN , PROFILE_CM_SEQ_PGR , PROFILE_CM_SEQ_EML , REGION_ID , PROVIDER_GRP_ID , PRIOR_PRVDR_GRP_ID , ASSIGNED_TO , PRIOR_ASSIGNED_TO , RC_STATUS , RC_PRIORITY , RC_SEVERITY , BUS_PROC_INSTANCE , RC_CATEGORY , RC_TYPE , RC_DETAIL , PROBLEM_TYPE , RC_FIRST_CONTACT , RES_FIRST_CNTCT , CREATION_DATE , CLOSED_DATE , CLOSED_DTTM , CLOSED_BY_OPRID , RC_SUMMARY , RC_TRACKING_NBR , ERROR_ID , RC_REOPN_REASON_CD , RC_CLOSE_REASON_CD , ERROR_CODE , ERROR_MESSAGE , RC_RESP_DATE , RC_RESP_TIME , RC_RESPMET_DATE , RC_RESPMET_TIME , RC_RESP_IND , RC_REST_DATE , RC_REST_TIME , RC_RESTMET_DATE , RC_RESTMET_TIME , RC_REST_IND , REMOTE_CASE_ID , RB_ANONYMOUS_FLAG , RB_SITE_NOCUST_FLG , SECURE_CASE_FLG , CASE_SUBTYPE , CASE_VISIBILITY , FIN_ACCOUNT_ID , TARGET_CLOSE_DATE , SALES_ENTRY_ID , TRANSACTION_NO , FORM_INSTANCE_ID , CONFIG_CODE , RBTACCTID , KEYWORDS FROM PS_RC_CASE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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.
Default Value: 999999999999999

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_RC_NONVW

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

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

5 MARKET Character(3) VARCHAR2(3) NOT NULL Market

6 CASE_TYPE Character(5) VARCHAR2(5) NOT NULL Case Type
Default Value: BUS_UNIT_DEF_VW.CASE_TYPE
Prompt Table: RC_CASETYPE_TBL

7 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_VW3

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

9 CASE_CONTACT Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
Prompt Table: RC_CNTCT_VW

10 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
Prompt Table: BO

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

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

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

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

15 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
Prompt Table: BO

16 BO_ID_ALT_CNCT Number(31,0) DECIMAL(31) NOT NULL Alternate Contact Business Object. Used in RC_CASE

17 AGREEMENT_CODE Character(30) VARCHAR2(30) NOT NULL This field represents the agreement code (name) for an agreement

18 AGR_RENEWAL_NUM Number(4,0) SMALLINT NOT NULL This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal)

19 AGREEMENT_LINE Character(10) VARCHAR2(10) NOT NULL This field records the value for the agreement line number

20 WARRANTY_NAME Character(40) VARCHAR2(40) NOT NULL This field is used to store the name of the warranty.

21 RC_PAY_FOR_SVC_FLG Character(1) VARCHAR2(1) NOT NULL This flag determines if "pay for service" is applicable for a support case. By default this is applicable unless otherwise the selected entitlement (agreement/warranty) determines it is not necessary.
Y/N Table Edit
Default Value: N

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

23 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
Prompt Table: PROD_ITEM

24 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the Serial ID of an item or installed product
Prompt Table: %EDITTABLE14

25 ASSETTAG Character(40) VARCHAR2(40) NOT NULL Asset Tag
Prompt Table: %EDITTABLE17

26 RC_SOURCE Character(5) VARCHAR2(5) NOT NULL Case Source How this case origianated
Default Value: BUS_UNIT_DEF_VW.RC_SOURCE
Prompt Table: RC_SOURCE_TBL

27 RC_CONTACT_METHOD Character(5) VARCHAR2(5) NOT NULL Contact Method for the Case

28 RC_CONTACT_INFO Character(70) VARCHAR2(70) NOT NULL This field displays the phone number with extension or email address based on the selection (phone/email) from the case page (support/helpdesk). If the user has overridden the value displayed then this is stored on the case record.

29 CM_TYPE_ID Number(6,0) INTEGER NOT NULL Contact Method Type ID
Prompt Table: RC_CM_TYPE

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

31 RB_LOCATION_DETAIL Character(254) VARCHAR2(254) NOT NULL RB_LOCATION_DETAIL

32 PROFILE_CM_SEQ_ADD Number(31,0) DECIMAL(31) NOT NULL This field is used to store the profile contact method sequence number for an address.
Prompt Table: RC_ADDRESS_VW2

33 PROFILE_CM_SEQ_PHN Number(31,0) DECIMAL(31) NOT NULL Used to store the contact method sequence number for a phone number.
Prompt Table: RC_PHONE_VW1

34 PROFILE_CM_SEQ_PGR Number(31,0) DECIMAL(31) NOT NULL Used to store the contact method sequence number for a pager number.

35 PROFILE_CM_SEQ_EML Number(31,0) DECIMAL(31) NOT NULL Used to store the contact method sequence number for a email address.
Prompt Table: RC_EMAIL_VW1

36 REGION_ID Character(15) VARCHAR2(15) NOT NULL This field stores the region id value.

37 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.
Prompt Table: RF_PROVGRP_VW2
Set Control Field: BUSINESS_UNIT

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

39 ASSIGNED_TO Character(15) VARCHAR2(15) NOT NULL This is a field to store assignment information.
Prompt Table: RC_GRP_MEM_VW
Set Control Field: BUSINESS_UNIT

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

41 RC_STATUS Character(5) VARCHAR2(5) NOT NULL Case Status
Default Value: BUS_UNIT_DEF_VW.RC_STATUS
Prompt Table: RC_STATUS_TBL

42 RC_PRIORITY Character(5) VARCHAR2(5) NOT NULL Case Priority
Default Value: BUS_UNIT_DEF_VW.RC_PRIORITY
Prompt Table: RC_PRIORITY_TBL

43 RC_SEVERITY Character(5) VARCHAR2(5) NOT NULL Case severity
Default Value: BUS_UNIT_DEF_VW.RC_SEVERITY
Prompt Table: RC_SEVERITY_TBL

44 BUS_PROC_INSTANCE Number(18,0) DECIMAL(18) NOT NULL Business Project Instance. This is the Business Project instance of a business project.

45 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

46 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

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

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

49 RC_FIRST_CONTACT Character(1) VARCHAR2(1) NOT NULL Marked Y if the case is resolved on the first call.
Y/N Table Edit
Default Value: Y

50 RES_FIRST_CNTCT Character(1) VARCHAR2(1) NOT NULL Resolved by First Contact
Y/N Table Edit
Default Value: N

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

52 CLOSED_DATE Date(10) DATE Date Closed

53 CLOSED_DTTM DateTime(26) TIMESTAMP Date Time stamp for when the case status category was changed to closed.

54 CLOSED_BY_OPRID Character(30) VARCHAR2(30) NOT NULL This field is indicate closed by oprid.

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

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

57 ERROR_ID Number(9,0) DECIMAL(9) NOT NULL Error ID

58 RC_REOPN_REASON_CD Character(10) VARCHAR2(10) NOT NULL Case Reopen Reason Code
Prompt Table: RC_ROPN_SS_VW

59 RC_CLOSE_REASON_CD Character(10) VARCHAR2(10) NOT NULL Case Close Reason Code. This is being used in SS
Prompt Table: RC_CLOSE_SS_VW

60 ERROR_CODE Character(20) VARCHAR2(20) NOT NULL Error Code

61 ERROR_MESSAGE Character(254) VARCHAR2(254) NOT NULL For Standard Journal (SJE)

62 RC_RESP_DATE Date(10) DATE Response date

63 RC_RESP_TIME Time(15) TIMESTAMP Response Time

64 RC_RESPMET_DATE Date(10) DATE Response Date Met

65 RC_RESPMET_TIME Time(15) TIMESTAMP Response Time Met

66 RC_RESP_IND Character(4) VARCHAR2(4) NOT NULL Response Indicator, to indicate different stage of response for SLA.
A=Pending
N=Late
NA=Not Applicable
Y=On-Time
Default Value: NA

67 RC_REST_DATE Date(10) DATE Restore Date

68 RC_REST_TIME Time(15) TIMESTAMP Restore Time

69 RC_RESTMET_DATE Date(10) DATE Restore Date Met

70 RC_RESTMET_TIME Time(15) TIMESTAMP Restore Time Met

71 RC_REST_IND Character(4) VARCHAR2(4) NOT NULL Restore Indicator, indicate different stage of restore for SLA
A=Pending
N=Late
NA=Not Applicable
Y=On-Time
Default Value: NA

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

73 RB_ANONYMOUS_FLAG Character(1) VARCHAR2(1) NOT NULL RB_ANONYMOUS_FLAG
Y/N Table Edit
Default Value: N

74 RB_SITE_NOCUST_FLG Character(1) VARCHAR2(1) NOT NULL Site without customer flag
Y/N Table Edit
Default Value: N

75 SECURE_CASE_FLG Character(1) VARCHAR2(1) NOT NULL Used in HRHD to Secure the case so that only people in the provider group assigned to the case can access the case.
N=No
Y=Yes
Default Value: N

76 CASE_SUBTYPE Character(5) VARCHAR2(5) NOT NULL Field to capture the case subtype.
Prompt Table: RC_CASE_SUBTYPE

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

78 FIN_ACCOUNT_ID Character(20) VARCHAR2(20) NOT NULL Financial Account Number
Prompt Table: RBF_FIN_ACCOUNT

79 TARGET_CLOSE_DATE Date(10) DATE Target close date

80 SALES_ENTRY_ID Character(15) VARCHAR2(15) NOT NULL sales entry id

81 TRANSACTION_NO Character(15) VARCHAR2(15) NOT NULL Transaction table's primary key.

82 FORM_INSTANCE_ID Number(15,0) DECIMAL(15) NOT NULL Instance ID

83 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

84 RBTACCTID Character(15) VARCHAR2(15) NOT NULL Unique service account indentifier
Prompt Table: RCF_BILL_AC_VW2

85 KEYWORDS Character(100) VARCHAR2(100) NOT NULL Query Keywords

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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. Default Value: 999999999999999
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_RC_NONVW
3	DISP_TMPL_FAM_CD	Character(30)	VARCHAR2(30) NOT NULL	Display Template Family Code
4	RC_VERTICAL	Character(4)	VARCHAR2(4) NOT NULL	Specifies the CallCenter type. See translates for valid values. HD=HelpDesk SW=Support
5	MARKET	Character(3)	VARCHAR2(3) NOT NULL	Market
6	CASE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Case Type Default Value: BUS_UNIT_DEF_VW.CASE_TYPE Prompt Table: RC_CASETYPE_TBL
7	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_VW3
8	SIN	Character(40)	VARCHAR2(40) NOT NULL	This field is used to represent the Site Identification Number Prompt Table: RC_SIN_VW2
9	CASE_CONTACT	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts Prompt Table: RC_CNTCT_VW
10	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer. Prompt Table: BO
11	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer
12	ROLE_TYPE_ID_CNTCT	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the contact
13	BO_ID_SITE	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID
14	ROLE_TYPE_ID_SITE	Number(12,0)	DECIMAL(12) NOT NULL	Role Type ID
15	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact. Prompt Table: BO
16	BO_ID_ALT_CNCT	Number(31,0)	DECIMAL(31) NOT NULL	Alternate Contact Business Object. Used in RC_CASE
17	AGREEMENT_CODE	Character(30)	VARCHAR2(30) NOT NULL	This field represents the agreement code (name) for an agreement
18	AGR_RENEWAL_NUM	Number(4,0)	SMALLINT NOT NULL	This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal)
19	AGREEMENT_LINE	Character(10)	VARCHAR2(10) NOT NULL	This field records the value for the agreement line number
20	WARRANTY_NAME	Character(40)	VARCHAR2(40) NOT NULL	This field is used to store the name of the warranty.
21	RC_PAY_FOR_SVC_FLG	Character(1)	VARCHAR2(1) NOT NULL	This flag determines if "pay for service" is applicable for a support case. By default this is applicable unless otherwise the selected entitlement (agreement/warranty) determines it is not necessary. Y/N Table Edit Default Value: N
22	INST_PROD_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the installed product ID (key field) Prompt Table: %EDITTABLE15
23	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID Prompt Table: PROD_ITEM
24	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the Serial ID of an item or installed product Prompt Table: %EDITTABLE14
25	ASSETTAG	Character(40)	VARCHAR2(40) NOT NULL	Asset Tag Prompt Table: %EDITTABLE17
26	RC_SOURCE	Character(5)	VARCHAR2(5) NOT NULL	Case Source How this case origianated Default Value: BUS_UNIT_DEF_VW.RC_SOURCE Prompt Table: RC_SOURCE_TBL
27	RC_CONTACT_METHOD	Character(5)	VARCHAR2(5) NOT NULL	Contact Method for the Case
28	RC_CONTACT_INFO	Character(70)	VARCHAR2(70) NOT NULL	This field displays the phone number with extension or email address based on the selection (phone/email) from the case page (support/helpdesk). If the user has overridden the value displayed then this is stored on the case record.
29	CM_TYPE_ID	Number(6,0)	INTEGER NOT NULL	Contact Method Type ID Prompt Table: RC_CM_TYPE
30	CM_ID	Number(31,0)	DECIMAL(31) NOT NULL	Contact Method ID
31	RB_LOCATION_DETAIL	Character(254)	VARCHAR2(254) NOT NULL	RB_LOCATION_DETAIL
32	PROFILE_CM_SEQ_ADD	Number(31,0)	DECIMAL(31) NOT NULL	This field is used to store the profile contact method sequence number for an address. Prompt Table: RC_ADDRESS_VW2
33	PROFILE_CM_SEQ_PHN	Number(31,0)	DECIMAL(31) NOT NULL	Used to store the contact method sequence number for a phone number. Prompt Table: RC_PHONE_VW1
34	PROFILE_CM_SEQ_PGR	Number(31,0)	DECIMAL(31) NOT NULL	Used to store the contact method sequence number for a pager number.
35	PROFILE_CM_SEQ_EML	Number(31,0)	DECIMAL(31) NOT NULL	Used to store the contact method sequence number for a email address. Prompt Table: RC_EMAIL_VW1
36	REGION_ID	Character(15)	VARCHAR2(15) NOT NULL	This field stores the region id value.
37	PROVIDER_GRP_ID	Character(10)	VARCHAR2(10) NOT NULL	Identification number for the provider group. Prompt Table: RF_PROVGRP_VW2 Set Control Field: BUSINESS_UNIT
38	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.
39	ASSIGNED_TO	Character(15)	VARCHAR2(15) NOT NULL	This is a field to store assignment information. Prompt Table: RC_GRP_MEM_VW Set Control Field: BUSINESS_UNIT
40	PRIOR_ASSIGNED_TO	Character(15)	VARCHAR2(15) NOT NULL	This is a field to store assignment information.
41	RC_STATUS	Character(5)	VARCHAR2(5) NOT NULL	Case Status Default Value: BUS_UNIT_DEF_VW.RC_STATUS Prompt Table: RC_STATUS_TBL
42	RC_PRIORITY	Character(5)	VARCHAR2(5) NOT NULL	Case Priority Default Value: BUS_UNIT_DEF_VW.RC_PRIORITY Prompt Table: RC_PRIORITY_TBL
43	RC_SEVERITY	Character(5)	VARCHAR2(5) NOT NULL	Case severity Default Value: BUS_UNIT_DEF_VW.RC_SEVERITY Prompt Table: RC_SEVERITY_TBL
44	BUS_PROC_INSTANCE	Number(18,0)	DECIMAL(18) NOT NULL	Business Project Instance. This is the Business Project instance of a business project.
45	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
46	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
47	RC_DETAIL	Character(5)	VARCHAR2(5) NOT NULL	Detail field on HD Case. Used in Quick Code. Prompt Table: RC_CTD_DET_F_VW
48	PROBLEM_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Problem Type for Support Cases Prompt Table: RC_PROBTYPE_TBL Set Control Field: BUSINESS_UNIT
49	RC_FIRST_CONTACT	Character(1)	VARCHAR2(1) NOT NULL	Marked Y if the case is resolved on the first call. Y/N Table Edit Default Value: Y
50	RES_FIRST_CNTCT	Character(1)	VARCHAR2(1) NOT NULL	Resolved by First Contact Y/N Table Edit Default Value: N
51	CREATION_DATE	Date(10)	DATE	Creation date of the case.
52	CLOSED_DATE	Date(10)	DATE	Date Closed
53	CLOSED_DTTM	DateTime(26)	TIMESTAMP	Date Time stamp for when the case status category was changed to closed.
54	CLOSED_BY_OPRID	Character(30)	VARCHAR2(30) NOT NULL	This field is indicate closed by oprid.
55	RC_SUMMARY	Character(80)	VARCHAR2(80) NOT NULL	Typically a summary of a long field.
56	RC_TRACKING_NBR	Character(30)	VARCHAR2(30) NOT NULL	Customer Tracking Number Field.
57	ERROR_ID	Number(9,0)	DECIMAL(9) NOT NULL	Error ID
58	RC_REOPN_REASON_CD	Character(10)	VARCHAR2(10) NOT NULL	Case Reopen Reason Code Prompt Table: RC_ROPN_SS_VW
59	RC_CLOSE_REASON_CD	Character(10)	VARCHAR2(10) NOT NULL	Case Close Reason Code. This is being used in SS Prompt Table: RC_CLOSE_SS_VW
60	ERROR_CODE	Character(20)	VARCHAR2(20) NOT NULL	Error Code
61	ERROR_MESSAGE	Character(254)	VARCHAR2(254) NOT NULL	For Standard Journal (SJE)
62	RC_RESP_DATE	Date(10)	DATE	Response date
63	RC_RESP_TIME	Time(15)	TIMESTAMP	Response Time
64	RC_RESPMET_DATE	Date(10)	DATE	Response Date Met
65	RC_RESPMET_TIME	Time(15)	TIMESTAMP	Response Time Met
66	RC_RESP_IND	Character(4)	VARCHAR2(4) NOT NULL	Response Indicator, to indicate different stage of response for SLA. A=Pending N=Late NA=Not Applicable Y=On-Time Default Value: NA
67	RC_REST_DATE	Date(10)	DATE	Restore Date
68	RC_REST_TIME	Time(15)	TIMESTAMP	Restore Time
69	RC_RESTMET_DATE	Date(10)	DATE	Restore Date Met
70	RC_RESTMET_TIME	Time(15)	TIMESTAMP	Restore Time Met
71	RC_REST_IND	Character(4)	VARCHAR2(4) NOT NULL	Restore Indicator, indicate different stage of restore for SLA A=Pending N=Late NA=Not Applicable Y=On-Time Default Value: NA
72	REMOTE_CASE_ID	Character(18)	VARCHAR2(18) NOT NULL	Remote system case ID. Used to store case unique identify ID from 3rd party system.
73	RB_ANONYMOUS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	RB_ANONYMOUS_FLAG Y/N Table Edit Default Value: N
74	RB_SITE_NOCUST_FLG	Character(1)	VARCHAR2(1) NOT NULL	Site without customer flag Y/N Table Edit Default Value: N
75	SECURE_CASE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Used in HRHD to Secure the case so that only people in the provider group assigned to the case can access the case. N=No Y=Yes Default Value: N
76	CASE_SUBTYPE	Character(5)	VARCHAR2(5) NOT NULL	Field to capture the case subtype. Prompt Table: RC_CASE_SUBTYPE
77	CASE_VISIBILITY	Character(4)	VARCHAR2(4) NOT NULL	Field to capture the case visibility. EXCL=Internal, exclude Case Contact EXTL=External INTL=Internal Default Value: INTL
78	FIN_ACCOUNT_ID	Character(20)	VARCHAR2(20) NOT NULL	Financial Account Number Prompt Table: RBF_FIN_ACCOUNT
79	TARGET_CLOSE_DATE	Date(10)	DATE	Target close date
80	SALES_ENTRY_ID	Character(15)	VARCHAR2(15) NOT NULL	sales entry id
81	TRANSACTION_NO	Character(15)	VARCHAR2(15) NOT NULL	Transaction table's primary key.
82	FORM_INSTANCE_ID	Number(15,0)	DECIMAL(15) NOT NULL	Instance ID
83	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator
84	RBTACCTID	Character(15)	VARCHAR2(15) NOT NULL	Unique service account indentifier Prompt Table: RCF_BILL_AC_VW2
85	KEYWORDS	Character(100)	VARCHAR2(100) NOT NULL	Query Keywords