USERIDPERSON_IDBUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
TE_TEMPLATE_IDWORK_ORDER_IDSPA_EMP_RC_WO_V(SQL View) |
Index Back |
|---|
| SELECT DISTINCT O.ROLEUSER ,W.WO_CONID ,W.BUSINESS_UNIT ,W.TE_TEMPLATE_ID ,W.WORK_ORDER_ID ,W.ACT_START_DT ,W.END_DATE , W.WO_NAME FROM PS_SPF_WORDERREC W , PS_ROLEXLATOPR O WHERE W.WO_STATUS IN ('C','F','L','T') AND W.SERVICE_METHOD = 'R' AND O.ROLEUSER IN (W.WO_CLIID, W.RECRUITER, W.SP_REPORT_TO_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | USERID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 2 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT |
| 4 | TE_TEMPLATE_ID |
Character(8) | VARCHAR2(8) NOT NULL | Used to define a particular type of travel, i.e. company relocation, internal travel, etc. Determines what type of expenses and expenditure limits are associated with that particular type of travel. Established in the Structure Expenses system and chosen on the header panel of cash expense sheets. |
| 5 | WORK_ORDER_ID |
Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |
| 6 | ACT_START_DT | Date(10) | DATE | Activity Start Date |
| 7 | ACT_END_DT | Date(10) | DATE | Activity End Date |
| 8 | WO_NAME | Character(30) | VARCHAR2(30) NOT NULL | Work Order Name |