EMPLIDWM_TRC_DESCRWM_TIME_QUIK_VW(SQL View) |
Index Back |
|---|---|
Time Entry Recent Work OrdersTime Entry Recent Work Orders view |
| SELECT DISTINCT D.EMPLID , D.WO_ID %Concat ' - ' %Concat %Sql(PTIA_LTRIM_WM,D.WO_TASK_ID) , D.TRC , ' ' , D.BUSINESS_UNIT , D.WO_ID , D.WO_TASK_ID , D.DESCR254 FROM PS_WM_TIME_DTL_VW D WHERE %DateDiff(D.PERIOD_END_DT, %CurrentDateIn) <= 30 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | WM_TRC_DESCR |
Character(100) | VARCHAR2(100) NOT NULL | Quick Fill / Time Reporting Code combo selection dropdown field |
| 3 | TRC | Character(5) | VARCHAR2(5) NOT NULL | Time Reporting Code |
| 4 | TIME_SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Time Sheet Unique Identifier (System Generated) |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | WO_ID | Character(10) | VARCHAR2(10) NOT NULL | Work Order Identification |
| 7 | WO_TASK_ID | Number(5,0) | INTEGER NOT NULL | Task Number |
| 8 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |