EO_EFFDTPUB_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 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL This is a Temp field.
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 RUNCNTLID Character(30) VARCHAR2(30) NOT NULL Run Control ID
5 FATAL_ERROR Character(1) VARCHAR2(1) NOT NULL Fatal Error
6 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once
7 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
8 MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
9 EFFDT_TO Date(10) DATE Effective Date To
10 EFFDT Date(10) DATE Effective Date

Default Value: %date

11 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
12 END_TRANS_FLG Character(1) VARCHAR2(1) NOT NULL End of Transaction Flag