SSF_PAY_CHK_VW

(SQL View)
 Index Back

SSF Pay Check View

SSF Product View of PAY_CHECK. Used by SFPAYDED.SQR

SELECT COMPANY ,PAYGROUP ,PAY_END_DT ,OFF_CYCLE ,PAGE_NUM ,LINE_NUM ,SEPCHK ,FORM_ID ,PAYCHECK_NBR ,EMPLID ,EMPL_RCD ,NAME ,TOTAL_GROSS ,TOTAL_TAXES ,TOTAL_DEDUCTIONS ,NET_PAY ,CHECK_DT ,PAYCHECK_STATUS ,PAYCHECK_OPTION ,PAYCHECK_ADDR_OPTN ,PAYCHECK_NAME ,LOCATION ,PAY_SHEET_SRC FROM PS_PAY_CHECK

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: HCR_COMPANY_I

2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

Prompt Table: SSF_PAYGRP_VW

3 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date

Prompt Table: SSF_PAY_CALNDR

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 FORM_ID Character(6) VARCHAR2(6) NOT NULL Form Identification
9 PAYCHECK_NBR Number(15,0) DECIMAL(15) NOT NULL Paycheck number.
10 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
11 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
12 NAME Character(50) VARCHAR2(50) NOT NULL Name
13 TOTAL_GROSS Signed Number(12,2) DECIMAL(10,2) NOT NULL Total Gross
14 TOTAL_TAXES Signed Number(12,2) DECIMAL(10,2) NOT NULL Total Taxes
15 TOTAL_DEDUCTIONS Signed Number(12,2) DECIMAL(10,2) NOT NULL Total Deductions
16 NET_PAY Signed Number(12,2) DECIMAL(10,2) NOT NULL Net Pay
17 CHECK_DT Date(10) DATE Check date.
18 PAYCHECK_STATUS Character(1) VARCHAR2(1) NOT NULL Paycheck status.
A=Adjusted
C=Calculated
F=Confirmed
R=Reversed
V=Reversing Check
19 PAYCHECK_OPTION Character(1) VARCHAR2(1) NOT NULL Paycheck Option
&=Check and Advice
A=Advice
C=Check
M=Manual Check
R=Check Reversal
20 PAYCHECK_ADDR_OPTN Character(1) VARCHAR2(1) NOT NULL Paycheck Address Option
1=Home Address
2=Mailing Address
3=Check Address
C=Check Address
E=Select on Payroll Options Page
H=Home Address
M=Mailing Address

Default Value: H

21 PAYCHECK_NAME Character(50) VARCHAR2(50) NOT NULL Paycheck Name
22 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
23 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