| Data element |
Definition |
AUDIT_DATE
Indexed - yes
Format - date
May be null? yes |
The date on which the audit record was created. |
AUDIT_KEY
Indexed - yes
Format - number
May be null? no |
Unique system-assigned key that identifies an audit record. |
AUDIT_TYPE
Indexed - yes
Format - varchar2(120)
May be null? yes |
The type of transaction which was audited. |
EMP_KEY
Indexed - yes
Format - number
May be null? yes |
The person who performed the transaction which was audited. |
NEW_VALUE
Indexed - no
Format - varchar2(1300)
May be null? yes |
Value of the audited field after the transaction occurred. |
OLD_VALUE
Indexed - no
Format - varchar2(1300)
May be null? yes |
Value of the audited field before the transaction occurred. |
PARAMETERS
Indexed - no
Format - varchar2(1300)
May be null? yes |
Text description of the audited transaction. |
PERSON_HOME_ORG
Indexed - yes
Format - varchar2(4)
May be null? yes |
4-digit number used to identify the organization that owns the employee’s record and is responsible for its maintenance in the PennWorks system. |
PERSON_HOME_SCHOOL_CTR
Indexed - yes
Format - varchar2(2)
May be null? yes |
2-digit number used to identify the school or center that owns the employee’s record and is responsible for its maintenance in the PennWorks system. |
PERSON_PENN_ID
Indexed - yes
Format - varchar2(8)
May be null? yes |
8-digit identification number assigned to the person by the Penn Community system. |
PROD_CODE
Indexed - yes
Format - varchar2(3)
May be null? yes |
Code for the Concur module in which the audited transaction occurred. |
SUBJECT_PK_VALUE
Indexed - yes
Format - varchar2(48)
May be null? yes |
The unique identifier for the related report (or other audited item). |
