RUN_CNTL_XMLP

(SQL Table)
Index Back

PS/Financials XMLP Run Ctrl

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPRID_VW

2 REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 REQUEST_DEFN_ID Character(12) VARCHAR2(12) NOT NULL Used in the XMLP processes
5 REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL Report Name (see PSXPRPTDEFN).
6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
7 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once

Default Value: N

8 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
X=No Success

Default Value: N

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

Default Value: N

10 REF_RECNAME Character(15) VARCHAR2(15) NOT NULL PeopleCode Recname
11 ASOFDATE Date(10) DATE As of Date
12 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
13 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
14 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
15 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.