SETIDRATE_PROFILE_TYPES=Salaried Staff
T=Temporary Staff
V=Associated Supplier
DETAIL_NODefault Value: 1
SEQ_NUMDefault Value: 1
Y/N Table Edit
Default Value: N
A=Pay and Bill
B=Bill Only
M=Mark-up
P=Pay Only
Default Value: A
FORATEPROFI_UPG(SQL Table) |
Index Back |
|---|---|
Staffing Rate Profile |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | RATE_PROFILE_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Profile Type
S=Salaried Staff T=Temporary Staff V=Associated Supplier |
| 3 | DETAIL_NO |
Number(3,0) | SMALLINT NOT NULL |
Detail Number
Default Value: 1 |
| 4 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL |
Sequence
Default Value: 1 |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 7 | FO_DFLT_RATE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Default Rate
Y/N Table Edit Default Value: N |
| 8 | FO_RATE_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Rate Action
A=Pay and Bill B=Bill Only M=Mark-up P=Pay Only Default Value: A |
| 9 | FO_PAY_RATE_FACTOR | Number(5,2) | DECIMAL(4,2) NOT NULL | Rate Factor |