EO_FILEPUB_AET

(SQL Table)
Index Back

Publish AE Cache Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUNCNTLID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 FILE_ID Character(30) VARCHAR2(30) NOT NULL File Identifier
5 FILE_INBOUND Character(127) VARCHAR2(127) NOT NULL Inbound File
6 INDEX_FILE_FLG Character(1) VARCHAR2(1) NOT NULL Index Flag
7 FILE_LAYOUT_ID Character(10) VARCHAR2(10) NOT NULL File Layout ID
8 LUW_PUB_SIZE Number(10,0) DECIMAL(10) NOT NULL LUW Publication Max Size
9 FLDDEFNNAME Character(30) VARCHAR2(30) NOT NULL Definition Name (see PSFLDDEFN).
10 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
11 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL This is a Temp field.
12 END_TRANS_FLG Character(1) VARCHAR2(1) NOT NULL End of Transaction Flag
13 FATAL_ERROR Character(1) VARCHAR2(1) NOT NULL Fatal Error
14 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once
15 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
16 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
17 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
18 CREATE_HDR_FLG Character(1) VARCHAR2(1) NOT NULL Create Message Header

Y/N Table Edit

Default Value: Y

19 CREATE_TRL_FLG Character(1) VARCHAR2(1) NOT NULL Create Message Trailer

Y/N Table Edit

Default Value: Y