FMSAUTOPILO_AET

(SQL Table)
Index Back

Financials Process Autopilot

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
5 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
6 RUN_CNTL_ID_SCHED Character(30) VARCHAR2(30) NOT NULL Resource Schedule Report ID
7 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
A=Active
I=Inactive
8 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
9 SERVERNAME Character(8) VARCHAR2(8) NOT NULL Server Name
10 MIN_WAIT_TIME Number(9,0) DECIMAL(9) NOT NULL Minimum Wait Time (Minutes)
11 MAX_WAIT_TIME Number(9,0) DECIMAL(9) NOT NULL Maximum Wait Time (Minutes)
12 MIN_TRANS_COUNT Number(9,0) DECIMAL(9) NOT NULL Minimum Transaction Count
13 MAX_TRANS_COUNT Number(9,0) DECIMAL(9) NOT NULL Maximum Transaction Count
14 LAST_PROC_DTTM DateTime(26) TIMESTAMP last processed datetime.