Penn Computing

University of Pennsylvania
Penn Computing << go backback

Back to Clickable Table Diagram

CHANGE LOG - Data Element Index

The Change Log contains information on changes which occurred when
attempting to add or modify data in Penn Community.

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

Data element Definition

ACTION

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

The action taken upon the table mentioned in the TABLE_NAME field. Values for Action are:

Insert
Update
Delete

top

LOG_DATE_TIME

Indexed -  no
Format -  date
May be null? no

Date and time of the creation of this row in the Log.

 

top

PENN_ID

Indexed -  no
Format -  number (8)
May be null? yes

Penn Id for the affected member of Penn Community.

 

top

TABLE_NAME

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

Name of the table which reflects a change.

 

top

Back to Clickable Table Diagram


Documentation Contact: penncommunity@isc.upenn.edu

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