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 Set ID

    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 Project Costing Business Unit

    Prompt Table: BUS_UNIT_PC_VW

    17 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
    18 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

    Default Value: %Datetime