TL_JOB_EMPL_DAT(SQL Table) |
Index Back |
|---|---|
Job data & TL_EMPL_DATA stageStaging table for JOB and TL_EMPL_DATA |
| # | 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 | FIRST_NAME |
Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 4 | LAST_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 5 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 7 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL | Department |
| 8 | SUPERVISOR_ID |
Character(11) | VARCHAR2(11) NOT NULL | Supervisor ID |
| 9 | REPORTS_TO |
Character(8) | VARCHAR2(8) NOT NULL | Reports To Position Number |
| 10 | LOCATION |
Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 11 | JOB_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Job Description |
| 12 | EMPL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Employee Type
E=Exception Hourly H=Hourly N=Not Applicable S=Salaried |
| 13 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 14 | BUSINESS_DESCR | Character(60) | VARCHAR2(60) NOT NULL | Business Description |
| 15 | DEPT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Department Description |
| 16 | LOCATION_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Location Description |
| 17 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 18 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 19 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 20 | WORKGROUP | Character(10) | VARCHAR2(10) NOT NULL | Workgroup |
| 21 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 22 | TASKGROUP | Character(10) | VARCHAR2(10) NOT NULL | Taskgroup |
| 23 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |
| 24 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 25 | DESCR3 | Character(30) | VARCHAR2(30) NOT NULL | Descr 3 |
| 26 | TASK_PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL | Task Profile ID |
| 27 | DESCR4 | Character(30) | VARCHAR2(30) NOT NULL | Descr 4 |
| 28 | UNION_CD | Character(3) | VARCHAR2(3) NOT NULL | Union Code |
| 29 | DESCR5 | Character(30) | VARCHAR2(30) NOT NULL | This field is used in a complex query that shows many descr fields. |
| 30 | SHIFT | Character(1) | VARCHAR2(1) NOT NULL |
Regular Shift
1=Day 2=Evening 3=Night A=Any C=Compressed N=Not Applicable R=Rotating |
| 31 | DESCR6 | Character(30) | VARCHAR2(30) NOT NULL | This field is used in a complex query that shows many descr fields. |
| 32 | PERIOD_ID | Character(12) | VARCHAR2(12) NOT NULL | Time Period ID |
| 33 | EFFDT_SELECT | Date(10) | DATE | Effective Date |
| 34 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 35 | EFFDT_USED | Date(10) | DATE | Date driving 'processed' code |
| 36 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL | Job Code Set ID |
| 37 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department Set ID |
| 38 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location Set ID |
| 39 | PER_ORG | Character(3) | VARCHAR2(3) NOT NULL |
Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
CWR=Contingent Worker EMP=Employee POI=Person of Interest |