SETIDRATE_PROFILE_IDRATE_ELEMENTPrompt Table: %EDITTABLE
A=Pay and Bill
B=Bill Only
M=Mark-up
P=Pay Only
O=Overtime
R=Regular
T=Other
Default Value: R
FO_PRF_ELEM_VW(SQL View) |
Index Back |
|---|---|
Rate Profile - Elements |
| SELECT L.SETID , L.RATE_PROFILE_ID , L.RATE_ELEMENT , L.SORT_ORDER_NUM , E.DESCR , E.FO_RATE_ACTION , E.RATE_PURPOSE , E.FO_PAY_RATE_FACTOR , E.FO_MARKUP_PCT FROM PS_FO_RATE_PRFL_LN L , PS_FO_RATE_ELEMENT E WHERE L.SETID = E.SETID AND L.RATE_ELEMENT = E.RATE_ELEMENT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | RATE_PROFILE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Rate Profile ID |
| 3 | RATE_ELEMENT |
Character(5) | VARCHAR2(5) NOT NULL |
Rate Element
Prompt Table: %EDITTABLE |
| 4 | SORT_ORDER_NUM | Number(2,0) | SMALLINT NOT NULL | Sort Order Number |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | FO_RATE_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Rate Action
A=Pay and Bill B=Bill Only M=Mark-up P=Pay Only |
| 7 | RATE_PURPOSE | Character(1) | VARCHAR2(1) NOT NULL |
Rate Purpose
O=Overtime R=Regular T=Other Default Value: R |
| 8 | FO_PAY_RATE_FACTOR | Number(5,2) | DECIMAL(4,2) NOT NULL | Rate Factor |
| 9 | FO_MARKUP_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Markup % |