RA_PROFILE

(SQL Table)
 Index Back

Profile table

Profile Definition table containing name, type, group

  • Related Language Record: RA_PROFILE_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
    2 RA_PROFILE_NAME Character(80) VARCHAR2(80) NOT NULL Profile - Name
    3 RA_PROFILE_TYPE Character(4) VARCHAR2(4) NOT NULL Profile - Type
    SYS=System Global
    USER=User

    Default Value: USER

    4 RA_PROFILE_GROUP Character(3) VARCHAR2(3) NOT NULL Profile - Group
    IND=Individuals
    ORG=Organizations

    Default Value: IND

    5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    6 RA_PROFILE_STATUS Character(3) VARCHAR2(3) NOT NULL Profile - status
    AC1=Activating
    ACT=Activated
    DES=In Design
    INA=Inactivated
    REJ=Rejected
    REQ=Requested
    UPD=Update

    Default Value: DES

    7 RA_ONE_OR_MANY Character(1) VARCHAR2(1) NOT NULL Profile - One or Many
    M=Many rows
    N=One row

    Default Value: N

    8 RA_AUTO_CREATE_TBL Character(1) VARCHAR2(1) NOT NULL Field to indicate whether or not to auto create profile.
    N=Create/Map Profile Manually
    Y=Create Profile Automatically

    Default Value: Y

    9 RA_PROFILE_RECNAME Character(15) VARCHAR2(15) NOT NULL Profile - record name
    10 RA_PROFILE_UPDATE Character(1) VARCHAR2(1) NOT NULL Profile Updateable
    A=Updates Allowed via App. Class
    D=Update Direct through SQL
    N=No Updates - Read Only

    Default Value: D

    11 EOCF_SUBJECT_ID Number(31,0) DECIMAL(31) NOT NULL Library Subject Id
    12 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    13 RA_SECURE_PRF Character(1) VARCHAR2(1) NOT NULL Security flag for profile definitions.
    N=No
    Y=Yes

    Default Value: N

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