SPF_REQ_SERV_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.SP_REQ_STATUS , A.DESCR , A.SP_DURATION , A.START_DATE , A.END_DATE , A.SPF_RATE , A.SP_RATE_UOM , A.UNIT_OF_MEASURE , A.JOB_TITLE , A.ROLE_TYPE , A.PROJ_ROLE , A.LOCATION , A.CURRENCY_CD , A.REQUESTOR_ID , A.RECRUITER , A.SPF_REQ_LN_TOTAL , A.EXPENSES_INCLUDED , A.DURATION , A.SERVICE_METHOD ,A.TEAM_ID ,A.SP_NUM_OF_POSITION ,A.SP_NUM_FILLED_POS , A.SPA_USE_EXPENSES , 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 AND A.SERVICE_METHOD = 'R' AND A.SUB_LINE = 'Y'

  • 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

    Default Value: NEXT

    3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

    Default Value: 1

    4 SP_REQ_STATUS Character(4) VARCHAR2(4) NOT NULL Requisition Status for Service Procurement
    A=Approved
    C=Complete
    D=Denied
    F=Filled
    O=Open
    P=Pending
    R=On Hold
    S=Sourced
    X=Canceled
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 SP_DURATION Character(4) VARCHAR2(4) NOT NULL Duration field
    -1=No Perference
    1=Less than 1 month
    2=1-3 months
    3=3-6 months
    4=6-12 months
    5=More than 12 months
    7 START_DATE Date(10) DATE Start Date for Gen Standing PO
    8 END_DATE Date(10) DATE End Date
    9 SPF_RATE Signed Number(16,4) DECIMAL(14,4) NOT NULL Rate
    10 SP_RATE_UOM Character(3) VARCHAR2(3) NOT NULL Rate Unit of Measure
    11 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage
    12 JOB_TITLE Character(50) VARCHAR2(50) NOT NULL Job Title
    13 ROLE_TYPE Character(6) VARCHAR2(6) NOT NULL Service Type
    APR=Approver
    MGR=Manager
    OPR=Operator
    14 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
    15 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: LOCATION_TBL
    Set Control Field: LOCATION

    16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: REQ_HDR.CURRENCY_CD

    17 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
    18 RECRUITER Character(15) VARCHAR2(15) NOT NULL Service Coordinator
    19 SPF_REQ_LN_TOTAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Stores the supplier's total rate.
    20 EXPENSES_INCLUDED Character(4) VARCHAR2(4) NOT NULL Expenses Included
    1=Not applicable
    2=Included in rate
    3=Per diem
    4=Actual
    21 DURATION Number(5,0) INTEGER NOT NULL Recurrence Duration
    22 SERVICE_METHOD Character(1) VARCHAR2(1) NOT NULL Service Method
    D=Deliverable
    M=Multi Resource
    R=Resource

    Default Value: R

    23 TEAM_ID Character(15) VARCHAR2(15) NOT NULL Team ID
    24 SP_NUM_OF_POSITION Number(5,0) INTEGER NOT NULL Number of Positions

    Default Value: 1

    25 SP_NUM_FILLED_POS Number(5,0) INTEGER NOT NULL Number of filled Positions

    Default Value: 0

    26 SPA_USE_EXPENSES Character(1) VARCHAR2(1) NOT NULL Field to indicate if the expenses is allowed in the transcation or not.
    D=Default from Business Unit
    N=No
    Y=Yes

    Default Value: N

    27 SPF_JOB_DESCRLONG Long Character CLOB stores the job description for a sp requisition.