SAL_ID_TBL_JPN

(SQL Table)
 Index Back

Salary Increase ID Table

This table holds Salary Increase ID and related fields,which are defined in Page: SALINC_ID_TBL_JPN.

  • Related Language Record: SAL_ID_JPN_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SAL_INC_ID Character(12) VARCHAR2(12) NOT NULL Salary Increase ID
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 CAL_BASE_DT Date(10) DATE NOT NULL Calculation As Of Date
    4 SAL_INC_DT Date(10) DATE NOT NULL Salary Increase Date
    5 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SETID_TBL

    6 EP_REVIEW_ID Character(8) VARCHAR2(8) NOT NULL Review ID

    Prompt Table: REV_DEF_TBL_JPN

    7 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code

    Prompt Table: DEFR_CRC_JPN_VW

    8 EFF_DIGIT Character(2) VARCHAR2(2) NOT NULL Apply Rounding At
    -1=1st Decimal
    -2=2nd Decimal
    -3=3rd Decimal
    -4=4th Decimal
    -5=5th Decimal
    -6=6th Decimal
    1=Units
    2=Tens
    3=Hundreds
    4=Thousands
    9 ROUNDING_RULEJ Character(1) VARCHAR2(1) NOT NULL Rounding Rule
    D=Round Down
    H=Round
    U=Round Up