| # |
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 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 6 |
AE_STEP |
Character(8) |
VARCHAR2(8) NOT NULL |
Name
|
| 7 |
AE_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 8 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 9 |
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 Value: S
|
| 10 |
PROGRAM_NAME |
Character(8) |
VARCHAR2(8) NOT NULL |
Program Name
|
| 11 |
AE_ABEND_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
On False Return
A=Abort Application
B=Break
I=Ignore Error
S=Suppress Error
Default Value: A
|
| 12 |
AE_COMMIT_AFTER |
Character(1) |
VARCHAR2(1) NOT NULL |
Commit After
D=Default Action
N=Later
Y=After this Step
Default Value: D
|
| 13 |
AE_DO_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Do Section
Prompt Table:
AE_SECTION_VW
|
| 14 |
AE_SQL_UPDATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit SQL
Y/N Table Edit
Default Value: N
|
| 15 |
AE_SQL_SELECT |
Character(1) |
VARCHAR2(1) NOT NULL |
SELECT Present
Y/N Table Edit
Default Value: N
|
| 16 |
AE_DO_WHEN |
Character(1) |
VARCHAR2(1) NOT NULL |
When
Y/N Table Edit
Default Value: N
|
| 17 |
AE_DO_WHILE |
Character(1) |
VARCHAR2(1) NOT NULL |
While
Y/N Table Edit
Default Value: N
|
| 18 |
AE_DO_UNTIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Until
Y/N Table Edit
Default Value: N
|
| 19 |
AE_DO_SELECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit
Default Value: N
|
| 20 |
AE_SELECT_END_DO |
Character(1) |
VARCHAR2(1) NOT NULL |
Select ends the Do
Y/N Table Edit
Default Value: N
|
| 21 |
AE_DO_SELECT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Do Select
F=Select and Fetch
R=Re-Select
Default Value: F
|
| 22 |
MC_DEFN_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Mass Change Definition
Prompt Table:
MC_DEFN
|
| 23 |
AE_DO_PRODUCT |
Character(2) |
VARCHAR2(2) NOT NULL |
Do Product
|
| 24 |
AE_DO_APPLID |
Character(8) |
VARCHAR2(8) NOT NULL |
Do Application
|