JOB_SP_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
6	ACTION_DT	Date(10)	DATE	Action Date
7	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
8	JOB_ENTRY_DT	Date(10)	DATE	Job Entry Date
9	DEPT_ENTRY_DT	Date(10)	DATE	Department Entry Date
10	POSITION_ENTRY_DT	Date(10)	DATE	Position Entry Date
11	GRADE_ENTRY_DT	Date(10)	DATE	Grade Entry Date
12	STEP_ENTRY_DT	Date(10)	DATE	Step Entry Date
13	COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Rate
14	CHANGE_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Change Amount
15	CHANGE_PCT	Signed Number(8,3)	DECIMAL(6,3) NOT NULL	Change Percent
16	ANNUAL_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Annual Rate
17	MONTHLY_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Monthly Rate
18	DAILY_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Daily Rate
19	HOURLY_RT	Number(19,6)	DECIMAL(18,6) NOT NULL	Hourly Rate
20	FORCE_PUBLISH	Date(10)	DATE	Used to Force a publish on a row of data that wouldn't otherwise have been changed. This field is a system field only and will not appear on any Page so it does not need to be translated.
21	EXPECTED_END_DATE	Date(10)	DATE	Expected End Date of a job.
22	SP_PROC_STAT	Character(1)	VARCHAR2(1) NOT NULL	Tracks the status of rows associated with a process. E=Error prevented processing N=Not Processed W=Row processed but check log Y=Processed