SPREQ_LINE_TEO2(SQL Table) |
Index Back |
|---|---|
SP Requisition LineCCU Temp Table for sPro Requisition Line |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_SP_NONVW |
| 3 | SP_REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Service Request ID |
| 4 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 5 | 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 |
| 6 | HOLD_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Hold From Further Processing |
| 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: DEPTID_BUGL_VW |
| 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:
SPB_ROLTYP_VW
|
| 23 | PROJ_ROLE | Character(15) | VARCHAR2(15) NOT NULL |
Project Role
Prompt Table:
%EDITTABLE
|
| 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
|
| 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: SPF_SRVC_CRD_VW |
| 36 | TE_APPROVER | Character(30) | VARCHAR2(30) NOT NULL |
Time Approver
Prompt Table: SPF_APPROVER_VW |
| 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 |
| 97 | CHNG_ORD_SEQ | Number(3,0) | SMALLINT NOT NULL | Change Order Sequence Number |
| 98 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |