USERGROUP

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

No

NAME

VARCHAR2(50)

Yes

DESCRIPTION

VARCHAR2(255)

No

TYPE

NUMBER

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: USERGROUP_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

NAME

Name associated with the User Group.

Key NULL Column Type (Size)

No

NAME

VARCHAR2(50)

DESCRIPTION

Description associated with the User Group.

Key NULL Column Type (Size)

Yes

DESCRIPTION

VARCHAR2(255)

TYPE

Fixed value identifying the type of User Group.

Key NULL Column Type (Size)

No

TYPE

NUMBER
Value List

0 = External

1 = Internal

ARCHIVED

For internal use only.

Key NULL Column Type (Size)

Yes

ARCHIVED

NUMBER(1)
Value List

0 = no

1 = yes

ARCHIVEDDATETIME

For internal use only.

Key NULL Column Type (Size)

Yes

ARCHIVEDDATETIME

DATE

VERSION

For internal use only.

Key NULL Column Type (Size)

No

VERSION

NUMBER

Indexes

Index Primary Unique Column(s) Source Table

USERGROUP_PK

Yes

Yes

OID

Relationships

Referenced Tables

No referenced tables available.

Referencing Tables

LEVELAPPROVAL

Refer to the chapter LEVELAPPROVAL for a detailed description of the table.

Foreign Key Referencing Column

LEVELAPPROVAL_FK_3

CONTROLLEDBYUSERGROUPOID
SCMLEVEL

Refer to the chapter SCMLEVEL for a detailed description of the table.

Foreign Key Referencing Column

SCMLEVEL_FK_3

REQUESTERUSERGROUPOID

SCMLEVEL_FK_4

PRENOTIFICATIONUSERGROUPOID

SCMLEVEL_FK_5

POSTNOTIFICATIONUSERGROUPOID
SCMLEVEL_POSTAPPRUSERGROUP

Refer to the chapter SCMLEVEL_POSTAPPRUSERGROUP for a detailed description of the table.

Foreign Key Referencing Column

SCMLEVEL_POSTAPPRUSERGROU_FK_2

USERGROUPOID
SCMLEVEL_PREAPPRUSERGROUP

Refer to the chapter SCMLEVEL_PREAPPRUSERGROUP for a detailed description of the table.

Foreign Key Referencing Column

SCMLEVEL_PREAPPRUSERGROUP_FK_2

USERGROUPOID
SCMUSER_USERGROUP

Refer to the chapter SCMUSER_USERGROUP for a detailed description of the table.

Foreign Key Referencing Column

SCMUSER_USERGROUP_FK_1

USERGROUPOID
SYSTEMSETTINGS

Refer to the chapter SYSTEMSETTINGS for a detailed description of the table.

Foreign Key Referencing Column

SYSTEMSETTINGS_FK_2

USERGROUPOID

SYSTEMSETTINGS_FK_1

ADMINGROUPOID

Report Labels

USERGROUP_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

USERGROUP_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

USERGROUP_DESCRIPTION_LABEL

English:

Description

French:

Description

German:

Beschreibung

USERGROUP_NAME_LABEL

English:

Name

French:

Nom

German:

Name

USERGROUP_OID_LABEL

English:

OID

French:

OID

German:

OID

USERGROUP_TYPE_LABEL

English:

Type

French:

Type

German:

Typ

USERGROUP_VERSION_LABEL

English:

Version

French:

Version

German:

Version