ALEX_APPLICATION_FILTER (Staging table)

Column name Data type Required Default update able Data target Comments
DATA_TYPE** VARCHAR (40) Yes* No Data type of the member to be assigned to the application filter. Refer to the above table.
Note: These names are case-sensitive.
DATA_KEY** VARCHAR (255) Yes* No ALCO_PROJECT_NUMBER.PROJECT_NUMBER_ID External key for this data type
APP_BOB_ID** INTEGER Yes* No ALCO_PROJECT_NUMBER.APP_FLAGS Name of application filter to assign to Refer to the above table for the application filter.
ACTIVE_STATUS SMALLINT Yes* Yes Membership status
  • 1 = Active
  • 0 = Inactive

*System required field

** Combination of (data_type, data_key, app_bob_id) must be unique.