Penn Computing

University of Pennsylvania
Penn Computing << go backback

FIS_COMMITMENTS Table
   Tables and Data Elements   Faculty Home   Data Warehouse Home

FIS_COMMITMENTS Table - Data Element Index

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



Data element Definition
ACTION_ID

Indexed - no
Format - integer
May be null? no

The unique identifier on each action. This value is assigned by the FIS system and is not visible from the application interface. It is intended solely for the internal use in the system.

 

COMMITMENT_ID

Indexed - yes (primary key)
Format - number
May be null - no

The unique identifier of each commitment associated with an action. A single action may have multiple commitments.

COMMITMENT_TYPE

Indexed - no
Format - number(12)
May be null? no

A numeric code indicating the type of commitment.Use this to join to the FIS_COMMITMENT_TYPE_LOOKUP table on the MESSAGE_ID field. The NAME_FRIENDLY column contains the associated description (e.g., Computer, Equipment, Lab Space).

CREATE_DT

Indexed - no
Format - date
May be null? no

The date the commitment record was created.
CREATE_ID

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

The Penn ID of the person who created the record.

FIS_COMMITMENTS Table
   Tables and Data Elements   Faculty 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