RA_CONTENT_TASK

(SQL Table)
 Index Back

Marketing Content Tasks

Marketing Content Tasks, used to define contents used in marketing campaigns

  • Parent record: RA_CONTENT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    2 RA_CONTENT_ID Character(15) VARCHAR2(15) NOT NULL Marketing - Content ID
    3 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    6 RA_TASK_STATUS Character(4) VARCHAR2(4) NOT NULL Status of the task
    ASGN=Assigned
    CANC=Cancelled
    CMPL=Completed
    NEW=New task - not assigned
    OVER=Over Due
    REJD=Rejected

    Default Value: NEW

    7 RA_TASK_TYPE Character(4) VARCHAR2(4) NOT NULL Marketing - Task Type

    Prompt Table: RA_UD_TASK_TYPE

    8 RA_PRIORITY Character(1) VARCHAR2(1) NOT NULL Marketing - campaign wave content task priority
    1=High Priority
    2=Medium Priority
    3=Low Priority
    9 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
    10 START_DATE Date(10) DATE Start Date for Gen Standing PO

    Default Value: %date

    11 END_DATE Date(10) DATE End date field to store an end date.
    12 RA_PCT_COMPLETE Character(3) VARCHAR2(3) NOT NULL Marketing - Task - Percent Complete
    13 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    14 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    15 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    16 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    17 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.
    18 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
    19 BO_ID_OWNER Number(31,0) DECIMAL(31) NOT NULL Financial Account Business Object ID
    20 BO_ROLE_TYPE_ID_1 Number(12,0) DECIMAL(12) NOT NULL BO_ROLE_TYPE_ID_1
    21 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
    22 BO_ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL BO_ROLE_TYPE_ID