| # |
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 |
ENGAGEMENT_MNGR |
Character(30) |
VARCHAR2(30) NOT NULL |
Engagement Manager
Prompt Table:
SP_REQSTR_NONVW
|
| 3 |
WORK_ORDER_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Work Order ID
Default Value: NEXT
|
| 4 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table:
SP_BU_PC_NONVW
|
| 5 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
SPF_WPROJ_VW
Set Control Field: BUSINESS_UNIT_PC
|
| 6 |
SP_REQ_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Service Request ID
Prompt Table:
%EDITTABLE9
Set Control Field: BUSINESS_UNIT
|
| 7 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Prompt Table:
%EDITTABLE11
|
| 8 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
%EDITTABLE4
Set Control Field: BUSINESS_UNIT
|
| 9 |
WO_CONID |
Character(15) |
VARCHAR2(15) NOT NULL |
Service Provider's ID assigned on work order
|
| 10 |
USE_SP_LOC_SUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Service Performed Location
1=Work Order Location
2=Supplier Location
3=Service Provider Location
4=Other Location
Default Value: 1
|
| 11 |
VNDR_LOC_SP |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table:
SPF_VNDR_LOC_VW
Set Control Field: BUSINESS_UNIT
|
| 12 |
WO_CLIID |
Character(30) |
VARCHAR2(30) NOT NULL |
Requester
Prompt Table:
SP_REQSTR_NONVW
|
| 13 |
WO_RATE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
WorkOrder Rate
|
| 14 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
Set Control Field: BUSINESS_UNIT
|
| 15 |
START_DATE |
Date(10) |
DATE NOT NULL |
Start Date for Gen Standing PO
Default Value: %date
|
| 16 |
END_DATE |
Date(10) |
DATE NOT NULL |
End Date
Default Value: %date
|
| 17 |
TE_TEMPLATE_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Used to define a particular type of travel, i.e. company relocation, internal travel, etc. Determines what type of expenses and expenditure limits are associated with that particular type of travel. Established in the Structure Expenses system and chosen on the header panel of cash expense sheets.
Prompt Table:
%EDITTABLE3
Set Control Field: BUSINESS_UNIT
|
| 18 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 19 |
POAMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Purchase Order / Work Order Amount
|
| 20 |
COMPUNIT |
Character(3) |
VARCHAR2(3) NOT NULL |
Unit of Measure
Prompt Table:
SPF_UOM_VW
|
| 21 |
INVOICE_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount
|
| 22 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
%EDITTABLE31
Set Control Field: BUSINESS_UNIT_HR
|
| 23 |
LINKEDWORDER |
Character(15) |
VARCHAR2(15) NOT NULL |
Linked Work Order
|
| 24 |
PROJ_ROLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Role
Prompt Table:
%EDITTABLE5
Set Control Field: BUSINESS_UNIT
|
| 25 |
ROLE_TYPE |
Character(6) |
VARCHAR2(6) NOT NULL |
Service Type
APR=Approver
MGR=Manager
OPR=Operator
Prompt Table:
%EDITTABLE2
Set Control Field: BUSINESS_UNIT
|
| 26 |
WO_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Order Status
A=Approved
C=Closed
D=Denied
F=Finalize
L=Released
N=Canceled
O=Open
P=Pending Terminate
S=Submitted
T=Terminated
Default Value: O
|
| 27 |
SP_BILL_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Billable Amount
|
| 28 |
ROW_CREATE_DATE |
DateTime(26) |
TIMESTAMP |
Row Creation Date Time
Default Value: %DateTime
|
| 29 |
ROW_MODIFY_DATE |
DateTime(26) |
TIMESTAMP |
Modified Date Time
Default Value: %DateTime
|
| 30 |
ROW_CREATE_USER |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Added By
|
| 31 |
ROW_MODIFY_USER |
Character(30) |
VARCHAR2(30) NOT NULL |
Modified User
|
| 32 |
SPECIAL_INSTRUCT |
Long Character |
CLOB |
Special Instructions
|
| 33 |
SP_UTILIZATION |
Number(3,0) |
SMALLINT NOT NULL |
Utilization%
Default Value: 100
|
| 34 |
OVERTIME_PERMITTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Overtime Permitted
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 35 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
SHIPTO_TBL
|
| 36 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 37 |
SP_ROUTE_TO |
Character(30) |
VARCHAR2(30) NOT NULL |
WorkOrder Approver Person.
Prompt Table:
SP_APPR_NONVW
|
| 38 |
SERVICE_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Service Method
D=Deliverable
M=Multi Resource
R=Resource
|
| 39 |
SP_WO_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
WorkOrder Type classified as original, extension, reassign wo
E=Extension
O=Original
P=Replacement
R=Reassign Work Order
Default Value: O
|
| 40 |
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
|
| 41 |
SP_CUR_BILL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Used to store the current billed amount with respect to Reassign WorkOrders.
|
| 42 |
SP_PLOG_PERCNT |
Number(3,0) |
SMALLINT NOT NULL |
Used to define the progress log percentage completed if workorder is service based and billing type is percentage.
|
| 43 |
SP_REASSIGN_WO_DT |
DateTime(26) |
TIMESTAMP |
To keep track of the last date against which the Service Provider books the time. Used in implementing the Reassign WorkOrder functionality.
|
| 44 |
SP_WO_PO_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
WorkOrder- Purchase Order generation processisng status flag
C=Completed
I=In Progress
S=Submitted
|
| 45 |
SP_ATTACHMENT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Attachment ID
|
| 46 |
ITM_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Item SetID
|
| 47 |
CATEGORY_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Category ID
|
| 48 |
JOB_TITLE |
Character(50) |
VARCHAR2(50) NOT NULL |
Job Title
|
| 49 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table:
SPF_VNDR_LOC_VW
Set Control Field: BUSINESS_UNIT
|
| 50 |
WO_EXP_RATE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Expense Rate
|
| 51 |
WO_EXP_RATE_BSE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Expense Rate in base currency
|
| 52 |
WO_EXP_RATE_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
Expense Rate UOM
Prompt Table:
SPF_UOM_VW
|
| 53 |
SPF_EXPENSE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total expense amount.
|
| 54 |
SPF_EXP_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total expense amount for base currency
|
| 55 |
CURRENCY_CD_BASE |
Character(3) |
VARCHAR2(3) NOT NULL |
Business Unit Base Currency
Prompt Table:
CURRENCY_CD_TBL
|
| 56 |
WO_RATE_BSE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
work order rate in the base currency
|
| 57 |
WOAMOUNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
PO amount in the base currency
|
| 58 |
SP_BILL_AMOUNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Time and Expense amount reported in the base currency
|
| 59 |
SP_BILL_EXP_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Billable Expense Amount
|
| 60 |
BILL_EXP_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Billed Expense Amount Base
|
| 61 |
SP_CUR_BILLAMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Billed Amount in the Base Amount
|
| 62 |
SP_CURBIL_EXP_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Current Billed Expense Amount
|
| 63 |
CURBIL_EXP_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Current Billed Expense Amount
|
| 64 |
INVOICE_AMOUNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount in Base Currency
|
| 65 |
INV_EXP_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Expense Amount
|
| 66 |
INV_EXP_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Expense Amount for Base Currency
|
| 67 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 68 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 69 |
RATE_EFFDT |
Date(10) |
DATE |
Rate Effective Date
|
| 70 |
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.
|
| 71 |
DURATION |
Number(5,0) |
INTEGER NOT NULL |
Recurrence Duration
|
| 72 |
DAYS_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
the unit of measure for days
|
| 73 |
FINAL_DTTM |
DateTime(26) |
TIMESTAMP |
Finalize Date and Time
|
| 74 |
TIME_EXP_TOL_PER |
Number(3,0) |
SMALLINT NOT NULL |
Time & Expense Tolerance Percent
|
| 75 |
PROVIDER_CONTACT |
Character(15) |
VARCHAR2(15) NOT NULL |
PROVIDER CONTACT
Prompt Table:
SPM_SPLRCNT_VW
Set Control Field: BUSINESS_UNIT
|
| 76 |
SP_EXTENDED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Requisition has been extended.
|
| 77 |
SP_MSP_PERCENT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
MSP percent
|
| 78 |
ACT_END_DT |
Date(10) |
DATE |
Activity End Date
|
| 79 |
TEAM_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Team ID
Prompt Table:
%EDITTABLE20
|
| 80 |
RECRUITER |
Character(15) |
VARCHAR2(15) NOT NULL |
Service Coordinator
Prompt Table:
%EDITTABLE21
Set Control Field: BUSINESS_UNIT
|
| 81 |
SP_VNDR_INTERNAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Vendor Internal or External type
N=N
Y=Yes
Default Value: N
|
| 82 |
FIRSTDAY_CONTAC_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Person ID - first day contact -
Prompt Table:
PO_OPRDEFN_VW
|
| 83 |
HEALTH_CONTACT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Person ID - Health and Safety contact -
Prompt Table:
PO_OPRDEFN_VW
|
| 84 |
SP_REPORT_TO_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Person ID - Report-to person
Prompt Table:
PO_OPRDEFN_VW
|
| 85 |
SP_SAFETY_YESNO |
Character(1) |
VARCHAR2(1) NOT NULL |
Safety equipment required?
Y/N Table Edit
|
| 86 |
SHIFT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shift ID
Prompt Table:
SPB_SHIFT
|
| 87 |
BID_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Bid Id
|
| 88 |
LINE_ROW |
Number(5,0) |
INTEGER NOT NULL |
Line Row
|
| 89 |
ACT_START_DT |
Date(10) |
DATE |
Activity Start Date
|
| 90 |
SP_REP_ACT_START |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N field to indicate if the replacement action started or not
C=Assign button clicked
E=Replacment Ended
N=Replacement Not Started
S=Replacement Started
X=Replacement Cancelled
Default Value: N
|
| 91 |
SP_SURVEY_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
sPro Work Order Survey Identifier
Prompt Table:
SP_SUR_SVTYP_VW
Set Control Field: BUSINESS_UNIT
|
| 92 |
SP_DSTRLST_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Distribution List ID
Prompt Table:
SP_DSTRLST_ACTV
|
| 93 |
SP_MANDATORY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Survey is mandatory for work order flag
N=No
Y=Yes
Default Value: N
|
| 94 |
SP_AUTO_SUR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatically send Survey to distribution list role actions
N=No
Y=Yes
Default Value: N
|
| 95 |
SP_TRACK_RESRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Track Resource
B=Default From Business Unit
N=No
Y=Yes
Default Value: N
|
| 96 |
SP_TIME_REPORT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Time Reporting Option
A=Actual Allocation
D=Default from Business Unit
P=Percent Allocation
|
| 97 |
SP_EXP_REPORT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Expense Reporting Option
A=Actual Allocation
D=Default from Business Unit
P=Percent Allocation
|
| 98 |
WO_RS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
WorkOrder Response Status
P=Published
S=Submitted
|
| 99 |
SP_TOT_LABOR_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Labor Amount
|
| 100 |
TOT_LABOR_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Labout Amount
|
| 101 |
WO_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Work Order Name
|
| 102 |
SEQNBR |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
Default Value: 1
|
| 103 |
MRSC_PARENT_WOID |
Character(15) |
VARCHAR2(15) NOT NULL |
Multi Resource Parent WOID
|
| 104 |
SUB_LINE |
Character(1) |
VARCHAR2(1) NOT NULL |
Sub Line
N=No
Y=Yes
Default Value: N
|
| 105 |
SRVC_COORDINATOR |
Character(15) |
VARCHAR2(15) NOT NULL |
Service Coordinator
|
| 106 |
SP_PERCENT_TOL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
03/22/11 SMO 11635747 Ensured that matching exceptions are
not displayed for invoice linked to purchase orders and workorder.
Y/N Table Edit
|
| 107 |
SP_TOL_PCT_OVER |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
03/22/11 SMO 11635747 Ensured that matching exceptions are
not displayed for invoice linked to purchase orders and workorder.
|
| 108 |
SP_TOL_PCT_UNDER |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
03/22/11 SMO 11635747 Ensured that matching exceptions are
not displayed for invoice linked to purchase orders and workorder.
|
| 109 |
SP_ENGAGEMENT_MGR |
Character(30) |
VARCHAR2(30) NOT NULL |
Engagement Manager
|