SPF_SRC_RQML_VW

(SQL View)
 Index Back

SP Requisition Line View

A view of the entire SPF_REQ_LINE record. This view contains no where clauses so it could be reused by appending the appropriate filter(s). SELECT A.BUSINESS_UNIT , A.SP_REQ_ID , A.LINE_NBR , A.SP_REQ_STATUS , A.HOLD_STATUS , A.IN_PROCESS_FLG , A.BUSINESS_UNIT_PC , A.PROJECT_ID , A.DESCR , A.DEPTID , A.SP_DURATION , A.START_DATE , A.END_DATE , A.TELECOMMUTE , A.SPF_RATE , A.SP_RATE_UOM , A.UNIT_OF_MEASURE , A.JOB_TITLE , A.ROLE_TYPE , A.PROJ_ROLE , A.LOCATION , A.EDUCATION_LVL , A.SPF_YRS_EXPERIENCE , A.COMPETENCY_DESC , A.INTERVIEWREQUIRED , A.TRAVEL_REQUIRED , A.TRAVEL_FREQUENCY , A.CONTRACT_FOR_HIRE , A.CURRENCY_CD , A.OPRID_APPROVED_BY , A.APPROVAL_DT , A.REQUESTOR_ID , A.RECRUITER , A.TE_APPROVER , A.SPF_SPLR_RATE , A.SP_SPLR_RATE_UOM , A.CURRENCY_CD_SPLR , A.SPF_REQ_LN_TOTAL , A.EXPENSES_INCLUDED , A.OVERTIME_PERMITTED , A.SPF_EXTERNAL , A.SPF_CUST_COMPANY , A.COMMENTS_254 , A.ROW_CREATE_DATE , A.ROW_MODIFY_DATE , A.ROW_CREATE_USER , A.ROW_MODIFY_USER , B.SPF_JOB_DESCRLONG FROM PS_SPF_REQ_LINE A , PS_SPF_REQ_LINE_JD B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SP_REQ_ID = B.SP_REQ_ID AND A.LINE_NBR = B.LINE_NBR

SELECT A.BUSINESS_UNIT , A.SP_REQ_ID , A.LINE_NBR , A.START_DATE , A.END_DATE , A.SPF_RATE , A.UNIT_OF_MEASURE , A.ROLE_TYPE , A.PROJ_ROLE , A.INTERVIEWREQUIRED , A.LOCATION , A.DURATION , A.SP_NUM_OF_POSITION , P.SP_PAY_RATE FROM PS_SPF_REQ_LINE A , PS_SPF_REQ_LINE_JD B , PS_SPF_REQ_LINE_PT P WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SP_REQ_ID = B.SP_REQ_ID AND A.LINE_NBR = B.LINE_NBR AND P.BUSINESS_UNIT = A.BUSINESS_UNIT AND P.SP_REQ_ID = A.SP_REQ_ID AND P.LINE_NBR = A.LINE_NBR AND A.LINE_NBR <> 1

  • Parent record: SPF_REQ_HDR

    • # 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_PM_NONVW

    2 SP_REQ_ID Character(10) VARCHAR2(10) NOT NULL Service Request ID
    3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
    4 START_DATE Date(10) DATE Start Date for Gen Standing PO
    5 END_DATE Date(10) DATE End Date
    6 SPF_RATE Signed Number(16,4) DECIMAL(14,4) NOT NULL Rate
    7 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage
    8 ROLE_TYPE Character(6) VARCHAR2(6) NOT NULL Service Type
    APR=Approver
    MGR=Manager
    OPR=Operator
    9 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
    10 INTERVIEWREQUIRED Character(1) VARCHAR2(1) NOT NULL Interview Required
    N=No
    Y=Yes
    11 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: %EDITTABLE

    12 DURATION Number(5,0) INTEGER NOT NULL Recurrence Duration
    13 SP_NUM_OF_POSITION Number(5,0) INTEGER NOT NULL Number of Positions
    14 SP_PAY_RATE Number(15,4) DECIMAL(14,4) NOT NULL pay rate