SAC_EWN_REG_BU

(SQL Table)
Index Back

EWN BU Level Registry

EWN BU Level Registry

  • Parent record: SAC_EWN_REG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EWN_PRCS_NAME Character(30) VARCHAR2(30) NOT NULL EWN Process Name

    Prompt Table: SAC_EWN_PRCS_VW

    2 EWN_CATEGORY Character(30) VARCHAR2(30) NOT NULL EWN Category

    Prompt Table: SAC_EWN_REG

    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_FS_NONVW

    4 EWN_PRCS_ACTIVE Character(1) VARCHAR2(1) NOT NULL EWN Process Status Flag

    Y/N Table Edit

    Default Value: Y

    5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: PSOPRDEFN_VW

    6 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

    Prompt Table: PSROLEDEFN

    7 EWN_NOTIFY_WRKLIST Character(1) VARCHAR2(1) NOT NULL EWN WL Notify Flag

    Y/N Table Edit

    Default Value: Y

    8 EWN_NOTIFY_EMAIL Character(1) VARCHAR2(1) NOT NULL EWN Email Notify Flag

    Y/N Table Edit

    Default Value: Y

    9 EWN_NOTIFY_APPMSG Character(1) VARCHAR2(1) NOT NULL EWN AppMsg Notify active

    Y/N Table Edit

    Default Value: Y

    10 NODE_NAME Character(40) VARCHAR2(40) NOT NULL Node Name

    Prompt Table: PSNODEDEFNVW