RA_PROFILE_IDRA_ATTRIBUTE_IDRA_CHOICE_IDC1=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
CS_DATA_MAP_VW(SQL View) |
Index Back |
|---|---|
CS_DATA_MAP_VWCRM table used to map SA values to CRM meta data values. |
| SELECT A.RA_PROFILE_ID ,B.RA_ATTRIBUTE_ID ,C.RA_CHOICE_ID ,A.RA_PROFILE_RECNAME ,B.RA_ATTRIB_FLDNAME ,C.RA_CHOICE_LABEL ,B.RA_ATTRIB_TYPE FROM PS_RA_PROFILE A , PS_RA_ATTRIBUTE B , PS_RA_ATTR_CHOICES C WHERE A.RA_PROFILE_ID = B.RA_PROFILE_ID AND B.RA_PROFILE_ID = C.RA_PROFILE_ID AND B.RA_ATTRIBUTE_ID = C.RA_ATTRIBUTE_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RA_PROFILE_ID |
Number(18,0) | DECIMAL(18) NOT NULL | Profile - profile ID |
| 2 | RA_ATTRIBUTE_ID |
Number(18,0) | DECIMAL(18) NOT NULL | Profile / Attribute ID |
| 3 | RA_CHOICE_ID |
Character(50) | VARCHAR2(50) NOT NULL | Profile Attribute Choice ID |
| 4 | RA_PROFILE_RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Profile - record name |
| 5 | RA_ATTRIB_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | Profile - Attribute field name |
| 6 | RA_CHOICE_LABEL | Character(50) | VARCHAR2(50) NOT NULL | Choice Label name |
| 7 | 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 |