PTAFNEM |
index back |
|---|---|
Main record for NEM |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
 PTAFNEM_EVENT_ID |
Character(32) | VARCHAR2(32) NOT NULL | Event ID |
| PTAFNEM_ACTIVE | Character(1) | VARCHAR2(1) NOT NULL |
Active
0=Inactive 1=Active Default: 1 |
| PTAFNEM_EVENT_TYPE | Character(32) | VARCHAR2(32) NOT NULL |
Event Type
Prompt Table: PTAFNEM_EVENTS |
| PTAFNEM_EVALTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Evaluation Type
1=SQL View 2=Query Object 3=PeopleCode |
| PTAFNEM_EVAL_PKG | Character(32) | VARCHAR2(32) NOT NULL |
Evaluation Package Name
Prompt Table: PTAFNEM_EPKG_VW |
| PTAFNEM_EVAL_CLS | Character(32) | VARCHAR2(32) NOT NULL |
Evaluation Class Name
Prompt Table: PTAFNEM_ECLS_VW |
| PTAFNEM_SQL_VIEW | Character(32) | VARCHAR2(32) NOT NULL |
SQL View Name
Prompt Table: PTAFNEM_VIEWS |
| PTAFNEM_QUERY_OBJ | Character(32) | VARCHAR2(32) NOT NULL |
Query Object Name
Prompt Table: QRY_NAME_VW |
| PTAFNEM_ACTIONTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Action Type
0=Email Notification 1=PeopleCode |
| PTAFNEM_ACTN_PKG | Character(32) | VARCHAR2(32) NOT NULL |
Action Package Name
Prompt Table: PTAFNEM_APKG_VW |
| PTAFNEM_ACTN_CLS | Character(32) | VARCHAR2(32) NOT NULL |
Action Class
Prompt Table: PTAFNEM_ACLS_VW |
| PTAFNEM_REPEATTIME | Number(5,0) | INTEGER NOT NULL | Repeat Time |
| PTAFNEM_RECURRENCE | Number(5,0) | INTEGER NOT NULL | Repeat Recurrence |
| PTAFNEM_TIME_UNIT | Character(1) | VARCHAR2(1) NOT NULL |
Display Recurrence Time on NEM Setup Page
1=Hours 2=Minutes 3=Seconds |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |