PY_PSHUP_TRX_VW

(SQL View)
 Index Back

Paysheet Load Search Record

This record is used in loading paysheet transactions using Excel-to-CI.

SELECT PU_SOURCE ,CREATION_DT ,COMPANY ,PAYGROUP ,PAY_END_DT ,OFF_CYCLE ,EARNS_BEGIN_DT ,EARNS_END_DT ,EMPLID ,EMPL_RCD ,SEQNO ,PU_TXN_TYPE ,PU_TXN_STATUS ,PAGE_NUM ,LINE_NUM ,ADDL_NBR ,SEPCHK ,DEPTID ,JOBCODE ,POSITION_NBR ,ACCT_CD ,GL_PAY_TYPE ,PU_DISTRIBUTE ,ERNCD ,ADDL_PAY_SHIFT ,ADDL_SEQ ,ADDLPAY_REASON ,OTH_HRS ,HOURLY_RT ,OK_TO_PAY ,DISABLE_DIR_DEP ,STATE ,LOCALITY ,TAX_PERIODS ,TAX_METHOD ,DED_TAKEN ,DED_SUBSET_ID ,DED_TAKEN_GENL ,DED_SUBSET_GENL ,BUSINESS_UNIT ,COMP_RATECD ,TAX_CLASS ,ONE_TIME_CD ,CTX_CLASS ,PLAN_TYPE ,BENEFIT_PLAN ,DEDCD ,DED_CLASS ,DED_CALC ,DED_RATE_PCT ,PU_AMT ,MANUAL_CHECK ,PAYCHECK_NBR ,DED_SLSTX_CLASS ,EX_DOC_ID ,EX_DOC_TYPE ,EX_LINE_NBR ,CURRENCY_CD ,OVERRIDE_ONLY ,GROSSUP ,VC_PLAN_ID ,VC_PAYOUT_PRD_ID ,GB_GROUP_ID ,APPLID ,AWARD_DATE ,EIM_KEY ,PAYOUT_DT ,PU_TXN_MANUAL_CHG ,CHECK_DT ,OPRID ,GARNID ,GARN_ONE_TIME_CD ,GARN_PRIORITY ,GARN_DED_CALC ,GARN_DED_PCT ,GARN_DED_AMT ,CMPNY_FEE_PCT ,CMPNY_FEE_AMT ,PAYEE_FEE_PCT ,PAYEE_FEE_AMT ,PY_GARN_EXEMPT ,WORK_PSD_CD ,RES_PSD_CD FROM PS_PSHUP_TXN WHERE PU_SOURCE LIKE 'O%'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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
2 CREATION_DT Date(10) DATE NOT NULL Creation Date
3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
4 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
5 PAY_END_DT Date(10) DATE Pay Period End Date
6 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?
7 EARNS_BEGIN_DT Date(10) DATE Earnings Begin Date
8 EARNS_END_DT Date(10) DATE Earnings End Date
9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
10 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

Default Value: 0

11 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
12 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
13 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
14 PAGE_NUM Number(5,0) INTEGER NOT NULL Page Nbr
15 LINE_NUM Number(3,0) SMALLINT NOT NULL Line Nbr
16 ADDL_NBR Number(3,0) SMALLINT NOT NULL Additional Pay Line Nbr
17 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.
18 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
19 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
20 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
21 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code
22 GL_PAY_TYPE Character(6) VARCHAR2(6) NOT NULL General Ledger Pay Type
23 PU_DISTRIBUTE Character(1) VARCHAR2(1) NOT NULL Paysheet Update Distribution

Y/N Table Edit

Default Value: Y

24 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
25 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
26 ADDL_SEQ Number(2,0) SMALLINT NOT NULL Additional Pay Sequence Number
27 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

