SPF_WO_TRKSP_VW

(SQL View)
 Index Back

Track Resources on WorkOrder

Track Resources on WorkOrder

SELECT A.BUSINESS_UNIT , A.WORK_ORDER_ID , A.ROW_CREATE_USER , A.PERSON_ID , B.FIRST_NAME , B.LAST_NAME , A.START_DATE , A.END_DATE , A.SP_PREMISE_LOC , A.COMMENTS_254 FROM PS_SPF_WO_TRK_RSRC A , PS_SPF_WORDERREC W , PS_SPB_PERSON_TBL B WHERE A.BUSINESS_UNIT = W.BUSINESS_UNIT AND A.WORK_ORDER_ID = W.WORK_ORDER_ID AND (A.ROW_CREATE_USER = %OperatorId OR A.ROW_CREATE_USER = W.ROW_CREATE_USER OR A.ROW_CREATE_USER = W.WO_CLIID OR A.ROW_CREATE_USER IN ( SELECT OPRID FROM PSOPRALIAS P WHERE (P.PERSON_ID = W.PROVIDER_CONTACT OR P.PERSON_ID = W.RECRUITER) AND P.OPRALIASTYPE = 'SPP')) AND A.PERSON_ID = B.PERSON_ID AND A.ACTIVE_FLAG = 'A'

  • Parent record: SPF_WORDERREC

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
    3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    4 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

    Prompt Table: SPB_SRVC_PRV_VW
    Set Control Field: BUSINESS_UNIT

    5 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    6 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    7 START_DATE Date(10) DATE Start Date for Gen Standing PO
    8 END_DATE Date(10) DATE End Date
    9 SP_PREMISE_LOC Character(1) VARCHAR2(1) NOT NULL Premise Location
    N=No
    Y=Yes
    10 COMMENTS_254 Character(254) VARCHAR2(254) NOT NULL EDI Comments