HOUSEKEEPING

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

No

ACTIONTYPE

NUMBER

No

STARTDATETIME

DATE

No

USERID

VARCHAR2(20)

Yes

MESSAGE

CLOB

No

DELETESTATUS

NUMBER

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: HOUSEKEEPING_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

ACTIONTYPE

The type of the Housekeeping Action.

Key NULL Column Type (Size)

No

ACTIONTYPE

NUMBER
Value List

0 = Delete

1 = Move to Trashbin (not implemented yet)

2 = Restore from Trashbin (not implemented yet)

STARTDATETIME

The date and time at which the Housekeeping Action started.

Key NULL Column Type (Size)

No

STARTDATETIME

DATE

USERID

The ID of the User who performed the Housekeeping Action.

Key NULL Column Type (Size)

No

USERID

VARCHAR2(20)

MESSAGE

Error message generated by the system.

Key NULL Column Type (Size)

Yes

MESSAGE

CLOB

DELETESTATUS

Indication of the Delete status.

Key NULL Column Type (Size)

No

DELETESTATUS

NUMBER
Value List

0 = Success

1 = Error

2 = Warning

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

HOUSEKEEPING_PK

Yes

Yes

OID

Relationships

Referenced Tables

No referenced tables available.

Referencing Tables

No referencing tables available.

Report Labels

HOUSEKEEPING_ACTIONTYPE_LABEL

English:

Action Type

French:

Type d’action

German:

Aktionstyp

HOUSEKEEPING_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

HOUSEKEEPING_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

HOUSEKEEPING_DELETESTATUS_LABEL

English:

Delete Status

French:

Statut de suppression

German:

Bereinigungsstatus

HOUSEKEEPING_MESSAGE_LABEL

English:

Log

French:

Trace

German:

Protokoll

HOUSEKEEPING_OID_LABEL

English:

OID

French:

OID

German:

OID

HOUSEKEEPING_STARTDATETIME_LABEL

English:

Start Date/Time

French:

Début d’exécution

German:

Ausführungsbeginn

HOUSEKEEPING_USERID_LABEL

English:

User ID

French:

ID Utilisateur

German:

Benutzer-ID

HOUSEKEEPING_VERSION_LABEL

English:

Version

French:

Version

German:

Version