PSIB_INFILE_AET

index back

State table

This is a state table used by the AE: PTIB_INFILE

PeopleSoft Field NameField TypeColumn TypeDescription
PROCESS_INSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
RUN_CNTL_IDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
IB_REQUEST_IDCharacter(10)VARCHAR2(10) NOT NULLRequest ID
IB_FILE_IDCharacter(30)VARCHAR2(30) NOT NULLFile Identifier
IB_FILE_INBOUNDCharacter(254)VARCHAR2(254) NOT NULLInbound File
IB_FILETYPECharacter(1)VARCHAR2(1) NOT NULLFile Type
1=Data File
2=Index File
IB_FILE_LAYOUT_IDCharacter(10)VARCHAR2(10) NOT NULLFile Layout ID
IB_SEGSIZENumber(5,0)INTEGER NOT NULLSegment Size
PUBNODECharacter(30)VARCHAR2(30) NOT NULLApplication Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.

Prompt Table: PSPUBNODE_VW

FLDDEFNNAMECharacter(30)VARCHAR2(30) NOT NULLDefinition Name (see PSFLDDEFN).
SEQ_NBRNumber(15,0)DECIMAL(15) NOT NULLSequence Number
PROCESS_FREQUENCYCharacter(1)VARCHAR2(1) NOT NULLProcess Frequency
A=Always Process
N=Don't Run
O=Process Once
AE_APPLIDCharacter(12)VARCHAR2(12) NOT NULLProgram Name (see PSAEAPPLDEFN).
AE_SECTIONCharacter(8)VARCHAR2(8) NOT NULLSection
IB_CREATE_HDR_FLGCharacter(1)VARCHAR2(1) NOT NULLCreate Message Header

Y/N Table Edit

Default: N

IB_CREATE_TRL_FLGCharacter(1)VARCHAR2(1) NOT NULLCreate Message Trailer

Y/N Table Edit

Default: N

PACKAGEROOTCharacter(30)VARCHAR2(30) NOT NULLRoot Package ID

Prompt Table: PSPACKAGE_VW

QUALIFYPATHCharacter(127)VARCHAR2(127) NOT NULLQualified Package/Class Path

Prompt Table: PSPACKAGPATH_VW

APPCLASSIDCharacter(30)VARCHAR2(30) NOT NULLApplication Class ID

Prompt Table: PSPACKAGCLAS_VW

IB_TEMP_FLDCharacter(1)VARCHAR2(1) NOT NULLTemporary Field for App Engine
IB_END_TRANS_FLGCharacter(1)VARCHAR2(1) NOT NULLEnd transaction flag
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19