USERIDPERSON_IDBUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_SP_NONVW
TE_TEMPLATE_IDPrompt Table: SPA_SP_RTMPL_VW
Prompt Table: SPA_SP_RC_PD_VW
SPA_EMP_RC_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT O.ROLEUSER ,W.WO_CONID ,W.BUSINESS_UNIT ,W.TE_TEMPLATE_ID , ' ' , B.DESCRSHORT FROM PS_SPF_WORDERREC W , PS_BUS_UNIT_TBL_FS B , PS_ROLEXLATOPR O WHERE W.WO_STATUS IN ('C','F','L','T') AND W.SERVICE_METHOD = 'R' AND W.BUSINESS_UNIT = B.BUSINESS_UNIT 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 Prompt Table: SP_BU_SP_NONVW |
| 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.
Prompt Table: SPA_SP_RTMPL_VW |
| 5 | SPA_DATE_RANGE | Character(23) | VARCHAR2(23) NOT NULL |
Date Range
Prompt Table: SPA_SP_RC_PD_VW |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |