RA_PROFILE_IDRA_ATTRIBUTE_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
RB_PRFL_FLD_VW(SQL View) |
Index Back |
|---|---|
Profile Field ViewProfile Fields View -- used in CDM Profiles page. |
| SELECT RA_PROFILE_ID , RA_ATTRIBUTE_ID , RA_ATTRIB_NAME , RA_ATTRIB_TYPE FROM PS_RA_ATTRIBUTE WHERE RA_ATTRIB_TYPE NOT IN ('FA', 'LT') |
| # | 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_ATTRIB_NAME | Character(90) | VARCHAR2(90) NOT NULL | Profile - Attribute name |
| 4 | 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 |