HP_ERN_ACC_RULE

(SQL Table)
Index Back

Earnings Account Mapping Rule

Define the field search priority the Actual Distribution process will use to select a match.

  • Parent record: HP_ERN_ACC_TMPL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    2 HP_FLDNAME Character(18) VARCHAR2(18) NOT NULL Field Name
    3 HP_FLDDESCR Character(18) VARCHAR2(18) NOT NULL Field Name
    4 HP_FLDREQ Character(1) VARCHAR2(1) NOT NULL Required?

    Y/N Table Edit

    Default Value: N

    5 HP_FLDUSED Character(1) VARCHAR2(1) NOT NULL Used?

    Y/N Table Edit

    Default Value: N

    6 HP_FLDPRIORITY Number(2,0) SMALLINT NOT NULL Priority