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 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
2 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
3 | WAGE_LOSS_PLAN | Character(3) | VARCHAR2(3) NOT NULL |
Wage Loss Replacement Plan
Prompt Table: WAGELS_PLAN_TBL |
4 | UI_PERIOD_DT | Date(10) | DATE NOT NULL | EI Period Date |
5 | EARNS_END_DT | Date(10) | DATE NOT NULL | Earnings End Date |
6 | BAL_ADJ_SEQ | 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 |