PTAFNEM

index back

Main record for NEM

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 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19