RA_AUDN_XCOL_VW(SQL View) |
Index Back |
|---|---|
View of audience exportExport columns for an audience export, including profile field information. |
| SELECT A.SETID , A.RA_LIST_ID , A.SEQ_NUM , A.RA_ATTRIB_SEQ , A.RA_ORDER_BY_NUMBER , A.RA_PROFILE_ID , B.RA_PROFILE_TYPE , B.RA_PROFILE_GROUP , A.RA_ATTRIBUTE_ID , C.RA_ATTRIB_NAME , C.RA_ATTRIB_RECNAME , C.RA_ATTRIB_FLDNAME , C.RA_ATTRIB_TYPE , A.RELATED_DISP_REC , A.RELATED_DISP_FIELD FROM PS_RA_AUDN_EXP_COL A , PS_RA_PROFILE B , PS_RA_ATTRIBUTE C WHERE A.RA_PROFILE_ID = B.RA_PROFILE_ID AND A.RA_PROFILE_ID = C.RA_PROFILE_ID AND A.RA_ATTRIBUTE_ID = C.RA_ATTRIBUTE_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 | RA_LIST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Audience ID |
| 3 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 4 | RA_ATTRIB_SEQ |
Number(31,0) | DECIMAL(31) NOT NULL | Profile / attribute sequence numbers |
| 5 | RA_ORDER_BY_NUMBER | Number(3,0) | SMALLINT NOT NULL | Order-By Number |
| 6 | RA_PROFILE_ID | Number(18,0) | DECIMAL(18) NOT NULL | Profile - profile ID |
| 7 | RA_PROFILE_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Profile - Type
SYS=System Global USER=User |
| 8 | RA_PROFILE_GROUP | Character(3) | VARCHAR2(3) NOT NULL |
Profile - Group
IND=Individuals ORG=Organizations |
| 9 | RA_ATTRIBUTE_ID | Number(18,0) | DECIMAL(18) NOT NULL | Profile / Attribute ID |
| 10 | RA_ATTRIB_NAME | Character(90) | VARCHAR2(90) NOT NULL | Profile - Attribute name |
| 11 | RA_ATTRIB_RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Profile - Attribute record name |
| 12 | RA_ATTRIB_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | Profile - Attribute field name |
| 13 | RA_ATTRIB_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Profile - attribute type
C1=Choose One C1R=Choose One (with Rating) CM=Choose Many DATE=Date DEC=Decimal FA=File INT=Integer LT=Text Block PRMT=Map Field Choice to Prompt TEXT=Text TIME=Time YN=Yes/No |
| 14 | RELATED_DISP_REC | Character(15) | VARCHAR2(15) NOT NULL | Record Name |
| 15 | RELATED_DISP_FIELD | Character(18) | VARCHAR2(18) NOT NULL | Field Name |