SSF_PSHUPDTL_VW

(SQL View)
 Index Back

Paysheet Load holding record

This record is used in the Paysheet Load process. It contains data from other products, (for example stock and expenses), to be used in creating a paysheet.

SELECT H.BUSINESS_UNIT ,H.REFUND_NBR ,A.PU_SOURCE ,A.CREATION_DT ,A.COMPANY ,A.PAYGROUP ,A.PAY_END_DT ,A.OFF_CYCLE ,A.EARNS_BEGIN_DT ,A.EARNS_END_DT ,A.EMPLID ,A.EMPL_RCD ,A.SEQNO ,A.PU_TXN_TYPE ,A.PU_TXN_STATUS ,A.PAGE_NUM ,A.LINE_NUM ,A.ADDL_NBR ,A.SEPCHK ,A.DEPTID ,A.JOBCODE ,A.POSITION_NBR ,A.ACCT_CD ,A.GL_PAY_TYPE ,A.PU_DISTRIBUTE ,A.ERNCD ,A.ADDL_PAY_SHIFT ,A.ADDL_SEQ ,A.ADDLPAY_REASON ,A.OTH_HRS ,A.HOURLY_RT ,A.OK_TO_PAY ,A.DISABLE_DIR_DEP ,A.STATE ,A.LOCALITY ,A.TAX_PERIODS ,A.TAX_METHOD ,A.DED_TAKEN ,A.DED_SUBSET_ID ,A.DED_TAKEN_GENL ,A.DED_SUBSET_GENL ,A.BUSINESS_UNIT ,A.COMP_RATECD ,A.TAX_CLASS ,A.ONE_TIME_CD ,A.CTX_CLASS ,A.PLAN_TYPE ,A.BENEFIT_PLAN ,A.DEDCD ,A.DED_CLASS ,A.DED_CALC ,A.DED_RATE_PCT ,A.AMT ,A.MANUAL_CHECK ,A.PAYCHECK_NBR ,A.DED_SLSTX_CLASS ,A.EX_DOC_ID ,A.EX_DOC_TYPE ,A.EX_LINE_NBR ,A.CURRENCY_CD ,A.OVERRIDE_ONLY ,A.GROSSUP ,A.VC_PLAN_ID ,A.VC_PAYOUT_PRD_ID ,A.GB_GROUP_ID ,A.APPLID ,A.AWARD_DATE FROM PS_PSHUP_TXN A , PS_REFUND_HDR H , PS_REFUND_DTL D WHERE A.PU_SOURCE = 'OT' AND A.COMPANY = H.COMPANY AND A.PAYGROUP = H.PAYGROUP AND A.EMPLID = H.REFUND_EMPLID AND D.SEQNO = A.SEQNO AND H.BUSINESS_UNIT = D.BUSINESS_UNIT AND H.REFUND_NBR = D.REFUND_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 REFUND_NBR Number(12,0) DECIMAL(12) NOT NULL Refund Nbr
3 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
RP=Rapid Paysheets
SP=Stock Admin - ESPP Refunds
ST=Stock Admin - Options & ESPP
VC=Variable Compensation
WI=What-If
4 CREATION_DT Date(10) DATE NOT NULL Creation Date
5 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
6 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
7 PAY_END_DT Date(10) DATE Pay Period End Date
8 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?
9 EARNS_BEGIN_DT Date(10) DATE Earnings Begin Date
10 EARNS_END_DT Date(10) DATE Earnings End Date
11 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
12 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
13 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
14 PU_TXN_TYPE Character(1) VARCHAR2(1) NOT NULL Paysheet Update Tax Type
C=Canada Tax Override
D=Deduction Override
E=Earnings
G=Total Gross
N=Net Pay
O=Override
T=US Tax Override
15 PU_TXN_STATUS Character(1) VARCHAR2(1) NOT NULL Paysheet Update Tax Status
A=Active
I=Inactive
16 PAGE_NUM Number(4,0) SMALLINT NOT NULL Page #
17 LINE_NUM Number(2,0) SMALLINT NOT NULL Line #
18 ADDL_NBR Number(3,0) SMALLINT NOT NULL Additional Pay Line #
19 SEPCHK Number(1,0) SMALLINT NOT NULL Separate check number.
20 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
21 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
22 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
23 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code
24 GL_PAY_TYPE Character(6) VARCHAR2(6) NOT NULL General Ledger Pay Type
25 PU_DISTRIBUTE Character(1) VARCHAR2(1) NOT NULL Paysheet Update Distribution

