index back

State table

This is a state table used by the AE: PTIB_INFILE

PeopleSoft Field Name Field Type Column Type Description
PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
IB_REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
IB_FILE_ID Character(30) VARCHAR2(30) NOT NULL File Identifier
IB_FILE_INBOUND Character(254) VARCHAR2(254) NOT NULL Inbound File
IB_FILETYPE Character(1) VARCHAR2(1) NOT NULL File Type
1=Data File
2=Index File
IB_FILE_LAYOUT_ID Character(10) VARCHAR2(10) NOT NULL File Layout ID
IB_SEGSIZE Number(5,0) INTEGER NOT NULL Segment Size
PUBNODE Character(30) VARCHAR2(30) NOT NULL Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.

Prompt Table: PSPUBNODE_VW

FLDDEFNNAME Character(30) VARCHAR2(30) NOT NULL Definition Name (see PSFLDDEFN).
SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once
AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
IB_CREATE_HDR_FLG Character(1) VARCHAR2(1) NOT NULL Create Message Header

Y/N Table Edit

Default: N

IB_CREATE_TRL_FLG Character(1) VARCHAR2(1) NOT NULL Create Message Trailer

Y/N Table Edit

Default: N

PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID

Prompt Table: PSPACKAGE_VW

QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path


APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID


IB_TEMP_FLD Character(1) VARCHAR2(1) NOT NULL Temporary Field for App Engine
IB_END_TRANS_FLG Character(1) VARCHAR2(1) NOT NULL End transaction flag
index back (c)David Kurtz 2020, PeopleTools 8.58
PTRef generated on 21-DEC-20