TL_JOB_EMPL_PAY

(SQL View)
 Index Back

Job with PayTime and PayGroup

Job Data with Payable Time and Pay Group

SELECT P.EMPLID ,P.EMPL_RCD ,P.DUR ,P.SEQ_NBR ,J.FIRST_NAME ,J.LAST_NAME ,J.BUSINESS_UNIT ,J.JOBCODE ,J.DEPTID ,J.SUPERVISOR_ID ,J.REPORTS_TO ,J.LOCATION ,J.COMPANY ,J.PAYGROUP ,J.GP_PAYGROUP FROM PS_TL_PAYABLE_TIME P , PS_TL_JOB_EMPL_DAT J WHERE J.EMPLID= P.EMPLID AND J.EMPL_RCD = P.EMPL_RCD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 DUR Date(10) DATE Date Under Report associates time being reported, scheduled or paid, to a specific date.
4 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
5 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
6 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
8 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
9 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
10 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID
11 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number
12 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
13 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
14 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
15 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group