SPWOREC1_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 |
| 3 | WORK_ORDER_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |
| 4 | VMS_SUPPLIER_ID | Character(10) | VARCHAR2(10) NOT NULL | VMS Supplier ID |
| 5 | VMS_LOCATION | Character(10) | VARCHAR2(10) NOT NULL | VMS Location - This is the Vendor Managed Service Supplier's office location |
| 6 | 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 |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 8 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 9 | 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 |
| 10 | 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 Y/N Table Edit Default Value: N |
| 11 | 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 |
| 12 | SPF_YRS_EXPERIENCE | Character(4) | VARCHAR2(4) NOT NULL |
Years Experience
Prompt Table:
SP_EXPERIENCE
|
| 13 | SP_SUP_INVAPPROVER | Character(15) | VARCHAR2(15) NOT NULL |
Supplier Proforma Invoice Approver
Prompt Table:
%EDITTABLE12
|
| 14 | COMPETENCY_DESC | Long Character | CLOB | Competencies Required |
| 15 | TRAVEL_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
Travel Required
N=No Y=Yes Default Value: N |
| 16 | TRAVEL_FREQUENCY | Number(3,0) | SMALLINT NOT NULL | Travel Frequency |
| 17 | TELECOMMUTE | Character(1) | VARCHAR2(1) NOT NULL |
Defines if the user telecommutes or not
N=No Y=Yes |
| 18 | SP_RATES_BY_SC | Character(1) | VARCHAR2(1) NOT NULL |
Flag for Rate definition by SC - Translate values
D - Rate defined by SC
N - Not applicable
P - Pending Rate Synchronization
R - Ready for rate definition.
S - Sent to SC for rate definition.
D=Rate Defined by SC N=Not Applicable P=Pending Rate Synchronization R=Ready for rate S=Sent to SC for Rate |
| 19 | SP_REQ_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Request type - reason code |
| 20 | SP_ALLOW_OVRIDE_RT | Character(1) | VARCHAR2(1) NOT NULL |
Flag used in the rate sheet page. It will indicated whether to allow rate override on the requisition page.
Y/N Table Edit Default Value: Y |
| 21 | SPF_JUSTIFICATION | Character(254) | VARCHAR2(254) NOT NULL | Requisition Justification |
| 22 | SP_USE_WO_ALERTS | Character(1) | VARCHAR2(1) NOT NULL |
Using Work Order Alerts flag
N=No Y=Yes Y/N Table Edit Default Value: N |
| 23 | WO_NOTIFY_BY | Character(2) | VARCHAR2(2) NOT NULL |
WorkOrder Alert Notification Method
EM=Email and Worklist WL=Worklist Only |
| 24 | REG_REGION | Character(5) | VARCHAR2(5) NOT NULL |
Regulatory Region
Prompt Table: REG_REGION_TBL |
| 25 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 26 | BUSINESS_UNIT_HR | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit HR
Prompt Table: BUS_UNIT_TBL_HR |
| 27 | DEPTID_JOB_SP | Character(10) | VARCHAR2(10) NOT NULL |
HCM Department ID
Prompt Table:
DEPT_TBL_EFF_VW
|
| 28 | LOCATION_JOB_SP | Character(10) | VARCHAR2(10) NOT NULL |
HCM Job Location
Prompt Table:
LOCATION_TBL
|
| 29 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
SP_JOBCODE_VW1
|
| 30 | LABOR_AGREEMENT | Character(6) | VARCHAR2(6) NOT NULL |
Labor Agreement
Prompt Table:
SP_LBR_AGRMT_VW
|
| 31 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table: %EDITTABLE40 |
| 32 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 33 | SPF_WO_HCM_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Spro-HCM integration status on work order
C=HCM Job Record Created P=Pending T=Terminated |
| 34 | SP_HCM_DEFLT_ADMIN | Character(30) | VARCHAR2(30) NOT NULL |
Default HCM Administrator
Prompt Table: PSOPRDEFN_VW |
| 35 | WO_SOURCE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Work Order Sourcing Status
C=Closed F=Filled I=Sourcing Initiated N=New R=Ready for Sourcing S=Sourced X=Cancel |
| 36 | INTERVIEWREQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
Interview Required
N=No Y=Yes |
| 37 | 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 |
| 38 | HCR_JOB_ADDED | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No field
N=No Y=Yes |
| 39 | HRS_CAND_WDRAW | Character(1) | VARCHAR2(1) NOT NULL | HRS_CAND_WDRAW |
| 40 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |