PTAFNEM(SQL Table) |
Index Back |
|---|---|
Main record for NEMMain record for NEM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PTAFNEM_EVENT_ID |
Character(32) | VARCHAR2(32) NOT NULL | Event ID |
| 2 | PTAFNEM_ACTIVE | Character(1) | VARCHAR2(1) NOT NULL |
Active
0=Inactive 1=Active Default Value: 1 |
| 3 | PTAFNEM_EVENT_TYPE | Character(32) | VARCHAR2(32) NOT NULL |
Event Type
Prompt Table: PTAFNEM_EVENTS |
| 4 | PTAFNEM_EVALTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Evaluation Type
1=SQL View 2=Query Object 3=PeopleCode |
| 5 | PTAFNEM_EVAL_PKG | Character(32) | VARCHAR2(32) NOT NULL |
Evaluation Package Name
Prompt Table: PTAFNEM_EPKG_VW |
| 6 | PTAFNEM_EVAL_CLS | Character(32) | VARCHAR2(32) NOT NULL |
Evaluation Class Name
Prompt Table: PTAFNEM_ECLS_VW |
| 7 | PTAFNEM_SQL_VIEW | Character(32) | VARCHAR2(32) NOT NULL |
SQL View Name
Prompt Table: PTAFNEM_VIEWS |
| 8 | PTAFNEM_QUERY_OBJ | Character(32) | VARCHAR2(32) NOT NULL |
Query Object Name
Prompt Table: QRY_NAME_VW |
| 9 | PTAFNEM_ACTIONTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Action Type
0=Email Notification 1=PeopleCode |
| 10 | PTAFNEM_ACTN_PKG | Character(32) | VARCHAR2(32) NOT NULL |
Action Package Name
Prompt Table: PTAFNEM_APKG_VW |
| 11 | PTAFNEM_ACTN_CLS | Character(32) | VARCHAR2(32) NOT NULL |
Action Class
Prompt Table: PTAFNEM_ACLS_VW |
| 12 | PTAFNEM_REPEATTIME | Number(5,0) | INTEGER NOT NULL | Repeat Time |
| 13 | PTAFNEM_RECURRENCE | Number(5,0) | INTEGER NOT NULL | Repeat Recurrence |
| 14 | PTAFNEM_TIME_UNIT | Character(1) | VARCHAR2(1) NOT NULL |
Display Recurrence Time on NEM Setup Page
1=Hours 2=Minutes 3=Seconds |