SAC_EWN_REG_BU(SQL Table) |
Index Back |
---|---|
EWN BU Level RegistryEWN BU Level Registry |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(30) | VARCHAR2(30) NOT NULL |
EWN Process Name
Prompt Table: SAC_EWN_PRCS_VW |
|
2 | Character(30) | VARCHAR2(30) NOT NULL |
EWN Category
Prompt Table: SAC_EWN_REG |
|
3 | 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 |