28 OTH_HRS Signed Number(8,2) DECIMAL(6,2) NOT NULL Other hours.
29 HOURLY_RT Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate
30 OK_TO_PAY Character(1) VARCHAR2(1) NOT NULL Okay to pay indicator.
31 DISABLE_DIR_DEP Character(1) VARCHAR2(1) NOT NULL Disable Direct Deposit
32 STATE Character(6) VARCHAR2(6) NOT NULL State
33 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality
34 TAX_PERIODS Number(2,0) SMALLINT NOT NULL Tax Periods
35 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
36 DED_TAKEN Character(1) VARCHAR2(1) NOT NULL Deductions Taken
D=Deduction Table Governs
N=None
R=No Override
S=Deduction Table Subset Governs
37 DED_SUBSET_ID Character(3) VARCHAR2(3) NOT NULL Deduction Subset ID
38 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
39 DED_SUBSET_GENL Character(3) VARCHAR2(3) NOT NULL Subset ID for general deductions.
40 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
41 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code
42 TAX_CLASS Character(3) VARCHAR2(3) NOT NULL Tax Balance Class
43 ONE_TIME_CD Character(1) VARCHAR2(1) NOT NULL Paysheet one-time code.
A=Addition
O=Override
P=Arrears Payback
R=Refund
44 CTX_CLASS Character(1) VARCHAR2(1) NOT NULL Canadian Tax Class.
A=Canadian Income Tax (T4A)
B=Canadian Bonus Tax
C=Canadian Income Tax (T4)
E=Employee EI Premium
H=Health Tax
I=Quebec Income Tax
J=Quebec Parental Insurance - EE
K=Quebec Parental Insurance - ER
L=CPP Second Addition EE
M=CPP Second Addition ER
N=Quebec Bonus Tax
P=Canada Pension Plan
Q=Quebec Pension Plan
R=Employer EI Premium
S=QPP Second Addition EE
T=Payroll Tax
U=QPP Second Addition ER
V=Quebec Income Tax (RL-2)
X=Take No CPP/QPP Exemption
Y=Canadian Pension Plan - ER
Z=Quebec Pension Plan - ER
45 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.
46 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan
47 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code
48 DED_CLASS Character(1) VARCHAR2(1) NOT NULL Deduction Classification
A=After-Tax
B=Before-Tax
L=QC Taxable Benefit
N=Nontaxable Benefit
P=Nontaxable Btax Benefit
T=Taxable Benefit
49 DED_CALC Character(1) VARCHAR2(1) NOT NULL Deduction Calculation Routine
A=Flat Amount
B=Percentage
C=Calculated by Salary System
D=Default to Deduction Table
E=Percent of Special Earnings
F=Percent of Federal Gross
G=Percent of Total Gross
H=Rate x Total Hours
N=Percent of Net Pay
P=Rate x Special Hours
S=Special Deduction Calculation
W=Rate x Hours Worked
50 DED_RATE_PCT Number(8,3) DECIMAL(7,3) NOT NULL Deduction Rate/Percent
51 PU_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL Paysheet transaction amount.
52 MANUAL_CHECK Character(1) VARCHAR2(1) NOT NULL Manual Check indicator.
N=No
R=Reversal
Y=Yes

Default Value: N

53 PAYCHECK_NBR Number(15,0) DECIMAL(15) NOT NULL Paycheck number.
54 DED_SLSTX_CLASS Character(1) VARCHAR2(1) NOT NULL Sales Tax Type
B=None
G=Goods and Services Tax
H=Harmonized Sales Tax
I=Provincial Sales Tax Insurance
P=Provincial Sales Tax
Q=QC Prov Sales Tax Insurance
S=QC Provincial Sales Tax
T=Provincial Premium Tax
U=QC Provincial Premium Tax
55 EX_DOC_ID Character(10) VARCHAR2(10) NOT NULL Expense Doc ID
56 EX_DOC_TYPE Character(1) VARCHAR2(1) NOT NULL Expense Doc Type
57 EX_LINE_NBR Number(5,0) INTEGER NOT NULL Expense Line #
58 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
59 OVERRIDE_ONLY Character(1) VARCHAR2(1) NOT NULL Override Only
60 GROSSUP Character(1) VARCHAR2(1) NOT NULL Gross-Up
61 VC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL VC Plan ID
62 VC_PAYOUT_PRD_ID Character(10) VARCHAR2(10) NOT NULL Payout Period ID
63 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
64 APPLID Character(11) VARCHAR2(11) NOT NULL External Job Applicant ID
65 AWARD_DATE Date(10) DATE Award Date
66 EIM_KEY Character(20) VARCHAR2(20) NOT NULL SIM Sequence Number
67 PAYOUT_DT Date(10) DATE Payout Date
68 PU_TXN_MANUAL_CHG Character(1) VARCHAR2(1) NOT NULL Field indicates whether paysheet transaction has been previously updated online.
69 CHECK_DT Date(10) DATE Check date.
70 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
71 GARNID Character(6) VARCHAR2(6) NOT NULL Garnishment id.
72 GARN_ONE_TIME_CD Character(1) VARCHAR2(1) NOT NULL Garnishment one-time code.
O=Override Garnishment Amounts
R=Refund Garnishment Amount
S=Suspend Garnishment
73 GARN_PRIORITY Number(3,0) SMALLINT NOT NULL Garnishment priority.
74 GARN_DED_CALC Character(1) VARCHAR2(1) NOT NULL Deduction calculation routine.
G=Greater of %DE or Amount
H=Greater of %Gross or Amount
M=Maximum Allowed
P=% DE + Amount
R=% Gross + Amount
S=No exempt; %DE + Amt
T=No exempt; % of Gross
75 GARN_DED_PCT Number(6,2) DECIMAL(5,2) NOT NULL Garnishment deduction percent.
76 GARN_DED_AMT Number(9,2) DECIMAL(8,2) NOT NULL Garnishment flat amount.
77 CMPNY_FEE_PCT Number(6,2) DECIMAL(5,2) NOT NULL Company's voucher fee percent.
78 CMPNY_FEE_AMT Number(9,2) DECIMAL(8,2) NOT NULL Company's voucher fee amount.
79 PAYEE_FEE_PCT Number(6,2) DECIMAL(5,2) NOT NULL Payee's voucher fee percent.
80 PAYEE_FEE_AMT Number(9,2) DECIMAL(8,2) NOT NULL Payee's voucher fee amount.
81 PY_GARN_EXEMPT Character(1) VARCHAR2(1) NOT NULL Yes/No field to indicate whether exemption amount should be calculated for a Tax levy garnishment or not
82 WORK_PSD_CD Character(6) VARCHAR2(6) NOT NULL Locality
83 RES_PSD_CD Character(6) VARCHAR2(6) NOT NULL Locality