BAL_ADJ_UI_CAN(SQL Table) |
Index Back |
|---|---|
EE CAN EI Bal AdjustmentAdjustment record for CAN EI balances. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
|
| 2 | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
|
| 3 | Character(3) | VARCHAR2(3) NOT NULL |
Wage Loss Replacement Plan
Prompt Table: WAGELS_PLAN_TBL |
|
| 4 | Date(10) | DATE NOT NULL | EI Period Date | |
| 5 | Date(10) | DATE NOT NULL | Earnings End Date | |
| 6 | Number(3,0) | SMALLINT NOT NULL | Balance Adjust Sequence Number | |
| 7 | DT_ENTERED | Date(10) | DATE NOT NULL | Date Entered |
| 8 | UI_WKLY_EARNS | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | EI Weekly Earnings(No Limit) |
| 9 | UI_WK_EARN_ADJ | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | EI Weekly Earnings Adjusted |
| 10 | UI_EARN_ADJ | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | EI Earnings Adjustment |
| 11 | UI_WKLY_HOURS | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | EI Weekly Hours |
| 12 | UI_WK_HRS_ADJ | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | EI Weekly Hours Adjusted |
| 13 | UI_HOURS_ADJ | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | EI Hours Adjustment |
| 14 | ADJ_REASON | Character(50) | VARCHAR2(50) NOT NULL | Adjustment Reason |