PSIBINFILERULE

index back

IB Inbound File Loader

Inbound file loader rules.

PeopleSoft Field Name Field Type Column Type Description
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

Default: 1

IB_FILE_LAYOUT_ID Character(10) VARCHAR2(10) NOT NULL File Layout ID
EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default: I

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

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

Prompt Table: PSPACKAGPATH_VW

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

Prompt Table: PSPACKAGCLAS_VW

AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).

Prompt Table: PSAEAPPLDEFN

AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section

Prompt Table: PSAESECTDEFN

index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20