ALEX_REPORTING_PERMISSION (Staging table)
| Column name | Data type | Required | Default updateable | Data target | Comments |
|---|---|---|---|---|---|
| USER_EKEY** | VARCHAR (255) | Yes* | No | ALCO_REPORTING_PERMISSION.USER_ID | External key identifying the user who has permission to report on an object |
| DATA_TYPE** | VARCHAR (40) | Yes* | No | ALCO_REPORTING_PERMISSION.PERMISSION_TYPE | Data type of the object to be reported on, (that is CostCenter, Client) Refer to the above table. These names are case-sensitive. |
| DATA_KEY** | VARCHAR (255) | Yes* | No | ALCO_REPORTING_PERMISSION.PERMISSION_OBJECT | External key of the reported object |
| ACTIVE_STATUS | SMALLINT | No | Yes | ALCO_MEMBERSHIP.MEMBER_ACTIVE_STATUS | Reporting permission status
|
* System required field
** Combination of (user_ekey, data_type, data_key) must be unique