GP_PMT_COMB_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	STRM_NUM	Number(4,0)	SMALLINT NOT NULL	Stream Number
6	EMPLID_FROM	Character(11)	VARCHAR2(11) NOT NULL	EMPLID (first for a range)
7	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
8	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
9	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
10	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
11	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
12	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
13	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
14	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number
15	RECIPIENT_TAG	Number(3,0)	SMALLINT NOT NULL	Used to identify recipients for E/D, PI
16	EMPLID_TO	Character(11)	VARCHAR2(11) NOT NULL	EmplID To
17	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
18	PYMT_DT	Date(10)	DATE	Payment Date
19	PRD_END_DT	Date(10)	DATE	Pay Period End Date
20	CAL_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Calendar Period ID
21	COMBINE_SEG	Character(1)	VARCHAR2(1) NOT NULL	Field used to determine if segments should be combined for Banking and Payslips.
22	COMBINE_MULTIJOBS	Character(1)	VARCHAR2(1) NOT NULL	Combine Multiple Jobs
23	COMBINE_DATE_OPT	Character(1)	VARCHAR2(1) NOT NULL	Field used to identify if dates are to be used to determine which payslips should be combined. A=Period End Date B=Payment Date
24	COUNT_1	Number(3,0)	SMALLINT NOT NULL	Count Work Field
25	COUNT_6	Number(3,0)	SMALLINT NOT NULL	Count
26	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
27	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
28	EMPLID_OLD	Character(11)	VARCHAR2(11) NOT NULL	Previous Employee ID
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	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
32	SRC_BANK_ID	Character(8)	VARCHAR2(8) NOT NULL	Source Bank ID
33	PYMT_ID	Character(6)	VARCHAR2(6) NOT NULL	Payment Identification
34	PMT_GRP_ID	Number(3,0)	SMALLINT NOT NULL	Group Id for grouping payment
35	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
36	GP_PMT_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount field on GP PAYMENT table
37	PAYMENT_MTHD1	Character(1)	VARCHAR2(1) NOT NULL	Zero Net payment method N=Negative Net Z=Zero Net
38	PYMT_NBR	Number(18,0)	DECIMAL(18) NOT NULL	Payment Number
39	PYMT_NBR_FROM	Number(18,0)	DECIMAL(18) NOT NULL	from payment number
40	PYMT_NBR_TO	Number(18,0)	DECIMAL(18) NOT NULL	to payment number
41	RECON_STAT	Character(2)	VARCHAR2(2) NOT NULL	Reconciliation Status 01=Unreconciled 02=Reconciled 03=Date Difference 04=Not Found 05=Amount Difference 06=Duplicate 07=Expired 08=Stop Payment 09=Unclaimed 10=Different Pay Method 11=Void 12=Re-Numbered
42	PRINT_NEW_PYMT	Character(1)	VARCHAR2(1) NOT NULL	This field will identify if a payslip should be printed once the process completes.
43	COUNTER_GLOB	Number(19,3)	DECIMAL(18,3) NOT NULL	Counter