RC_QUESTTOGRP_V(SQL View) |
Index Back |
---|---|
Question - Question Group viewView of Question Groups that reference a given Question |
SELECT A.QUESTION_ID ,A.RC_QUEST_GRP_ID ,B.RC_GRP_NAME ,B.DESCRLONG FROM PS_RC_QUEST_ITEM A ,PS_RC_QUESTION_GRP 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 | RC_GRP_NAME | Character(40) | VARCHAR2(40) NOT NULL | Question Group Name |
4 | DESCRLONG | Long Character | CLOB | Long Description |