| RA_SEG_GRP_A_VW(SQL View) | Index Back | 
|---|---|
| Active Segment GroupsPrompt view for active segment groups | 
| SELECT SETID , RA_SEGMENT_GRP_ID , RA_SEGMENT_GROUP FROM PS_RA_SEG_GRP_TBL WHERE STATUS = 'A' | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | 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 | Character(15) | VARCHAR2(15) NOT NULL | Marketing Segment Group Key ID field | |
| 3 | RA_SEGMENT_GROUP | Character(30) | VARCHAR2(30) NOT NULL | Marketing Segment Group name field. |