GPGB_PY_LNG_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 Default Value: 0
6	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
7	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number
8	SRC_BANK_ID	Character(8)	VARCHAR2(8) NOT NULL	Source Bank ID
9	RECIPIENT_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment recipient ID
10	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
11	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
12	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
13	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
14	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
15	PMT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Payment Type 01=Net Pay Distribution 02=General Recipient Deduction 03=Individual Recipient Deduction
16	DEBIT_DT	Date(10)	DATE	Debit Date
17	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
18	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description