RC_SOLUTION

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW
2	SOLUTION_ID	Number(15,0)	DECIMAL(15) NOT NULL	Solution ID Default Value: 999999999999999
3	RC_SOLUTION_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Solution Type ADHC=Adhoc Solution CAND=Canned Solution FILE=File LINK=Link S=Standard Solution W=Workaround Solution Default Value: ADHC
4	SOLN_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Solution Status ACTV=4 - Active DNED=5 - Denied DRFT=1 - Draft EXPR=6 - Expired REVW=3 - In Review RWRK=8 - Rework SUBM=2 - Submitted for Review SUPR=7 - Superseded Default Value: DRFT
5	RC_SOLN_VISIBILITY	Character(4)	VARCHAR2(4) NOT NULL	Solution Visibility A=All I=Internal Default Value: A
6	RC_SUMMARY	Character(80)	VARCHAR2(80) NOT NULL	Typically a summary of a long field.
7	SYMPTOM_DESCR	Character(254)	VARCHAR2(254) NOT NULL	Symptom Description
8	KEYWORDS	Character(100)	VARCHAR2(100) NOT NULL	Query Keywords
9	LAST_ACTION_DTTM	DateTime(26)	TIMESTAMP	LAST_ACTION_DTTM
10	EXPIRY_IND	Character(1)	VARCHAR2(1) NOT NULL	Expiry Indicator N=Not Expired Y=Expired Default Value: N
11	EXPIRY_DATE	Date(10)	DATE	Expiry Date
12	EXPIRY_REASON	Character(80)	VARCHAR2(80) NOT NULL	Expiry reason
13	NEW_SOLUTION_ID	Number(15,0)	DECIMAL(15) NOT NULL	Superceding Solution ID Prompt Table: RC_SOLN_NEW_DVW
14	LIBRARY_ID	Character(5)	VARCHAR2(5) NOT NULL	Solution Library ID or Troubleshooting Guide ID Prompt Table: RC_SOLN_LIB_TBL
15	USAGE_COUNT	Number(8,0)	INTEGER NOT NULL	Counter of how often this row was selected in a Search Results page and marked as 'Used'. Usage Count is incremented by the USAGE_INCREMENT amount on the Search Setup Parameters page each time the row is 'Used'. Default Value: 0
16	LAST_USAGE_DTTM	DateTime(26)	TIMESTAMP	Used to identify last time the record was marked 'Used' in a Search result
17	USER_UPDATE_DTTM	DateTime(26)	TIMESTAMP	USER_UPDATE_DTTM
18	UPDATED_BY_USER	Character(30)	VARCHAR2(30) NOT NULL	Updated By
19	RC_SOLVED_COUNT	Number(6,0)	INTEGER NOT NULL	Solved Count Field in Solution Default Value: 0
20	RC_UNSOLVED_COUNT	Number(6,0)	INTEGER NOT NULL	Counting number of times a solution failed to solve cases Default Value: 0
21	FAQ_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag to identify a Frequently Asked Question Y/N Table Edit Default Value: N
22	URL	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)
23	RB_TEMPLATE_CD	Character(4)	VARCHAR2(4) NOT NULL	Outbout email template name 0=No templates available Prompt Table: RC_SOLN_TMPL_VW
24	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
25	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
26	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
27	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
28	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
29	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time
30	RC_SOLN_OWNERID	Character(5)	VARCHAR2(5) NOT NULL	Solution Content Owner ID field - uppercase denoting an Owner Prompt Table: RC_SOLN_CTNT_VW
31	START_DATE	Date(10)	DATE	Start Date Default Value: %Date
32	SOLUTION_DESCR	Long Character	CLOB	Solution Description
33	RC_SS_SOLVED_COUNT	Number(6,0)	INTEGER NOT NULL	Solved Count Field in Solution
34	RC_SS_UNSOLVED_CNT	Number(6,0)	INTEGER NOT NULL	Solved Count Field in Solution
35	SS_USAGE_COUNT	Number(8,0)	INTEGER NOT NULL	Counter of how often this row was selected in a Search Results page and marked as 'Used'. Usage Count is incremented by the USAGE_INCREMENT amount on the Search Setup Parameters page each time the row is 'Used'.