SSF_POIJOB1_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	RPT_ONLY	Character(1)	VARCHAR2(1) NOT NULL	Report Only N=No Y=Yes Default Value: N
6	SSF_PROCESS_EFFDT	Date(10)	DATE	Job Effective Date
7	SSF_PROC_POI_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Processing Population B=Refund Batch R=Refund Students S=Student List T=T4A Students
8	BATCH_ID	Character(12)	VARCHAR2(12) NOT NULL	Batch ID
9	SF_DATETIME	DateTime(26)	TIMESTAMP	SF DateTime Default Value: %DATETIME
10	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN). Default Value: SSF_POIJOB_A
11	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
12	BUSINESS_UNIT_HR	Character(5)	VARCHAR2(5) NOT NULL	Business Unit for HRMS
13	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
14	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
15	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
16	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
17	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
18	PAY_SYSTEM_FLG	Character(2)	VARCHAR2(2) NOT NULL	Payroll System GP=Global Payroll NA=Payroll for North America OT=Other PI=Payroll Interface
19	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
20	SSF_COMMIT_FREQ	Number(6,0)	INTEGER NOT NULL	Commit Frequency
21	SSF_CNFRM_JOBDATA	Character(1)	VARCHAR2(1) NOT NULL	Confirm Job Data Created
22	SSF_NBR_STU_PROC	Number(9,0)	DECIMAL(9) NOT NULL	Number of Students Processed
23	SSF_NBR_STU_SKIP	Number(9,0)	DECIMAL(9) NOT NULL	Number of Students Skipped