AE_APPLIDRECNAMEFIELDNAMEGP_DIAG_AET_VW(SQL View) |
Index Back |
|---|---|
AET record and fieldsView of AET record and fields by AE APPLID. Used in GP diagnostics |
| SELECT A.AE_APPLID , R.RECNAME , R.FIELDNAME FROM PSRECFIELD R , PSAEAPPLSTATE A WHERE A.AE_STATE_RECNAME=R.RECNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AE_APPLID |
Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 2 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 3 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |