RA_DLG_PROF_VW

(SQL View)
 Index Back

Custom Profile table

Marketing Custom view of the Profile table

SELECT A.RA_PROFILE_ID , A.RA_PROFILE_NAME , A.RA_PROFILE_TYPE , A.RA_PROFILE_GROUP , A.RA_PROFILE_UPDATE , A.DESCR254 , A.RA_PROFILE_STATUS , A.RA_ONE_OR_MANY , A.RA_PROFILE_RECNAME ,C.OPRID , A.ROW_ADDED_DTTM , A.ROW_ADDED_OPRID , A.ROW_LASTMANT_DTTM , A.ROW_LASTMANT_OPRID , A.SYNCID , A.SYNCDTTM FROM PS_RA_PROFILE A , PS_RY_PROF B ,PS_RA_PRF_SCRTY_VW C WHERE RA_PROFILE_STATUS NOT IN ('DES') AND A.SYNCID = B.RY_PROFILE_SYNCID AND A.RA_PROFILE_ID=C.RA_PROFILE_ID

  • Related Language Record: RA_DLG_PROF_LVW

    • # 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
    4 RA_PROFILE_GROUP Character(3) VARCHAR2(3) NOT NULL Profile - Group
    IND=Individuals
    ORG=Organizations
    5 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
    6 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    7 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
    8 RA_ONE_OR_MANY Character(1) VARCHAR2(1) NOT NULL Profile - One or Many
    M=Many rows
    N=One row
    9 RA_PROFILE_RECNAME Character(15) VARCHAR2(15) NOT NULL Profile - record name
    10 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    11 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    12 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    13 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    14 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    15 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.
    16 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time