| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SPB_VMS_BY_BU
Set Control Field: BUSINESS_UNIT
|
| 2 |
ROLE_TYPE |
Character(6) |
VARCHAR2(6) NOT NULL |
Service Type
APR=Approver
MGR=Manager
OPR=Operator
Prompt Table:
SPB_ROLE_TYPE
|
| 3 |
VMS_SUPPLIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
VMS Supplier ID
Prompt Table:
SPF_VMSSUP_VW
Set Control Field: BUSINESS_UNIT
|
| 4 |
VMS_LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
VMS Location - This is the Vendor Managed Service Supplier's office location
Prompt Table:
SPF_VMSBULOC_VW
Set Control Field: BUSINESS_UNIT
|
| 5 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 6 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 7 |
MARKUP_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Markup type for Manage Services rates in either percentage or rate based
P=Percentage
R=Rate
|
| 8 |
SP_MSP_PERCENT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
MSP percent
|
| 9 |
VMS_TEAM_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
VMS Team ID
Prompt Table:
SPB_VMS_TMID_VW
Set Control Field: BUSINESS_UNIT
|
| 10 |
VMS_RECRUITER |
Character(15) |
VARCHAR2(15) NOT NULL |
VMS Recruiter
Prompt Table:
SPB_VMS_SC_SPLR
|
| 11 |
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
|
| 12 |
MS_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
Unit of Measure for the Managed Services Rates
Prompt Table:
SPF_UOM_VW
|
| 13 |
MS_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code used on Managed Services Subrecord
Prompt Table:
CURRENCY_CD_TBL
|