SPF_REQ_LN_EXT

(SQL Table)
 Index Back

SP Requisition Line

Services Procurement Requisition line. Child table of SPF_REQ_HDR.

  • 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

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_SP_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

    Default Value: O

    5 HOLD_STATUS Character(1) VARCHAR2(1) NOT NULL Hold From Further Processing
    6 CHANGE_STATUS Character(1) VARCHAR2(1) NOT NULL Change Order Status
    C=Changed
    U=Unchanged

    Default Value: U

    7 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

    Y/N Table Edit

    Default Value: N

    8 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

    Prompt Table: SP_BU_PC_NONVW

    9 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

    Prompt Table: SPF_WPROJ_VW

    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    11 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: %EDITTABLE31
    Set Control Field: BUSINESS_UNIT_HR

    12 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
    13 START_DATE Date(10) DATE NOT NULL Start Date for Gen Standing PO
    14 END_DATE Date(10) DATE NOT NULL End Date
    15 TELECOMMUTE Character(1) VARCHAR2(1) NOT NULL Defines if the user telecommutes or not
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: Y

    16 SPF_RATE Signed Number(16,4) DECIMAL(14,4) NOT NULL Rate
    17 SP_RATE_UOM Character(3) VARCHAR2(3) NOT NULL Rate Unit of Measure

    Prompt Table: SPF_UOM_VW

    18 SPF_EXPENSE_RATE Signed Number(16,4) DECIMAL(14,4) NOT NULL Expense Rate
    19 SP_EXP_RATE_UOM Character(3) VARCHAR2(3) NOT NULL stores the supplier's rate uom

    Prompt Table: SPF_UOM_VW

    20 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage
    21 JOB_TITLE Character(50) VARCHAR2(50) NOT NULL Job Title
    22 ROLE_TYPE Character(6) VARCHAR2(6) NOT NULL Service Type
    APR=Approver
    MGR=Manager
    OPR=Operator

    Prompt Table: %EDITTABLE16
    Set Control Field: BUSINESS_UNIT

    23 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

    Prompt Table: %EDITTABLE
    Set Control Field: BUSINESS_UNIT

    24 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: SHIPTO_TBL

    25 EDUCATION_LVL Character(2) VARCHAR2(2) NOT NULL Education Level
    1=No Formal Education
    10=Associate Degree
    11=Three Years College
    12=Four Years College
    13=Bachelor Degree
    14=Post Bachelors
    15=First Professional
    16=Post-First Professional
    17=Masters Degree
    18=Post Masters
    19=Sixth Year Degree
    2=Elementary School Completed
    20=Post Sixth Year
    21=Doctorate Degree
    22=Post Doctorate
    3=Some High School
    4=High School Graduate
    5=Terminal Occupation Prog DNC
    6=Terminal Occupation Program
    7=Some College - Less than 1 Yr
    8=One Year College
    9=Two Years College
    A=University - Advanced
    T=Trade School
    U=University
    26 SPF_YRS_EXPERIENCE Character(4) VARCHAR2(4) NOT NULL Years Experience

    Prompt Table: SP_EXPERIENCE
    Set Control Field: BUSINESS_UNIT

    27 INTERVIEWREQUIRED Character(1) VARCHAR2(1) NOT NULL Interview Required
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: Y

    28 TRAVEL_REQUIRED Character(1) VARCHAR2(1) NOT NULL Travel Required
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    29 TRAVEL_FREQUENCY Number(3,0) SMALLINT NOT NULL Travel Frequency
    30 CONTRACT_FOR_HIRE Character(1) VARCHAR2(1) NOT NULL Contract for Hire

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: CURRENCY_CD_TBL

    32 OPRID_APPROVED_BY Character(30) VARCHAR2(30) NOT NULL Approved By
    33 APPROVAL_DT Date(10) DATE Date of Approval
    34 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id

    Default Value: SPF_REQ_HDR.REQUESTOR_ID

    Prompt Table: REQUESTOR_TBL

    35 RECRUITER Character(15) VARCHAR2(15) NOT NULL Service Coordinator

    Prompt Table: SP_SERVCO_NONVW

    36 TE_APPROVER Character(30) VARCHAR2(30) NOT NULL Time Approver

    Prompt Table: %EDITTABLE30
    Set Control Field: BUSINESS_UNIT

    37 SPF_SPLR_RATE Signed Number(16,4) DECIMAL(14,4) NOT NULL Stores the supplier rate.
    38 SP_SPLR_RATE_UOM Character(3) VARCHAR2(3) NOT NULL stores the supplier's rate uom

    Prompt Table: UNITS_TBL

    39 CURRENCY_CD_SPLR Character(3) VARCHAR2(3) NOT NULL Currency Code of the supplier

    Prompt Table: CURRENCY_CD_TBL

    40 SPF_REQ_LN_TOTAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Stores the supplier's total rate.
    41 EXPENSES_INCLUDED Character(4) VARCHAR2(4) NOT NULL Expenses Included
    1=Not applicable
    2=Included in rate
    3=Per diem
    4=Actual
    42 OVERTIME_PERMITTED Character(1) VARCHAR2(1) NOT NULL Overtime Permitted
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    43 SPF_EXTERNAL Character(1) VARCHAR2(1) NOT NULL External Company
    44 SPF_CUST_COMPANY Character(15) VARCHAR2(15) NOT NULL External Comapny
    45 COMMENTS_254 Character(254) VARCHAR2(254) NOT NULL EDI Comments
    46 SPF_JUSTIFICATION Character(254) VARCHAR2(254) NOT NULL Requisition Justification
    47 ROW_CREATE_DATE DateTime(26) TIMESTAMP Row Creation Date Time

    Default Value: %DateTime

    48 ROW_MODIFY_DATE DateTime(26) TIMESTAMP Modified Date Time

    Default Value: %DateTime

    49 ROW_CREATE_USER Character(30) VARCHAR2(30) NOT NULL Row Added By
    50 ROW_MODIFY_USER Character(30) VARCHAR2(30) NOT NULL Modified User
    51 COMPETENCY_DESC Long Character CLOB Competencies Required
    52 SP_UTILIZATION Number(3,0) SMALLINT NOT NULL Utilization%

    Default Value: 100

    53 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

    Default Value: BUS_UNIT_TBL_PM.CURRENCY_CD

    54 SPF_RATE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Base Rate field for sPro Requisitions
    55 SPF_LN_TOTAL_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Requisition line total in Base currency
    56 SPF_FILL_CURR_CD Character(3) VARCHAR2(3) NOT NULL Requisition filled currency code

    Prompt Table: CURRENCY_CD_TBL

    57 SPF_RATE_FILL Signed Number(16,4) DECIMAL(14,4) NOT NULL Filled Rate
    58 SPF_RATE_FILL_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Filled Rate in Base currency
    59 SPF_LN_FILL_TOTAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Requisition line Filled total
    60 SPF_LN_FIL_TOT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Requisition line Filled total in Base currency
    61 SPF_EXP_RATE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Expense Rate in base currency
    62 SPF_EXPENSE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total expense amount.
    63 SPF_EXP_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Total expense amount for base currency
    64 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
    65 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

    Default Value: 1

    66 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

    Default Value: BUS_UNIT_TBL_PM.RT_TYPE

    67 RATE_EFFDT Date(10) DATE Rate Effective Date

    Default Value: %date

    68 DURATION Number(5,0) INTEGER NOT NULL Recurrence Duration
    69 DAYS_UOM Character(3) VARCHAR2(3) NOT NULL the unit of measure for days

    Prompt Table: UNITS_TBL

    70 SERVICE_METHOD Character(1) VARCHAR2(1) NOT NULL Service Method
    D=Deliverable
    M=Multi Resource
    R=Resource

    Default Value: R

    71 SP_BILL_METHOD Character(1) VARCHAR2(1) NOT NULL Used in Service Based Workorders to identify the billing method.
    F=Fixed Amount
    M=Milestone
    P=Percentage
    R=Rate Based
    72 SP_SHOW_BID Character(1) VARCHAR2(1) NOT NULL Show Bid
    N=Hide Rate
    Y=Display Rate

    Default Value: N

    73 SP_ORIGIN_TYPE Character(3) VARCHAR2(3) NOT NULL Requisition Origin Type - Original Extended Copied Consolidated Linked
    EXT=Extended Requisition
    ORG=Original Requisition

    Default Value: ORG

    74 SP_LINKED_REQ_ID Character(10) VARCHAR2(10) NOT NULL Service Request Lined Req. ID
    75 SP_LINKED_LINENUM Number(5,0) INTEGER NOT NULL Linked sPro Req. ID Line number
    76 SP_REQ_TYPE Character(10) VARCHAR2(10) NOT NULL Request type - reason code

    Prompt Table: SP_REQUEST_TYPE

    77 SP_NUM_OF_POSITION Number(5,0) INTEGER NOT NULL Number of Positions

    Default Value: 1

    78 TEAM_ID Character(15) VARCHAR2(15) NOT NULL Team ID

    Prompt Table: SPB_TEAM_ID_VW

    79 SP_EXTENDED_FLG Character(1) VARCHAR2(1) NOT NULL Requisition has been extended.

    Y/N Table Edit

    Default Value: N

    80 SRC_ASSIGNED Character(1) VARCHAR2(1) NOT NULL Service Coordinator assigned?

    Y/N Table Edit

    Default Value: Y

    81 SP_MSP_PERCENT Number(6,2) DECIMAL(5,2) NOT NULL MSP percent
    82 WO_CONID Character(15) VARCHAR2(15) NOT NULL Service Provider's ID assigned on work order
    83 SP_NUM_FILLED_POS Number(5,0) INTEGER NOT NULL Number of filled Positions

    Default Value: 0

    84 FIRSTDAY_CONTAC_ID Character(15) VARCHAR2(15) NOT NULL Person ID - first day contact -

    Prompt Table: PO_OPRDEFN_VW

    85 HEALTH_CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Person ID - Health and Safety contact -

    Prompt Table: PO_OPRDEFN_VW

    86 SP_REPORT_TO_ID Character(15) VARCHAR2(15) NOT NULL Person ID - Report-to person

    Prompt Table: PO_OPRDEFN_VW

    87 SP_SAFETY_YESNO Character(1) VARCHAR2(1) NOT NULL Safety equipment required?

    Y/N Table Edit

    88 SHIFT_ID Character(10) VARCHAR2(10) NOT NULL Shift ID

    Prompt Table: SPB_SHIFT

    89 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

    90 MS_RATE Signed Number(16,4) DECIMAL(14,4) NOT NULL Rate charged by either the Vendor Managed Service (VMS) Supplier or the Managed Service Provider (MSP) organization
    91 MS_RATE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Rate charged by either the Vendor Managed Service (VMS) Supplier or the Managed Service Provider (MSP) organization
    92 SPF_SPLR_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Stores the supplier's amount
    93 SP_EXP_APPROVER Character(30) VARCHAR2(30) NOT NULL Expense Approver
    94 SUB_LINE Character(1) VARCHAR2(1) NOT NULL Sub Line
    N=No
    Y=Yes

    Default Value: N

    95 MRSC_PARENT_LINE Number(5,0) INTEGER NOT NULL Multi resource Parent Line number
    96 PV_SP_ORIGIN Character(2) VARCHAR2(2) NOT NULL RM -> Resource Management LB --> ePro Left Browser. SR --> Services Request Icon. Date Initials Reference # Description 10/10/2007 Raja 1621990009 Build C314 audit errors are resolved.
    LB=Left Browser
    RM=Resource Management
    RS=Recruiting Solutions
    RS=Recruiting Solutions
    SR=Service Request Icon