RC_CTD_SEARCH

(SQL View)
 Index Back

CTD combination search view

Category, Type, Detail combination search view for configurable search

SELECT DISTINCT SETID , RC_CATEGORY , RC_TYPE , RC_DETAIL , ' ' , ' ' , ' ' , ' ' , START_DT , END_DT , CASE WHEN START_DT <= %CurrentDateIn AND END_DT IS NULL THEN 'A' WHEN END_DT <= %CurrentDateIn THEN 'I' ELSE 'P' END ,' ' ,' ' FROM PS_RC_CTD WHERE SETID <> ' ' AND RC_CATEGORY <> ' '

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

Prompt Table: SP_SETID_NONVW

2 RC_CATEGORY Character(5) VARCHAR2(5) NOT NULL CallCenter Category. Used in HD.

Prompt Table: RC_CTD_CAT_VW2

3 RC_TYPE Character(5) VARCHAR2(5) NOT NULL Specialty type. Used on HD case.

Prompt Table: RC_CTD_TYP_VW2

4 RC_DETAIL Character(5) VARCHAR2(5) NOT NULL Detail field on HD Case. Used in Quick Code.

Prompt Table: RC_CTD_DET_VW2

5 SETID_WRK Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: RC_CTD_SEARCH.SETID

6 CAT_DESCR Character(20) VARCHAR2(20) NOT NULL This field is used to represent the short description for various objects
7 TYP_DESCR Character(20) VARCHAR2(20) NOT NULL This field is used to represent the short description for various objects
8 DET_DESCR Character(20) VARCHAR2(20) NOT NULL This field is used to represent the short description for various objects
9 START_DT Date(10) DATE Start date field to store start date value.
10 END_DT Date(10) DATE This field stores the end date values.
11 CTD_STATUS Character(1) VARCHAR2(1) NOT NULL Category, Type, Detail combination status
A=Active
I=Inactive
P=Pending
12 TRF_TO_COMPETENCY Character(1) VARCHAR2(1) NOT NULL Field to display Competencies icon for allowing transfer to the secondary competency page
13 DELETED_FLG Character(1) VARCHAR2(1) NOT NULL Deleted Flag Field