RC_SA_RSLT_HDR (SQL Table)	Index Back
Solution Advisor Search Info

RC_SA_RSLT_HDR

(SQL Table)

Solution Advisor Search Info

Parent Record Of RC_SA_CASE_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 KEY_CASE_ID Number(15,0) DECIMAL(15) NOT NULL Case ID

3 KEY_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

4 RC_SEARCH_CRITERIA Long Character CLOB Addition Search Text

5 RC_CASE_IND Character(1) VARCHAR2(1) NOT NULL Case Indicator
Y/N Table Edit
Default Value: Y

6 RC_PST_IND Character(1) VARCHAR2(1) NOT NULL Problem Solving Technique
Y/N Table Edit
Default Value: Y

7 RC_RESOLUTION_IND Character(1) VARCHAR2(1) NOT NULL Independent Text Solution
Y/N Table Edit
Default Value: Y

8 RC_SOLUTION_IND Character(1) VARCHAR2(1) NOT NULL Solution Indicator
Y/N Table Edit
Default Value: Y

9 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	KEY_CASE_ID	Number(15,0)	DECIMAL(15) NOT NULL	Case ID
3	KEY_BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	RC_SEARCH_CRITERIA	Long Character	CLOB	Addition Search Text
5	RC_CASE_IND	Character(1)	VARCHAR2(1) NOT NULL	Case Indicator Y/N Table Edit Default Value: Y
6	RC_PST_IND	Character(1)	VARCHAR2(1) NOT NULL	Problem Solving Technique Y/N Table Edit Default Value: Y
7	RC_RESOLUTION_IND	Character(1)	VARCHAR2(1) NOT NULL	Independent Text Solution Y/N Table Edit Default Value: Y
8	RC_SOLUTION_IND	Character(1)	VARCHAR2(1) NOT NULL	Solution Indicator Y/N Table Edit Default Value: Y
9	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.