PTAE_ACT_PLUGIN

index back

AE Action Plugin


PeopleSoft Field Name Field Type Column Type Description
AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
PTAE_SECTION Character(8) VARCHAR2(8) NOT NULL Section

Prompt Table: PTAE_ACT_SCT_VW
Set Control Field: AE_APPLID

PTAE_STEP Character(8) VARCHAR2(8) NOT NULL Name

Prompt Table: PTAE_ACT_STP_VW
Set Control Field: PTAE_SECTION

PTAE_ACTION_TYPE Character(1) VARCHAR2(1) NOT NULL Action Type
P=PeopleCode
S=SQL
SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number
PTAE_PLUG_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name

Prompt Table: PTAE_ACT_PLGXVW

PTAE_PLUG_SECTION Character(8) VARCHAR2(8) NOT NULL Section

Prompt Table: PTAE_ACT_SCTP_V
Set Control Field: PTAE_PLUG_APPLID

PTAE_PLUG_STEP Character(8) VARCHAR2(8) NOT NULL Name

Prompt Table: PTAE_ACT_STPP_V
Set Control Field: PTAE_PLUG_SECTION

PTAE_PLUG_ACTNTYPE Character(1) VARCHAR2(1) NOT NULL Action Type
P=PeopleCode
S=SQL
PTAE_PLUG_MODE Character(1) VARCHAR2(1) NOT NULL Plug Mode Type
A=After
B=Before
R=Replace
PTAE_MODE_SEQ Number(5,0) INTEGER NOT NULL Sequence Control
ENABLED Character(1) VARCHAR2(1) NOT NULL A flag indicates whether this row is enabled or not.

Y/N Table Edit

LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
DESCR Character(30) VARCHAR2(30) NOT NULL Description
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20