RA_ATTR_ACT_VW

(SQL View)
 Index Back

Profile Fields

a view of selected profile attribute Fields

SELECT B.RA_PROFILE_ID , B.RA_ATTRIBUTE_ID , A.RA_PROFILE_TYPE , A.RA_PROFILE_GROUP , A.RA_PROFILE_NAME , B.RA_ATTRIB_NAME , B.RA_ATTRIB_TYPE , B.RA_ATTRIB_STATUS , B.DESCR100 , B.RA_ATTRIB_LENGTH , B.RA_ATTRIB_INDEX , B.RA_ATTRIB_IS_INDEX , B.RA_ATTRIB_QUESTION , B.RA_ATTRIB_FLDNAME , B.RA_ATTRIB_RECNAME , B.DESCR254 , B.RA_ATTRIB_UPDATE , B.PROMPT_TABLE , B.VALIDATION_RULE_ID , B.RA_ATTRIB_FLDTYPE ,A.RA_ONE_OR_MANY , B.ROW_ADDED_DTTM , B.ROW_ADDED_OPRID , B.ROW_LASTMANT_DTTM , B.ROW_LASTMANT_OPRID , B.SYNCID , B.SYNCDTTM FROM PS_RA_PROFILE A , PS_RA_ATTRIBUTE B , PS_RY_PROF C WHERE A.RA_PROFILE_ID = B.RA_PROFILE_ID AND B.RA_ATTRIB_TYPE <> 'PRMT' AND B.RA_ATTRIB_STATUS NOT IN ('DES') AND A.SYNCID = C.RY_PROFILE_SYNCID

  • Related Language Record: RA_ATTR_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RA_PROFILE_ID Number(18,0) DECIMAL(18) NOT NULL Profile - profile ID

    Prompt Table: RA_PROFILE

    2 RA_ATTRIBUTE_ID Number(18,0) DECIMAL(18) NOT NULL Profile / Attribute ID
    3 RA_PROFILE_TYPE Character(4) VARCHAR2(4) NOT NULL Profile - Type
    SYS=System Global
    USER=User
    4 RA_PROFILE_GROUP Character(3) VARCHAR2(3) NOT NULL Profile - Group
    IND=Individuals
    ORG=Organizations
    5 RA_PROFILE_NAME Character(80) VARCHAR2(80) NOT NULL Profile - Name
    6 RA_ATTRIB_NAME Character(90) VARCHAR2(90) NOT NULL Profile - Attribute 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
    8 RA_ATTRIB_STATUS Character(3) VARCHAR2(3) NOT NULL Profile - attribute status
    ACT=Active
    DES=In Design
    INA=Inactivated
    UPD=Update

    Default Value: DES

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

    Default Value: 10

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: RA_DUMMY_PROMPT

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

    Prompt Table: RA_DUMMY_PROMPT

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

    Y/N Table Edit

    Default Value: Y

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

    Prompt Table: RA_RECDEFN_VW

    19 VALIDATION_RULE_ID Character(15) VARCHAR2(15) NOT NULL Validation Rule
    20 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

    21 RA_ONE_OR_MANY Character(1) VARCHAR2(1) NOT NULL Profile - One or Many
    M=Many rows
    N=One row
    22 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    23 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    24 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    25 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    26 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    27 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time