UPG_ADDLPAY_TAO

#	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	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date
5	ADDL_SEQ	Number(2,0)	SMALLINT NOT NULL	Additional Pay Sequence Number
6	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
7	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
8	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
9	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code
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
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
16	SEPCHK	Number(2,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	Goal Balance
20	OK_TO_PAY	Character(1)	VARCHAR2(1) NOT NULL	Okay to pay indicator.
21	DISABLE_DIR_DEP	Character(1)	VARCHAR2(1) NOT NULL	Disable Direct Deposit
22	PRORATE_ADDL_PAY	Character(1)	VARCHAR2(1) NOT NULL	Prorate Additional Pay
23	PRORATE_CUI_WEEKS	Character(1)	VARCHAR2(1) NOT NULL	Prorate EI Weeks
24	PAY_PERIOD1	Character(1)	VARCHAR2(1) NOT NULL	First Pay Period
25	PAY_PERIOD2	Character(1)	VARCHAR2(1) NOT NULL	Second Pay Period
26	PAY_PERIOD3	Character(1)	VARCHAR2(1) NOT NULL	Third Pay Period
27	PAY_PERIOD4	Character(1)	VARCHAR2(1) NOT NULL	Fourth Pay Period
28	PAY_PERIOD5	Character(1)	VARCHAR2(1) NOT NULL	Fifth Pay Period
29	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
30	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality
31	TAX_PERIODS	Number(2,0)	SMALLINT NOT NULL	Tax Periods
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
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
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
35	DED_SUBSET_ID	Character(3)	VARCHAR2(3) NOT NULL	Deduction Subset ID
36	DED_TAKEN_GENL	Character(1)	VARCHAR2(1) NOT NULL	Specify how general deduction is to be taken. D=Deduction Table Governs N=None R=No Override S=Deduction Table Subset Governs
37	DED_SUBSET_GENL	Character(3)	VARCHAR2(3) NOT NULL	Subset ID for general deductions.
38	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.
39	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
40	COMP_RATECD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code
41	RECORD_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Record Source B=Batch O=On-line