Penn Community Documentation


			<< go back

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

LOG_DATE_TIME

Indexed - no
Format - date
May be null? no

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

PENN_ID

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

Penn Id for the affected member of Penn Community.

TABLE_NAME

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

Name of the table which reflects a change.