ALEX_USER_PREFERENCE (Staging table)

Column name Data type Required Default update able Data target Comments
USER_EKEY** VARCHAR (255) Yes* No alco_user_preference.user_id User external key --Primary Key
CCT_FILTER_STATUS SMALLINT Yes* No alco_user_preference. cct_filter_status Credit card transaction filter status.
  • 1 = Include only unattached transactions
  • 2 = Include only attached transactions
  • 3 = Include unattached and attached transactions
  • 4 = Include only removed transactions
  • 5 = Include unattached and removed transactions
  • 6 = Include attached and removed transactions
  • 7 = Include all transactions
CCT_FILTER_PERIOD SMALLINT No No alco_user_preference.cct_filter_period Credit card transaction filter period
  • 0 or null = all dates
  • 1 = Date range specified with cct_filter_startdate and cct_filter_enddate columns
  • 2 = Last year from the current date
  • 3 = Last quarter from the current date
  • 4 = Last month from the current date
  • 5 = Last calendar year
  • 6 = Year to date
CCT_FILTER_STARTDATE DATETIME No No alco_user_preference. cct_filter_startdate Credit card transaction filter start date
CCT_FILTER_ENDDATE DATETIME No No alco_user_preference. cct_filter_enddate Credit card transaction filter end date.
CCT_FILTER_TRANSACTION_TYPE VARCHAR (255) No No alco_user_preference. cct_filter_transaction_type Credit card transaction filter transaction type.
CCT_FILTER_CARD_NAME VARCHAR (255) No No alco_user_preference. cct_filter_card_name Credit card transaction filter card name.
CCT_FILTER_ER_TITLE VARCHAR (255) No No alco_user_preference. cct_filter_er_title Credit card transaction filter expense report title.
CCT_FILTER_ER_ID VARCHAR (255) No No alco_user_preference. cct_filter_er_id Credit card transaction filter expense report ID.

* System required field

** Value must be unique