RA_ATTR_CHOICES

(SQL Table)
Index Back

Records attribute choices

Profile Field Choices / Records attribute choices

  • Related Language Record: RA_ATTR_CHC_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

    Prompt Table: RA_ATTRIBUTE

    3 RA_CHOICE_ID Character(50) VARCHAR2(50) NOT NULL Profile Attribute Choice ID
    4 RA_CHOICE_PAREN_ID Character(50) VARCHAR2(50) NOT NULL Profile Attribute Parent Choice ID. This field is used for creating parent child relationship, which helps in dropdown filtering.

    Prompt Table: RA_ATTR_CHOICES

    5 RA_CHOICE_LABEL Character(50) VARCHAR2(50) NOT NULL Choice Label name
    6 RA_CHOICE_INDEX Number(5,0) INTEGER NOT NULL Order of Appearance
    7 RA_CHOICE_STATUS Character(3) VARCHAR2(3) NOT NULL Profile Attribute Choice Status Field
    ACT=Active
    DES=In Design
    INA=Inactive

    Default Value: DES

    8 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    9 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    10 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    11 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    12 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.
    13 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time