EO_AE_STEP_VW

(SQL View)
 Index Back

EO AE $ Section Step View


Select AE_PRODUCT , AE_APPL_ID , AE_SECTION , DB_PLATFORM , EFFDT , AE_STEP , AE_SEQ_NUM , EFF_STATUS , AE_STEP_TYPE , PROGRAM_NAME , AE_ABEND_ACTION , AE_COMMIT_AFTER , AE_DO_SECTION , AE_SQL_UPDATE , AE_SQL_SELECT , AE_DO_WHEN , AE_DO_WHILE , AE_DO_UNTIL , AE_DO_SELECT , AE_SELECT_END_DO , AE_DO_SELECT_TYPE , MC_DEFN_ID , AE_DO_PRODUCT , AE_DO_APPLID from PS_AE_STEP_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
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 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

Prompt Table: AE_DO_PROD_VW

24 AE_DO_APPLID Character(8) VARCHAR2(8) NOT NULL Do Application

Prompt Table: AE_DO_APPL_VW