GPUS_PRENOT_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	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
6	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
7	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
8	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
9	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
10	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
11	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
12	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number
13	RECIPIENT_TAG	Number(3,0)	SMALLINT NOT NULL	Used to identify recipients for E/D, PI
14	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
15	GP_PMT_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount field on GP PAYMENT table
16	PAYMENT_MTHD	Character(1)	VARCHAR2(1) NOT NULL	Payment Method A=Cash C=Check O=Pay Primary Account Only P=Postal Order T=Bank Transfer U=Use Normal Distribution W=Wire Transfer
17	SRC_BANK_ID	Character(8)	VARCHAR2(8) NOT NULL	Source Bank ID
18	PMT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status field for a generated payment transaction F=Finalized M=Manually Paid N=No Active Allocations P=Prepared T=Payment Transferred V=Hold W=Void
19	CAL_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Calendar Period ID
20	PYMT_ID	Character(6)	VARCHAR2(6) NOT NULL	Payment Identification
21	PYMT_NBR	Number(18,0)	DECIMAL(18) NOT NULL	Payment Number
22	PYMT_DT	Date(10)	DATE	Payment Date
23	ACCOUNT_ID	Number(3,0)	SMALLINT NOT NULL	Account ID
24	STRM_NUM	Number(4,0)	SMALLINT NOT NULL	Stream Number
25	EMPLID_FROM	Character(11)	VARCHAR2(11) NOT NULL	EMPLID (first for a range)
26	EMPLID_TO	Character(11)	VARCHAR2(11) NOT NULL	EmplID To
27	PRD_END_DT	Date(10)	DATE	Pay Period End Date
28	COUNTER	Number(10,0)	DECIMAL(10) NOT NULL	Counter
29	RUN_FINAL_IND	Character(1)	VARCHAR2(1) NOT NULL	Finalize Entire Run
30	RUN_CALC_IND	Character(1)	VARCHAR2(1) NOT NULL	Calculate Payees
31	GPUS_PRENOTE_DATE	Date(10)	DATE	Prenotification Date
32	GPUS_PRENOTE_REQD	Character(1)	VARCHAR2(1) NOT NULL	Prenotification Required
33	GPUS_PRENOTE_STAT	Character(2)	VARCHAR2(2) NOT NULL	Prenotification Status 01=Completed 02=Not Submitted 03=Rejected 04=Submitted
34	PRENOTE_WAIT_DAYS	Number(3,0)	SMALLINT NOT NULL	Prenote Wait Days (U.S.)
35	GPUS_PRENOTE_ALLOW	Character(1)	VARCHAR2(1) NOT NULL	Prenote Allowed