Data Objects
Find here a list of data objects that are used by this content package from Data Delivery Service.
|
DDS objects |
Opens SQL Schema Object Tables |
|---|---|
|
Attendee |
CONCUR_EXP_DDS_OBJ_ATTENDEE |
|
Core User |
CONCUR_EXP_DDS_OBJ_CORE_USER |
|
Credit Card Transactions |
CONCUR_EXP_DDS_OBJ_CREDITCARD_TRANSACTIONS |
|
Credit Card Accounts |
CONCUR_EXP_DDS_OBJ_CREDITCARD_ACCOUNTS |
|
Expense Report |
CONCUR_EXP_DDS_OBJ_EXPENSE_REPORT |
|
List Items |
CONCUR_EXP_DDS_OBJ_LIST_ITEMS |
|
Spend User |
CONCUR_EXP_DDS_OBJ_SPEND_USER |
|
Expense Type |
CONCUR_EXP_DDS_OBJ_REF_EXPENSE_TYPE |
|
Approval & Payment Status |
CONCUR_EXP_DDS_OBJ_REF_STATUS |
|
Spend Category |
CONCUR_EXP_DDS_OBJ_REF_SPEND_CATEGORY |
|
Payment Type |
CONCUR_EXP_DDS_OBJ_REF_PAYMENT_TYPE |
The above DDS objects are loaded as JSON lines CLOB data in the database and then further referenced by stored procedures to parse and load it into normalized tables.