PSIB_INFILE_AET

(SQL Table)
Index Back

State table

This is a state table used by the AE: PTIB_INFILE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 IB_REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
4 IB_FILE_ID Character(30) VARCHAR2(30) NOT NULL File Identifier
5 IB_FILE_INBOUND Character(254) VARCHAR2(254) NOT NULL Inbound File
6 IB_FILETYPE Character(1) VARCHAR2(1) NOT NULL File Type
1=Data File
2=Index File
7 IB_FILE_LAYOUT_ID Character(10) VARCHAR2(10) NOT NULL File Layout ID
8 IB_SEGSIZE Number(5,0) INTEGER NOT NULL Segment Size
9 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

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Prompt Table: PSPACKAGE_VW

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

Prompt Table: PSPACKAGPATH_VW

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

Prompt Table: PSPACKAGCLAS_VW

20 IB_TEMP_FLD Character(1) VARCHAR2(1) NOT NULL Temporary Field for App Engine
21 IB_END_TRANS_FLG Character(1) VARCHAR2(1) NOT NULL End transaction flag