PTAE_PLUG_APPLIDPTAE_PLUG_SECTIONPTAE_PLUG_STEPPTAE_ACT_STPP_V(SQL View) |
Index Back |
|---|
| SELECT DISTINCT AE_APPLID , AE_SECTION , AE_STEP FROM PSAESTMTDEFN WHERE AE_STMT_TYPE IN ('P', 'S') UNION SELECT AE_APPLID , AE_SECTION , '< ALL >' FROM PSAESTMTDEFN WHERE AE_STMT_TYPE IN ('P', 'S') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTAE_PLUG_APPLID |
Character(12) | VARCHAR2(12) NOT NULL | Program Name |
| 2 | PTAE_PLUG_SECTION |
Character(8) | VARCHAR2(8) NOT NULL | Section |
| 3 | PTAE_PLUG_STEP |
Character(8) | VARCHAR2(8) NOT NULL | Name |