BOND_LOG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	BOND_ID	Character(3)	VARCHAR2(3) NOT NULL	Savings Bond ID Prompt Table: BOND_TBL
3	BOND_OWNER_ID	Character(2)	VARCHAR2(2) NOT NULL	Bond Owner ID
4	BOND_OTH_REG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Bond Other Registrant Type B=Beneficiary C=Co-Owner N=No Other Bond Registrant
5	BOND_OTH_REG_ID	Character(2)	VARCHAR2(2) NOT NULL	Bond Other Registrant ID
6	BOND_LOG_SEQ	Number(3,0)	SMALLINT NOT NULL	Bond Activity Seq #
7	BOND_LOG_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Bond Activity Status D=Funds Disbursed F=Refunded Balance N=Funds Not Ready to Disburse R=Funds Ready to Disburse S=Suspended Due To Annual Limit T=Transferred Balance
8	REVERSED	Character(1)	VARCHAR2(1) NOT NULL	Reversed Y/N Table Edit
9	FORM_ID	Character(6)	VARCHAR2(6) NOT NULL	Form Identification
10	PAYCHECK_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Paycheck number.
11	CHECK_DT	Date(10)	DATE NOT NULL	Check date.
12	BOND_COLLECT_AMT	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	Bond Collection Amount
13	BOND_DISBURSE_AMT	Number(8,2)	DECIMAL(7,2) NOT NULL	Bond Disbursement Amount
14	BOND_PURCH_UNITS	Number(3,0)	SMALLINT NOT NULL	Bond Purchase Units
15	BOND_ACCUM_AMT	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	Bond Accumulated Amount
16	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
17	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
18	PAY_END_DT	Date(10)	DATE	Pay Period End Date
19	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ?
20	AP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	AP Status S=Sent to AP X=Extracted