ALEX_USER_GROUP_DEFN (Staging table)

Column name Data type Required Default updateable Data target Comments
EXTERNAL_KEY** VARCHAR (255) Yes* No ALCO_EXTERNAL_KEY.EXTERNAL_KEY External key – primary key
GROUP_NAME VARCHAR (255) Yes* Yes ALCO_GROUP_DEFN. GROUP_NAME Name of group
GROUP_DESC VARCHAR (255) No Yes ALCO_GROUP_DEFN.GROUP_ DESCRIPTION Description of group
ACTIVE_STATUS SMALLINT Yes* Yes ALCO_GROUP_DEFN.GROUP_ ACTIVE_STATUS Flag to indicate whether group is active or inactive.
  • 1 = Active
  • 0 = Inactive
GROUP_TYPE INTEGER (38) Yes* No ALCO_GROUP_DEFN. GROUP_TYPE_CODE Valid values are:
  • 1 Role
  • 2 Data
  • 4 Admin
  • 8 User
ORG_ID INTEGER (38) No No None Used for Expense Management implementations only. Used during initial setup of Expense Management by scripting process. Deprecated in Release 6.1. Retained only for backward compatibility of pre-6.1 Extensity Advantage customers.
GRP_ID INTEGER (38) No No None Used for Expense Management implementations only. Used during initial setup of Expense Management by scripting process. Deprecated in Release 6.1. Retained only for backward compatibility of pre-6.1 Extensity Advantage customers.
AVAILABLE_IN_REPORT SMALLINT No Yes ALCO_GROUP_DEFN.AVAILABLE_IN_REPORT Indicates whether this group will be available in reports.
  • 1 = True
  • 0 or null = False
Applicable only to groups of type User.

*System required field

** Value must be unique