EO_AE_SECTN_VW(SQL View) |
Index Back |
---|---|
EO AE $ Section View |
SELECT AE_PRODUCT , AE_APPL_ID , AE_SECTION , DB_PLATFORM , EFFDT , EFF_STATUS , DESCR , AE_STMT_CHUNK_SIZE , AE_AUTO_COMMIT , AE_SECTION_TYPE FROM PS_AE_SECTION_TBL WHERE AE_PRODUCT = 'EO' AND AE_APPL_ID = 'CURRENCY' and AE_SECTION IN ('$ALLKEYS', '$AUDIT' ,'$CNVFROM' ,'$CNVSL0' ,'$CNVSL1' ,'$CNVSL2' ,'$CNVSL3' ,'$CNVSL4' ,'$CNVSL5' ,'$CNVSL6' ,'$CNVSL7' ,'$CNVSL8' ,'$CNVSL9' ,'$CNVSL10' ,'$CNVSL11' ,'$CNVSL12' ,'$CNVSL13' ,'$CNVSL14' ,'$CNVSL15' ,'$CNVWHRE' ,'$CNVWH0' ,'$CNVWH1' ,'$CNVWH2' ,'$CNVWH3' ,'$CNVWH4' ,'$CNVWH5' ,'$CNVWH6' ,'$CNVWH7' ,'$CNVWH8' ,'$CNVWH9' ,'$CNVWH10' ,'$CNVWH11' ,'$CNVWH12' ,'$CNVWH13' ,'$CNVWH14' ,'$CNVWH15' ,'$COMP10A' ,'$COMP2A' ,'$COMP3A' ,'$COMP4A' ,'$COMP5A' ,'$COMP6A' ,'$COMP7A' ,'$COMP8A' ,'$COMP9A' ,'$EFFDTS1' ,'$EFFDTS2' ,'$EFFDTW1' ,'$EFFDTW2' ,'$EFFDTWO' ,'$FROM' ,'$GROUPBY' ,'$RCNFROM' ,'$RCNSLCT' ,'$RCNWHR' ,'$RECORD' ,'$SELECT1' ,'$WHERE1') AND DB_PLATFORM = ' ' AND EFFDT = %DATEIN('1900-01-01') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | 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 |
2 | AE_APPL_ID | Character(8) | VARCHAR2(8) NOT NULL | Application |
3 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
4 | 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 |
5 | AE_ASOF_EFFDT | Date(10) | DATE | Effdt Override |
6 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
8 | AE_STMT_CHUNK_SIZE | Number(3,0) | SMALLINT NOT NULL |
Statement Chunk Size
Default Value: 250 |
9 | AE_AUTO_COMMIT | Character(1) | VARCHAR2(1) NOT NULL |
Commit after each step
M=Auto Commit Conditionally N=No Auto commit Y=Commit after each STEP Y/N Table Edit Default Value: N |
10 | AE_SECTION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Section Type
C=Critical Database Updates P=Preparation Only Default Value: P |