Penn Computing

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

HCM_POSITION_COSTING Table - Data Element Index

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




Data element Definition

COSTING_COA_CNAC

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The Chart of Accounts Center Net Asset code (CNAC) segment value used in the costing allocation.

COSTING_COA_CREF

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The Chart of Accounts Center Reference (CREF) code segment value used in the costing allocation.

COSTING_COA_FUND

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The Chart of Accounts Fund code segment value used in the costing allocation.

COSTING_COA_ORG

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The Chart of Accounts Organization (ORG) code segment value used in the costing allocation.

COSTING_COA_PROGRAM

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The Chart of Accounts Program code segment value used in the costing allocation.

COSTING_COA_RESP_ORG

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The fund responsible organization for the Fund code segment value used in the costing allocation.

COSTING_EARNING_CODE

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The earning code associated with the position costing record.

COSTING_EARNING_DESC

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The description of the earning code associated with the position costing record.

COSTING_END_DATE

Format DATE

Indexed? Yes

May be Null? Yes

The end date of the costing allocation.

COSTING_END_FISCAL_YEAR

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The fiscal year of the end date of the costing allocation.

COSTING_END_YEAR

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The calendar year of the end date of the costing allocation.

COSTING_START_DATE

Format DATE

Indexed? Yes

May be Null? Yes

The start date of the costing allocation.

COSTING_START_FISCAL_YEAR

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The fiscal year of the start date of the costing allocation.

COSTING_START_YEAR

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The calendar year of the start date of the costing allocation.

DISTRIBUTION_PERCENT

Format NUMBER

Indexed? No

May be Null? Yes

The percentage of the total costing allocations for the position represented by the particular costing record.

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.

PENN_ID

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The 8-digit identification number assigned to the worker by Penn Community system. For example: 77777777. No two persons have the same Penn ID. Note that Penn IDs created in and assigned by Penn Community begin at 10000000. Within the Data Warehouse, the numeric range from 00000000-00999999 is used for individuals who do not yet have a Penn ID in Penn Community, to allow for reliable joins between tables using the PENN_ID column. When a Penn ID appears for the individual appear in Penn Community, it will replace the assigned value throughout the Data Warehouse.

POSITION_ID

Format VARCHAR2(200)

Indexed? Yes

May be Null? No

The unique system identifier for the position.

POSITION_PENN_COST_CENTER

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The 4-digit number for the Penn Cost Center associated with the position.

POSITION_SCHOOL_CTR

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The 2-digit number used to identify the school or center for the Penn Cost Center associated with the position.

POSITION_SUPERVISORY_ORG_ID

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The system name representing the Supervisory Organization for the position.

POSITION_SUPERVISORY_ORG_NAME

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The descriptive name representing the Supervisory Organization for the position.

PRI_PENN_COST_CENTER

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The 4-digit number for the Penn Cost Center associated with the worker's primary position.

PRI_PENN_SCH_CTR

Format VARCHAR2(200)

Indexed? Yes

May be Null? Yes

The 2-digit number used to identify the school or center for the Penn Cost Center associated with the worker's primary position.

WORKDAY_ID

Format VARCHAR2(200)

Indexed? Yes

May be Null? No

The unique ID for the worker in Workday. Although 8 digits long, it is distinct from and should not be confused with the Penn ID.

 
HCM_POSITION_COSTING 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