SSF_PAY_EARN_VW (SQL View)	Index Back
Pay Check Earnings View This record gives the view of the pay earnings record.

SSF_PAY_EARN_VW

(SQL View)

Pay Check Earnings View

This record gives the view of the pay earnings record.

SELECT A.COMPANY ,A.PAYGROUP ,A.PAY_END_DT ,A.OFF_CYCLE ,A.PAGE_NUM ,A.LINE_NUM ,A.SEPCHK ,A.ADDL_NBR ,A.EMPLID ,A.EMPL_RCD ,A.EARNS_END_DT ,A.EARNS_BEGIN_DT ,A.ADDLPAY_REASON ,A.DISABLE_DIR_DEP ,A.GROSSUP ,A.PAY_LINE_STATUS ,A.OK_TO_PAY ,A.JOB_PAY ,A.ACCT_CD ,A.GL_PAY_TYPE ,A.DEPTID ,A.JOBCODE ,A.POSITION_NBR ,A.SHIFT ,A.SHIFT_RT ,A.HOURLY_RT ,A.FLSA_RT ,A.RATE_USED ,A.FLSA_REQUIRED ,A.ERNCD_REG_HRS ,A.ERNCD_OT_HRS ,A.REG_HRS ,A.OT_HRS ,A.REG_HRLY_EARNS ,A.OT_HRLY_EARNS ,A.ERNCD_REG_EARNS ,A.REG_PAY_HRS ,A.REG_PAY ,A.REG_EARNS ,A.REG_EARN_HRS ,A.DED_TAKEN ,A.DED_SUBSET_ID ,A.DED_TAKEN_GENL ,A.DED_SUBSET_GENL ,A.STATE ,A.LOCALITY ,A.PAY_FREQUENCY ,A.TAX_PERIODS ,A.TAX_METHOD ,A.ADDL_TAXES ,A.BENEFIT_RCD_NBR ,A.SINGLE_CHECK_USE ,A.PAY_SHEET_SRC ,A.BUSINESS_UNIT ,A.EI_PRIOR_PD_CORR ,A.COMP_RATECD_REG ,A.COMP_RATECD_OT ,A.COMPRATE_USED_REG ,A.COMPRATE_USED_OT ,A.FICA_STATUS_EE ,A.PAID_PRDS_PER_YEAR ,A.ORIG_PAYGROUP FROM PS_PAY_EARNINGS 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
Default Value: N

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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

10 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

11 EARNS_END_DT Date(10) DATE Earnings End Date

12 EARNS_BEGIN_DT Date(10) DATE Earnings Begin Date

13 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

14 DISABLE_DIR_DEP Character(1) VARCHAR2(1) NOT NULL Disable Direct Deposit
Y/N Table Edit
Default Value: N

15 GROSSUP Character(1) VARCHAR2(1) NOT NULL Gross-Up
Y/N Table Edit
Default Value: N

16 PAY_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Payline Calculation Status
C=Calculated
E=Calculation Error
F=Confirmed
I=Initial Load
P=Pay in Progress
U=Updated by User
V=Reversing Check

17 OK_TO_PAY Character(1) VARCHAR2(1) NOT NULL OK to Pay
Y/N Table Edit
Default Value: N

18 JOB_PAY Character(1) VARCHAR2(1) NOT NULL Job Pay
Y/N Table Edit
Default Value: N

19 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code

20 GL_PAY_TYPE Character(6) VARCHAR2(6) NOT NULL General Ledger Pay Type

21 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

22 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

23 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

24 SHIFT Character(1) VARCHAR2(1) NOT NULL Regular Shift
1=1
2=2
3=3
A=Any
C=Compressed
N=Not Applicable
R=Rotating
Default Value: N

25 SHIFT_RT Number(19,6) DECIMAL(18,6) NOT NULL Shift Differential Rate

26 HOURLY_RT Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate

27 FLSA_RT Number(19,6) DECIMAL(18,6) NOT NULL FLSA Rate

28 RATE_USED Character(1) VARCHAR2(1) NOT NULL Rate Used
A=Alternative Rate
F=FLSA Rate
H=Hourly Rate

29 FLSA_REQUIRED Character(1) VARCHAR2(1) NOT NULL FLSA required
N=NO FLSA REQUIRED
Y=FLSA REQUIRED

30 ERNCD_REG_HRS Character(3) VARCHAR2(3) NOT NULL Regular Hours Earnings Type

31 ERNCD_OT_HRS Character(3) VARCHAR2(3) NOT NULL OT Hours Earnings Type

