PSIBFILERUNCNTL (SQL Table)	Index Back
Inbound File Loader Run Cntrl Run control information for the inbound file loader application engine program.

PSIBFILERUNCNTL

(SQL Table)

Inbound File Loader Run Cntrl

Run control information for the inbound file loader application engine program.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

2 IB_REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID

3 REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number

4 IB_FILE_ID Character(30) VARCHAR2(30) NOT NULL File Identifier
Prompt Table: PSIBINFILERULE

5 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once

6 PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now

7 PROCESS_ORIG Character(1) VARCHAR2(1) NOT NULL Process Origin
N=Other Source
P=Process Scheduler

8 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

9 DTTM_STAMP_SEC DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
2	IB_REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Request ID
3	REQUEST_NBR	Number(4,0)	SMALLINT NOT NULL	Request Number
4	IB_FILE_ID	Character(30)	VARCHAR2(30) NOT NULL	File Identifier Prompt Table: PSIBINFILERULE
5	PROCESS_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Process Frequency A=Always Process N=Don't Run O=Process Once
6	PROCESS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Process Status A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now
7	PROCESS_ORIG	Character(1)	VARCHAR2(1) NOT NULL	Process Origin N=Other Source P=Process Scheduler
8	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
9	DTTM_STAMP_SEC	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.