PAY_LINE_WORK

(SQL View)
 Index Back

U.S. Pay Line View

This record is used by Payroll to view Pay Line data.

SELECT A.COMPANY ,A.PAYGROUP ,A.PAY_END_DT ,A.OFF_CYCLE ,A.PAGE_NUM ,A.LINE_NUM ,A.EMPLID ,A.EMPL_RCD ,A.JOB_CHANGE ,A.PARTIAL_PERIOD ,A.DEPTID ,A.NAME ,A.SINGLE_CHECK_USE ,A.BUSINESS_UNIT ,A.LOCKED_FOR_CONF FROM PS_PAY_LINE A ,PS_PAYGROUP_TBL C WHERE A.CONFIRMED='N' AND A.SINGLE_CHECK_USE IN ('N', 'P') AND A.COMPANY=C.COMPANY AND A.PAYGROUP=C.PAYGROUP AND C.COUNTRY<>'CAN'

  • Parent record: PAY_PAGE

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

    Prompt Table: PAY_LINE_CO_VW

    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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    8 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    9 JOB_CHANGE Character(1) VARCHAR2(1) NOT NULL Job Pay Data Change
    N=No
    R=Calculation Required
    Y=Yes
    10 PARTIAL_PERIOD Character(1) VARCHAR2(1) NOT NULL Partial Pay Period

    Y/N Table Edit

    11 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    12 NAME Character(50) VARCHAR2(50) NOT NULL Name
    13 SINGLE_CHECK_USE Character(1) VARCHAR2(1) NOT NULL How is Single Check Used
    C=Check Only
    N=Not Applicable
    P=Paysheet Only
    14 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_HR

    15 LOCKED_FOR_CONF Character(1) VARCHAR2(1) NOT NULL Locked for Confirm