32 REG_HRS Signed Number(8,2) DECIMAL(6,2) NOT NULL Regular Hours

33 OT_HRS Signed Number(8,2) DECIMAL(6,2) NOT NULL Overtime Hours

34 REG_HRLY_EARNS Signed Number(12,2) DECIMAL(10,2) NOT NULL Regular Hourly Earnings

35 OT_HRLY_EARNS Signed Number(12,2) DECIMAL(10,2) NOT NULL Overtime Hourly Earnings

36 ERNCD_REG_EARNS Character(3) VARCHAR2(3) NOT NULL Regular Earns Earnings Type

37 REG_PAY_HRS Signed Number(8,2) DECIMAL(6,2) NOT NULL Regular Hours Input

38 REG_PAY Signed Number(12,2) DECIMAL(10,2) NOT NULL Regular Salaried Earnings

39 REG_EARNS Signed Number(12,2) DECIMAL(10,2) NOT NULL Regular Earnings

40 REG_EARN_HRS Signed Number(8,2) DECIMAL(6,2) NOT NULL Regular Earnings Hours

41 DED_TAKEN Character(1) VARCHAR2(1) NOT NULL Deductions Taken
D=Deduction Table Governs
N=None
R=No Override
S=Deduction Table Subset Governs
Default Value: D

42 DED_SUBSET_ID Character(3) VARCHAR2(3) NOT NULL Deduction Subset ID

43 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
Default Value: D

44 DED_SUBSET_GENL Character(3) VARCHAR2(3) NOT NULL General Ded Subset ID

45 STATE Character(6) VARCHAR2(6) NOT NULL State

46 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality

47 PAY_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Pay Frequency
A=Annual
B=Biweekly
D=Daily
M=Monthly
Q=Quarterly
S=Semimonthly
W=Weekly

48 TAX_PERIODS Number(2,0) SMALLINT NOT NULL Tax Periods
Default Value: 1

49 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
Default Value: A

50 ADDL_TAXES Character(1) VARCHAR2(1) NOT NULL Additional Taxes
Y/N Table Edit
Default Value: Y

51 BENEFIT_RCD_NBR Number(3,0) SMALLINT NOT NULL Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.

52 SINGLE_CHECK_USE Character(1) VARCHAR2(1) NOT NULL How is Single Check Used
C=Check Only
N=Not Applicable
P=Paysheet Only
Default Value: N

53 PAY_SHEET_SRC Character(1) VARCHAR2(1) NOT NULL Source of Paysheet
F=FLSA Paysheet
K=Batch Final Check
L=Online Final Check
O=On-line Paysheet
P=Paysheet Load
S=Regular Paysheet

54 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

55 EI_PRIOR_PD_CORR Character(1) VARCHAR2(1) NOT NULL EI Prior Period Correction
Y/N Table Edit
Default Value: N

56 COMP_RATECD_REG Character(6) VARCHAR2(6) NOT NULL Regular Comp Rate Code

57 COMP_RATECD_OT Character(6) VARCHAR2(6) NOT NULL Overtime Comp Rate Code

58 COMPRATE_USED_REG Number(19,6) DECIMAL(18,6) NOT NULL Comp Rate Used for Regular

59 COMPRATE_USED_OT Number(19,6) DECIMAL(18,6) NOT NULL Comp Rate Used for Overtime

60 FICA_STATUS_EE Character(1) VARCHAR2(1) NOT NULL FICA Status-Employee
E=Exempt
H=ER FICA Exmpt
M=Medicare only
N=Subject

61 PAID_PRDS_PER_YEAR Number(6,2) DECIMAL(5,2) NOT NULL Annual Tax Periods

62 ORIG_PAYGROUP Character(3) VARCHAR2(3) NOT NULL Original Paygroup

