GP_PAYMENT_HST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
6	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
7	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
8	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
9	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
10	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
11	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number
12	RECIPIENT_TAG	Number(3,0)	SMALLINT NOT NULL	Used to identify recipients for E/D, PI
13	RECIPIENT_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment recipient ID
14	RECIPIENT_NAME	Character(30)	VARCHAR2(30) NOT NULL	Recipient Name
15	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
16	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
17	SEG_END_DT	Date(10)	DATE	Payee Process Segment's End Date
18	PYMT_KEY1	Character(25)	VARCHAR2(25) NOT NULL	Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
19	PYMT_KEY2	Character(25)	VARCHAR2(25) NOT NULL	Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
20	PYMT_KEY3	Character(25)	VARCHAR2(25) NOT NULL	Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
21	PYMT_KEY4	Character(25)	VARCHAR2(25) NOT NULL	Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
22	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
23	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name
24	ACCOUNT_ID	Number(3,0)	SMALLINT NOT NULL	Account ID
25	PMT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Payment Type 01=Net Pay Distribution 02=General Recipient Deduction 03=Individual Recipient Deduction
26	GP_PMT_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount field on GP PAYMENT table
27	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
28	CURRENCY_CD2	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
29	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
30	DEBIT_DT	Date(10)	DATE	Debit Date
31	REVERSAL_IND	Number(1,0)	SMALLINT NOT NULL	Reversal Indicator. Used in the GP BANKING process to identify transactions that are reversals. 0 means not reversal, 1 means reversal.
32	SRC_BANK_ID	Character(8)	VARCHAR2(8) NOT NULL	Source Bank ID
33	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
34	CAL_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Calendar Period ID
35	PYMT_ID	Character(6)	VARCHAR2(6) NOT NULL	Payment Identification
36	PYMT_NBR	Number(18,0)	DECIMAL(18) NOT NULL	Payment Number
37	LASTUPDDTTM	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.
38	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.