| Data element |
Definition |
ATN_KEY
Indexed - yes
Format - number
May be null? no |
Unique system-assigned key that identifies the attendee. |
ATN_TYPE_KEY
Indexed - yes
Format - number
May be null? yes |
Unique system-assigned key that identifies a type of attendee. |
ATTENDEE_APPROVED_AMOUNT
Indexed - no
Format - number(23,8)
May be null? yes |
The amount approved for attendee expenses. |
ATTENDEE_ENTRY_LAST_MODIFIED
Indexed - no
Format - date
May be null? yes |
Date on which the attendee/report mapping record was last modified. |
ATTENDEE_LAST_MODIFIED
Indexed - no
Format - date
May be null? yes |
Date on which the attendee record was last modified. |
COMPANY
Indexed - no
Format - varchar2(32)
May be null? yes |
Company employing the attendee. |
EMP_KEY
Indexed - yes
Format - number
May be null? yes |
Unique system-assigned key that identifies the employee in the Concur system. |
IS_DELETED
Indexed - no
Format - char(1)
May be null? yes |
Indicates that the employee has deleted the attendee from their attendee list; does not indicate the attendee was deleted from the expense entry. |
LAST_NAME
Indexed - yes
Format - varchar2(132)
May be null? yes |
Attendee last name. |
RPE_KEY
Indexed - yes
Format - number
May be null? no |
Unique system-assigned key that identifies the report entry expense. |
RPT_KEY
Indexed - yes
Format - number
May be null? yes |
Unique system-assigned key that identifies the expense report on which the expense was submitted. |
TITLE
Indexed - no
Format - varchar2(32)
May be null? yes |
Job title of the attendee. |
