| Data element |
Definition |
ACTION_CODE
Indexed - yes
Format - number (12)
May be null? yes
|
Indicates the type of change action performed.
Values:
Refer to the DWCOMP.COMP_ACTION_TYPE_LOOKUP table for values.
|
ACTION_DATE
Indexed - yes
Format - date (7)
May be null? yes
|
The date the change action was performed.
|
CHANGE_LOG_ID
Indexed - yes
Format - number (12)
May be null? no
|
Uniquely identifies a record in the COMP_CHANGE_LOG table. |
HOME_CENTER
Indexed - yes
Format - varchar (2)
May be null? yes
|
A 2-digit number used to identify the school or center that owns the employee's record and is responsible for its maintenance. The code set is from the University's General Ledger, and has been in use since July 1, 1996.
Example: 40 (School of Medicine)
Values:
Refer to the DWADMIN.ORG_CODES table, for values where
Home_Center = Center_Code.
|
HOME_ORG
Indexed - yes
Format - varchar (4)
May be null? yes
|
The 4-digit number that represents the organization that owns the employee's record and is responsible for its maintenance. An organization is a subdivision of the University created for management purposes. An Organization belongs to only one School or Responsibility Center, and its organization code is unique. (The code set is from the University's General Ledger, and has been in use since July 1, 1996.)
Examples: 0104 (CHEMISTRY); 0001 (GEN UNIVERSITY)
Values:
Refer to the DWADMIN.ORG_CODES table for values.
|
NEW_VALUE
Indexed - no
Format - varchar2 (4000)
May be null? yes
|
The new value of the data element, as a result of the change action. |
OLD_VALUE
Indexed - no
Format - varchar2 (4000)
May be null? yes
|
The value of the data element, prior to the change action.
|
|
OPERATOR_ID
Indexed - no
Format - varchar2 (12)
May be null? no
|
The ID of the PennWorks user (or system ID) that created the change record.
|
PENN_ID
Indexed - yes
Format - char (8)
May be null? yes
|
The 8-digit identification number assigned to an individual by Penn Community system. For example: 77777777. No two persons have the same Penn ID. Note that Penn IDs created in and assigned by Penn Community begin at 10000000. Within the Data Warehouse, the numeric range from 00000000-00999999 is used for individuals who do not yet have a Penn ID in Penn Community, to allow for reliable joins between tables using the PENN_ID column. When a Penn ID appears for the individual appear in Penn Community, it will replace the assigned value throughout the Data Warehouse.
|
TABLE_FIELD_NAME
Indexed - no
Format - varchar2 (1)
May be null? yes
|
The name of the data element that was changed. |
