AE_APPL_VW(SQL View) |
Index Back |
|---|---|
AE Application View |
| select ae_section, descr, db_platform, effdt, ae_appl_id, ae_product, eff_status from PS_AE_SECTION_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  AE_SECTION |
Character(8) | VARCHAR2(8) NOT NULL | Section |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DB_PLATFORM |
Character(1) | VARCHAR2(1) NOT NULL |
Database Platform
0=DB2/MVS 1=SQLBase 2=Oracle 3=SQL Server 4=DB2/UNIX 5=Rdb 6=Informix 7=DB2/400 8=Sybase SQLServer 9=Microsoft SQLServer |
| 4 | EFFDT |
Date(10) | DATE | Effective Date |
| 5 | AE_APPL_ID |
Character(8) | VARCHAR2(8) NOT NULL |
Application
Prompt Table: AE_APPL_TBL |
| 6 | AE_PRODUCT |
Character(2) | VARCHAR2(2) NOT NULL |
Product
AE=PS/AE AM=PS/AM AP=PS/AP AR=PS/AR BI=PS/BI EO=PS/EO EX=PS/EX FS=PS/FS GL=PS/GL HR=PS/HR IN=PS/IN OM=PS/OM PC=PS/PC PO=PS/PO TR=PS/TR |
| 7 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |