JOB_SP_AET

#	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 Rcd Nbr
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
6	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
7	ACTION_DT	Date(10)	DATE	Action Date
8	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
9	JOB_ENTRY_DT	Date(10)	DATE	Job Entry Date
10	DEPT_ENTRY_DT	Date(10)	DATE	Department Entry Date
11	POSITION_ENTRY_DT	Date(10)	DATE	Position Entry Date
12	GRADE_ENTRY_DT	Date(10)	DATE	Grade Entry Date
13	STEP_ENTRY_DT	Date(10)	DATE	Step Entry Date
14	COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Rate
15	CHANGE_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Change Amount
16	CHANGE_PCT	Signed Number(8,3)	DECIMAL(6,3) NOT NULL	Change Percent
17	ANNUAL_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Annual Rate
18	MONTHLY_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Monthly Rate
19	DAILY_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Daily Rate
20	HOURLY_RT	Number(19,6)	DECIMAL(18,6) NOT NULL	Hourly Rate
21	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.
22	EXPECTED_END_DATE	Date(10)	DATE	Expected End Date of a job.
23	SALARY_PACKAGED	Character(1)	VARCHAR2(1) NOT NULL	Sal Package - Salary Packaged Flag
24	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