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 |