BPW_TASK_TBL

(SQL Table)
 Index Back

  • Related Language Record: BPW_TASK_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BPW_TASK_ID Character(30) VARCHAR2(30) NOT NULL Task ID
    2 BPW_DESCR Character(80) VARCHAR2(80) NOT NULL Description
    3 BPW_TASK_TYPE Character(4) VARCHAR2(4) NOT NULL Task Type
    APPC=App Class
    JOB=Job
    PROC=Process

    Default Value: PROC

    4 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type

    Prompt Table: BPW_PRCSTYPE_VW

    5 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name

    Prompt Table: PRCSDEFN

    6 PRCSJOBNAME Character(8) VARCHAR2(8) NOT NULL Process Job Name

    Prompt Table: PRCSJOBDEFN

    7 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

    Prompt Table: PSMENUDEFN

    8 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name

    Prompt Table: PRCSBARNAME_VW

    9 ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name

    Prompt Table: PSMENUITEM_VW2

    10 ITEMPANELNAME Character(30) VARCHAR2(30) NOT NULL Panel Name

    Prompt Table: BPW_MENUPNL_VW

    11 MENU_ACTION Character(1) VARCHAR2(1) NOT NULL Menu Action
    A=Add
    C=Correction
    E=Data Entry
    L=Update/Display All
    U=Update

    Default Value: U

    12 BPW_RC_PRMPT_REC Character(15) VARCHAR2(15) NOT NULL Run Control Prompt Record

    Prompt Table: PSRECDEFN

    13 BPW_RC_REQUIRE_FLG Character(1) VARCHAR2(1) NOT NULL Run Control Required

    Y/N Table Edit

    Default Value: Y

    14 BPW_TASK_HDLR_ID Character(30) VARCHAR2(30) NOT NULL Task Handler ID

    Prompt Table: BPW_AC_TASK_VW

    15 BPW_TASK_HDLR_PARM Character(254) VARCHAR2(254) NOT NULL Task Handler Parameter
    16 BPW_EVNT_HDLR_ID Character(30) VARCHAR2(30) NOT NULL Event Handler ID

    Prompt Table: BPW_AC_EVNT_VW

    17 BPW_EVNT_HDLR_PARM Character(254) VARCHAR2(254) NOT NULL Event Handler Parameter
    18 OUTDESTTYPE Character(3) VARCHAR2(3) NOT NULL Process Request output destination type.
    0=Any
    1=(None)
    2=File
    3=Printer
    4=Window
    5=Email
    6=Web
    7=Default
    8=Feed
    9=IB Node
    19 OUTDESTFORMAT Character(3) VARCHAR2(3) NOT NULL Process Request output format
    0=Any
    1=(None)
    10=Postscript (*.lis)
    11=Crystal Report (*.rpt)
    12=Rich Text File (*.rtf)
    13=SQR Portable Format (*.spf)
    14=Text Files (*.txt)
    15=Other
    16=Default
    17=XML Format(*.xml)
    18=Data Mover Data File (*.dat)
    19=Crystal Report Explorer(*.rpt)
    2=Acrobat (*.pdf)
    20=XMLP
    21=Atom
    22=Transformation
    23=Printer Command Lang. (*.pcl)
    24=PostScript (*.ps)
    3=Comma delimited (*.csv)
    4=HP Format (*.lis)
    5=HTML Documents (*.htm)
    6=Line Printer Format (*.lis)
    7=Lotus 1-2-3 Files (*.wks)
    8=Microsoft Excel Files (*.xls)
    9=Microsoft Word (*.doc)
    20 BPW_SYS_DEFN_FLG Character(1) VARCHAR2(1) NOT NULL System Defined

    Y/N Table Edit

    21 BPW_OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Additional valid values are from OBJECTOWNERID

    Prompt Table: BPW_OBJOWNID_VW

    22 BPW_TASK_ICON Character(250) VARCHAR2(250) NOT NULL Icon Name

    Prompt Table: PTPPB_IMGCAT_VW

    23 BPW_DATA_CHECK_REC Character(15) VARCHAR2(15) NOT NULL Data Check Record

    Prompt Table: BPW_DTCKREC_VW