Penn Computing

University of Pennsylvania
Penn Computing << go backback
PURPOSE_CODES Table   Tables and Data Elements   General Ledger Home   Data Warehouse Home

PURPOSE_CODES Table - Data Element Index

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



Data Element Definition
PURPOSE_CODE

Indexed - no
Format - char (2)
May be null? no

The 2-character code indicating the primary purpose of organization or fund expenditures.

Examples: 01 (Instruction), NA (Not applicable)

Values:

01  Instruction (for example, School Specific 

    "Dean's Fund")

10  Sponsored Research

11  Other, Separately Budgeted Research (for example,

    URF {University Research Foundation}, 

    RFDF {Research Facilities Development Fund},

    Technology Transfer, Research Matching Program,

    Insurance Fund)

20  Libraries

30  Student Aid (for example, University Fellowship)

40  Student Services

50  Extension & Public Service

60  Auxiliary Enterprise:  Dormitories

61  Auxiliary Enterprise:  Bookstore

62  Auxiliary Enterprise:  Dining Services

63  Auxiliary Enterprise:  Intercollegiate Athletics

64  Auxiliary Enterprise:  Other

70  Hospitals & Clinics:  Medical

71  Hospitals & Clinics:  Dental

72  Hospitals & Clinics:  Veterinary

73  Hospitals & Clinics:  Nursing

80  Independent Operations

90  Management and General (for example, Debt Service,

    Employee Benefit Pool)

92  Fundraising

93  Maintenance & Operation of Facilities (for example,

    Deferred Maintenance)

NA  not applicable (for example, General Unrestricted,

    Anticipated revenue & expense, Capital Construction

    Fund, other 02XXXX funds, Loan funds, annuities,

    capital gifts funds, agency)

    NA is used for "parent" funds and other funds where 

    purpose does not really apply (for example, capital 

    gifts, annuities)

UN  unknown, to be assigned later; UN is the default.
PURPOSE_DESC

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

The description that corresponds to the PURPOSE_CODE.

Examples: Instruction (01); Not applicable (NA)

Values:



01  Instruction (for example, School Specific 

    "Dean's Fund")

10  Sponsored Research

11  Other, Separately Budgeted Research (for example,

    URF {University Research Foundation}, 

    RFDF {Research Facilities Development Fund},

    Technology Transfer, Research Matching Program,

    Insurance Fund)

20  Libraries

30  Student Aid (for example, University Fellowship)

40  Student Services

50  Extension & Public Service

60  Auxiliary Enterprise:  Dormitories

61  Auxiliary Enterprise:  Bookstore

62  Auxiliary Enterprise:  Dining Services

63  Auxiliary Enterprise:  Intercollegiate Athletics

64  Auxiliary Enterprise:  Other

70  Hospitals & Clinics:  Medical

71  Hospitals & Clinics:  Dental

72  Hospitals & Clinics:  Veterinary

73  Hospitals & Clinics:  Nursing

80  Independent Operations

90  Management and General (for example, Debt Service,

    Employee Benefit Pool)

92  Fundraising

93  Maintenance & Operation of Facilities (for example,

    Deferred Maintenance)

NA  not applicable (for example, General Unrestricted,

    Anticipated revenue & expense, Capital Construction

    Fund, other 02XXXX funds, Loan funds, annuities,

    capital gifts funds, agency)

    NA is used for "parent" funds and other funds where 

    purpose does not really apply (for example, capital 

    gifts, annuities)

UN  unknown, to be assigned later; UN is the default.
 
PURPOSE_CODES Table   Tables and Data Elements   General Ledger 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