RA_TASK_SHELL

(SQL Table)
 Index Back

Marketing Tasks

Holds all the Tasks for the Marketing

  • Related Language Record: RA_TSK_SHL_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RA_TASK_SHELL_ID Number(15,0) DECIMAL(15) NOT NULL Marketing - Task Shell ID
    2 RA_TASK_SHELL_TYPE Character(4) VARCHAR2(4) NOT NULL created for MArketing Task shell type
    CAMP=Campaign
    CONT=Collateral
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    5 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

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

    Prompt Table: RA_UD_TASK_TYPE
    Set Control Field: BUSINESS_UNIT

    7 RA_PRIORITY Character(1) VARCHAR2(1) NOT NULL Marketing - campaign wave content task priority
    1=High Priority
    2=Medium Priority
    3=Low Priority
    8 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.
    9 RA_PCT_COMPLETE Character(3) VARCHAR2(3) NOT NULL Marketing - Task - Percent Complete
    10 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    11 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    12 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    13 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    14 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.
    15 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
    16 BO_ID_OWNER Number(31,0) DECIMAL(31) NOT NULL Financial Account Business Object ID
    17 BO_ROLE_TYPE_ID_1 Number(12,0) DECIMAL(12) NOT NULL BO_ROLE_TYPE_ID_1
    18 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

    Prompt Table: RA_TEAM_TASK_VW

    19 BO_ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL BO_ROLE_TYPE_ID
    20 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive