PSHUP_TXN_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PU_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Paysheet update source. AM=Absence Management ER=Recruiting Interface EX=Expense Interface IM=SIM Interface OT=Other Sources PL=Lifetime Balance Payout USF RP=Rapid Paysheets SP=Stock Admin - ESPP Refunds ST=Stock Admin - Options & ESPP VC=Variable Compensation VF=Bonus from Fusion WI=What-If
3	CREATION_DT	Date(10)	DATE NOT NULL	Creation Date
4	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
5	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
6	PAY_END_DT	Date(10)	DATE	Pay Period End Date
7	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ?
8	EARNS_BEGIN_DT	Date(10)	DATE	Earnings Begin Date
9	EARNS_END_DT	Date(10)	DATE	Earnings End Date
10	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
11	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
12	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
13	PU_TXN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Paysheet transaction type. C=Canada Tax Override D=Deduction Override E=Earnings G=Total Gross N=Net Pay O=Override S=Garnishment Override T=US Tax Override
14	PU_TXN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Paysheet transaction status. A=Active E=Exclude I=Inactive I=Loaded M=Manually Paid R=Rejected X=In Progress
15	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code
16	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.
17	DEDCD	Character(6)	VARCHAR2(6) NOT NULL	Deduction Code
18	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration
19	ACTIVE_EMPL	Character(1)	VARCHAR2(1) NOT NULL	Active Employees
20	PSHUP_PROG_ID	Character(3)	VARCHAR2(3) NOT NULL	Paysheet Update for Inactive Employees Program Id.
21	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
22	MSGID	Character(6)	VARCHAR2(6) NOT NULL	Message ID