ALEX_PROXY (Staging table)
| Column name | Data type | Required | Default updateable | Data target | Comments |
|---|---|---|---|---|---|
| USER_EKEY** | VARCHAR (255) | No | No | ALCO_PROXY.USER_ID | External key of user being represented |
| PROXY_USER_EKEY** | VARCHAR (255) | Yes* | No | ALCO_PROXY.PROXY_USER_ID | External key of user representing another user |
| PROXY_ROLE** | SMALLINT | Yes* | No | ALCO_PROXY.PROXY_ROLE |
|
| BUSINESS_PROCESS_ID** | INTEGER | Yes* | No | ALCO_PROXY.BUSINESS_RPOCESS_ID | Business process ID of the application proxy. See table above for values. |
| ONLY_OUT_OF_OFFICE | SMALLINT | Yes* | No | ALCO_PROXY.ONLY_OUT_OF_OFFICE | A value of 1 means apply proxy only when user is out of office. Only applicable for proxy reviewer |
| ACTIVE_STATUS | SMALLINT | Yes* | Yes | N/A |
|
| USER_GROUP_EKEY** | VARCHAR (255) | No | No | ALCO_PROXY.USER_GROUP_ID | External key of represented user group |
*System required field
** Combination of (user_ekey, user_group_ekey, proxy_user_ekey, proxy_role, business_process_id) must be unique