GP_BUS_UNIT_VW(SQL View) |
Index Back |
---|---|
Used in Payroll AnalyticsCloned HR Business Unit Table to use in Payroll Analytics |
SELECT A.BUSINESS_UNIT ,A.DESCR FROM PS_BUS_UNIT_TBL_HR A WHERE A.ACTIVE_INACTIVE = 'A' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
2 | BUSINESS_DESCR | Character(60) | VARCHAR2(60) NOT NULL | Business Description |