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.