PTIAAURUNCNTL (SQL Table)	Index Back
Run Control

PTIAAURUNCNTL

(SQL Table)

Run Control

# 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: OPERATOR_VW

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

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 LANGUAGE_OPTION Character(1) VARCHAR2(1) NOT NULL Language Option
O=Specified Language
R=Recipient's Language
Default Value: O

5 RECURNAME Character(30) VARCHAR2(30) NOT NULL Recurrence Name

6 RUNDATE Date(10) DATE Process Scheduler Run Date

7 RUNTIME Time(15) TIMESTAMP Process Scheduler Process Run Time

8 PTIAAUJOBDATA Long Character CLOB Job Data

9 PTIAAUJOBRUNMODE Character(1) VARCHAR2(1) NOT NULL Run Mode
A=Ad hoc
S=Scheduled

10 PTIAAURESUMEFLG Character(4) VARCHAR2(4) NOT NULL Resume
CC=COMPLETECONTINUE
NEW=NEW
RC=RESTARTCONTINUE
RT=RETRY
RTRC=READYTORUNCONTINUE
WR=WARNINGREVIEWED
Default Value: N

11 PTIAAUJOBID Character(100) VARCHAR2(100) NOT NULL Job ID

12 LASTUPDDTTM 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	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: OPERATOR_VW
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	LANGUAGE_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Language Option O=Specified Language R=Recipient's Language Default Value: O
5	RECURNAME	Character(30)	VARCHAR2(30) NOT NULL	Recurrence Name
6	RUNDATE	Date(10)	DATE	Process Scheduler Run Date
7	RUNTIME	Time(15)	TIMESTAMP	Process Scheduler Process Run Time
8	PTIAAUJOBDATA	Long Character	CLOB	Job Data
9	PTIAAUJOBRUNMODE	Character(1)	VARCHAR2(1) NOT NULL	Run Mode A=Ad hoc S=Scheduled
10	PTIAAURESUMEFLG	Character(4)	VARCHAR2(4) NOT NULL	Resume CC=COMPLETECONTINUE NEW=NEW RC=RESTARTCONTINUE RT=RETRY RTRC=READYTORUNCONTINUE WR=WARNINGREVIEWED Default Value: N
11	PTIAAUJOBID	Character(100)	VARCHAR2(100) NOT NULL	Job ID
12	LASTUPDDTTM	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.