GPUS_BND_LOG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
4	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
5	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
6	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
7	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
8	GPUS_BND_ID	Character(12)	VARCHAR2(12) NOT NULL	Savings Bond ID
9	GPUS_BND_NUM	Number(3,0)	SMALLINT NOT NULL	Bond Number
10	PAYMENT_DT	Date(10)	DATE	Payment Date
11	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp
12	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
13	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number
14	GPUS_BND_LOG_STAT	Character(2)	VARCHAR2(2) NOT NULL	Bond Activity Log Status 10=Ready to Purchase 20=Purchased 30=Not Ready to Purchase 40=Deduction 50=Purchase
15	PROCESSED_IND	Character(1)	VARCHAR2(1) NOT NULL	Processed Indicator
16	GPUS_BND_PURCH_UNI	Number(3,0)	SMALLINT NOT NULL	Bond Purchase Units
17	GPUS_BND_PURCH_AMT	Number(12,2)	DECIMAL(11,2) NOT NULL	Bond Purchase Amount
18	GPUS_BND_AMT_S	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Bond Amount (Signed)
19	GPUS_BND_BAL_AMT_S	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Bond Balance Amount
20	SEG_BGN_DT	Date(10)	DATE	Payee Process Segment's Begin Date
21	SEG_END_DT	Date(10)	DATE	Payee Process Segment's End Date