SAC_EWN_REG_SYS(SQL Table) |
Index Back |
---|---|
EWN System Level RegistryEWN System Level Registry |
# | 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 | EWN_PRCS_ACTIVE | Character(1) | VARCHAR2(1) NOT NULL |
EWN Process Status Flag
Y/N Table Edit Default Value: Y |
4 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN_VW |
5 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table: PSROLEDEFN |
6 | EWN_NOTIFY_WRKLIST | Character(1) | VARCHAR2(1) NOT NULL |
EWN WL Notify Flag
Y/N Table Edit Default Value: Y |
7 | EWN_NOTIFY_EMAIL | Character(1) | VARCHAR2(1) NOT NULL |
EWN Email Notify Flag
Y/N Table Edit Default Value: Y |
8 | EWN_NOTIFY_APPMSG | Character(1) | VARCHAR2(1) NOT NULL |
EWN AppMsg Notify active
Y/N Table Edit Default Value: Y |
9 | NODE_NAME | Character(40) | VARCHAR2(40) NOT NULL |
Node Name
Prompt Table: PSNODEDEFNVW |