ZZ_PCHK_S_VW

(SQL View)
Index Back

U.S. Pay Chk Vw Summary Dept

This record contains emplooyee paycheck key information.

SELECT A.COMPANY ,A.PAYGROUP ,A.PAY_END_DT ,A.OFF_CYCLE ,A.PAGE_NUM ,A.LINE_NUM ,A.SEPCHK ,A.FORM_ID ,B.OPRID ,A.PAYCHECK_NBR ,A.EMPLID ,A.NAME FROM PS_PAY_CHECK_S_VW A ,PS_PERS_SRCH_GBL B WHERE A.EMPLID = B.EMPLID

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

Prompt Table: COMPANY_TBL

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

Prompt Table: PAYGROUP_TBL

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

Prompt Table: PAY_CALENDAR

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 #

Prompt Table: PAY_PAGE

6 LINE_NUM Number(2,0) SMALLINT NOT NULL Line #

Prompt Table: PAY_LINE

7 SEPCHK Number(1,0) SMALLINT NOT NULL Separate check number.
8 FORM_ID Character(6) VARCHAR2(6) NOT NULL Form Identification
9 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
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