PTAE_ACT_PLUGIN(SQL Table) |
Index Back |
|---|---|
AE Action Plugin |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  AE_APPLID |
Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 2 | PTAE_SECTION |
Character(8) | VARCHAR2(8) NOT NULL |
Section
Prompt Table:
PTAE_ACT_SCT_VW
|
| 3 | PTAE_STEP |
Character(8) | VARCHAR2(8) NOT NULL |
Name
Prompt Table:
PTAE_ACT_STP_VW
|
| 4 | PTAE_ACTION_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Action Type
C=Call Section P=PeopleCode S=SQL |
| 5 | SEQNBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 6 | PTAE_PLUG_APPLID | Character(12) | VARCHAR2(12) NOT NULL |
Program Name
Prompt Table: PTAE_ACT_PLGXVW |
| 7 | PTAE_PLUG_SECTION | Character(8) | VARCHAR2(8) NOT NULL |
Section
Prompt Table:
PTAE_ACT_SCTP_V
|
| 8 | PTAE_PLUG_STEP | Character(8) | VARCHAR2(8) NOT NULL |
Name
Prompt Table:
PTAE_ACT_STPP_V
|
| 9 | PTAE_PLUG_ACTNTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Action Type
P=PeopleCode S=SQL |
| 10 | PTAE_PLUG_MODE |
Character(1) | VARCHAR2(1) NOT NULL |
Plug Mode Type
A=After B=Before R=Replace |
| 11 | PTAE_MODE_SEQ |
Number(5,0) | INTEGER NOT NULL | Sequence Control |
| 12 | ENABLED | Character(1) | VARCHAR2(1) NOT NULL |
A flag indicates whether this row is enabled or not.
Y/N Table Edit |
| 13 | 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. |
| 14 | 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. |
| 15 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |