Penn Computing

University of Pennsylvania
Penn Computing << go backback
UPHS_ACCOUNTING_UNIT Table   Tables and Data Elements   Space@Penn Home   Data Warehouse Home

UPHS_ACCOUNTING_UNIT Table - Data Element Index

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



Data Element Definition

ACCOUNTING_DESC

Indexed - no
Format - varchar2(50)
May be null? yes

The descripton of the accounting unit.
ACCOUNTING_UNIT

Indexed - yes
Format - varchar2(15)
May be null? no

A Health System accounting unit code.

ACCOUNTING_UNIT_PARENT

Indexed - yes
Format - varchar2(15)
May be null? no

The roll-up group to which the accounting unit belongs.

DATE_CREATED

Indexed - no
Format - date
May be null? yes

The date the accounting unit record was first created.

DATE_MODIFIED

Indexed - no
Format - date
May be null? yes

The date the accounting unit record was last modified.

ORG_CODE

Indexed - yes
Format - varchar2(4)
May be null? no

The University organization code associated with the accounting unit.
USER_NAME_CREATED

Indexed - no
Format - varchar2(12)
May be null? yes

The ID of the user who created the accounting unit record.

USER_NAME_MODIFIED

Indexed - no
Format - varchar2(12)
May be null? yes

The ID of the user who modified the accounting unit record.
 
UPHS_ACCOUNTING_UNIT Table   Tables and Data Elements   Space@Penn 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