| Data element |
Definition |
COMMENT_KEY
Indexed - yes
Format - number
May be null? no |
Unique system-assigned key that identifies the expense comment record. |
COMMENT_PARAMS
Indexed - no
Format - varchar2(2000)
May be null? yes |
Text of the expense report or report entry comment. |
COMMENT_TYPE
Indexed - no
Format - varchar2(40)
May be null? yes |
Identifies the type of expense comment. |
CREATED_BY_EMP_KEY
Indexed - no
Format - number
May be null? yes |
Unique system-assigned key that identifies the person that entered the comment. |
CREATED_BY_HOME_ORG
Indexed - yes
Format - varchar2(4)
May be null? yes |
4-digit number used to identify the organization that owns the record of the employee that created the comment and is responsible for its maintenance in the PennWorks system. |
CREATED_BY_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 record of the employee that created the comment and is responsible for its maintenance in the PennWorks system. |
CREATED_BY_PENN_ID
Indexed - yes
Format - varchar2(8)
May be null? yes |
8-digit identification number assigned by the Penn Community system to the person that entered the comment. |
CREATED_FOR_EMP_KEY
Indexed - no
Format - number
May be null? yes |
Unique system-assigned key that identifies the person for whom the comment was entered. |
CREATED_FOR_HOME_ORG
Indexed - yes
Format - varchar2(4)
May be null? yes |
4-digit number used to identify the organization that owns the record of the employee for whom the comment was entered and is responsible for its maintenance in the PennWorks system. |
CREATED_FOR_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 record of the employee for whom the comment was entered and is responsible for its maintenance in the PennWorks system. |
CREATED_FOR_PENN_ID
Indexed - yes
Format - varchar2(8)
May be null? yes |
8-digit identification number assigned by the Penn Community system to person for whom the comment was entered. |
CREATION_DATE
Indexed - no
Format - date
May be null? yes |
Date and time when the comment was entered. |
IS_LATEST
Indexed - no
Format - char(1)
May be null? yes |
|
LAST_MODIFIED
Indexed - no
Format - date
May be null? yes |
Date on which the expense comment was last modified. |
RPE_KEY
Indexed - yes
Format - number
May be null? yes |
Unique system-assigned key that identifies the report entry expense for which the expense-level comment was entered. |
RPT_KEY
Indexed - yes
Format - number
May be null? yes |
Unique system-assigned key that identifies the expense report for which the comment was entered. |
STEP_INSTANCE_KEY
Indexed - yes
Format - number
May be null? yes |
|
