RA_PROF_UPD

(SQL Table)
 Index Back

Profile Changer Primary Table

Mass Profile Changer Primary Table for storing Profile Changer definition

  • Related Language Record: RA_PUPD_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RA_PUPD_ID Signed Number(32,0) DECIMAL(31) NOT NULL Manage Profile Update ID using for tracking mass profile changer ids
    2 RA_PUPD_NAME Character(80) VARCHAR2(80) NOT NULL Name of the Manage Profile Changer
    3 RA_PUPD_DESCR Character(254) VARCHAR2(254) NOT NULL Description field for Manager Profile Changer
    4 RA_PUPD_STATUS Character(3) VARCHAR2(3) NOT NULL Status of the current Manager Profile Changer
    010=In Design
    020=Queued
    030=Processing
    040=Completed
    050=Failed
    060=Aborted

    Default Value: 010

    5 RA_PUPD_ACTION Character(3) VARCHAR2(3) NOT NULL Action related to multo row profile for a particular Profile Changer defintion.
    010=Insert Row if Existing Row Not
    020=No Action if Existing Row Not

    Default Value: 010

    6 RA_PUPD_LOG Long Character CLOB Field for saving log generated by executing Profile Changer.
    7 RA_PROFILE_ID Number(18,0) DECIMAL(18) NOT NULL Profile - profile ID

    Prompt Table: RA_PUPD_PRFP_VW

    8 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_RB.SETID

    Prompt Table: SP_SETID_NONVW

    9 RA_LIST_ID Character(15) VARCHAR2(15) NOT NULL Audience ID

    Prompt Table: RA_PUPD_AUDP_VW
    Set Control Field: SETID

    10 RA_PUPD_SAVE_ACT Character(3) VARCHAR2(3) NOT NULL This field stores the execute profile update option - preview count, date or now.
    010=Preview Count
    020=Date
    030=Now

    Default Value: 010

    11 SCHED_GEN_DATE Date(10) DATE Audience - scheduled generation date
    12 SCHED_GEN_TIME Time(15) TIMESTAMP Audience - scheduled generation time
    13 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    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