RA_CONTN_TSK_VW

(SQL View)
 Index Back

Content Task Shell View

Content Task Shell View---view that lists task shells for contents

SELECT A.RA_TASK_SHELL_ID , A.RA_TASK_SHELL_TYPE ,A.DESCR FROM PS_RA_TASK_SHELL A WHERE A.RA_TASK_SHELL_TYPE = 'CONT' AND A.STATUS = 'A'

  • Related Language Record: RA_CN_TSK_LN_VW

    • # 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