SSF_PY_OTERN_VW

(SQL View)
 Index Back

Pay Check Other Earns View

This view is used to access Pay Other Earnings information.

SELECT A.COMPANY ,A.PAYGROUP ,A.PAY_END_DT ,A.OFF_CYCLE ,A.PAGE_NUM ,A.LINE_NUM ,A.SEPCHK ,A.ADDL_NBR ,A.ERNCD ,A.JOB_PAY ,A.OTH_HRS ,A.OTH_PAY ,A.OTH_EARNS ,A.ADD_GROSS ,A.TAX_METHOD ,A.ADDL_SEQ ,A.RATE_USED ,A.COMP_RATECD ,A.COMPRATE ,A.COMPRATE_USED ,A.HRS_DIST_SW FROM PS_PAY_OTH_EARNS A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
3 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date
4 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

Y/N Table Edit

5 PAGE_NUM Number(4,0) SMALLINT NOT NULL Page #
6 LINE_NUM Number(2,0) SMALLINT NOT NULL Line #
7 SEPCHK Number(1,0) SMALLINT NOT NULL Separate check number.
8 ADDL_NBR Number(3,0) SMALLINT NOT NULL Additional Pay Line #
9 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
10 JOB_PAY Character(1) VARCHAR2(1) NOT NULL Job Pay

Y/N Table Edit

11 OTH_HRS Signed Number(8,2) DECIMAL(6,2) NOT NULL Other Hours
12 OTH_PAY Signed Number(12,2) DECIMAL(10,2) NOT NULL Other Pay
13 OTH_EARNS Signed Number(12,2) DECIMAL(10,2) NOT NULL Other Earnings
14 ADD_GROSS Character(1) VARCHAR2(1) NOT NULL Add to Gross Pay
N=No
Y=Yes

Y/N Table Edit

15 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
16 ADDL_SEQ Number(2,0) SMALLINT NOT NULL Additional Pay Sequence Number
17 RATE_USED Character(1) VARCHAR2(1) NOT NULL Rate Used
A=Alternative Rate
F=FLSA Rate
H=Hourly Rate
18 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code
19 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
20 COMPRATE_USED Number(19,6) DECIMAL(18,6) NOT NULL Comp Rate Used
21 HRS_DIST_SW Character(1) VARCHAR2(1) NOT NULL Hours Distribution