AP_PCJOB_STAT (SQL Table)	Index Back
PayCycle Job Status

AP_PCJOB_STAT

(SQL Table)

PayCycle Job Status

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PRCSJOBNAME Character(8) VARCHAR2(8) NOT NULL Process Job Name

2 PRCSJOBSEQ Number(5,0) INTEGER NOT NULL Process Job Item

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

4 RUNDTTM DateTime(26) TIMESTAMP Run Date/Time

5 JOB_STATUS Character(1) VARCHAR2(1) NOT NULL Job Status
C=Completed
D=Processed
F=No Success
N=New
P=Processing
R=Reset
S=Submitted

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

7 SERVERNAME Character(8) VARCHAR2(8) NOT NULL Server Name

8 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle

9 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number

10 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PRCSJOBNAME	Character(8)	VARCHAR2(8) NOT NULL	Process Job Name
2	PRCSJOBSEQ	Number(5,0)	INTEGER NOT NULL	Process Job Item
3	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
4	RUNDTTM	DateTime(26)	TIMESTAMP	Run Date/Time
5	JOB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Job Status C=Completed D=Processed F=No Success N=New P=Processing R=Reset S=Submitted
6	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
7	SERVERNAME	Character(8)	VARCHAR2(8) NOT NULL	Server Name
8	PAY_CYCLE	Character(6)	VARCHAR2(6) NOT NULL	Pay Cycle
9	PAY_CYCLE_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Pay Cycle Sequence Number
10	MESSAGE_TEXT	Character(100)	VARCHAR2(100) NOT NULL	Message Text This field refers to the Text for a particular Message Number in the Message Catalog.