SETIDPrompt Table: SP_SETID_NONVW
JOBCODEWA_COMPCODEASOF_DTA=Active
I=Inactive
Default Value: A
1=Annual
2=Hourly
3=Monthly
Default Value: 1
WA_MKT_RATE_TBL(SQL Table) |
Index Back |
|---|---|
Market Rate TableMarket Rate Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 3 | WA_COMPCODE |
Character(10) | VARCHAR2(10) NOT NULL | Compensation Code for use in Workforce Analytics. Typcially will be mapped from HRMS Earnings Codes, Deduction Codes, and Benefit Plans. |
| 4 | ASOF_DT |
Date(10) | DATE NOT NULL | As of Date |
| 5 | ASOF_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
As of Status
A=Active I=Inactive Default Value: A |
| 6 | WA_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Rate Type for use in Market Based Pricing and Base Pay Structure modules of Workforce Analytics. Represents the frequency salaries are communicated.
1=Annual 2=Hourly 3=Monthly Default Value: 1 |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 8 | WA_MEASURE_VAL | Number(22,6) | DECIMAL(21,6) NOT NULL | Measure Value (Market Rate) |