SETIDROLE_TYPEAPR=Approver
MGR=Manager
OPR=Operator
EFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
P=Percentage
R=Rate
Default Value: 0
Prompt Table: SPF_UOM_VW
Prompt Table: CURRENCY_CD_TBL
SPB_MSP_BY_SRVC(SQL Table) |
Index Back |
|---|---|
MSP fee by service typeallows customers to define MSP fees by service type. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | ROLE_TYPE |
Character(6) | VARCHAR2(6) NOT NULL |
Service Type
APR=Approver MGR=Manager OPR=Operator |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | MARKUP_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Markup type for Manage Services rates in either percentage or rate based
P=Percentage R=Rate |
| 6 | SP_MSP_PERCENT | Number(6,2) | DECIMAL(5,2) NOT NULL |
MSP percent
Default Value: 0 |
| 7 | 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 |
| 8 | MS_UOM | Character(3) | VARCHAR2(3) NOT NULL |
Unit of Measure for the Managed Services Rates
Prompt Table: SPF_UOM_VW |
| 9 | MS_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code used on Managed Services Subrecord
Prompt Table: CURRENCY_CD_TBL |