PTAFNEM

index back

Main record for NEM

Main record for NEM

PeopleSoft Field NameField TypeColumn TypeDescription
PTAFNEM_EVENT_IDCharacter(32)VARCHAR2(32) NOT NULLEvent ID
PTAFNEM_ACTIVECharacter(1)VARCHAR2(1) NOT NULLActive
0=Inactive
1=Active

Default: 1

PTAFNEM_EVENT_TYPECharacter(32)VARCHAR2(32) NOT NULLEvent Type

Prompt Table: PTAFNEM_EVENTS

PTAFNEM_EVALTYPECharacter(1)VARCHAR2(1) NOT NULLEvaluation Type
1=SQL View
2=Query Object
3=PeopleCode
PTAFNEM_EVAL_PKGCharacter(32)VARCHAR2(32) NOT NULLEvaluation Package Name

Prompt Table: PTAFNEM_EPKG_VW

PTAFNEM_EVAL_CLSCharacter(32)VARCHAR2(32) NOT NULLEvaluation Class Name

Prompt Table: PTAFNEM_ECLS_VW

PTAFNEM_SQL_VIEWCharacter(32)VARCHAR2(32) NOT NULLSQL View Name

Prompt Table: PTAFNEM_VIEWS

PTAFNEM_QUERY_OBJCharacter(32)VARCHAR2(32) NOT NULLQuery Object Name

Prompt Table: QRY_NAME_VW

PTAFNEM_ACTIONTYPECharacter(1)VARCHAR2(1) NOT NULLAction Type
0=Email Notification
1=PeopleCode
PTAFNEM_ACTN_PKGCharacter(32)VARCHAR2(32) NOT NULLAction Package Name

Prompt Table: PTAFNEM_APKG_VW

PTAFNEM_ACTN_CLSCharacter(32)VARCHAR2(32) NOT NULLAction Class

Prompt Table: PTAFNEM_ACLS_VW

PTAFNEM_REPEATTIMENumber(5,0)INTEGER NOT NULLRepeat Time
PTAFNEM_RECURRENCENumber(5,0)INTEGER NOT NULLRepeat Recurrence
PTAFNEM_TIME_UNITCharacter(1)VARCHAR2(1) NOT NULLDisplay Recurrence Time on NEM Setup Page
1=Hours
2=Minutes
3=Seconds
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19