Penn Computing

University of Pennsylvania
Penn Computing << go backback
HCM_SUPERVISORY_ORG Table    Tables and Data Elements   Human Capital Management Home   Data Warehouse Home

HCM_SUPERVISORY_ORG Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.




Data element Definition

ACTIVE_FLAG

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

A Y/N flag indicating whether the Supervisory Organization is active.

DEFAULT_COST_CENTER

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The default cost center of the Supervisory Organization. The value can be overridden at the position level.

INHERITED_AU

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The inherited Academic Unit associated by the Supervisory Organization's hierarchy.

LAST_EXTRACT_DATE

Format DATE

Indexed? No

May be Null? Yes

The date on which the record was extracted from Workday and loaded to the Data Warehouse.

MANAGER_PENN_ID

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

Then Penn ID of the manager of the Supervisory Organization.

MANAGER_WORKDAY_ID

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The Workday ID of the manager of the Supervisory Organization.

PRIMARY_BUSINESS_SITE_REF

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The primary business location of the Supervisory Organization.

RELATED_AU

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The Academic Unit directly related to the Supervisory Organization.

SUPERIOR_SUPERVISORY_ORG_ID

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The next level hierarchical parent of the Supervisory Organization.

SUPERVISORY_ORG_CODE

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The abbreviated prefix representing the school or center of the Supervisory Organization.

SUPERVISORY_ORG_ID

Format VARCHAR2(200)

Indexed? Yes

May be Null? No

The system name representing a Supervisory Organization.

SUPERVISORY_ORG_LONG_DESC

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The long description of the Supervisory Organization, including the Supervisory ORG Code, the Supervisory ORG Name, the manager name and Penn ID.

SUPERVISORY_ORG_NAME

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The descriptive name representing the Supervisory Organization for the position.

SUPERVISORY_ORG_SUBTYPE

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The type of Supervisory Organization (e.g., Department).

 
HCM_SUPERVISORY_ORG Table    Tables and Data Elements   Human Capital Management Home   Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania