PTPRTNINSTTBL

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PTSCHDL_NAME Character(30) VARCHAR2(30) NOT NULL Partition Schedule

2 SCHDL_INSTANCE Signed Number(6,0) DECIMAL(5) NOT NULL Schedule Instance

3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

4 INSTCREATEDTTM DateTime(26) TIMESTAMP Created On

5 ARCHIVE_PRTN Character(1) VARCHAR2(1) NOT NULL Archive
Y/N Table Edit
Default Value: N

6 RUNSTATUS Character(2) VARCHAR2(2) NOT NULL Process Scheduler Process Run Status
1=Cancel
10=Not Successful
11=Posted
12=Unable to post
13=Resend
14=Posting
15=Content Generated
16=Pending
17=Success With Warning
18=Blocked
19=Restart
2=Delete
3=Error
4=Hold
5=Queued
6=Initiated
7=Processing
8=Cancelled
9=Success

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTSCHDL_NAME	Character(30)	VARCHAR2(30) NOT NULL	Partition Schedule
2	SCHDL_INSTANCE	Signed Number(6,0)	DECIMAL(5) NOT NULL	Schedule Instance
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	INSTCREATEDTTM	DateTime(26)	TIMESTAMP	Created On
5	ARCHIVE_PRTN	Character(1)	VARCHAR2(1) NOT NULL	Archive Y/N Table Edit Default Value: N
6	RUNSTATUS	Character(2)	VARCHAR2(2) NOT NULL	Process Scheduler Process Run Status 1=Cancel 10=Not Successful 11=Posted 12=Unable to post 13=Resend 14=Posting 15=Content Generated 16=Pending 17=Success With Warning 18=Blocked 19=Restart 2=Delete 3=Error 4=Hold 5=Queued 6=Initiated 7=Processing 8=Cancelled 9=Success