| PeopleSoft Field Name |
Field Type |
Column Type |
Description |
 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
|
| AE_APPL_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Application
|
| AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 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
|
| EFFDT |
Date(10) |
DATE |
Effective Date
|
| AE_STEP |
Character(8) |
VARCHAR2(8) NOT NULL |
Name
|
| AE_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default: A
|
| AE_STEP_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Step Type
C=COBOL Program
D=Do Section
M=Mass Change
P=Peoplecode
S=SQL Statement
Default: S
|
| PROGRAM_NAME |
Character(8) |
VARCHAR2(8) NOT NULL |
Program Name
|
| AE_ABEND_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
On False Return
A=Abort Application
B=Break
I=Ignore Error
S=Suppress Error
Default: A
|
| AE_COMMIT_AFTER |
Character(1) |
VARCHAR2(1) NOT NULL |
Commit After
D=Default Action
N=Later
Y=After this Step
Default: D
|
| AE_DO_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Do Section
Prompt Table:
AE_SECTION_VW
|
| AE_SQL_UPDATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit SQL
Y/N Table Edit
Default: N
|
| AE_SQL_SELECT |
Character(1) |
VARCHAR2(1) NOT NULL |
SELECT Present
Y/N Table Edit
Default: N
|
| AE_DO_WHEN |
Character(1) |
VARCHAR2(1) NOT NULL |
When
Y/N Table Edit
Default: N
|
| AE_DO_WHILE |
Character(1) |
VARCHAR2(1) NOT NULL |
While
Y/N Table Edit
Default: N
|
| AE_DO_UNTIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Until
Y/N Table Edit
Default: N
|
| AE_DO_SELECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default: N
|
| AE_SELECT_END_DO |
Character(1) |
VARCHAR2(1) NOT NULL |
Select ends the Do
Y/N Table Edit
Default: N
|
| AE_DO_SELECT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Do Select
F=Select and Fetch
R=Re-Select
Default: F
|
| MC_DEFN_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Mass Change Definition
Prompt Table:
MC_DEFN
|
| AE_DO_PRODUCT |
Character(2) |
VARCHAR2(2) NOT NULL |
Do Product
Prompt Table:
AE_DO_PROD_VW
|
| AE_DO_APPLID |
Character(8) |
VARCHAR2(8) NOT NULL |
Do Application
Prompt Table:
AE_DO_APPL_VW
|