PSIBINFILERULE

index back

IB Inbound File Loader

Inbound file loader rules.

PeopleSoft Field NameField TypeColumn TypeDescription
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

Default: 1

IB_FILE_LAYOUT_IDCharacter(10)VARCHAR2(10) NOT NULLFile Layout ID
EFF_STATUSCharacter(1)VARCHAR2(1) NOT NULLEffective Status
A=Active
I=Inactive

Default: I

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

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

AE_APPLIDCharacter(12)VARCHAR2(12) NOT NULLProgram Name (see PSAEAPPLDEFN).

Prompt Table: PSAEAPPLDEFN

AE_SECTIONCharacter(8)VARCHAR2(8) NOT NULLSection

Prompt Table: PSAESECTDEFN

index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19