PAY_OL_CS_US_VW

(SQL View)
 Index Back

SrchRec Online Results (SF)

This record contains employee paycheck key information and is used to access Online Results panel for USA. The BUS_UNIT_TBL_SF is included in the select to restrict data to only those Company's and Paygroup's which are defined in Student Financials.

SELECT DISTINCT D.BUSINESS_UNIT ,A.COMPANY ,A.PAYGROUP ,A.PAY_END_DT ,A.OFF_CYCLE ,A.PAGE_NUM ,A.LINE_NUM ,A.SEPCHK ,A.FORM_ID ,A.PAYCHECK_NBR ,A.EMPLID ,A.NAME FROM PS_PAY_CHECK A ,PS_PAY_EARNINGS B ,PS_PAYGROUP_TBL C ,PS_REFUND_HDR D WHERE A.COMPANY=D.COMPANY AND A.PAYGROUP=D.PAYGROUP AND A.PAY_END_DT = D.PAY_END_DT AND A.PAGE_NUM = D.PAGE_NUM AND A.COMPANY=B.COMPANY AND A.PAYGROUP=B.PAYGROUP AND A.PAY_END_DT=B.PAY_END_DT AND A.OFF_CYCLE=B.OFF_CYCLE AND A.PAGE_NUM=B.PAGE_NUM AND A.LINE_NUM=B.LINE_NUM AND A.SEPCHK=B.SEPCHK AND B.PAY_LINE_STATUS IN ('C','F') AND A.COMPANY=C.COMPANY AND A.PAYGROUP=C.PAYGROUP AND C.COUNTRY<>'CAN' AND A.PAY_SHEET_SRC = 'O'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT

Prompt Table: SP_BU_SF_NONVW

2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: HCR_COMPANY_I

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

Prompt Table: SSF_PAYGRP_VW

4 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date
5 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

Y/N Table Edit

Default Value: Y

6 PAGE_NUM Number(4,0) SMALLINT NOT NULL Page #
7 LINE_NUM Number(2,0) SMALLINT NOT NULL Line #
8 SEPCHK Number(1,0) SMALLINT NOT NULL Separate check number.
9 FORM_ID Character(6) VARCHAR2(6) NOT NULL Form Identification
10 PAYCHECK_NBR Number(15,0) DECIMAL(15) NOT NULL Paycheck number.
11 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
12 NAME Character(50) VARCHAR2(50) NOT NULL Name