SPF_CUR_RS_VW(SQL View) |
Index Back |
|---|---|
Current RateSheet ViewDetermines the current ratesheet for the specified time. SELECT A.SETID , A.PROJ_ROLE , A.EFFDT , A.REGION_CD , A.UNIT_OF_MEASURE , A.EFF_STATUS , A.DESCR , A.CURRENCY_CD , A.MINRATE , A.MAXRATE , A.TARGETRATE , B.LOCATION FROM PS_SPB_RATESHEET A , PS_SPB_REGIONLOCAT B WHERE A.REGION_CD = B.REGION_CD AND A.REGION_CD_TYPE = 'SPRS' |
| SELECT A.SETID , A.PROJ_ROLE , A.REGION_CD , A.CURRENCY_CD , A.EFFDT , A.UNIT_OF_MEASURE , A.EFF_STATUS , A.DESCR , A.MINRATE , A.MAXRATE , A.TARGETRATE , A.SP_ALLOW_OVRIDE_RT , A.SP_MIN_PAY_RATE , A.SP_MAX_PAY_RATE , A.SP_TAR_PAY_RATE , A.SP_MIN_FIXED_COST , A.SP_MAX_FIXED_COST , A.SP_TAR_FIXED_COST , A.SP_MIN_VNDR_MARKUP , A.SP_MAX_VNDR_MARKUP , A.SP_TAR_VNDR_MARKUP , A.SP_MIN_3RDPARTY , A.SP_MAX_3RDPARTY , A.SP_TAR_3RDPARTY , A.SP_EXP_RATE_UOM , A.SP_MIN_EXP_RATE , A.SP_MAX_EXP_RATE , A.SP_TAR_EXP_RATE FROM PS_SPB_RATESHEET A WHERE A.REGION_CD_TYPE = 'SPRS' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 2 | PROJ_ROLE |
Character(15) | VARCHAR2(15) NOT NULL | Project Role |
| 3 | REGION_CD |
Character(10) | VARCHAR2(10) NOT NULL |
Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
Prompt Table: SPB_REGIONCD_VW |
| 4 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 5 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 6 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 7 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 9 | MINRATE | Number(15,4) | DECIMAL(14,4) NOT NULL | Minimum rate |
| 10 | MAXRATE | Number(15,4) | DECIMAL(14,4) NOT NULL | Max rate |
| 11 | TARGETRATE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Target Rate |
| 12 | 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 |
| 13 | SP_MIN_PAY_RATE | Number(15,4) | DECIMAL(14,4) NOT NULL | Pay rate Minimum |
| 14 | SP_MAX_PAY_RATE | Number(15,4) | DECIMAL(14,4) NOT NULL | Pay rate Maximum |
| 15 | SP_TAR_PAY_RATE | Number(15,4) | DECIMAL(14,4) NOT NULL | Pay rate Maximum |
| 16 | SP_MIN_FIXED_COST | Number(15,4) | DECIMAL(14,4) NOT NULL | Fixed Cost Minimum |
| 17 | SP_MAX_FIXED_COST | Number(15,4) | DECIMAL(14,4) NOT NULL | Fixed Cost Maximum |
| 18 | SP_TAR_FIXED_COST | Number(15,4) | DECIMAL(14,4) NOT NULL | Fixed Cost Maximum |
| 19 | SP_MIN_VNDR_MARKUP | Number(15,4) | DECIMAL(14,4) NOT NULL | Vendor Markup Minimum |
| 20 | SP_MAX_VNDR_MARKUP | Number(15,4) | DECIMAL(14,4) NOT NULL | Vendor Markup Maximum |
| 21 | SP_TAR_VNDR_MARKUP | Number(15,4) | DECIMAL(14,4) NOT NULL | Vendor Markup Target |
| 22 | SP_MIN_3RDPARTY | Number(15,4) | DECIMAL(14,4) NOT NULL | 3rd Party Markup Minimum |
| 23 | SP_MAX_3RDPARTY | Number(15,4) | DECIMAL(14,4) NOT NULL | 3rd Party Markup Maximum |
| 24 | SP_TAR_3RDPARTY | Number(15,4) | DECIMAL(14,4) NOT NULL | 3rd Party Markup Target |
| 25 | SP_EXP_RATE_UOM | Character(3) | VARCHAR2(3) NOT NULL |
stores the supplier's rate uom
Prompt Table:
SPF_UOM_VW
|
| 26 | SP_MIN_EXP_RATE | Number(15,4) | DECIMAL(14,4) NOT NULL | Expense rate Minimum |
| 27 | SP_MAX_EXP_RATE | Number(15,4) | DECIMAL(14,4) NOT NULL | Expense rate Maximum |
| 28 | SP_TAR_EXP_RATE | Number(15,4) | DECIMAL(14,4) NOT NULL | Expense rate Target |