FO_PC_RATE_DTL(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 3 | ACTIVITY_ID |
Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %DATE |
| 5 | DETAIL_NO |
Number(3,0) | SMALLINT NOT NULL |
Detail Number
Default Value: 1 |
| 6 | TEMPLATE_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Used to identify what document/transaction is associated with a particular template. This is a translate table field whose value is either expense sheet or travel authorization. Cash advances do not use templates.
Projects is using types are R and C.
C=Contract E=Expense Report R=Standard T=Travel Authorization |
| 7 | LINE_NO | Number(3,0) | SMALLINT NOT NULL |
Line Number
Default Value: 1 |
| 8 | FO_PAY_RATE | Number(19,6) | DECIMAL(18,6) NOT NULL | Pay Rate |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 10 | FO_AVE_PAY_RATE | Number(19,6) | DECIMAL(18,6) NOT NULL | Contractor Pay Rate |
| 11 | FO_AVE_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 12 | FO_DFLT_RATE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Default Rate |
| 13 | FO_RATE_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Rate Action
A=Pay and Bill B=Bill Only M=Mark-up P=Pay Only |
| 14 | FO_HR_PAY_RATE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Employee Pay Rate |
| 15 | PAY_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | The holding currency for a bank account on the disbursing side of a settlement transaction. |
| 16 | RATE_PROFILE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Profile Type
S=Salaried Staff T=Temporary Staff V=Associated Supplier |
| 17 | FO_PAY_RATE_FACTOR | Number(5,2) | DECIMAL(4,2) NOT NULL | Rate Factor |
| 18 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL |
Rate Divisor
Default Value: 1 |
| 19 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |