PTAFNEM

(SQL Table)
Index Back

Main record for NEM

Main 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