QUESTION_IDRC_QUEST_GRP_IDLANGUAGE_CDRC_QUESTTOGRP_L(SQL View) |
Index Back |
|---|---|
Question - Question Group RLRRelated language view for RC_QUESTTOGRP_V |
| SELECT A.QUESTION_ID ,A.RC_QUEST_GRP_ID ,B.LANGUAGE_CD ,B.RC_GRP_NAME ,B.DESCRLONG FROM PS_RC_QUEST_ITEM A ,PS_RC_QUES_GRP_LNG B WHERE A.RC_QUEST_GRP_ID = B.RC_QUEST_GRP_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | QUESTION_ID |
Number(12,0) | DECIMAL(12) NOT NULL | Used in CRM branch script |
| 2 | RC_QUEST_GRP_ID |
Number(12,0) | DECIMAL(12) NOT NULL | Branch script |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | RC_GRP_NAME | Character(40) | VARCHAR2(40) NOT NULL | Question Group Name |
| 5 | DESCRLONG | Long Character | CLOB | Long Description |