TL_TIME_STATUS(SQL Table) |
Index Back |
|---|---|
TL_TIME_STATUS stagingStaging table foTL Time Status pivot grid |
| # | 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 | SUPERVISOR_ID |
Character(11) | VARCHAR2(11) NOT NULL | Supervisor ID |
| 6 | REPORTS_TO |
Character(8) | VARCHAR2(8) NOT NULL | Reports To Position Number |
| 7 | FIRST_NAME |
Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 8 | LAST_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 9 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 10 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 11 | JOB_DESCR |
Character(30) | VARCHAR2(30) NOT NULL | Job Description |
| 12 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL | Department |
| 13 | LOCATION |
Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 14 | PUNCH_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Global Punch Types
0=Elapsed 1=In 2=Out 3=Meal 4=Break 5=Transfer |
| 15 | PUNCH_TIME | Time(15) | TIMESTAMP | punch time |
| 16 | TL_QUANTITY | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | This field represents the measure of Work in hrs,amount etc., |
| 17 | REPORTED_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Reported Status
AP=Approved DN=Denied IP=Approval In Process NA=Needs Approval NW=New PB=Pushed Back PR=Processed SB=Submitted SV=Saved |
| 18 | REPORTED_STATUS_PG | Character(2) | VARCHAR2(2) NOT NULL |
Reported Status for Pivot Grid
AP=Approved DN=Denied EX=Exception IP=Approval In Process MS=Missing NA=Needs Approval NW=New PB=Pushed Back PR=Processed SB=Submitted SV=Saved |
| 19 | TRC | Character(5) | VARCHAR2(5) NOT NULL | Time Reporting Code used to report time in Time and Labor |
| 20 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project/Grant |
| 21 | APPROVER_NAME | Character(50) | VARCHAR2(50) NOT NULL | Approver Name |
| 22 | ORIGINATORID | Character(30) | VARCHAR2(30) NOT NULL | Originator Identifier |
| 23 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 24 | BUSINESS_DESCR | Character(60) | VARCHAR2(60) NOT NULL | Business Description |
| 25 | DEPT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Department Description |
| 26 | LOCATION_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Location Description |
| 27 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 28 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 29 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 30 | WORKGROUP | Character(10) | VARCHAR2(10) NOT NULL | Workgroup |
| 31 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 32 | TASKGROUP | Character(10) | VARCHAR2(10) NOT NULL | Taskgroup |
| 33 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |
| 34 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 35 | DESCR3 | Character(30) | VARCHAR2(30) NOT NULL | Descr 3 |
| 36 | TASK_PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL | Task Profile ID |
| 37 | DESCR4 | Character(30) | VARCHAR2(30) NOT NULL | Descr 4 |
| 38 | DATETIME_CREATED | DateTime(26) | TIMESTAMP | DateTime Created |
| 39 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |