SETIDRC_PHONE_CUSTLANGUAGE_CDPrompt Table: RC_CM_PURP_VW2
RC_PHONELVW4(SQL View) |
Index Back |
|---|---|
View for PhoneRelated Language view for Phone. |
| SELECT DISTINCT G.SETID , C.PHONE , D.LANGUAGE_CD , %Substring(F.BO_NAME_DISPLAY,1,50) , F.BO_NAME_AC , D.DESCR FROM PS_BO_SRCH_PHN C , PS_CM_PURP_TYP_LNG D , PS_BO_NAME F , PS_BC G WHERE C.ROLE_TYPE_ID IN (2,9) AND C.BO_CM_USE_TYPE = 'R' AND C.CM_PURPOSE_TYPE_ID = D.CM_PURPOSE_TYPE_ID AND C.BO_ID = F.BO_ID AND F.PRIMARY_IND = 'Y' AND C.BO_ID = G.BO_ID |
| # | 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. |
| 2 | RC_PHONE_CUST |
Character(24) | VARCHAR2(24) NOT NULL | This is the phone field used in case search. The reason is to have the ability to enter partial value for the phone and search on it. The standard PHONE field has a format mask associated with it, which does not permit entering partial values. |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | BO_NAME | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 5 | BO_NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 6 | RC_PURP_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL |
Short Description
Prompt Table: RC_CM_PURP_VW2 |