RC_CNTXT_PREF

(SQL Table)
Index Back

Store Context Preferences

Recordd to store preferences for a context

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONTEXT_ID Character(15) VARCHAR2(15) NOT NULL Context Map Code

Prompt Table: RC_CNTXT_DEFN

2 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code
3 TOP_SOLUTION Character(1) VARCHAR2(1) NOT NULL Top Solution

Y/N Table Edit

Default Value: Y

4 RESTRICT_SOLUTIONS Character(1) VARCHAR2(1) NOT NULL Restrict Solutions by Time
A=All Solutions Considered
C=By Created Date
L=By Last Updated Date
5 FAQ_PB Character(1) VARCHAR2(1) NOT NULL Frequently asked questions hyperlink field

Y/N Table Edit

Default Value: Y

6 KNOWN_ISSUES Character(1) VARCHAR2(1) NOT NULL Known Issues

Y/N Table Edit

Default Value: Y

7 FEATURE_SOL Character(1) VARCHAR2(1) NOT NULL Featured Solution

Y/N Table Edit

Default Value: Y

8 MAX_COUNT Number(3,0) SMALLINT NOT NULL Maximum count of solutions
9 FROM_DATE Date(10) DATE From Date
10 ORDER_BY Character(1) VARCHAR2(1) NOT NULL Order By
L=By Last Updated
S=By Solved Count
U=By Usage Count
11 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
12 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
13 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
14 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
15 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.
16 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time