W1099_JOB_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Request ID
3	PROCESS_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Process Frequency A=Always Process N=Don't Run O=Process Once
4	WTHD_RPT_ID	Character(10)	VARCHAR2(10) NOT NULL	Withholding Report ID
5	CALENDAR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Calendar SetID
6	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID
7	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
8	PERIOD	Number(3,0)	SMALLINT NOT NULL	Period
9	FROM_DT	Date(10)	DATE	From Date
10	THRU_DATE	Date(10)	DATE	Through Date
11	RPT_DT	Date(10)	DATE	Report Date
12	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
13	WTHD_CNTL_ID	Character(10)	VARCHAR2(10) NOT NULL	Control ID
14	MANUAL_CHANGE_SW	Character(1)	VARCHAR2(1) NOT NULL	Include withholding manual adjustments/overrides
15	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
16	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
17	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
18	PROCESSINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
19	PRCSTYPE	Character(30)	VARCHAR2(30) NOT NULL	Process Type
20	PRCSNAME	Character(12)	VARCHAR2(12) NOT NULL	Process Name
21	SERVERNAME	Character(8)	VARCHAR2(8) NOT NULL	Server Name
22	DTTM_STAMP_SEC	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
23	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
24	SELECT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Selection Flag N=No Y=Yes
25	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
26	MAX_WAIT_TIME	Number(9,0)	DECIMAL(9) NOT NULL	Maximum Wait Time (Minutes)