RA_ATTR_CNTC_VW

(SQL View)
 Index Back

Profile Fields for People

Profile Fields valid for RA_PROFILE_ID = 1

SELECT RA_PROFILE_ID , RA_ATTRIBUTE_ID , RA_ATTRIB_NAME , RA_ATTRIB_TYPE , RA_ATTRIB_STATUS , DESCR100 , RA_ATTRIB_LENGTH , RA_ATTRIB_INDEX , RA_ATTRIB_IS_INDEX , RA_ATTRIB_QUESTION , RA_ATTRIB_FLDTYPE , RA_ATTRIB_FLDNAME , RA_ATTRIB_RECNAME , DESCR254 , RA_ATTRIB_UPDATE , PROMPT_TABLE , VALIDATION_RULE_ID FROM PS_RA_ATTRIBUTE WHERE RA_PROFILE_ID = 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RA_PROFILE_ID_CNT Number(18,0) DECIMAL(18) NOT NULL Contact 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
5 RA_ATTRIB_STATUS Character(3) VARCHAR2(3) NOT NULL Profile - attribute status
ACT=Active
DES=In Design
INA=Inactivated
UPD=Update

Default Value: DES

6 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
7 RA_ATTRIB_LENGTH Number(5,0) INTEGER NOT NULL Profile - Attribute length

Default Value: 10

8 RA_ATTRIB_INDEX Number(3,0) SMALLINT NOT NULL Profile - Attribute index
9 RA_ATTRIB_IS_INDEX Character(1) VARCHAR2(1) NOT NULL Profile - Attribute index

Y/N Table Edit

Default Value: N

10 RA_ATTRIB_QUESTION Character(1) VARCHAR2(1) NOT NULL Profile - Attribute question

Y/N Table Edit

Default Value: N

11 RA_ATTRIB_FLDTYPE Character(4) VARCHAR2(4) NOT NULL Profile Attribute Field Data Type
CHAR=Character
LONG=Long Text Block
NUM=Number - with decimal 0

Default Value: NUM

12 RA_ATTRIB_FLDNAME Character(18) VARCHAR2(18) NOT NULL Profile - Attribute field name

Prompt Table: RA_DUMMY_PROMPT

13 RA_ATTRIB_RECNAME Character(15) VARCHAR2(15) NOT NULL Profile - Attribute record name

Prompt Table: RA_DUMMY_PROMPT

14 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
15 RA_ATTRIB_UPDATE Character(1) VARCHAR2(1) NOT NULL Profile / Attribute - updateable?

Y/N Table Edit

Default Value: Y

16 PROMPT_TABLE Character(15) VARCHAR2(15) NOT NULL Record Name

Prompt Table: RA_RECDEFN_VW

17 VALIDATION_RULE_ID Character(15) VARCHAR2(15) NOT NULL Validation Rule