Y/N Table Edit

Default Value: Y

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

30 OTH_HRS Signed Number(8,2) DECIMAL(6,2) NOT NULL Other Hours
31 HOURLY_RT Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate
32 OK_TO_PAY Character(1) VARCHAR2(1) NOT NULL OK to Pay
33 DISABLE_DIR_DEP Character(1) VARCHAR2(1) NOT NULL Disable Direct Deposit
34 STATE Character(6) VARCHAR2(6) NOT NULL State
35 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality
36 TAX_PERIODS Number(2,0) SMALLINT NOT NULL Tax Periods
37 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
38 DED_TAKEN Character(1) VARCHAR2(1) NOT NULL Deductions Taken
D=Deduction Table Governs
N=None
R=No Override
S=Deduction Table Subset Governs
39 DED_SUBSET_ID Character(3) VARCHAR2(3) NOT NULL Deduction Subset ID
40 DED_TAKEN_GENL Character(1) VARCHAR2(1) NOT NULL General Deductions Taken
D=Deduction Table Governs
N=None
R=No Override
S=Deduction Table Subset Governs
41 DED_SUBSET_GENL Character(3) VARCHAR2(3) NOT NULL General Ded Subset ID
42 BUSINESS_UNIT2 Character(5) VARCHAR2(5) NOT NULL Business Unit
43 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code
44 TAX_CLASS Character(1) VARCHAR2(1) NOT NULL Tax Balance Class
45 ONE_TIME_CD Character(1) VARCHAR2(1) NOT NULL PaySheet One-Time Code
A=Addition
O=Override
P=Arrears Payback
R=Refund
46 CTX_CLASS Character(1) VARCHAR2(1) NOT NULL Canadian Tax Type
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
N=Quebec Bonus Tax
P=Canada Pension Plan
Q=Quebec Pension Plan
R=Employer EI Premium
T=Payroll Tax
V=Quebec Income Tax (RL-2)
X=Take No CPP/QPP Exemption
Y=Canadian Pension Plan - ER
Z=Quebec Pension Plan - ER
47 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.
48 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan
49 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code
50 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
51 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
52 DED_RATE_PCT Number(8,3) DECIMAL(7,3) NOT NULL Deduction Rate/Percent
53 AMT Number(11,2) DECIMAL(10,2) NOT NULL Dollar Amount
54 MANUAL_CHECK Character(1) VARCHAR2(1) NOT NULL Manual Check
N=No
R=Reversal
Y=Yes

Default Value: N

55 PAYCHECK_NBR Number(15,0) DECIMAL(15) NOT NULL Paycheck number.
56 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
57 EX_DOC_ID Character(10) VARCHAR2(10) NOT NULL Expense Doc ID
58 EX_DOC_TYPE Character(1) VARCHAR2(1) NOT NULL Expense Doc Type
59 EX_LINE_NBR Number(5,0) INTEGER NOT NULL Expense Line #
60 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
61 OVERRIDE_ONLY Character(1) VARCHAR2(1) NOT NULL Override Only
62 GROSSUP Character(1) VARCHAR2(1) NOT NULL Gross-Up
63 VC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL VC Plan ID
64 VC_PAYOUT_PRD_ID Character(10) VARCHAR2(10) NOT NULL Payout Period ID
65 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
66 APPLID Character(11) VARCHAR2(11) NOT NULL External Job Applicant ID
67 AWARD_DATE Date(10) DATE Award Date