BAL_ADJ_UI_CAN

(SQL Table)
Index Back

EE CAN EI Bal Adjustment

Adjustment record for CAN EI balances.

  • Parent record: PERSON
  • # 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