TEST2_AET

(SQL Table)
Index Back

Mail Reader Input

Spawning Type input for Mail Reader Process

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
4 LENGTH Number(5,0) INTEGER NOT NULL Length
5 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
6 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
7 AE_STEP Character(8) VARCHAR2(8) NOT NULL Name
8 MARKET Character(3) VARCHAR2(3) NOT NULL Market
9 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
10 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
11 SQLTEXT Long Character(14000) CLOB SQL Statement Text
12 SQLTABLENAME Character(18) VARCHAR2(18) NOT NULL SQL Table Name
13 PNLFIELDNAME Character(18) VARCHAR2(18) NOT NULL Panel Field Name
14 OCCURSLEVEL Number(1,0) SMALLINT NOT NULL Occurs level
15 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
16 LBLTEXT Character(60) VARCHAR2(60) NOT NULL Label Text
17 FIELDUSE Number(10,0) DECIMAL(10) NOT NULL Panel Field Use