PV_MOB_TRK_VW2(SQL View) |
Index Back |
---|
SELECT DISTINCT A.BUSINESS_UNIT , A.REQ_ID , A.REQUESTOR_ID FROM PS_PV_MOB_TRK_VW A |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PM_NONVW |
|
2 | Character(10) | VARCHAR2(10) NOT NULL | Requisition ID | |
3 | REQUESTOR_ID | Character(30) | VARCHAR2(30) NOT NULL |
Requestor id
Prompt Table: %EDITTABLE16 |