BUSINESS_UNITPrompt Table: SP_BU_PC_NONVW
FO_BRANCHDefault Value: OPR_DEF_TBL_FO.FO_BRANCH
Prompt Table: SP_BR_FO_NONVW
SO_IDDefault Value: NEXT
USER_ORDER_TYPEDefault Value: OPR_DEF_TBL_FO.USER_ORDER_TYPE
Prompt Table: FO_ORDER_TYPE
FO_ORDR_ADD_VW(SQL View) |
Index Back |
|---|---|
Staffing Order Search VWStaffing Front Office Order Search View |
| SELECT BUSINESS_UNIT ,%Substring(OWNERSHIP_ID, 1, 5) ,SO_ID ,USER_ORDER_TYPE FROM PS_RS_SO_HDR WHERE SYSTEM_SOURCE = 'STF' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 2 | FO_BRANCH |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FO.FO_BRANCH Prompt Table: SP_BR_FO_NONVW |
| 3 | SO_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Service Order ID
Default Value: NEXT |
| 4 | USER_ORDER_TYPE |
Character(5) | VARCHAR2(5) NOT NULL |
User Order Type
Default Value: OPR_DEF_TBL_FO.USER_ORDER_TYPE Prompt Table: FO_ORDER_TYPE |