SPWO_REC_TEO2(SQL Table) |
Index Back |
|---|---|
CCU Temp TableCCU Temp Table for Work Order Record |
| # | 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
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_SP_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
|
| 6 | SP_REQ_ID | Character(10) | VARCHAR2(10) NOT NULL |
Service Request ID
Prompt Table:
%EDITTABLE9
|
| 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
|
| 9 | WO_CONID | Character(15) | VARCHAR2(15) NOT NULL |
Service Provider's ID assigned on work order
Prompt Table:
%EDITTABLE8
|
| 10 | WO_CLIID | Character(30) | VARCHAR2(30) NOT NULL |
Requester
Prompt Table:
REQUESTOR_TBL
|
| 11 | WO_RATE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | WorkOrder Rate |
| 12 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
SPF_VNDR_CUR_VW
|
| 13 | START_DATE | Date(10) | DATE NOT NULL |
Start Date for Gen Standing PO
Default Value: %date |
| 14 | END_DATE | Date(10) | DATE NOT NULL |
End Date
Default Value: %date |
| 15 | INVAPPROVER | Character(30) | VARCHAR2(30) NOT NULL |
Invoice Approver
Prompt Table: SPF_INVAPRVR_VW |
| 16 | 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
|
| 17 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 18 | POAMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Purchase Order / Work Order Amount |
| 19 | COMPUNIT | Character(3) | VARCHAR2(3) NOT NULL |
Unit of Measure
Prompt Table: SPF_UOM_VW |
| 20 | INVOICE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount |
| 21 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPTID_BUGL_VW
|
| 22 | LINKEDWORDER | Character(15) | VARCHAR2(15) NOT NULL | Linked Work Order |
| 23 | PROJ_ROLE | Character(15) | VARCHAR2(15) NOT NULL |
Project Role
Prompt Table:
%EDITTABLE5
|
| 24 | ROLE_TYPE | Character(6) | VARCHAR2(6) NOT NULL |
Service Type
APR=Approver MGR=Manager OPR=Operator Prompt Table:
%EDITTABLE2
|
| 25 | 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 |
| 26 | SP_BILL_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Billable Amount |
| 27 | ROW_CREATE_DATE | DateTime(26) | TIMESTAMP |
Row Creation Date Time
Default Value: %DateTime |
| 28 | ROW_MODIFY_DATE | DateTime(26) | TIMESTAMP |
Modified Date Time
Default Value: %DateTime |
| 29 | ROW_CREATE_USER | Character(30) | VARCHAR2(30) NOT NULL | Row Added By |
| 30 | ROW_MODIFY_USER | Character(30) | VARCHAR2(30) NOT NULL | Modified User |
| 31 | SPECIAL_INSTRUCT | Long Character | CLOB | Special Instructions |
| 32 | SP_UTILIZATION | Number(3,0) | SMALLINT NOT NULL |
Utilization%
Default Value: 100 |
| 33 | OVERTIME_PERMITTED | Character(1) | VARCHAR2(1) NOT NULL |
Overtime Permitted
N=No Y=Yes Y/N Table Edit Default Value: N |
| 34 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: SHIPTO_TBL |
| 35 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 36 | SP_ROUTE_TO | Character(30) | VARCHAR2(30) NOT NULL |
WorkOrder Approver Person.
Prompt Table: SPF_APPROVER_VW |
| 37 | SERVICE_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Service Method
D=Deliverable M=Multi Resource R=Resource |
| 38 | 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 |
| 39 | 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 |
| 40 | 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. |
| 41 | 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. |
| 42 | 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. |
| 43 | SP_WO_PO_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
WorkOrder- Purchase Order generation processisng status flag
C=Completed I=In Progress S=Submitted |
| 44 | SP_ATTACHMENT_ID | Number(15,0) | DECIMAL(15) NOT NULL | Attachment ID |
| 45 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 46 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL | Category ID |
| 47 | JOB_TITLE | Character(50) | VARCHAR2(50) NOT NULL | Job Title |
| 48 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table:
SPF_VNDR_LOC_VW
|
| 49 | WO_EXP_RATE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Expense Rate |
| 50 | WO_EXP_RATE_BSE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Expense Rate in base currency |
| 51 | WO_EXP_RATE_UOM | Character(3) | VARCHAR2(3) NOT NULL |
Expense Rate UOM
Prompt Table: SPF_UOM_VW |
| 52 | SPF_EXPENSE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total expense amount. |
| 53 | SPF_EXP_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total expense amount for base currency |
| 54 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL |
Business Unit Base Currency
Prompt Table: CURRENCY_CD_TBL |
| 55 | WO_RATE_BSE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | work order rate in the base currency |
| 56 | WOAMOUNT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | PO amount in the base currency |
| 57 | SP_BILL_AMOUNT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Time and Expense amount reported in the base currency |
| 58 | SP_BILL_EXP_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Billable Expense Amount |
| 59 | BILL_EXP_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Billed Expense Amount Base |
| 60 | SP_CUR_BILLAMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Billed Amount in the Base Amount |
| 61 | SP_CURBIL_EXP_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Current Billed Expense Amount |
| 62 | CURBIL_EXP_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Current Billed Expense Amount |
| 63 | INVOICE_AMOUNT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount in Base Currency |
| 64 | INV_EXP_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Expense Amount |
| 65 | INV_EXP_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Expense Amount for Base Currency |
| 66 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 67 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 68 | RATE_EFFDT | Date(10) | DATE | Rate Effective Date |
| 69 | 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. |
| 70 | DURATION | Number(5,0) | INTEGER NOT NULL | Recurrence Duration |
| 71 | DAYS_UOM | Character(3) | VARCHAR2(3) NOT NULL | the unit of measure for days |
| 72 | FINAL_DTTM | DateTime(26) | TIMESTAMP | Finalize Date and Time |
| 73 | TIME_EXP_TOL_PER | Number(3,0) | SMALLINT NOT NULL | Time & Expense Tolerance Percent |
| 74 | PROVIDER_CONTACT | Character(15) | VARCHAR2(15) NOT NULL |
PROVIDER CONTACT
Prompt Table:
SPM_SPLRCNT_VW
|
| 75 | SP_EXTENDED_FLG | Character(1) | VARCHAR2(1) NOT NULL | Requisition has been extended. |
| 76 | SP_MSP_PERCENT | Number(6,2) | DECIMAL(5,2) NOT NULL | MSP percent |
| 77 | ACT_END_DT | Date(10) | DATE | Activity End Date |
| 78 | TEAM_ID | Character(15) | VARCHAR2(15) NOT NULL |
Team ID
Prompt Table: %EDITTABLE20 |
| 79 | RECRUITER | Character(15) | VARCHAR2(15) NOT NULL |
Service Coordinator
Prompt Table:
%EDITTABLE21
|
| 80 | SP_VNDR_INTERNAL | Character(1) | VARCHAR2(1) NOT NULL |
Vendor Internal or External type
N=N Y=Yes Default Value: N |
| 81 | FIRSTDAY_CONTAC_ID | Character(15) | VARCHAR2(15) NOT NULL |
Person ID - first day contact -
Prompt Table: PO_OPRDEFN_VW |
| 82 | HEALTH_CONTACT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Person ID - Health and Safety contact -
Prompt Table: PO_OPRDEFN_VW |
| 83 | SP_REPORT_TO_ID | Character(15) | VARCHAR2(15) NOT NULL |
Person ID - Report-to person
Prompt Table: PO_OPRDEFN_VW |
| 84 | SP_SAFETY_YESNO | Character(1) | VARCHAR2(1) NOT NULL |
Safety equipment required?
Y/N Table Edit |
| 85 | SHIFT_ID | Character(10) | VARCHAR2(10) NOT NULL |
Shift ID
Prompt Table: SPB_SHIFT |
| 86 | BID_ID | Number(10,0) | DECIMAL(10) NOT NULL | Bid Id |
| 87 | LINE_ROW | Number(5,0) | INTEGER NOT NULL | Line Row |
| 88 | ACT_START_DT | Date(10) | DATE | Activity Start Date |
| 89 | 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 |
| 90 | SP_SURVEY_ID | Character(18) | VARCHAR2(18) NOT NULL |
sPro Work Order Survey Identifier
Prompt Table:
SP_SUR_SVTYP_VW
|
| 91 | SP_DSTRLST_ID | Character(18) | VARCHAR2(18) NOT NULL |
Distribution List ID
Prompt Table: SP_DSTRLST_ACTV |
| 92 | SP_MANDATORY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Survey is mandatory for work order flag
N=No Y=Yes |
| 93 | SP_AUTO_SUR_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Automatically send Survey to distribution list role actions
N=No Y=Yes |
| 94 | SP_TRACK_RESRC | Character(1) | VARCHAR2(1) NOT NULL |
Track Resource
B=Default From Business Unit N=No Y=Yes Default Value: N |
| 95 | SP_TIME_REPORT_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Time Reporting Option
A=Actual Allocation D=Default from Business Unit P=Percent Allocation |
| 96 | WO_RS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
WorkOrder Response Status
P=Published S=Submitted |
| 97 | SP_TOT_LABOR_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Labor Amount |
| 98 | TOT_LABOR_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Labout Amount |
| 99 | WO_NAME | Character(30) | VARCHAR2(30) NOT NULL | Work Order Name |
| 100 | SEQNBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 101 | MRSC_PARENT_WOID | Character(15) | VARCHAR2(15) NOT NULL | Multi Resource Parent WOID |
| 102 | SUB_LINE | Character(1) | VARCHAR2(1) NOT NULL |
Sub Line
N=No Y=Yes |
| 103 | SRVC_COORDINATOR | Character(15) | VARCHAR2(15) NOT NULL | Service Coordinator |
| 104 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |