BUS_UNIT_TBL_HR

(SQL Table)
 Index Back

HR Business Unit Table

HR Business Unit Table

  • Related Language Record: BUS_UNIT_HR_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 ACTIVE_INACTIVE Character(1) VARCHAR2(1) NOT NULL Definition Active or Inactive?
    A=Active
    I=Inactive

    Default Value: A

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 BUSINESS_UNIT_DUP Character(5) VARCHAR2(5) NOT NULL Clone from Business Unit

    Prompt Table: BUS_UNIT_TBL_HR

    6 DEFAULT_SETID Character(5) VARCHAR2(5) NOT NULL Default SetID

    Prompt Table: SETID_TBL

    7 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL Asset Management Business Unit
    8 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
    9 BUSINESS_UNIT_AR Character(5) VARCHAR2(5) NOT NULL AR Business Unit
    10 BUSINESS_UNIT_BAL Character(5) VARCHAR2(5) NOT NULL Balancing Business Unit
    11 BUSINESS_UNIT_BD Character(5) VARCHAR2(5) NOT NULL Budgeting Business Unit
    12 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit
    13 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL General Ledger Unit

    Prompt Table: BUS_UNIT_GL_VW

    14 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Business Unit
    15 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
    16 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

    Prompt Table: BUS_UNIT_PC_VW

    17 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit