|
Access
Access Code
User assigned identification code.
|
The access code defines what a
|
user can do to a database object.
|
Access codes are S &null; Select, U &null;
|
Update, I &null; Insert, D &null; Delete. If a
|
user has an access code of I or D
|
then they can automatically do U
|
or S. If a user has an access code
|
of U then they can also do S.
|
Access Description
Long name, description, or title for
|
code. The access description
|
stores the meaning of the access
|
code. For example, insert, update,
|
delete, and select are all
|
descriptions of access codes.
|
Last Changed Date
|
Last Changed By
|
Timestamp
|
Class
Class Identification
System assigned identification
|
number. The class identification is
|
the unique identifier for the
|
classification. This integer is a
|
system assigned value, not user
|
assigned.
|
Abstract
Description of classification. The
|
abstract is the legal definition of
|
the classification.
|
Class Code
User assigned identification code.
|
The class code is a 10 character
|
user assigned classification code.
|
The first two characters of the
|
class code are the major class. The
|
third and fourth characters are the
|
primary class. The fifth and sixth
|
characters are the secondary class.
|
Characters 7-8 represent the next
|
relationship level. Characters 9-10
|
represent the last relationship
|
level.
|
Classification Title
Long name or title for class. The
|
classification title is the name of
|
the class code.
|
Classification Title
Class title and all parent class
|
Extended
titles. The extended classification
|
title contains the titles of all the
|
parent classifications plus this
|
classification's title. For example,
|
if this classification code is ACAP,
|
then the extended classification
|
title is &null;Accounting, Payables&null;.
|
Center Retention
Quantity of months in offsite
|
Months
storage. The center retention
|
months is the quantity of months
|
an inventory item is held in a
|
records center or off site storage
|
facility. The office retention plus
|
the center retention months equals
|
the total retention period for a
|
classification.
|
Organization
System assigned identification
|
Identification
number. The organization
|
identification is the unique
|
identification for a company,
|
department, or cost center. The
|
integer value is system assigned,
|
not user assigned. Organizations
|
own users and classifications.
|
Created By
User ID of person who created the
|
class. The created by column
|
contains the user identification of
|
the Records Manager who created
|
the classification.
|
Media Type Code
User assigned identification code
|
for media type. The media type
|
code defines what form the
|
inventory item is stored in. For
|
example, DISK&null;hard disk,
|
FLOPPY&null;floppy disk, CD&null;CD
|
ROM, TAPE &null;magnetic table,
|
FICH&null;microfich,
|
PAPER&null;hardcopy.
|
Office Retention
Quantity of months stored on site.
|
Months
The office retention months is the
|
quantity of months an inventory
|
item is held in an office storage
|
area before it is moved to a long
|
term, off site storage facility. The
|
office retention plus the center
|
retention months equals the total
|
retention period for a
|
classification.
|
Parent Class
Owning parent classification. The
|
Identification
parent class identification is the
|
identification number to the class
|
that owns this one.
|
Record Type Code
User assigned identification code.
|
The record type code defines
|
importance to a classification. For
|
example, I&null;informational and
|
O&null;official record types. Inventory
|
items assigned a classification
|
having an official record type can
|
only be deleted by a Department
|
Coordinator.
|
Retention Reference
User assigned identification
|
number. The retention reference
|
column is used to store the
|
identification number for the
|
reference document or law
|
governing a set of classes and their
|
retention periods. For example,
|
&null;26 CFR 1.6001.1&null; is a document
|
defining how checks ought to
|
stored.
|
Retention Start
User assigned identification code.
|
Code
The retention start code defines
|
when the retention period of the
|
document starts. The quantity of
|
months an inventoiy item is held
|
may start when the document first
|
created, or it may start when the
|
document is moved to an off site
|
storage facility.
|
Sensitivity Code
User assigned identification code.
|
The sensitivity code defines the
|
security associated with a
|
classification. For example,
|
TS&null;top secrete and
|
CO&null;confidential are sensitivity
|
codes.
|
Vital Flag
Vital record (Y&null;yes, N&null;no). The
|
vital flag is a yes/no column
|
denoting if the classification
|
involves vital documents. Vital
|
documents are those records
|
whose loss would have a financial
|
impact on the organization.
|
Last Changed Date
|
Last Changed By
|
Timestamp
|
Data
Entity Name
Entity or long table name. The
|
Dictionary
name of the entity in the logical
|
data model. In most cases, the
|
entity name is similar to the long
|
name for the table in the database.
|
Attribute Name
Attribute or long column name.
|
The attribute name from the
|
logical data model. In most cases,
|
this is the long name for the
|
column.
|
Attribute Definition
Attribute description or meaning.
|
The attribute definition contains
|
the description, meaning, or
|
purpose of the attribute.
|
Column Name
SQL column name. The column
|
name is the physical name for the
|
attribute in the SQL database.
|
Datatype
SQL column datatype. The
|
datatype is the physical format of
|
the column in the SQL database.
|
Entity Definition
Entity description or meaning.
|
The entity definition contains the
|
description, meaning, or purpose
|
of the entity.
|
Null Option
SQL null option. The null option
|
is a flag denoting if a column must
|
always contain data or not. If the
|
null option equals &null;Yes&null; then the
|
column does not have to contain
|
data all the time. If the null option
|
is set to &null;No&null; then the column must
|
always have data in it.
|
User Defined Data-
|
type Name
|
Last Changed Date
|
Last Changed By
|
Timestamp
|
Function
Function Number
User assigned identification
|
number. The function number is
|
the unique identification of a
|
function of the system. Function
|
numbers are assigned by
|
programmers. For example,
|
ERS110 could be a function
|
number assigned to a performance
|
report. Function numbers 000 to
|
099 are utility functions, 100 to
|
199 are performance or
|
management reports, 200 to 299
|
are operational reports, 300 to 399
|
are audit reports, 400 to 499 are
|
static table listings, 500 to 599 are
|
user functions, 600 to 699 are
|
interface functions, 700 to 799 are
|
dynamic table update functions,
|
800 to 899 are static table update
|
functions, and 900 to 999 are
|
administration functions.
|
Function Purpose
Description or purpose of function.
|
The function purpose is a text
|
column defining how the report or
|
update screen ought to be applied
|
by the user.
|
Function Subject
User assigned identification code.
|
Code
The function subject code defines
|
what area of interest, for the user,
|
the function relates to. For
|
example, MANAGEMENT &null;
|
management performance reports.
|
The function subject code uniquely
|
identifies subjects. Function
|
subjects, types, and titles are used
|
to build menus.
|
Function Title
Title or name of function. The
|
function title is the name of the
|
function as it appears at the top of
|
the window or in the menu. For
|
example &null;User Maintenance&null; is a
|
function title.
|
Function Type Code
User assigned identification code.
|
The function type code is a way of
|
grouping like functions together.
|
For example R&null;report, U&null;update,
|
M&null;menu, T&null;utility, I&null;interface are
|
all function type codes. Function
|
types, subject, and titles can be
|
used to build menus.
|
Last Changed Date
|
Last Changed By
|
Timestamp
|
Function
Function Number
User assigned identification
|
Column
number. The function number is
|
the unique identification of a
|
function of the system. Function
|
numbers are assigned by
|
programmers. For example,
|
ERS110 could be a function
|
number assigned to a performance
|
report. Function numbers 000 to
|
099 are utility functions, 100 to
|
199 are performance or
|
management reports, 200 to 299
|
are operational reports, 300 to 399
|
are audit reports, 400 to 499 are
|
static table listings, 500 to 599 are
|
user functions, 600 to 699 are
|
interface functions, 700 to 799 are
|
dynamic table update functions,
|
800 to 899 are static table update
|
functions, and 900 to 999 are
|
administration functions.
|
Table Name
SQL table name. The table name
|
is the SQL table or view name that
|
will be used as part of a WHERE
|
phrase to limit report retrieval.
|
Column Name
SQL column name. The column
|
name is the SQL table or view
|
column name that will be used as
|
part of a WHERE phrase to limit
|
report retrieval. For example,
|
DPT_NBR is the department
|
number column name.
|
Column Null Flag
Column contains NULL's, Y&null;yes,
|
N&null;no. The column null flag is
|
used to state if the WHERE phrase
|
should be constructed to search for
|
null values for the column. For
|
example, if the column name is
|
DPT_NBR and the column null
|
flag is set to Y&null;yes, then the
|
WHERE phrase should be
|
WHERE DPT_NBR &null; NULL.
|
Column Title
Long name or title of column. The
|
column title is what the users sees
|
when selecting from a list of
|
columns to use to limit report
|
retrieval. For example, when the
|
user wishes to pick the DPT_NBR
|
column, they would see
|
&null;Department Number&null;.
|
Column Type
SQL datatype (DATE, INT,
|
CHAR, FLOAT, YESNO). The
|
column type is a code defining the
|
columns datatype. For example,
|
DATE, INT, CHAR, FLOAT are
|
all column types. The column type
|
dictates which dialogue box
|
appears displaying values for the
|
column.
|
Relationship Code
Column/value relation (EQUAL,
|
LIKE, BOTH). The relationship
|
code defines if the relationship in
|
the WHERE phase could be an
|
equality, a string search, or both.
|
For example, if the relationship
|
code is EQUAL then the
|
relationship between the column
|
name and its values in the
|
WHERE phrase is IN for character
|
type columns, BETWEEN for nun-
|
null numeric columns, and &null; for
|
null numeric columns. If the
|
relationship code is LIKE then the
|
relationship between the column
|
name and its values is LIKE. If
|
the relationship code is BOTH,
|
then the user can choose either an
|
equality or string search
|
relationship.
|
Required Flag
Column value required (Y&null;yes,
|
N&null;no). The required flag denotes
|
if the user must use this column to
|
limit retrieval. This column helps
|
prevent the user from constructing
|
a report request that extracts every
|
row from the database by forcing
|
them to have a WHERE phrase on
|
at least one column name.
|
Sequence Number
Sort sequence number. The
|
sequence number is a character
|
column used to sort the column
|
titles for display on the screen.
|
The sequence number allows the
|
system to display a list of column
|
names in some other sort order
|
besides alphabetically by column
|
title.
|
Last Changed Date
|
Last Changed By
|
Timestamp
|
Function
Function Number
User assigned identification
|
Column Last
number. The function number is
|
Used
the unique identification of a
|
function of the system. Function
|
numbers are assigned by
|
programmers. For example,
|
ERS110 could be a function
|
number assigned to a performance
|
report. Function numbers 000 to
|
099 are utility functions, 100 to
|
199 are performance or
|
management reports, 200 to 299
|
are operational reports, 300 to 399
|
are audit reports, 400 to 499 are
|
static table listings, 500 to 599 are
|
user functions, 600 to 699 are
|
interface functions, 700 to 799 are
|
dynamic table update functions,
|
800 to 899 are static table update
|
functions, and 900 to 999 are
|
administration functions.
|
Column Name
SQL column name. The column
|
name is the SQL table or view
|
column name that will be used as
|
part of a WHERE phrase to limit
|
report retrieval. For example,
|
DPT_NBR is the department
|
number column name.
|
User Identification
Logon user identification. The
|
user identification is the SQL
|
database name for the user.
|
Normally, it is the user's first name
|
initial and full last name.
|
Table Name
SQL table name. The table name
|
is the SQL table or view name that
|
will be used as part ofa WHERE
|
phrase to limit report retrieval.
|
Column Value
Column values last used. This text
|
column stores the &null;right hand side&null;
|
of a SQL WHERE phrase. It
|
contains the list of values desired
|
for column when a specific report
|
was last run by a given user. For
|
example, if a user had requested a
|
set of departments to appear on a
|
report the last time it was run, then
|
this column would contain that list
|
of departments.
|
Operator Code
Code to indicate exact value or list
|
of values. Determines whether the
|
user can enter a value or select
|
from a list of values.
|
Last Changed Date
|
Last Changed By
|
Timestamp
|
Function
Table Name
SQL table name. The table name
|
Data Window
is the SQL table or view name that
|
will be used as part of a WHERE
|
phrase to limit report retrieval.
|
Column Name
SQL column name. The column
|
name is the SQL table or view
|
column name that will be used as
|
part of a WHERE phrase to limit
|
report retrieval. For example,
|
DPT_NBR is the department
|
number column name.
|
Data Window Name
Data Window Used for selection of
|
column for SQL table.
|
Last Changed Date
|
Last Changed By
|
Timestamp
|
Function Sort
Function Number
User assigned identification
|
number. The function number is
|
the unique identification of a
|
function of the system. Function
|
numbers are assigned by
|
programmers. For example,
|
ERS110 could be a function
|
number assigned to a performance
|
report. Function numbers 000 to
|
099 are utility functions, 100 to
|
199 are performance or
|
management reports, 200 to 299
|
are operational reports, 300 to 399
|
are audit reports, 400 to 499 are
|
static table listings, 500 to 599 are
|
user functions, 600 to 699 are
|
interface functions, 700 to 799 are
|
dynamic table update functions,
|
800 to 899 are static table update
|
functions, and 900 to 999 are
|
administration functions.
|
Order By
SQL ORDER BY and/or GROUP
|
BY. The order by column contains
|
the SQL GROUP BY and/or
|
ORDER BY phrase for the report
|
request.
|
Data Window Name
PowerBuilder Data Window name.
|
The Data Window name is the
|
name of the PowerBuilder
|
Data Window name that should be
|
displayed when a particular sort is
|
requested by the user. Different
|
Data Windows are used for
|
different sorts because there may
|
be different subtotaling on the
|
same report depending upon how it
|
is sorted.
|
Default Sort Flag
Default sort (Y&null;yes, N&null;no). The
|
default sort flag is a yes/no column
|
denoting what sort will be applied
|
to the report if the user does not
|
select one.
|
Order By Title
Title or long name of the sort. The
|
order by title is what the user sees
|
when selecting from a list of sort
|
sequences to apply to a report. For
|
example, the order by column
|
value may be ORDER BY
|
CO_NBR, DPT_NBR,
|
CST_CTR_NBR. The order by
|
title would be &null;By Company,
|
Department, and Cost Center
|
Numbers&null;.
|
Sequence Number
Sort sequence number. The
|
sequence number column is used
|
to sort the order by titles in some
|
other sequence other than
|
alphabetically by order by title.
|
Last Changed Date
|
Last Changed By
|
Requires Stored
Required stored procedure name.
|
Procedure
The purpose of this column is to
|
record the name of any stored
|
procedure required to generate a
|
report output. Some reports,
|
because of their complexity, can
|
not be created without the use of
|
an SQL stored procedure. If a
|
stored procedure is needed, its
|
name would be found in this
|
column.
|
Timestamp
|
Function Sort
Function Number
User assigned identification
|
Last Used
number. The function number is
|
the unique identification of a
|
function of the system. Function
|
numbers are assigned by
|
programmers. For example,
|
ERS110 could be a function
|
number assigned to a performance
|
report. Function numbers 000 to
|
099 are utility functions, 100 to
|
199 are performance or
|
management reports, 200 to 299
|
are operational reports, 300 to 399
|
are audit reports, 400 to 499 are
|
static table listings, 500 to 599 are
|
user functions, 600 to 699 are
|
interface functions, 700 to 799 are
|
dynamic table update functions,
|
800 to 899 are static table update
|
functions, and 900 to 999 are
|
administration functions.
|
Order By
SQL ORDER BY and/or GROUP
|
BY. The order by column contains
|
the SQL GROUP BY and/or
|
ORDER BY phrase for the report
|
request.
|
User Identification
Logon user identification. The
|
user identification is the SQL
|
database name for the user.
|
Normally, it is the user's first name
|
initial and full last name.
|
Last Changed Date
|
Last Changed By
|
Timestamp
|
Function
Function Subject
User assigned identification code.
|
Subject
Code
The function subject code defines
|
what area of interest, for the user,
|
the function relates to. For
|
example, MANAGEMENT &null;
|
management performance reports.
|
The function subject code uniquely
|
identifies subjects. Function
|
subjects, types, and titles are used
|
to build menus.
|
Function Subject
Long name, description or title for
|
Description
code. The function subject
|
description is the long name for
|
the subject. For example
|
management performance reports,
|
operational reports, utility, user
|
functions are all subject
|
descriptions.
|
Last Changed Date
|
Last Changed By
|
Timestamp
|
Function Type
Function Type Code
User assigned identification code.
|
The function type code is a way of
|
grouping like functions together.
|
For example R&null;report, U&null;update,
|
M&null;menu, T&null;utility, I&null;interface are
|
all function type codes. Function
|
types, subject, and titles can be
|
used to build menus.
|
Function Type
Long name, description, or title for
|
Description
code. The function type
|
description is the meaning of the
|
function type code. For example,
|
report, update, menu, utility, and
|
interface are all function type
|
descriptions.
|
Last Changed Date
|
Last Changed By
|
Timestamp
|
Function
Usage Start Date
Date/time function started being
|
Usage
used. The usage start date is the
|
date and time the update or report
|
was activated.
|
Function Number
User assigned identification
|
number. The function number is
|
the unique identification of a
|
function of the system. Function
|
numbers are assigned by
|
programmers. For example,
|
ERS110 could be a function
|
number assigned to a performance
|
report. Function numbers 000 to
|
099 are utility functions, 100 to
|
199 are performance or
|
management reports, 200 to 299
|
are operational reports, 300 to 399
|
are audit reports, 400 to 499 are
|
static table listings, 500 to 599 are
|
user functions, 600 to 699 are
|
interface functions, 700 to 799 are
|
dynamic table update functions,
|
800 to 899 are static table update
|
functions, and 900 to 999 are
|
administration functions.
|
User Identification
Logon user identification. The
|
user identification is the SQL
|
database name for the user.
|
Normally, it is the user's first name
|
initial and full last name.
|
Rows Processed
Quantity of rows retrieved or
|
updated. The quantity of rows
|
retrieved for a reporting function
|
or the quantity of rows inserted,
|
updated, or deleted for an update
|
function.
|
Usage End Date
Date/time function stopped being
|
used. The usage end date is the
|
date and time the function
|
completed processing the rows.
|
The difference between the usage
|
start and end dates is the seconds
|
required to retrieve the report rows
|
or post the changes to the database
|
for an update function.
|
Last Changed Date
|
Last Changed By
|
Timestamp
|
Inventory
Inventory
System assigned identification
|
Identification
number. The inventory
|
identification is the unique
|
identifier for a document. It is a
|
system assigned integer, not user
|
assigned.
|
Organization
System assigned identification
|
Identification
number. The organization
|
identification is the unique
|
identification for a company,
|
department, or cost center. The
|
integer value is system assigned,
|
not user assigned. Organizations
|
own users and classifications.
|
Author
Document written-by user
|
identification. Identification for
|
writer of the document. It can be
|
any value.
|
Class Identification
System assigned identification
|
number. The class identification is
|
the unique identifier for the
|
classification. This integer is a
|
system assigned value, not user
|
assigned.
|
Created By
Logon user identification. The
|
user identification is the SQL
|
database name for the user.
|
Normally, it is the user's first name
|
initial and full last name.
|
Original File Name
PC file name and extension. The
|
name of the computer file from
|
which the inventory item
|
originated.
|
Inventory Label
First line of label. The inventory
|
Line 1
label consists of three columns that
|
appear on the label for the
|
document, file folder, or box. The
|
first label line typically contains a
|
name. For example, vendor name,
|
customer name, person name, etc.
|
for the document.
|
Inventory Label
Second line of label. The
|
Line 2
inventory label consists of three
|
columns that appear on the label
|
for the document, file folder, or
|
box. The second label line
|
typically contains a geography.
|
Inventory Label
Third line of label. The inventory
|
Line 3
label consists of three columns that
|
appear on the label for the
|
document, file folder, or box. The
|
third label line typically contains
|
numbers or dates. For example,
|
part numbers, purchase order
|
numbers, contract numbers,
|
employee numbers, etc.
|
Location
System assigned identification
|
Identification
number. The location
|
identification is the unique
|
identifier for a shelf or drawer
|
within an aisle or file cabinet in a
|
storage area. It is a system
|
assigned integer, not user assigned.
|
Media Type Code
User assigned identification code
|
for media type. The media type
|
code defines what form the
|
inventory item is stored in. For
|
example, DISK&null;hard disk,
|
FLOPPY&null;floppy disk, CD&null;CD
|
ROM, TAPE&null;magnetic table,
|
FICH&null;microfich,
|
PAPER&null;hardcopy.
|
Record Type Code
User assigned identification code.
|
The record type code defines
|
importance to a classification. For
|
example, I&null;informational and
|
O&null;official record types. Inventory
|
items assigned a classification
|
having an official record type can
|
only be deleted by a Department
|
Coordinator.
|
Storage Date
Date entered into the Electronic
|
Records System. The storage date
|
is the date and time the inventory
|
item was placed into the system.
|
Series Code
Code to flag special documents. A
|
10 character code applied by the
|
user to help flag documents that
|
are special to them.
|
System Entry Date
Date Inventory was entered into
|
the system. It can never be
|
changed.
|
Last Changed Date
|
Last Changed By
|
Timestamp
|
Inventory
Inventory
System assigned identification
|
Abstract
Identification
number. The inventory
|
identification is the unique
|
identifier for a document. It is a
|
system assigned integer, not user
|
assigned.
|
Abstract
Long description of inventory
|
item. The abstract column
|
contains a long textual description
|
of the inventory item.
|
Center Retention
Quantity of months in offsite
|
Months
storage. The center retention
|
months is the quantity of months
|
an inventory item is held in a
|
records center or off site storage
|
facility. The office retention plus
|
the center retention months equals
|
the total retention period for a
|
classification.
|
Office Retention
Quantity of months stored on site.
|
Months
The office retention months is the
|
quantity of months an inventory
|
item is held in an office storage
|
area before it is moved to a long
|
term, off site storage facility. The
|
office retention plus the center
|
retention months equals the total
|
retention period for a
|
classification.
|
Last Changed Date
|
Last Changed By
|
Timestamp
|
Inventory
Inventory
System assigned identification
|
Request
Identification
number. The inventory
|
identification is the unique
|
identifier for a document. It is a
|
system assigned integer, not user
|
assigned.
|
User Identification
Logon user identification. The
|
user identification is the SQL
|
database name for the user.
|
Normally, it is the user's first name
|
initial and full last name.
|
Request Type Code
User assigned identification code.
|
The request type code is a user
|
created code to define what needs
|
to be done to an inventory item.
|
Request type codes are M&null;Change
|
Media R&null;Retrieve from storage
|
facility, S&null;sent to storage facility,
|
T&null;Retire inventory item.
|
Location
System assigned identification
|
Identification
number. The location
|
identification is the unique
|
identifier for a shelf or drawer
|
within an aisle or file cabinet in a
|
storage area. It is a system
|
assigned integer, not user assigned.
|
Media Type
User assigned identification code
|
Requested
for media type. The media type
|
code defines what form the
|
inventory item is stored in. For
|
example, DISK&null;hard disk,
|
FLOPPY&null;floppy disk, CD&null;CD
|
ROM, TAPE&null;magnetic table,
|
FICH&null;microfich,
|
PAPER&null;hardcopy.
|
Request Date
Date inventory request was
|
created. The request date is the
|
date and time a user has requested
|
and inventory item be moved from
|
one media to another.
|
Last Changed Date
|
Last Changed By
|
Timestamp
|
Inventory
Class Identification
System assigned identification
|
Statistics
number. The class identification is
|
the unique identifier for the
|
classification. This integer is a
|
system assigned value, not user
|
assigned.
|
Location
System assigned identification
|
Identification
number. The location
|
identification is the unique
|
identifier for a shelf or drawer
|
within an aisle or file cabinet in a
|
storage area. It is a system
|
assigned integer, not user assigned.
|
Record Type Code
User assigned identification code.
|
The record type code defines
|
importance to a classification. For
|
example, I&null;informational and
|
O&null;official record types. Inventory
|
items assigned a classification
|
having an official record type can
|
only be deleted by a Department
|
Coordinator.
|
Collection Date
Date statistics were collected. The
|
date the count of inventory items
|
was collected. The quantity of
|
inventory items by class and
|
record type will be collected once
|
a month or once a quarter.
|
Inventory Quantity
Quantity of inventory items found.
|
The inventory quantity contains
|
the number of inventory items
|
found for a class and record type at
|
a given point in time.
|
Last Changed Date
|
Last Changed By
|
Timestamp
|
Location
Location
System assigned identification
|
Identification
number. The location
|
identification is the unique
|
identifier for a shelf or drawer
|
within an aisle or file cabinet in a
|
storage area. It is a system
|
assigned integer, not user assigned.
|
Location
Long name, description, or title.
|
Description
The location description is the
|
meaning of a location number. For
|
example, &null;Third drawer down&null; or
|
&null;Fourth shelf up&null; are location
|
descriptions.
|
Location Number
User assigned identification
|
number. The location number is
|
the user assigned identifier for a
|
file cabinet drawer or shelf.
|
Location Type Code
User assigned identification code
|
for location type. The location
|
type code is a user assigned code
|
for the type of document storage
|
facility. For example,
|
BL&null;Building, FA&null;File area,
|
PR&null;Property, SH&null;Shelf,
|
AI&null;Aisle.
|
Parent Location
Parent or owner of location. The
|
Identification
parent location identification is the
|
unique identifier for building or
|
file area that owns the location.
|
Last Changed Date
|
Last Changed By
|
Timestamp
|
Location Type
Location Type Code
User assigned identification code
|
for location type. The location
|
type code is a user assigned code
|
for the type of document storage
|
facility. For example,
|
BL&null;Building, FA&null;File area,
|
PR&null;Property, SH&null;Shelf,
|
AI&null;Aisle.
|
Archive Facility
Archive facility (offsite storage)
|
Flag
Y/N flag. The archive facility flag
|
is a yes/no column used to define
|
if the location is found in an
|
archive facility. An archive
|
facility would be an offsite
|
warehouse, for example.
|
Location Type
Long name or title of location
|
Description
type. The location description is
|
the meaning of the location type
|
code.
|
Level Number
Location hierarchy level number.
|
The level number defines what
|
level of the location hierarchy this
|
location can be found. Level one
|
is the top level of the hierarchy and
|
level number five is the bottom.
|
Last Changed Date
|
Last Changed By
|
Timestamp
|
Media Type
Media Type Code
User assigned identification code
|
for media type. The media type
|
code defines what form the
|
inventory item is stored in. For
|
example, DISK&null;hard disk,
|
FLOPPY&null;floppy disk, CD&null;CD
|
ROM, TAPE&null;magnetic table,
|
FICH&null;microfich,
|
PAPER&null;hardcopy.
|
Media Type
Long name, description, or title.
|
Description
The media type description adds
|
meaning to the media type code.
|
For example, &null;Hardcopy&null; and
|
&null;Magnetic Tape&null; are media type
|
descriptions.
|
ERSExpress Access
File name required yes/no. The
|
Flag
purpose of this column is to record
|
whether a document being entered
|
for a given media type should have
|
a file name entered also. For
|
example, if a document is entered
|
into the system that has a media
|
type of &null;hard disk&null; , and the file
|
name required flag is set to &null;yes&null;,
|
then the system will prompt the
|
user to input a file name for the
|
document. If the file name
|
required flag is set to &null;no&null; then the
|
system will not prompt the user for
|
a file name when they input
|
information about a document.
|
Last Changed Date
|
Last Changed By
|
Timestamp
|
Object
Object Name
Name of database object (table or
|
Identification
view). The object name is the
|
SQL database name for a table or
|
view.
|
Identification
Last system assigned identification
|
number. The identification
|
column contains the last or highest
|
integer value assigned to the
|
identification column in the table.
|
For example, if the table name was
|
tbl_dpt and the identification
|
column contains 145, then the
|
highest identification number
|
assigned thus far to departments is
|
145.
|
Last Changed Date
|
Last Changed By
|
Timestamp
|
Filler 1
This is a character field of 255
|
bytes used to pad one row in the
|
identification table out to one page
|
long. This technique is use
|
because SQLServer only has page
|
locking, not row locking.
|
Filler 2
This is a character field of 255
|
bytes used to pad one row in the
|
identification table out to one page
|
long. This technique is use
|
because SQLServer only has page
|
locking, not row locking.
|
Filler 3
This is a character field of 255
|
bytes used to pad one row in the
|
identification table out to one page
|
long. This technique is use
|
because SQLServer only has page
|
locking, not row locking.
|
Filler 4
This is a character field of 255
|
bytes used to pad one row in the
|
identification table out to one page
|
long. This technique is use
|
because SQLServer only has page
|
locking, not row locking.
|
Filler 5
This is a character field of 255
|
bytes used to pad one row in the
|
identification table out to one page
|
long. This technique is use
|
because SQLServer only has page
|
locking, not row locking.
|
Filler 6
This is a character field of 255
|
bytes used to pad one row in the
|
identification table out to one page
|
long. This technique is use
|
because SQLServer only has page
|
locking, not row locking.
|
Filler 7
This is a character field of 255
|
bytes used to pad one row in the
|
identification table out to one page
|
long. This technique is use
|
because SQLServer only has page
|
locking, not row locking.
|
Filler 8
This is a character field of 151
|
bytes used to pad one row in the
|
identification table out to one page
|
long. This technique is use
|
because SQLServer only has page
|
locking, not row locking.
|
Organization
Organization
System assigned identification
|
Identification
number. The organization
|
identification is the unique
|
identification for a company,
|
department, or cost center. The
|
integer value is system assigned,
|
not user assigned. Organizations
|
own users and classifications.
|
Organization Code
User assigned identification code.
|
The organization code is a user
|
assigned identification for a
|
company, department, or cost
|
center.
|
Organization Name
Long name, description, or title.
|
The organization name is the
|
meaning for the organization code.
|
For example, &null;Account Payable&null;,
|
&null;Payroll&null; , &null;Inside Sales&null; are all
|
organization names for cost
|
centers.
|
Organization Type
User assigned organization type
|
Code
code. The organization type code
|
defines if an organization is a
|
company, department, or cost
|
center.
|
Parent Organization
Parent owner for organization.
|
Identification
The parent organization
|
identification is the unique
|
identification for a company, or
|
department that owns the
|
organization.
|
Last Changed Date
|
Last Changed By
|
Timestamp
|
Organization
Organization Type
User assigned organization type
|
Type
Code
code. The organization type code
|
defines if an organization is a
|
company, department, or cost
|
center.
|
Organization Type
Long name, description, or title.
|
Description
The organization type description
|
is the meaning of the organization
|
type code.
|
Level Number
Organization hierarchy level
|
number. The level number defines
|
at what level of the organization
|
hierarchy this organization
|
(company, department, or cost
|
center) can be found. Level
|
number one is the top of the
|
hierarchy and level number five is
|
the bottom.
|
Last Changed Date
|
Last Changed By
|
Timestamp
|
Record Type
Record Type Code
User assigned identification code.
|
The record type code defines
|
importance to a classification. For
|
example, I&null;informational and
|
O&null;official record types. Inventory
|
items assigned a classification
|
having an official record type can
|
only be deleted by a Department
|
Coordinator.
|
Record Type
Long name, description, or title.
|
Description
The record type description adds
|
meaning to the record type code.
|
Record Type
Office policy for record type. The
|
Procedure
record type procedure states the
|
office policy associated with the
|
record type. For example,
|
&null;Inventory items assigned a
|
classification having an official
|
record type can only be deleted by
|
a Department Coordinator&null;.
|
Last Changed Date
|
Last Changed By
|
Timestamp
|
Request Type
Request Type Code
User assigned identification code.
|
The request type code is a user
|
created code to define what needs
|
to be done to an inventory item.
|
Request type codes are M&null;Change
|
Media, R&null;Retrieve from storage
|
facility, S&null;sent to storage facility,
|
T&null;Retire inventory item.
|
Request Type
Long name, description, or title.
|
Description
The request type description
|
defines the meaning for the request
|
type code.
|
Last Changed Date
|
Last Changed By
|
Timestamp
|
Retention
Retention Reference
User assigned identification
|
Reference
number. The retention reference
|
column is used to store the
|
identification number for the
|
reference document or law
|
governing a set of classes and their
|
retention periods. For example,
|
&null;26 CFR 1.6001.1&null; is a document
|
defining how checks ought to
|
stored.
|
Abstract
Long description of reference.
|
The abstract column contains a
|
paragraph about the reference.
|
This paragraph states the policy for
|
storing a type of document.
|
Last Changed Date
|
Last Changed By
|
Timestamp
|
Retention
Retention Start
User assigned identification code.
|
Start
Code
The retention start code defines
|
when the retention period of the
|
document starts. The quantity of
|
months an inventory item is held
|
may start when the document first
|
created, or it may start when the
|
document is moved to an off site
|
storage facility.
|
Retention Start
Long name, description, or title.
|
Description
The retention start description adds
|
meaning to the retention start code.
|
It is the office policy stating when
|
the retention period begins for a
|
document.
|
Last Changed Date
|
Last Changed By
|
Timestamp
|
Sensitivity
Sensitivity Code
User assigned identification code.
|
The sensitivity code defines the
|
security associated with a
|
classification. For example,
|
TS&null;top secrete and
|
CO&null;confidential are sensitivity
|
codes.
|
Sensitivity
Long name, description, or title.
|
Description
The sensitivity description adds
|
meaning to the sensitivity code.
|
Last Changed Date
|
Last Changed By
|
Timestamp
|
Synonym
Synonym
System assigned identification
|
Identification
number. The synonym
|
identification is the unique
|
identifier for the synonym. This
|
integer is a system assigned value,
|
not user assigned.
|
Synonym Name
Name of synonym. The synonym
|
name is the name of the synonym.
|
Synonyms are alternate means to
|
refer to a classification. Synonyms
|
can be class codes, class names, or
|
any value the user wishes.
|
User Identification
Logon user identification. The
|
user identification is the SQL
|
database name for the user.
|
Normally, it is the user's first name
|
initial and full last name.
|
Class Identification
System assigned identification
|
number. The class identification is
|
the unique identifier for the
|
classification. This integer is a
|
system assigned value, not user
|
assigned.
|
Keyword Flag
Corporate keyword (Y&null;yes,
|
N&null;no). The keyword flag denotes
|
if this synonym is a Corporate
|
synonym. All synonyms have to
|
be related to a Corporate keyword.
|
Last Changed Date
|
Last Changed By
|
Timestamp
|
User
User Identification
Logon user identification. The
|
user identification is the SQL
|
database name for the user.
|
Normally, it is the user's first name
|
initial and full last name.
|
Default Location
System assigned identification
|
Identification
number. The location
|
identification is the unique
|
identifier for a shelf or drawer
|
within an aisle or file cabinet in a
|
storage area. It is a system
|
assigned integer, not user assigned.
|
Organization
System assigned identification
|
Identification
number. The organization
|
identification is the unique
|
identification for a company,
|
department, or cost center. The
|
integer value is system assigned,
|
not user assigned. Organizations
|
own users and classifications.
|
Mail Stop
User's mail stop. Physical mailing
|
address of an ERSuser in the
|
company.
|
Output Directory
Directory path for extract files.
|
The output directory is the disk
|
drive and directory name where
|
the user would like extract files
|
placed. If the user elects to have a
|
report exported into a spread sheet,
|
then the spread sheet will be
|
placed in the output directory.
|
Last Changed Date
|
Last Changed By
|
Timestamp
|
User Class
Class Identification
System assigned identification
|
number. The class identification is
|
the unique identifier for the
|
classification. This integer is a
|
system assigned value, not user
|
assigned.
|
User Identification
Logon user identification. The
|
user identification is the SQL
|
database name for the user.
|
Normally, it is the user's first name
|
initial and full last name.
|
Access Code
User assigned identification code.
|
The access code defines what a
|
user can do to a database object.
|
Access codes are S &null; Select, U &null;
|
Update, I &null; Insert, D &null; Delete. If a
|
user has an access code of I or D
|
then they can automatically do U
|
or S. If a user has an access code
|
of U then they can also do S.
|
Default Class Flag
Default class (Y&null;yes, N&null;no).
|
Denotes default class if none is
|
selected.
|
Last Assigned Date
Date last used. The date and time
|
the class was last assigned by the
|
user to a document. This column
|
can help determine if a user has
|
ever assigned this class to a
|
document.
|
Last Changed Date
|
Last Changed By
|
Timestamp
|