Query column mappings
The following table lists the name differences for query result columns between Objective Navigator and Objective
|
Objective Navigator |
Objective |
|---|---|
|
Last Updated |
date updated |
|
Last Updated By |
last updater |
|
Id |
object id |
|
Object Aliased |
original object |
|
Type |
object type |
|
Objective Navigator |
Objective |
|---|---|
|
Barcode Id |
barcode |
|
Created By |
creator |
|
Created On |
creation date |
|
Id |
object id |
|
Last Updated |
date updated |
|
Last Updated By |
last updater |
|
Privileges |
privilege |
|
Repository |
home repository |
|
Type |
object type |
|
Objective Navigator |
Objective |
|---|---|
|
Additional Object 1 |
other object 1 |
|
Additional Object 2 |
other object 2 |
|
Description |
audit trail comment |
|
Event |
audit event |
|
Id |
object id |
|
Initiated By |
user |
|
When |
event date |
|
Objective Navigator |
Objective |
|---|---|
|
Accepted Types |
object type list |
|
Created By |
creator |
|
Created On |
creation date |
|
Fields |
catalogue fields |
|
Id |
object id |
|
Last Updated |
date updated |
|
Last Updated By |
last updater |
|
Privileges |
privilege |
|
Objective Navigator |
Objective |
|---|---|
|
Completed By |
user completed |
|
Date Submitted |
submission date |
|
Destination Repository |
home repository |
|
Duration Required |
Duration Duration Units |
|
Id |
object id |
|
Last Updated |
date updated |
|
Note |
description |
|
Object Requested |
object required |
|
Required By |
required by date |
|
Required For |
requested custodian |
|
Submitted By |
submitter |
|
Task |
name |
|
Objective Navigator |
Objective |
|---|---|
|
Created By |
creator |
|
Created On |
creation date |
|
Disposal Authority |
authority |
|
Id |
object id |
|
Last Updated |
date updated |
|
Last Updated By |
last updater |
|
Parent |
parent disposal folder |
|
Privileges |
privilege |
|
Sentence Description |
sentence sentence event sentence time sentence units |
|
Objective Navigator |
Objective |
|---|---|
|
Corporate Value |
has any corporate value versions |
|
Created By |
creator |
|
Created On |
creation date |
|
Date Approved |
latest approval date |
|
Date Display From |
latest date display from |
|
Date Display To |
latest date display to |
|
Date Released |
latest date released |
|
Editor |
current editor |
|
File Created |
date file created |
|
File Size |
file size (bytes) |
|
File Type |
document extension |
|
Id |
object id |
|
Last Edited By |
last editor |
|
Last Updated |
date updated |
|
Last Updated By |
last updater |
|
Privileges |
privilege |
|
Type |
object type |
|
Version |
latest version label latest version number |
|
Objective Navigator |
Objective |
|---|---|
|
Corporate Value |
corporate value flag |
|
Created By |
creator |
|
Created On |
creation date |
|
Date Approved |
date approval completed |
|
File |
document version file id |
|
File Created |
date file created |
|
File Part |
file part id |
|
File Size |
file size (bytes) |
|
Id |
object id |
|
Last Updated |
date updated |
|
Reason |
change reason |
|
Version |
version label version number |
|
Objective Navigator |
Objective |
|---|---|
|
Caveats |
caveat |
|
Created By |
creator |
|
Created On |
creation date |
|
Id |
object id |
|
Last Updated |
date updated |
|
Last Updated By |
last updater |
|
Privileges |
privilege |
|
Type |
object type |
|
Objective Navigator |
Objective |
|---|---|
|
Completed By |
user completed |
|
Date Content From |
requested date content from |
|
Date Content To |
requested date content to |
|
Date Required By |
required by date |
|
Date Submitted |
submission date |
|
Id |
object id |
|
Last Updated |
date updated |
|
Object Requested |
object required |
|
Submitted By |
submitter |
|
Task |
name |
|
Objective Navigator |
Objective |
|---|---|
|
Barcode Id |
barcode |
|
Caveats |
caveat |
|
Created By |
creator |
|
Created On |
creation date |
|
Date Due |
date due back |
|
File |
parent file |
|
Id |
object id |
|
Last Updated |
date updated |
|
Last Updated By |
last updater |
|
Privileges |
privilege |
|
Repository |
home repository |
|
Type |
object type |
|
Objective Navigator |
Objective |
|---|---|
|
Created By |
creator |
|
Created On |
creation date |
|
Id |
object id |
|
Last Updated |
date updated |
|
Last Updated By |
last updater |
|
Objective Navigator |
Objective |
|---|---|
|
Catalogues |
catalogue |
|
Caveats |
caveat |
|
Created By |
creator |
|
Created On |
creation date |
|
Disposal Schedule |
disposal schedule disposal schedule (inherited) |
|
Id |
object id |
|
Last Updated |
date updated |
|
Last Updated By |
last updater |
|
Privileges |
privilege |
|
Type |
object type |
|
Objective Navigator |
Objective |
|---|---|
|
Created By |
creator |
|
Created On |
creation date |
|
Id |
object id |
|
Last Updated |
date updated |
|
Last Updated By |
last updater |
|
Parent |
parent group |
|
Privileges |
privilege |
|
Type |
object type |
|
Objective Navigator |
Objective |
|---|---|
|
Created By |
creator |
|
Created On |
creation date |
|
Id |
object id |
|
Last Updated |
date updated |
|
Last Updated By |
last updater |
|
Privileges |
privilege |
|
Objective Navigator |
Objective |
|---|---|
|
Can Be Assigned |
assignable |
|
Created By |
creator |
|
Created On |
creation date |
|
Id |
object id |
|
Last Updated |
date updated |
|
Last Updated By |
last updater |
|
Privileges |
privilege |
|
Source |
source authority |
|
Type |
object type |
|
Objective Navigator |
Objective |
|---|---|
|
Created By |
creator |
|
Created On |
creation date |
|
Id |
object id |
|
Last Updated |
date updated |
|
Last Updated By |
last updater |
|
Objective Navigator |
Objective |
|---|---|
|
Barcode Id |
barcode |
|
Created By |
creator |
|
Created On |
creation date |
|
Current Location |
ancestor location |
|
Id |
object id |
|
Last Updated |
date updated |
|
Last Updated By |
last updater |
|
Privileges |
privilege |
|
Repository |
home repository |
|
Type |
object type |
|
Objective Navigator |
Objective |
|---|---|
|
Barcode Id |
barcode |
|
Created By |
creator |
|
Created On |
creation date |
|
Id |
object id |
|
Last Updated |
date updated |
|
Last Updated By |
last updater |
|
Privileges |
privilege |
|
Repository |
home repository |
|
Type |
object type |
|
Objective Navigator |
Objective |
|---|---|
|
Barcode Id |
barcode |
|
Caveats |
caveat |
|
Created By |
creator |
|
Created On |
creation date |
|
Date Due |
date due back |
|
File |
parent file |
|
File Part |
record file part |
|
Id |
object id |
|
Last Updated |
date updated |
|
Last Updated By |
last updater |
|
Parents |
ancestor |
|
Parents |
ancestor location |
|
Privileges |
privilege |
|
Repository |
home repository |
|
Type |
object type |
|
Objective Navigator |
Objective |
|---|---|
|
Barcode Id |
barcode |
|
Caveats |
caveat |
|
Created By |
creator |
|
Created On |
creation date |
|
Date Due |
date due back |
|
File |
parent file |
|
File Part |
record file part |
|
Id |
object id |
|
Last Updated |
date updated |
|
Last Updated By |
last updater |
|
Privileges |
privilege |
|
Repository |
home repository |
|
Type |
object type |
|
Objective Navigator |
Objective |
|---|---|
|
Created By |
creator |
|
Created On |
creation date |
|
Date Due |
date due back |
|
Id |
object id |
|
Last Updated |
date updated |
|
Last Updated By |
last updater |
|
Privileges |
privilege |
|
Objective Navigator |
Objective |
|---|---|
|
Caveats |
caveat |
|
Corporate Value |
has any corporate value version |
|
Created By |
creator |
|
Created On |
creation date |
|
Date Approved |
latest date approved |
|
Date Display From |
latest date display from |
|
Date Display To |
latest date display to |
|
Date Released |
latest released |
|
Editor |
current editor |
|
File Created |
date file created |
|
File Size |
file size (bytes) |
|
File Type |
document extension |
|
Id |
object id |
|
Last Edited By |
last editor |
|
Last Updated |
date updated |
|
Last Updated By |
last updater |
|
Privileges |
privilege |
|
Reserved To |
reserved to |
|
Type |
object type |
|
Version |
latest version label latest version number |
|
Objective Navigator |
Objective |
|---|---|
|
Archivists |
archivist list |
|
Barcode Id |
barcode |
|
Clerks |
clerk list |
|
Created By |
creator |
|
Created On |
creation date |
|
Id |
object id |
|
Last Updated |
date updated |
|
Last Updated By |
last updater |
|
Managers |
manager list |
|
Privileges |
privilege |
|
Staff |
staff list |
|
Type |
object type |
|
Objective Navigator |
Objective |
|---|---|
|
Created By |
creator |
|
Created On |
creation date |
|
Id |
object id |
|
Last Updated |
date updated |
|
Last Updated By |
last updater |
|
Privileges |
privilege |
|
Objective Navigator |
Objective |
|---|---|
|
Created By |
creator |
|
Created On |
creation date |
|
Date Deleted |
date cancelled |
|
E-mail Address |
email address |
|
Id |
object id |
|
Last Login |
last login date |
|
Last Updated |
date updated |
|
Last Updated By |
last updater |
|
Login Id |
user signon |
|
Parent |
parent group |
|
Privileges |
privilege |
|
Type |
object type |
|
User inactivated on |
date inactivated |
|
Objective Navigator |
Objective |
|---|---|
|
Caveats |
caveat |
|
Corporate Value |
has any corporate value version |
|
Created By |
creator |
|
Created On |
creation date |
|
Date Approved |
latest date approved |
|
Date Display From |
latest date display from |
|
Date Display To |
latest date display to |
|
Date Released |
latest date released |
|
Editor |
current editor |
|
File Created |
date file created |
|
File Size |
file size (bytes) |
|
File Type |
document extension |
|
Id |
object id |
|
Last Edited By |
last editor |
|
Last Updated |
date updated |
|
Last Updated By |
last updater |
|
Privileges |
privilege |
|
Type |
object type |
|
Version |
version number version label |
|
Objective Navigator |
Objective |
|---|---|
|
Action |
alarm action |
|
Cancelled By |
user disabled |
|
Case Object |
alarm case object |
|
Created By |
creator |
|
Created On |
creation date |
|
Date Triggered |
date completed |
|
Id |
object id |
|
Last Updated |
date updated |
|
Last Updated By |
last updater |
|
Object Alarmed |
slip or task |
|
Privileges |
privilege |
|
Resumed By |
user resumed |
|
Suspended By |
user suspended |
|
Objective Navigator |
Objective |
|---|---|
|
Comment |
description |
|
Created By |
creator |
|
Due |
workflow due date |
|
Id |
object id |
|
Last Updated |
date updated |
|
Last Updated By |
last updater |
|
Priority |
slip priority |
|
Started |
creation date |
|
Objective Navigator |
Objective |
|---|---|
|
Chosen Action |
action definition completed |
|
Completed By |
user completed |
|
Created By |
creator |
|
Id |
object id |
|
Priority |
workflow task priority |
|
Started |
creation date |
|
Status |
task status |
|
Task |
name |
|
Workflow |
parent workflow |