SCMLEVEL_PREAPPRUSERGROUP

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

F

No

SCMLEVELOID

NUMBER

F

No

USERGROUPOID

NUMBER

No

USERGROUPSEQUENCENUMBER

NUMBER

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: SCMLEVEL_PREAPPRUSERGROUP_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

SCMLEVELOID

Identifier for the SCMLEVEL table.

For more information, refer to the description of the foreign key SCMLEVEL_PREAPPRUSERGROUP_FK_.

See also: SCMLEVEL_PREAPPRUSERGROUP_FK_1.

Key NULL Column Type (Size)

F

No

SCMLEVELOID

NUMBER

USERGROUPOID

Identifier for the USERGROUP table.

For more information, refer to the description of the foreign key SCMLEVEL_PREAPPRUSERGROUP_FK_2.

See also: SCMLEVEL_PREAPPRUSERGROUP_FK_2.

Key NULL Column Type (Size)

F

No

USERGROUPOID

NUMBER

USERGROUPSEQUENCENUMBER

Number indicating the position of the User Group within the sequence of Pre-Approval User Groups associated with the Level.

Key NULL Column Type (Size)

No

USERGROUPSEQUENCENUMBER

NUMBER

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

SCMLEVEL_PREAPPRUSERGROUP_PK

Yes

Yes

OID

SCMLEVEL_PREAPPRUSERGROUP_FK_1

No

No

SCMLEVELOID

SCMLEVEL

SCMLEVEL_PREAPPRUSERGROUP_FK_2

No

No

USERGROUPOID

USERGROUP

Relationships

Referenced Tables

SCMLEVEL

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

Foreign Key Referenced Column(s)

SCMLEVEL_PREAPPRUSERGROUP_FK_1

OID
USERGROUP

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

Foreign Key Referenced Column(s)

SCMLEVEL_PREAPPRUSERGROUP_FK_2

OID

Referencing Tables

No referencing tables available.

Report Labels

SCMLEVEL_PREAPPRUSERGROUP_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

SCMLEVEL_PREAPPRUSERGROUP_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

SCMLEVEL_PREAPPRUSERGROUP_OID_LABEL

English:

OID

French:

OID

German:

OID

SCMLEVEL_PREAPPRUSERGROUP_SCMLEVELOID_LABEL

English:

OID

French:

OID

German:

OID

SCMLEVEL_PREAPPRUSERGROUP_USERGROUPOID_LABEL

English:

OID

French:

OID

German:

OID

SCMLEVEL_PREAPPRUSERGROUP_USERGROUPSEQUENCENUMBER_LABEL

English:

User Group Sequence Number

French:

Numéro de séquence du Groupe

German:

Laufende Nummer der Rolle

SCMLEVEL_PREAPPRUSERGROUP_VERSION_LABEL

English:

Version

French:

Version

German:

Version