PV_ACTIONS

(SQL Table)
Index Back

Role Actions

8/30/07 - JK - Added Record Description.

  • Related Language Record: PV_ACTIONS_LANG
  • Parent Record Of PV_ACT_ROLE_VW PV_BU_ACTION PV_ROLE_ACTION PV_ROLE_ACTN_V PV_ROLE_ACTN_V2 UPG_PV_ROLE_TMP
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PV_ACTION Character(60) VARCHAR2(60) NOT NULL Action Name
    2 DESCRLONG Long Character CLOB Long Description
    3 PV_TRANSACTION Character(3) VARCHAR2(3) NOT NULL Transaction
    ADM=Administration
    BYR=Buyer Center
    CMN=Common Actions
    EXP=Expense
    INV=Invoice
    PRG=Progress Log
    RCV=Receiving
    REQ=Requisition
    SUP=Supplier Administration
    SWO=Work Order
    TIM=Timesheet
    WKL=Workflow
    4 PV_ACT_CATEGORY_CD Character(6) VARCHAR2(6) NOT NULL Category Code

    Prompt Table: PV_ACT_CAT_VW

    5 PV_OBJECTTYPE Character(2) VARCHAR2(2) NOT NULL Object Type
    B=Buttons
    D=Data
    D2=Data
    F1=Fields
    F2=Fields
    H=Hyperlinks
    I1=Icon and Hyperlink
    IP=Initial Page
    P1=Page
    P2=Page
    S1=Sections
    S2=Sections
    6 PV_ACT_CONTROL Character(4) VARCHAR2(4) NOT NULL Action Controls
    100=CATALOG
    1000=EXTERNAL CATALOGS
    200=EXPRESS REQUISITION
    2000=TEMPLATES
    300=SPECIAL REQUEST
    400=FAVORITES
    500=WEB
    600=FORMS
    700=ePro SERVICES
    701=Fixed Cost Service
    702=Variable Cost Service
    703=Time and Materials
    800=SERVICE REQUEST
    900=RECENTLY ORDERED
    A=Enabled
    C=Catalog Item Only
    D=Disabled
    E=Editable
    H=Hide
    V=Display Only
    7 PV_REQUESTER_FLG Character(1) VARCHAR2(1) NOT NULL Requester Role Action

    Default Value: N

    8 PV_FORM_NAME Character(18) VARCHAR2(18) NOT NULL Form Name
    9 PV_ACT_TYPE Character(1) VARCHAR2(1) NOT NULL Action type defined as eProcurement or sProcurement or both
    B=ePro&sPro
    E=ePro Only
    S=sPro Only

    Default Value: E