GVT_BAL_ADJ_LIM

(SQL Table)
 Index Back

EE Pay Limit Balance Adj

Adjustment record for employee pay limit balances.

  • Parent record: PER_ORG_ASGN_VW

    • # 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 BALANCE_ID Character(2) VARCHAR2(2) NOT NULL Balance ID

    Prompt Table: BALANCE_ID_TBL

    4 BALANCE_YEAR Number(4,0) SMALLINT NOT NULL Balances for Year

    Prompt Table: BALANCE_YR_VW

    5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    6 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code

    Prompt Table: EARNINGS_TBL

    7 BAL_ADJ_SEQ Number(3,0) SMALLINT NOT NULL Balance Adjust Sequence Number
    8 DT_ENTERED Date(10) DATE NOT NULL Date Entered
    9 BALANCE_QTR Number(3,0) SMALLINT NOT NULL Balances for Quarter

    Prompt Table: BALANCE_ID_QTR

    10 BALANCE_PERIOD Number(3,0) SMALLINT NOT NULL Balances for Period

    Prompt Table: BALANCE_ID_DEF

    11 GVT_LT_BAL Signed Number(15,2) DECIMAL(13,2) NOT NULL Life time balance.
    12 GRS_YTD Signed Number(15,2) DECIMAL(13,2) NOT NULL Gross Earnings YTD
    13 GRS_QTD Signed Number(15,2) DECIMAL(13,2) NOT NULL Gross Earnings QTD
    14 GRS_MTD Signed Number(15,2) DECIMAL(13,2) NOT NULL Gross Earnings MTD
    15 GVT_LT_BAL_ADJ Signed Number(15,2) DECIMAL(13,2) NOT NULL Life time balance adjusted.
    16 GRS_YTD_ADJ Signed Number(15,2) DECIMAL(13,2) NOT NULL Gross Earnings YTD Adjusted
    17 GRS_QTD_ADJ Signed Number(15,2) DECIMAL(13,2) NOT NULL Gross Earnings QTD Adjusted
    18 GRS_MTD_ADJ Signed Number(15,2) DECIMAL(13,2) NOT NULL Gross Earnings MTD Adjusted
    19 GRS_ADJ Signed Number(15,2) DECIMAL(13,2) NOT NULL Gross Earnings Adjustment
    20 ADJ_REASON Character(50) VARCHAR2(50) NOT NULL Adjustment Reason