COUNTRYDefault Value: USA
Prompt Table: COUNTRY_TBL
STATEPrompt Table: STATE_NAMES_TBL
EFFDTDefault Value: %date
ERNCDPrompt Table: EARNINGS_TBL
E=Exclude Earnings Code
F=Full
H=One Half
T=Two Thirds
FO_WC_ST_EARN(SQL Table) |
Index Back |
|---|---|
PBWorker's Comp State EarningsThis table is used to calculate the worker's comp based on the earnings code to exclude from calculation, use full amount for calculation, use one half or two thirds of the pay amount for the calculation. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Default Value: USA Prompt Table: COUNTRY_TBL |
| 2 | STATE |
Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_NAMES_TBL |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | ERNCD |
Character(3) | VARCHAR2(3) NOT NULL |
Earnings Code
Prompt Table: EARNINGS_TBL |
| 5 | FO_WC_STHRS_ONLY | Character(1) | VARCHAR2(1) NOT NULL |
For Pay/Bill GL WC
E=Exclude Earnings Code F=Full H=One Half T=Two Thirds |