SETIDRATE_NAMEEFFDTDefault Value: %date
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
PC_CRATE_CUR_VW(SQL View) |
Index Back |
|---|---|
Current Custom Rates ViewThis view returns the most effective-dated custom rate values. |
| SELECT A.SETID , A.RATE_NAME , A.EFFDT , A.CURRENCY_CD , A.UNIT_OF_MEASURE , B.FIELDVALUE1 , B.FIELDVALUE2 , B.FIELDVALUE3 , B.FIELDVALUE4 , B.FIELDVALUE5 , B.COST_RATE , B.BILL_RATE FROM PS_PC_CRATE_LN A , PS_PC_CRATE_VALS B WHERE A.SETID = B.SETID AND A.RATE_NAME = B.RATE_NAME AND A.EFFDT = B.EFFDT AND A.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_PC_CRATE_LN X WHERE A.SETID = X.SETID AND A.RATE_NAME = X.RATE_NAME AND X.EFFDT <= %CurrentDateIn) |
| # | 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 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 5 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 6 | FIELDVALUE1 | Character(30) | VARCHAR2(30) NOT NULL | Field Value |
| 7 | FIELDVALUE2 | Character(30) | VARCHAR2(30) NOT NULL | Field Value |
| 8 | FIELDVALUE3 | Character(30) | VARCHAR2(30) NOT NULL | Field Value |
| 9 | FIELDVALUE4 | Character(30) | VARCHAR2(30) NOT NULL | Field Value |
| 10 | FIELDVALUE5 | Character(30) | VARCHAR2(30) NOT NULL | Field Value |
| 11 | COST_RATE | Number(27,3) | DECIMAL(26,3) NOT NULL | Cost Rate |
| 12 | BILL_RATE | Number(27,3) | DECIMAL(26,3) NOT NULL | Billing Rate |