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 |