#	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 Default Value: N
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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
10	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
11	EARNS_END_DT	Date(10)	DATE	Earnings End Date
12	EARNS_BEGIN_DT	Date(10)	DATE	Earnings Begin Date
13	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
14	DISABLE_DIR_DEP	Character(1)	VARCHAR2(1) NOT NULL	Disable Direct Deposit Y/N Table Edit Default Value: N
15	GROSSUP	Character(1)	VARCHAR2(1) NOT NULL	Gross-Up Y/N Table Edit Default Value: N
16	PAY_LINE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payline Calculation Status C=Calculated E=Calculation Error F=Confirmed I=Initial Load P=Pay in Progress U=Updated by User V=Reversing Check
17	OK_TO_PAY	Character(1)	VARCHAR2(1) NOT NULL	OK to Pay Y/N Table Edit Default Value: N
18	JOB_PAY	Character(1)	VARCHAR2(1) NOT NULL	Job Pay Y/N Table Edit Default Value: N
19	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code
20	GL_PAY_TYPE	Character(6)	VARCHAR2(6) NOT NULL	General Ledger Pay Type
21	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
22	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
23	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
24	SHIFT	Character(1)	VARCHAR2(1) NOT NULL	Regular Shift 1=1 2=2 3=3 A=Any C=Compressed N=Not Applicable R=Rotating Default Value: N
25	SHIFT_RT	Number(19,6)	DECIMAL(18,6) NOT NULL	Shift Differential Rate
26	HOURLY_RT	Number(19,6)	DECIMAL(18,6) NOT NULL	Hourly Rate
27	FLSA_RT	Number(19,6)	DECIMAL(18,6) NOT NULL	FLSA Rate
28	RATE_USED	Character(1)	VARCHAR2(1) NOT NULL	Rate Used A=Alternative Rate F=FLSA Rate H=Hourly Rate
29	FLSA_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	FLSA required N=NO FLSA REQUIRED Y=FLSA REQUIRED
30	ERNCD_REG_HRS	Character(3)	VARCHAR2(3) NOT NULL	Regular Hours Earnings Type
31	ERNCD_OT_HRS	Character(3)	VARCHAR2(3) NOT NULL	OT Hours Earnings Type
32	REG_HRS	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Regular Hours
33	OT_HRS	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Overtime Hours
34	REG_HRLY_EARNS	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Regular Hourly Earnings
35	OT_HRLY_EARNS	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Overtime Hourly Earnings
36	ERNCD_REG_EARNS	Character(3)	VARCHAR2(3) NOT NULL	Regular Earns Earnings Type
37	REG_PAY_HRS	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Regular Hours Input
38	REG_PAY	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Regular Salaried Earnings
39	REG_EARNS	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Regular Earnings
40	REG_EARN_HRS	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Regular Earnings Hours
41	DED_TAKEN	Character(1)	VARCHAR2(1) NOT NULL	Deductions Taken D=Deduction Table Governs N=None R=No Override S=Deduction Table Subset Governs Default Value: D
42	DED_SUBSET_ID	Character(3)	VARCHAR2(3) NOT NULL	Deduction Subset ID
43	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 Default Value: D
44	DED_SUBSET_GENL	Character(3)	VARCHAR2(3) NOT NULL	General Ded Subset ID
45	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
46	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality
47	PAY_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Pay Frequency A=Annual B=Biweekly D=Daily M=Monthly Q=Quarterly S=Semimonthly W=Weekly
48	TAX_PERIODS	Number(2,0)	SMALLINT NOT NULL	Tax Periods Default Value: 1
49	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 Default Value: A
50	ADDL_TAXES	Character(1)	VARCHAR2(1) NOT NULL	Additional Taxes Y/N Table Edit Default Value: Y
51	BENEFIT_RCD_NBR	Number(3,0)	SMALLINT NOT NULL	Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.
52	SINGLE_CHECK_USE	Character(1)	VARCHAR2(1) NOT NULL	How is Single Check Used C=Check Only N=Not Applicable P=Paysheet Only Default Value: N
53	PAY_SHEET_SRC	Character(1)	VARCHAR2(1) NOT NULL	Source of Paysheet F=FLSA Paysheet K=Batch Final Check L=Online Final Check O=On-line Paysheet P=Paysheet Load S=Regular Paysheet
54	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
55	EI_PRIOR_PD_CORR	Character(1)	VARCHAR2(1) NOT NULL	EI Prior Period Correction Y/N Table Edit Default Value: N
56	COMP_RATECD_REG	Character(6)	VARCHAR2(6) NOT NULL	Regular Comp Rate Code
57	COMP_RATECD_OT	Character(6)	VARCHAR2(6) NOT NULL	Overtime Comp Rate Code
58	COMPRATE_USED_REG	Number(19,6)	DECIMAL(18,6) NOT NULL	Comp Rate Used for Regular
59	COMPRATE_USED_OT	Number(19,6)	DECIMAL(18,6) NOT NULL	Comp Rate Used for Overtime
60	FICA_STATUS_EE	Character(1)	VARCHAR2(1) NOT NULL	FICA Status-Employee E=Exempt H=ER FICA Exmpt M=Medicare only N=Subject
61	PAID_PRDS_PER_YEAR	Number(6,2)	DECIMAL(5,2) NOT NULL	Annual Tax Periods
62	ORIG_PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Original Paygroup