| Data element |
Definition |
CA_KEY
Indexed - yes
Format - number
May be null? no |
Unique system-assigned key that identifies the cash advance on which the comment was entered. |
CASH_ADVANCE_COMMENT
Indexed - no
Format - varchar2(2000)
May be null? yes |
Text of the cash advance comment. |
COMMENT_DATE
Indexed - no
Format - date
May be null? yes |
Date when the cash advance comment was entered. |
COMMENTER_HOME_ORG
Indexed - yes
Format - varchar2(4)
May be null? yes |
4-digit number used to identify the organization that owns the commenter’s record and is responsible for its maintenance in the PennWorks system. |
COMMENTER_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 commenter’s record and is responsible for its maintenance in the PennWorks system. |
COMMENTER_PENN_ID
Indexed - yes
Format - varchar2(8)
May be null? yes |
8-digit identification number assigned to the commenter by the Penn Community system. |
EMP_KEY
Indexed - yes
Format - number
May be null? yes |
Unique system-assigned key that identifies the employee entering the cash advance comment. |
LAST_MODIFIED
Indexed - no
Format - date
May be null? yes |
Date on which the cash advance comment record was last modified. |
