CPBUSUNITTBL_HR

(SQL View)
Index Back

HR Business Unit Table

HR Business Unit Table

SELECT BUSINESS_UNIT , ACTIVE_INACTIVE , DESCR , DESCRSHORT FROM PS_BUS_UNIT_TBL_HR

  • 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