EO_BATLIB_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 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
3 JOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Job Instance
4 ACTIVE_FLG Character(1) VARCHAR2(1) NOT NULL Event Status
N=Inactive
Y=Active
5 ACTIVE Number(5,0) INTEGER NOT NULL Active
6 PROCESS_NAME Character(12) VARCHAR2(12) NOT NULL Process Name
7 MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
8 PUBLISH_RULE_ID Character(30) VARCHAR2(30) NOT NULL Publish Rule ID
9 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL This is a Temp field.
10 CHUNK_RULE_ID Character(30) VARCHAR2(30) NOT NULL Chunking Rule ID
11 CREATE_HDR_FLG Character(1) VARCHAR2(1) NOT NULL Create Message Header
12 CREATE_TRL_FLG Character(1) VARCHAR2(1) NOT NULL Create Message Trailer
13 END_TRANS_FLG Character(1) VARCHAR2(1) NOT NULL End of Transaction Flag
14 END_LANG_FLG Character(1) VARCHAR2(1) NOT NULL End of related language
15 SRCRECNAME Character(15) VARCHAR2(15) NOT NULL Source Record Name
16 MSGRECNAME Character(15) VARCHAR2(15) NOT NULL Message Record Name
17 BASE_LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
18 PUBLISH_BASE_LANG Character(1) VARCHAR2(1) NOT NULL Publish Base Language
19 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
20 FIELDVALUE Character(4) VARCHAR2(4) NOT NULL Field Value
21 RECNAME_CHUNK Character(15) VARCHAR2(15) NOT NULL Chunk Table
22 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
23 BATCH_CLEANUP_FLG Character(1) VARCHAR2(1) NOT NULL Batch Cleanup Flag
C=Clear Fields
D=Delete Rows Published
U=Update Rows Published
24 CREATE_FILE_FLG Character(1) VARCHAR2(1) NOT NULL Output Format
C=Flat File with Control Record
N=Message
Y=Flat File

Y/N Table Edit

Default Value: N

25 CREATE_DELAY_FLG Character(1) VARCHAR2(1) NOT NULL Create Delay Records
26 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
27 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
28 PUBLISH_TYPE Character(1) VARCHAR2(1) NOT NULL Publish Type
B=Batch Publish Rule
F=Full Table Publish Rule
29 PUBLISH_LANG_FLG Character(1) VARCHAR2(1) NOT NULL Publish All Related Languages