SETIDRATE_NAMEEFFDTDefault Value: %date
A=Source Amount
Q=Source Quantity
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
PC_RATE_CUSTVW(SQL View) |
Index Back |
|---|---|
Custom Rates ViewThis view returns the custom rate values. |
| SELECT B.SETID , B.RATE_NAME , B.EFFDT , A.APPLY_RATE_TO , B.CURRENCY_CD , B.UNIT_OF_MEASURE , C.FIELDVALUE1 , C.FIELDVALUE2 , C.FIELDVALUE3 , C.FIELDVALUE4 , C.FIELDVALUE5 , C.COST_RATE , C.BILL_RATE , C.COST_MUP , C.BILL_MUP FROM PS_PC_CRATE_DEFN A , PS_PC_CRATE_LN B , PS_PC_CRATE_VALS C WHERE A.SETID = C.SETID AND A.RATE_NAME = C.RATE_NAME AND B.SETID = C.SETID AND B.RATE_NAME = C.RATE_NAME AND B.EFFDT = C.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | RATE_NAME |
Character(15) | VARCHAR2(15) NOT NULL | Unique Identifier for a Custom Rate Name |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | APPLY_RATE_TO | Character(1) | VARCHAR2(1) NOT NULL |
Apply Rates to
A=Source Amount Q=Source Quantity |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 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 | FIELDVALUE1 | Character(30) | VARCHAR2(30) NOT NULL | Field Value |
| 8 | FIELDVALUE2 | Character(30) | VARCHAR2(30) NOT NULL | Field Value |
| 9 | FIELDVALUE3 | Character(30) | VARCHAR2(30) NOT NULL | Field Value |
| 10 | FIELDVALUE4 | Character(30) | VARCHAR2(30) NOT NULL | Field Value |
| 11 | FIELDVALUE5 | Character(30) | VARCHAR2(30) NOT NULL | Field Value |
| 12 | COST_RATE | Number(27,3) | DECIMAL(26,3) NOT NULL | Cost Rate |
| 13 | BILL_RATE | Number(27,3) | DECIMAL(26,3) NOT NULL | Billing Rate |
| 14 | COST_MUP | Number(30,6) | DECIMAL(29,6) NOT NULL | Cost Markup Rate |
| 15 | BILL_MUP | Number(30,6) | DECIMAL(29,6) NOT NULL | Billing Markup Rate |