AE_DO_PRODUCTAE_DO_APPLIDAE_DO_APPL_VW(SQL View) |
Index Back |
|---|---|
AE Appl ID view |
| SELECT DISTINCT A.AE_PRODUCT, A.AE_APPL_ID, A.DESCR FROM PS_AE_SECTION_TBL S, PS_AE_APPL_TBL A WHERE S.AE_PRODUCT = A.AE_PRODUCT AND S.AE_APPL_ID = A.AE_APPL_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AE_DO_PRODUCT |
Character(2) | VARCHAR2(2) NOT NULL | Do Product |
| 2 | AE_DO_APPLID |
Character(8) | VARCHAR2(8) NOT NULL | Do Application |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |