| # |
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 |
WORK_ORDER_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Work Order ID
Default Value: NEXT
|
| 3 |
SEQNBR |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
Default Value: 1
|
| 4 |
SP_REQ_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Service Request ID
Prompt Table:
%EDITTABLE9
Set Control Field: BUSINESS_UNIT
|
| 5 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Prompt Table:
%EDITTABLE11
|
| 6 |
ROLE_TYPE |
Character(6) |
VARCHAR2(6) NOT NULL |
Service Type
APR=Approver
MGR=Manager
OPR=Operator
Prompt Table:
%EDITTABLE33
Set Control Field: BUSINESS_UNIT
|
| 7 |
PROJ_ROLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Role
Prompt Table:
%EDITTABLE34
Set Control Field: BUSINESS_UNIT
|
| 8 |
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
Default Value: R
|
| 9 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
%EDITTABLE35
Set Control Field: BUSINESS_UNIT_HR
|
| 10 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
SHIPTO_TBL
|
| 11 |
JOB_TITLE |
Character(50) |
VARCHAR2(50) NOT NULL |
Job Title
|
| 12 |
START_DATE |
Date(10) |
DATE NOT NULL |
Start Date for Gen Standing PO
Default Value: %date
|
| 13 |
END_DATE |
Date(10) |
DATE NOT NULL |
End Date
Default Value: %date
|
| 14 |
DURATION |
Number(5,0) |
INTEGER NOT NULL |
Recurrence Duration
|
| 15 |
INTERVIEWREQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
Interview Required
N=No
Y=Yes
Default Value: N
|
| 16 |
TELECOMMUTE |
Character(1) |
VARCHAR2(1) NOT NULL |
Defines if the user telecommutes or not
N=No
Y=Yes
Default Value: N
|
| 17 |
TRAVEL_REQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
Travel Required
N=No
Y=Yes
Default Value: N
|
| 18 |
TRAVEL_FREQUENCY |
Number(3,0) |
SMALLINT NOT NULL |
Travel Frequency
|
| 19 |
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
|
| 20 |
SPF_YRS_EXPERIENCE |
Character(4) |
VARCHAR2(4) NOT NULL |
Years Experience
Prompt Table:
SP_EXPERIENCE
Set Control Field: BUSINESS_UNIT
|
| 21 |
SP_UTILIZATION |
Number(3,0) |
SMALLINT NOT NULL |
Utilization%
Default Value: 100
|
| 22 |
DAYS_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
the unit of measure for days
|
| 23 |
OVERTIME_PERMITTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Overtime Permitted
N=No
Y=Yes
Default Value: N
|
| 24 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
Set Control Field: BUSINESS_UNIT
|
| 25 |
CURRENCY_CD_BASE |
Character(3) |
VARCHAR2(3) NOT NULL |
Business Unit Base Currency
Prompt Table:
CURRENCY_CD_TBL
|
| 26 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 27 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 28 |
RATE_EFFDT |
Date(10) |
DATE |
Rate Effective Date
|
| 29 |
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.
|
| 30 |
COMPUNIT |
Character(3) |
VARCHAR2(3) NOT NULL |
Unit of Measure
Prompt Table:
SPF_UOM_VW
|
| 31 |
WO_RATE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
WorkOrder Rate
|
| 32 |
WO_RATE_BSE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
work order rate in the base currency
|
| 33 |
SP_TOT_LABOR_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Labor Amount
|
| 34 |
TOT_LABOR_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Labout Amount
|
| 35 |
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
|
| 36 |
WO_EXP_RATE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Expense Rate
|
| 37 |
WO_EXP_RATE_BSE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Expense Rate in base currency
|
| 38 |
WO_EXP_RATE_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
Expense Rate UOM
Prompt Table:
SPF_UOM_VW
|
| 39 |
SPF_EXPENSE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total expense amount.
|
| 40 |
SPF_EXP_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total expense amount for base currency
|
| 41 |
POAMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Purchase Order / Work Order Amount
|
| 42 |
WOAMOUNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
PO amount in the base currency
|
| 43 |
SP_MSP_PERCENT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
MSP percent
|
| 44 |
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
|
| 45 |
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
|
| 46 |
SP_NUM_OF_POSITION |
Number(5,0) |
INTEGER NOT NULL |
Number of Positions
|
| 47 |
SP_NUM_FILLED_POS |
Number(5,0) |
INTEGER NOT NULL |
Number of filled Positions
|
| 48 |
SP_PAY_RATE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
pay rate
|
| 49 |
SP_PAY_RATE_BSE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
pay rate in the base currency
|
| 50 |
SP_FIXED_COST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
fixed costs
|
| 51 |
SP_FIXED_COST_BSE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
fixed costs in the base currency
|
| 52 |
SP_VNDR_MARKUP |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
vendor markup
|
| 53 |
SP_VNDR_MARKUP_BSE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
vendor markup in the base currency
|
| 54 |
SP_VNDR_MARKUP_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
vendor markup percent
|
| 55 |
SP_3RDPARTY_MARKUP |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
third party markup amount
|
| 56 |
SP_3RDPTY_MKUP_BSE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
third party markup amount in the base currency
|
| 57 |
SP_3RDPTY_MKUP_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
third party vendor markup percent
|
| 58 |
SP_3RDPARTY_VNDR |
Character(40) |
VARCHAR2(40) NOT NULL |
the name of the 3rd party vendor used when bidding, part of the rate breakdown feature
|
| 59 |
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.
|
| 60 |
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
Default Value: N
|
| 61 |
SP_SHOW_BID |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Bid
N=Hide Rate
Y=Display Rate
|
| 62 |
SRVC_COORDINATOR |
Character(15) |
VARCHAR2(15) NOT NULL |
Service Coordinator
|
| 63 |
LINKED_SRVC_SEQNBR |
Number(5,0) |
INTEGER NOT NULL |
Linked Service Seqnbr
|
| 64 |
SPF_RATE_FILL |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Filled Rate
|
| 65 |
SPF_RATE_FILL_BSE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Filled Rate in Base currency
|
| 66 |
TOTAL_FILL_RATE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Total Fill Rate
|
| 67 |
TOTAL_FILLRATE_BSE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Total Fill Rate
|
| 68 |
SP_TIME_REPORT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Time Reporting Option
A=Actual Allocation
D=Default from Business Unit
P=Percent Allocation
|
| 69 |
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.
|
| 70 |
SP_EXP_REPORT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Expense Reporting Option
A=Actual Allocation
D=Default from Business Unit
P=Percent Allocation
|
| 71 |
COMPETENCY_DESC |
Long Character |
CLOB |
Competencies Required
|