EOAWNEM(SQL Table) |
Index Back |
|---|---|
Main record for NEMMain record for NEM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EOAWNEM_EVENT_ID |
Character(32) | VARCHAR2(32) NOT NULL | Event ID |
| 2 | EOAWNEM_ACTIVE | Character(1) | VARCHAR2(1) NOT NULL |
Active
0=Inactive 1=Active Default Value: 1 |
| 3 | EOAWNEM_EVENT_TYPE | Character(32) | VARCHAR2(32) NOT NULL |
Event Type
Prompt Table: EOAWNEM_EVENTS |
| 4 | EOAWNEM_EVALTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Evaluation Type
1=SQL View 2=Query Object 3=PeopleCode |
| 5 | EOAWNEM_EVAL_PKG | Character(32) | VARCHAR2(32) NOT NULL |
Evaluation Package Name
Prompt Table: EOAWNEM_EPKG_VW |
| 6 | EOAWNEM_EVAL_CLS | Character(32) | VARCHAR2(32) NOT NULL |
Evaluation Class Name
Prompt Table: EOAWNEM_ECLS_VW |
| 7 | EOAWNEM_SQL_VIEW | Character(32) | VARCHAR2(32) NOT NULL |
SQL View Name
Prompt Table: EOAWNEM_VIEWS |
| 8 | EOAWNEM_QUERY_OBJ | Character(32) | VARCHAR2(32) NOT NULL |
Query Object Name
Prompt Table: QRY_NAME_VW |
| 9 | EOAWNEM_ACTIONTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Action Type
0=Email Notification 1=PeopleCode |
| 10 | EOAWNEM_ACTN_PKG | Character(32) | VARCHAR2(32) NOT NULL |
Action Package Name
Prompt Table: EOAWNEM_APKG_VW |
| 11 | EOAWNEM_ACTN_CLS | Character(32) | VARCHAR2(32) NOT NULL |
Action Class
Prompt Table: EOAWNEM_ACLS_VW |
| 12 | EOAWNEM_REPEATTIME | Number(5,0) | INTEGER NOT NULL | Repeat Time |
| 13 | EOAWNEM_RECURRENCE | Number(5,0) | INTEGER NOT NULL | Repeat Recurrence |
| 14 | EOAWNEM_TIME_UNIT | Character(1) | VARCHAR2(1) NOT NULL |
Display Recurrence Time on NEM Setup Page
1=Hours 2=Minutes 3=Seconds |