BOND_REF_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr Prompt Table: PER_ORG_ASGN_VW
3	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code Prompt Table: EARNINGS_TBL
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	ADDL_SEQ	Number(2,0)	SMALLINT NOT NULL	Additional Pay Sequence Number
6	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
7	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: JOBCODE_TBL
8	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number Prompt Table: POSITION_DATA
9	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code Prompt Table: ACCT_CD_TBL
10	GL_PAY_TYPE	Character(6)	VARCHAR2(6) NOT NULL	General Ledger Pay Type
11	ADDL_PAY_SHIFT	Character(1)	VARCHAR2(1) NOT NULL	Additional Pay Shift 1=1 2=2 3=3 J=Use Job Shift N=Not Applicable Default Value: J
12	OTH_HRS	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Other Hours
13	HOURLY_RT	Number(19,6)	DECIMAL(18,6) NOT NULL	Hourly Rate
14	OTH_PAY	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Other Pay
15	ADDLPAY_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason for Additional Pay A=Anniversary Award AWD=Award Data BAS=Benefits Administration Credit C=Contract Pay JOB=Job Other Pay N=Not Specified O=Outstanding Contribution P=Performance Award Q=President's Award S=Productivity Award Default Value: N
16	SEPCHK	Number(1,0)	SMALLINT NOT NULL	Separate check number.
17	EARNINGS_END_DT	Date(10)	DATE	Earnings End Date
18	GOAL_AMT	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Goal Amount
19	GOAL_BAL	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Current Goal Balance
20	OK_TO_PAY	Character(1)	VARCHAR2(1) NOT NULL	OK to Pay Y/N Table Edit Default Value: N
21	DISABLE_DIR_DEP	Character(1)	VARCHAR2(1) NOT NULL	Disable Direct Deposit Y/N Table Edit Default Value: N
22	PRORATE_ADDL_PAY	Character(1)	VARCHAR2(1) NOT NULL	Prorate Additional Pay Y/N Table Edit Default Value: N
23	PRORATE_CUI_WEEKS	Character(1)	VARCHAR2(1) NOT NULL	Prorate EI Weeks Y/N Table Edit Default Value: Y
24	PAY_PERIOD1	Character(1)	VARCHAR2(1) NOT NULL	First Pay Period Y/N Table Edit Default Value: Y
25	PAY_PERIOD2	Character(1)	VARCHAR2(1) NOT NULL	Second Pay Period Y/N Table Edit
26	PAY_PERIOD3	Character(1)	VARCHAR2(1) NOT NULL	Third Pay Period Y/N Table Edit
27	PAY_PERIOD4	Character(1)	VARCHAR2(1) NOT NULL	Fourth Pay Period Y/N Table Edit
28	PAY_PERIOD5	Character(1)	VARCHAR2(1) NOT NULL	Fifth Pay Period Y/N Table Edit
29	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TAX_TBL
30	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality Prompt Table: LOCAL_TAX_TBL
31	TAX_PERIODS	Number(2,0)	SMALLINT NOT NULL	Tax Periods Default Value: 1
32	TAX_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Tax method. A=Annualized B=Bonus C=Cumulative G=Aggregate L=Lump Sum M=Commission P=Specified on Paysheet S=Supplemental X=Special Supplemental Default Value: A
33	ADDL_PAY_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Tax Frequency A=Annually B=Biweekly D=Daily M=Monthly P=Use Pay Group Frequency Q=Quarterly S=Semimonthly W=Weekly Default Value: P
34	DED_TAKEN	Character(1)	VARCHAR2(1) NOT NULL	Deductions Taken D=Deduction Table Governs N=None R=No Override S=Deduction Table Subset Governs Default Value: D
35	DED_SUBSET_ID	Character(3)	VARCHAR2(3) NOT NULL	Deduction Subset ID Prompt Table: DED_SUBSET_TBL
36	PLAN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
37	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
38	COMP_RATECD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code
39	RECORD_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Record Source B=Batch O=On-line Default Value: O