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
|
*System required field
** Combination of (data_type, data_key, app_bob_id) must be unique.