TL_JOB_EMPL_PAY(SQL View) |
Index Back |
---|---|
Job with PayTime and PayGroupJob 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 |