User Group inbound interface is designed to load data into the following DB tables:
- PACE_MASTERDBO.PACE_USERS – user fields
- PACE_MASTERDBO.PACE_USER_GROUPS – business group fields
- PACE_MASTERDBO.STARSEC_USER_GROUP – application group fields
- PACE_MASTERDBO.EGL_CENTER_ROLE – center Role role fields
- PACE_MASTERDBO.EGL_CENTER_ROLE_USER – center Role role for User user fields
- PACE_MASTERDBO.PACE_USERS_CONTACT_INFO or PACE_MASTERDBO.PACE_MAIL_USER_INFO (only 1 exists in a database) – email field
...
If <groupCode> = ‘Business’, the list of Users will be added/deleted to/from the Business Group.
If <groupCode> = ‘Application’, the list of Users will be added/deleted to/from the Application Group.
If <groupCode> = ‘CenterRole’, the list of Users will be assigned/removed to/from the Center Role.
| CENTER_CODE | CENTER_DESCRIPTION |
|---|---|
| ACM | Account Reference Manager |
| NEWACCOUNTINGCENTER | Accounting Center |
| ARC | Archive Manager |
| PROCESSCENTER | Automation Center |
| CDC | Common |
| CC | Control Center |
| IWS | Integration and Workflow Studio |
| TRANSLATORCENTER | Language Translation Center |
| MDC | Metadata Center |
| MIGRATIONWIZARD | Migration Wizard |
| PANELS | Panels Center |
| PERFORMANCECENTER | Performance Center |
| PDCX | Portfolio Data Center |
| SCRUB | Reference Data Center (classic) |
| RDC | Reference Data Center |
| SCHEDRES | Report Viewer Center |
| REPORTINGCENTER | Reporting Center |
| SYS | System Management Center |
| UA | User Administration Center |
Passing tag 989
| Info |
|---|
Available on 17R2 environments only. Stored procedures and panels do not contain tag 989 on other versions. |
The tag 989 with ‘EXACT’ value is passed to User and Center Role lookups (qusersummary and qroles panel) in the User and User Group inbound interfaces.