AE_APPLIDPTAE_SECTIONPrompt Table:
PTAE_ADL_SCT_VW
Set Control Field: AE_APPLID
PTAE_STEPPrompt Table:
PTAE_ADL_STP_VW
Set Control Field: PTAE_SECTION
P=PeopleCode
S=SQL
Y/N Table Edit
PSAESTEPSUI_VW(SQL View) |
Index Back |
|---|---|
PSAESTEPSUI_VWA View for UI dropdown box display, using the promote table, promote to PSAESTEPSVW. |
| SELECT d.AE_APPLID , d.AE_SECTION , d.AE_STEP , m.AE_STMT_TYPE , d.PTAE_LOGGING_SQL FROM PSAESTEPDEFN d, PSAESTMTDEFN m WHERE d.AE_APPLID= m.AE_APPLID AND d.AE_SECTION= m.AE_SECTION AND d.AE_STEP= m.AE_STEP AND m.AE_STMT_TYPE = 'S' AND d.PTAE_LOGGING_SQL = 'Y' |
| # | 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_ADL_SCT_VW
|
| 3 | PTAE_STEP |
Character(8) | VARCHAR2(8) NOT NULL |
Name
Prompt Table:
PTAE_ADL_STP_VW
|
| 4 | PTAE_ACTION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type
P=PeopleCode S=SQL |
| 5 | PTAE_LOGGING_SQL | Character(1) | VARCHAR2(1) NOT NULL |
Y/N Table Edit |