PAY_CHECK_NUMVW

(SQL View)
 Index Back

Confirmed Check View

This record contains paycheck status information

SELECT A.PAYCHECK_NBR ,A.CHECK_DT ,A.COMPANY ,A.PAYGROUP ,A.PAY_END_DT ,A.OFF_CYCLE ,A.PAGE_NUM ,A.LINE_NUM ,A.SEPCHK ,A.EMPLID ,A.EMPL_RCD ,A.NAME ,A.DEPTID ,A.EMPL_TYPE ,A.SSN ,A.SIN ,A.TOTAL_GROSS ,A.TOTAL_TAXES ,A.TOTAL_DEDUCTIONS ,A.NET_PAY ,A.PAYCHECK_STATUS ,A.PAYCHECK_OPTION ,A.PAYCHECK_ADJUST ,A.PAYCHECK_REPRINT ,A.PAYCHECK_CASHED ,A.PAYCHECK_ADDR_OPTN ,A.PAYCHECK_NAME ,A.ADDRESS1 ,A.ADDRESS2 ,A.ADDRESS3 ,A.ADDRESS4 ,A.CITY ,A.COUNTY ,A.STATE ,A.POSTAL ,A.COUNTRY ,A.LOCATION ,A.BENEFIT_RCD_NBR ,A.BUSINESS_UNIT FROM PS_PAY_CHECK A WHERE A.PAYCHECK_STATUS IN ('F','A') AND A.PAYCHECK_OPTION<>'R' AND A.PAYCHECK_NBR<>0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PAYCHECK_NBR Number(15,0) DECIMAL(15) NOT NULL Paycheck number.
2 CHECK_DT Date(10) DATE Check date.
3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

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

Prompt Table: PAYGROUP_TBL

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

Prompt Table: PAY_CALENDAR

6 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

Y/N Table Edit

7 PAGE_NUM Number(5,0) INTEGER NOT NULL Page Nbr

Prompt Table: PAY_PAGE

8 LINE_NUM Number(3,0) SMALLINT NOT NULL Line Nbr

Prompt Table: PAY_LINE

9 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.
10 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
11 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
12 NAME Character(50) VARCHAR2(50) NOT NULL Name
13 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
14 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
E=Exception Hourly
H=Hourly
N=Not Applicable
S=Salaried
15 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #
16 SIN Character(9) VARCHAR2(9) NOT NULL Social Insurance Nbr
17 TOTAL_GROSS Signed Number(12,2) DECIMAL(10,2) NOT NULL Total Gross
18 TOTAL_TAXES Signed Number(12,2) DECIMAL(10,2) NOT NULL Total Taxes
19 TOTAL_DEDUCTIONS Signed Number(12,2) DECIMAL(10,2) NOT NULL Total Deductions
20 NET_PAY Signed Number(12,2) DECIMAL(10,2) NOT NULL Net Pay
21 PAYCHECK_STATUS Character(1) VARCHAR2(1) NOT NULL Paycheck status.
A=Adjusted
C=Calculated
F=Confirmed
R=Reversed
V=Reversing Check
22 PAYCHECK_OPTION Character(1) VARCHAR2(1) NOT NULL Paycheck Option
&=Check and Advice
A=Advice
C=Check
M=Manual Check
R=Check Reversal
23 PAYCHECK_ADJUST Character(1) VARCHAR2(1) NOT NULL Paycheck Adjustment Entry
N=Reversal
Y=Reversal/Adjustment

Y/N Table Edit

24 PAYCHECK_REPRINT Character(1) VARCHAR2(1) NOT NULL Paycheck Reprint

Y/N Table Edit

25 PAYCHECK_CASHED Character(1) VARCHAR2(1) NOT NULL Paycheck Cashed

Y/N Table Edit

26 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
27 PAYCHECK_NAME Character(50) VARCHAR2(50) NOT NULL Paycheck Name
28 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
29 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
30 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
31 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
32 CITY Character(30) VARCHAR2(30) NOT NULL City
33 COUNTY Character(30) VARCHAR2(30) NOT NULL County
34 STATE Character(6) VARCHAR2(6) NOT NULL State
35 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
36 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
37 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
38 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.

Default Value: PER_ORG_ASGN_VW.EMPL_RCD

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

Prompt Table: BUS_UNIT_TBL_HR