FORMATS: TABULAR HIERARCHICAL

Entity
Entity Name Entity Definition  
ACCOUNT An Account represents a system account that has elevated privileges or special features/functions needed by the Staff for support.
  Attribute Name Attribute Definition Attribute Datatype Attribute Is PK Attribute Required Attribute Is FK
  Account Identifier An Account Identifier is a unique value assigned to represent a certain database account that has special priviledges needed by the Staff to maintain the Application Database. INTEGER Yes Yes No
  Application Database Identifier An Application Database Identifier is a unique value that denotes a particular application database. INTEGER No Yes Yes
  User Identifier A User Identifier is an alphanumeric value used to depict a Staff or an Application which must access the database. VARCHAR(25) No Yes No
  Account Description An Account Description is the free form text that describes the Account or User Identifier VARCHAR(150) No Yes No
  Password Text The Password Text is an encrypted value that is a given account's secret code for logging onto the database. VARCHAR(50) No Yes No
APPLICATION An Application is a piece or multiple pieces of software that have been coupled together for a specific purpose.
  Attribute Name Attribute Definition Attribute Datatype Attribute Is PK Attribute Required Attribute Is FK
  Application Identifier An Application Identifier is a unique value assigned to represent a particular software application. INTEGER Yes Yes No
  Application Name An Application Name is the word or words by which a particular piece of software is known. VARCHAR(50) No Yes No
  Application Description An Application Description is the free form description that further clarifies or defines a piece of software VARCHAR(150) No Yes No
  Start Date A Start Date is the specific 24 hour period on the Gregorian calendar that denotes when the application began active use. DATE No Yes No
  End Date An End Date is the specific 24 hour period on the Gregorian calendar that denotes when the application ceased to be used. DATE No No No
APPLICATION DATABASE An Application Database is the part of an application that is used to store data for a given piece of software or pieces of software for a particular set of related functions.
  Attribute Name Attribute Definition Attribute Datatype Attribute Is PK Attribute Required Attribute Is FK
  Application Database Identifier An Application Database Identifier is a unique value that denotes a particular application database. INTEGER Yes Yes No
  Application Identifier An Application Identifier is a unique value assigned to represent a particular software application. INTEGER No Yes Yes
  Database Instance Name A Database Instance Name is the word or words by which a particular instance of an Application Database is known by. VARCHAR(50) No Yes No
  Start Up Procedure Text A Start Up Procedure Text is the free form text that describes the steps necessary to bring up the database instance. VARCHAR(4000) No No No
  Shut Down Procedure Text A Shut Down Procedure Text is the free form text that describes the steps necessary to bring down the database instance. VARCHAR(4000) No No No
  Login Procedure Text A Login Procedure Text is the free form text that describes the steps necessary to log into the application database for a specific purpose, usually maintenance of some kind. VARCHAR(4000) No No No
  Backup Procedure Text A Backup Procedure Text is the free form text that describes the steps necessary to backup the database. VARCHAR(4000) No No No
  Environment Code An Environment Code is a particular set of letters and/or numbers that represents a particular software domain. VARCHAR(10) No Yes Yes
  Start Date A (Application Database) Start Date is the specific 24 hour period on the Gregorian calendar that the Application Database began operations. DATE No Yes No
  End Date An (Application Database) End Date is the specific 24 hour period on the Gregorian Calendar that denotes when the Application Database ceased operations. DATE No No No
  Tablespace Name
A Tablespace Name is the word or words by which a particular tablespace in the database is known.  Usually one or more is assigned to a specific database.
VARCHAR(50) No No No
  Current Size Bytes Number A Current Size Bytes Number is the numeric value in bytes that shows the current size of the entire Application Database NUMBER(15,2) No No No
  Service Level Agreement Code A Service Level Agreement Code is a specific alphanumeric code assigned to represent a particular response time to critical events and the timing of their resolution VARCHAR(10) No Yes Yes
  Database Management System Identifier A Database Management System Identifier is a unique value assigned to represent a specific database management system and its specific version. INTEGER No Yes Yes
  Application Database Status Code An Application Database Status Code is specific combination of letters and/or numbers that represents the current state of a particular Application Database. VARCHAR(10) No Yes Yes
APPLICATION DATABASE HOST An Application Database Host is the main server/computer that has a particular applications database running on it.
  Attribute Name Attribute Definition Attribute Datatype Attribute Is PK Attribute Required Attribute Is FK
  Application Database Host Identifier
An Application Database Host Identifier is a unique value that represents the assignment of  an Application Host and the related Application Database
INTEGER Yes Yes No
  Application Host Identifier An Application Host Identifier is a unique value assigned to represent a particular computer functioning as a server. INTEGER No Yes Yes
  Application Database Identifier An Application Database Identifier is a unique value that denotes a particular application database. INTEGER No Yes Yes
  Standby Indicator A Standby Indicator is a binary representation of whether or not a particular application database host has been configured as a Standby ("Y") database or not ("N"). CHAR(1) No Yes No
APPLICATION DATABASE NOTE An Application Database Note is some free form text that is relevant to the application.
  Attribute Name Attribute Definition Attribute Datatype Attribute Is PK Attribute Required Attribute Is FK
  Application Database Note Identifier An Application Database Note Identifier is a unique value assigned to represent a particular collection of free form text that pertains to a given application database. INTEGER Yes Yes No
  Application Database Identifier An Application Database Identifier is a unique value that denotes a particular application database. INTEGER No Yes Yes
  Note Text A Note Text is the free form text that provides additional information or context for a given Application Database. VARCHAR(4000) No Yes No
APPLICATION DATABASE STATUS An Application Database Status reflects the known state of a particular application's database.
  Attribute Name Attribute Definition Attribute Datatype Attribute Is PK Attribute Required Attribute Is FK
  Application Database Status Code An Application Database Status Code is specific combination of letters and/or numbers that represents the current state of a particular Application Database. VARCHAR(10) Yes Yes No
  Application Database Status Description An Application Database Status Description is the free form text that further clarifies or defines a particular Application Database Status. VARCHAR(150) No Yes No
APPLICATION HOST A Host is a computer server that usually exists for the purpose of hosting some kind of software (web server, database, application server, etc...)
  Attribute Name Attribute Definition Attribute Datatype Attribute Is PK Attribute Required Attribute Is FK
  Application Host Identifier An Application Host Identifier is a unique value assigned to represent a particular computer functioning as a server. INTEGER Yes Yes No
  Application Host Name An Application Host Name is the word or words by which a particular computer server is known by. VARCHAR(256) No Yes No
  Location Text A Location Text is the free form textual description of where a particular computer server resides. VARCHAR(4000) No No No
  Central Processing Unit Core Count A Central Processing Unit Core Count is the number of CPUs a particular host may physically have available. INTEGER No No No
  Operating System Code An Operating System Code is the unique value assigned to represent a particular computer operating system and the particular version. VARCHAR(10) No Yes Yes
  Enterprise Data Architecture Group Identifier An Enterprise Data Architecture Group Identifier is a unique value that represents a certain collection of individuals within the group INTEGER No Yes Yes
APPLICATION STAFF An Application Staff is the association of an individual to a particular application.
  Attribute Name Attribute Definition Attribute Datatype Attribute Is PK Attribute Required Attribute Is FK
  Application Staff Identifier An Application Staff Identifier is a unique value that represents the intersection between the person in the organization and the application database that the individual is responsible for. INTEGER Yes Yes No
  Application Identifier An Application Identifier is a unique value assigned to represent a particular software application. INTEGER No No Yes
  Staff Identifier A Staff Identifier is a unique value assigned to represent a particular person within the organization. INTEGER No Yes Yes
  Staff Role Code A Staff Role Code is an alphanumeric code that is used to represent a particular set of functions and responsibilities that an individual in the organization fulfills. VARCHAR(10) No Yes Yes
  Start Date An (Application Staff) Start Date denotes the specific 24 hour period on the Gregorian calendar when a particular Staff member became associated with a unique piece of software. DATE No Yes No
  End Date An (Application Staff) End Date denotes the specific 24 hour period on the Gregorian calendar when a particular Staff memeber ceases to be associated with a unique piece of software. DATE No No No
AUTHORIZED REQUESTOR An Authorized Requestor is an individual who is permitted to request additional resources for a piece of computer hardware
  Attribute Name Attribute Definition Attribute Datatype Attribute Is PK Attribute Required Attribute Is FK
  Authorized Requestor Identifier An Authorized Requestor Identifier is a unique value assigned to represent a specific person who is authorized to request hardware changes to a particular application database. INTEGER Yes Yes No
  First Name A (Authorized Requestor) First Name is the word or words that a particular individual is commonly addressed by. VARCHAR(50) No No No
  Last Name A (Authorized Requestor) Last Name is the word or words that a particular individual is known by in addition to their First Name. VARCHAR(50) No No No
  Electronic Mail Address
The domain-based address by which a "electronic mailbox" is referred to.
VARCHAR(320) No Yes No
  Telephone Number
The number that designates the origination or destination of a voice or data transmission via a public telephone carrier.  This EXCLUDES the country calling code and any extension number provided by a Private Branch Exchange (PBX).
VARCHAR(14) No No No
CALENDAR EVENT TYPE A Calendar Event Type classifies an event that occurs on a particular day in association with a particular staff individual.
  Attribute Name Attribute Definition Attribute Datatype Attribute Is PK Attribute Required Attribute Is FK
 
Calendar Event  Code
A Calendar Event Code is a combination of letters and/or numbers that represents a unique kind of temporal thing. VARCHAR(10) Yes Yes No
  Calendar Event Name A Calendar Event Name is the word or words by which a unique temporal thing is known by. VARCHAR(50) No Yes No
DATABASE INSTANCE A Database Instance represents processes and the portion of an Oracle database that runs in memory.
  Attribute Name Attribute Definition Attribute Datatype Attribute Is PK Attribute Required Attribute Is FK
  Database Instance Identifier A Database Instance Identifier is a unique value assigned to represent a particular instance of a database. INTEGER Yes Yes No
  Database Instance Name A Database Instance Name is the word or words by which an exact database instance is known by. VARCHAR(50) No Yes No
  Application Database Host Identifier
An Application Database Host Identifier is a unique value that represents the assignment of  an Application Host and the related Application Database
INTEGER No No Yes
DATABASE INSTANCE SERVICE
A Database Instance Service is defined as a logical representation of a database, which is the way a database is presented to clients. A database can be presented as multiple services and a service can be implemented as multiple database instances. The service name is a string that is the global database name, that is, a name comprising the database name and domain name, entered during installation or database creation.
http://docs.oracle.com/cd/B19306_01/network.102/b14212/glossary.htm
  Attribute Name Attribute Definition Attribute Datatype Attribute Is PK Attribute Required Attribute Is FK
  Database Instance Service Identifier A Database Instance Service Identifier is the unique value assigned to represent the Service Name running on a particular database instance. INTEGER Yes Yes No
  Database Instance Service Name A Database Instance Service Name is the word or words by which a particular database instance is known by. VARCHAR(100) No No No
  Database Instance Identifier A Database Instance Identifier is a unique value assigned to represent a particular instance of a database. INTEGER No Yes Yes
DATABASE MANAGEMENT SYSTEM
A Database Management System is software that handles the storage, retrieval, and updating of data in a computer system.  More commonly known as a database.
  Attribute Name Attribute Definition Attribute Datatype Attribute Is PK Attribute Required Attribute Is FK
  Database Management System Identifier A Database Management System Identifier is a unique value assigned to represent a specific database management system and its specific version. INTEGER Yes Yes No
  Database Management System Name A Database Management System Name is the word or words by which a particular set of computer programs is known by that is designed for the storage and retrieval of data. VARCHAR(75) No Yes No
  Version Number A (DBMS) Version Number is the alphanumeric representation of a given DBMS at particular point in time. VARCHAR(100) No Yes No
  Enterprise Data Architecture Group Identifier An Enterprise Data Architecture Group Identifier is a unique value that represents a certain collection of individuals within the group INTEGER No Yes Yes
ENTERPRISE DATA ARCHITECTURE GROUP The Enterprise Data Architecture Group classifies a group of people into one of the sub-categories within EDA.
  Attribute Name Attribute Definition Attribute Datatype Attribute Is PK Attribute Required Attribute Is FK
  Enterprise Data Architecture Group Identifier An Enterprise Data Architecture Group Identifier is a unique value that represents a certain collection of individuals within the group INTEGER Yes Yes No
  Enterprise Data Architecture Group Name An Enterprise Data Architecture Group Name is the word or words by which a certain collection of individuals within the larger group are known by. VARCHAR(50) No Yes No
ENVIRONMENT An Environment represents a collection of servers, software, data, etc..for the purposes of either development, quality assurance or the running of a production application or set of applications.
  Attribute Name Attribute Definition Attribute Datatype Attribute Is PK Attribute Required Attribute Is FK
  Environment Code An Environment Code is a particular set of letters and/or numbers that represents a particular software domain. VARCHAR(10) Yes Yes No
  Environment Description An Environment Description is the free form text that further clarifies or describes a software domain. VARCHAR(150) No Yes No
EVENT An Event is somethng that happens that is noteworthy or notable
  Attribute Name Attribute Definition Attribute Datatype Attribute Is PK Attribute Required Attribute Is FK
  Event Identifier An Event Identifier is a unique value assigned to represent a temporal incident that occured for a given Application Database. INTEGER Yes Yes No
  Application Database Identifier An Application Database Identifier is a unique value that denotes a particular application database. INTEGER No Yes Yes
  Technology Event Type Identifier A Technology Event Type Identifier is a unique value that represents kind of computer / software occurence that may be planned or unexpected. INTEGER No Yes Yes
  Summary Text A Summary Text is the free form text that describes something that has happened at a particular point in time VARCHAR(4000) No Yes No
  Start Timestamp A Start Timestamp is a particular point within the noted 24 hour period on the Gregorian calendar that something was first noticed or started to happen. TIMESTAMP No Yes No
  End Timestamp An End Timestamp is a particular point within the noted 24 hour period on the Gregorian calendar that something came to an end. TIMESTAMP No No No
OPERATING SYSTEM An Operating System represents a particular collection of software programs centered around a particular kernel that runs a computer.
  Attribute Name Attribute Definition Attribute Datatype Attribute Is PK Attribute Required Attribute Is FK
  Operating System Code An Operating System Code is the unique value assigned to represent a particular computer operating system and the particular version. VARCHAR(10) Yes Yes No
  Operating System Name An Operating System Name is the word or words by which a particular kernel and related applications are known by. VARCHAR(50) No No No
  Version Number A Version Number is an alphanumeric representation of the Operating System at a point in time. VARCHAR(100) No No No
PROVISIONING A Provisioning represents one or more Provisoining Requests for additonal resources, usually disk space, but can also be CPUs and memory.
  Attribute Name Attribute Definition Attribute Datatype Attribute Is PK Attribute Required Attribute Is FK
  Provisioning Identifier A Provisioning Identifier is a unique value assigned to represent one or more requested hardware changes to an application database server. INTEGER Yes Yes No
  Application Database Identifier An Application Database Identifier is a unique value that denotes a particular application database. INTEGER No Yes Yes
  Provisioning Request Timestamp A Provisioning Request Timestamp is a certain point in time within the noted 24 hour period on the Gregorian calendear during which additional server resources were asked for. TIMESTAMP No Yes No
  Authorized Requestor Identifier An Authorized Requestor Identifier is a unique value assigned to represent a specific person who is authorized to request hardware changes to a particular application database. INTEGER No Yes Yes
  Comment Text A Commnet Text is the free form text with provides additional information regarding a particular Provisioning Request. VARCHAR(4000) No Yes No
PROVISIONING REQUEST A Provisioning Request represents a specific application for additonal resources, usually disk space, but can also be CPUs and memory.
  Attribute Name Attribute Definition Attribute Datatype Attribute Is PK Attribute Required Attribute Is FK
  Provisioning Request Identifier A Provisioning Request Identifier is the unique value that represents precisely what hardware change is being requested by the Authorized Requestor. INTEGER Yes Yes No
  Provisioning Identifier A Provisioning Identifier is a unique value assigned to represent one or more requested hardware changes to an application database server. INTEGER No Yes Yes
  Requested Size Count A Requested Size Count is the numeric value of the kind of request being made. NUMBER(15,2) No Yes No
  Provisioning Request Type Code A Provisioning Request Type Code is a alphanumeric value that classifies the type of Provisioning Request being made. VARCHAR(10) No Yes Yes
  Comment Text A Comment Text is the free form text that further clarifies the requested resources. VARCHAR(4000) No No No
PROVISIONING REQUEST TYPE
A Provisioning Request Type classifies the kind of request being made.  In other words, is a request be made for additional CPUs, disk space, or RAM.
  Attribute Name Attribute Definition Attribute Datatype Attribute Is PK Attribute Required Attribute Is FK
  Provisioning Request Type Code A Provisioning Request Type Code is a alphanumeric value that classifies the type of Provisioning Request being made. VARCHAR(10) Yes Yes No
  Provisioning Request Type Description A Provisioning Request Type Description is the free form text that clarifies the categorization of the request. VARCHAR(150) No Yes No
SERVICE LEVEL AGREEMENT A Service Level Agreement represents a written statement about response and resolution times for various systems varying by their importance to the business.
  Attribute Name Attribute Definition Attribute Datatype Attribute Is PK Attribute Required Attribute Is FK
  Service Level Agreement Code A Service Level Agreement Code is a specific alphanumeric code assigned to represent a particular response time to critical events and the timing of their resolution VARCHAR(10) Yes Yes No
  Service Level Agreement Description A Service Level Agreement Description is the free form text that further clarifies or defines a particular Service Level Agreement Code. VARCHAR(150) No Yes No
STAFF A Staff is an individual who works within the organization
  Attribute Name Attribute Definition Attribute Datatype Attribute Is PK Attribute Required Attribute Is FK
  Staff Identifier A Staff Identifier is a unique value assigned to represent a particular person within the organization. INTEGER Yes Yes No
  First Name A First Name is the word by which an individual is generaly known by VARCHAR(50) No No No
  Last Name A Last Name is the word or words which makes up the last part of an individual's name. VARCHAR(50) No No No
  Staff Role Code A Staff Role Code is an alphanumeric code that is used to represent a particular set of functions and responsibilities that an individual in the organization fulfills. VARCHAR(10) No Yes Yes
  Work Telephone Number
The number that designates the origination or destination of a voice or data transmission via a public telephone carrier.  This EXCLUDES the country calling code and any extension number provided by a Private Branch Exchange (PBX).
VARCHAR(14) No No No
  Cell Telephone Number
The number that designates the origination or destination of a voice or data transmission via a public telephone carrier.  This EXCLUDES the country calling code and any extension number provided by a Private Branch Exchange (PBX).
VARCHAR(14) No No No
  Start Date A Start Date denotes the specific 24 hour period on the Gregorian calendar that an individual became a part of the Staff DATE No Yes No
  End Date An End Date denotes the specific 24 hour period on the Gregorian calendar that an individual ceased to be an active member of the staff. DATE No No No
  Team Code A Team Code is an alphanumeric representation of a particalur collection of Staff who either perform the same function or work on the same DBMS. VARCHAR(10) No Yes Yes
  Enterprise Data Architecture Group Identifier An Enterprise Data Architecture Group Identifier is a unique value that represents a certain collection of individuals within the group INTEGER No Yes Yes
STAFF CALENDAR A Staff Calendar is representation of a series of events that occurs in relation to members of the organization.
  Attribute Name Attribute Definition Attribute Datatype Attribute Is PK Attribute Required Attribute Is FK
  Staff Calendar Event Identifier A Staff Calendar Event Identifier is the unique value assigned to represent a particular event that a certain individual within the organization is involved in. INTEGER Yes Yes No
  Start Event Date A (Staff Calendar) Start Event Date is a particular 24 hour period on the Gregorian calendar where something relating to a given Staff member begins. DATE No Yes No
  End Event Date An (Staff Calendar) End Event Date is the particular 24 hour period on the Gregorian calendar that denotes the conclusion of something relating to a given Staff member. DATE No Yes No
  Enterprise Data Architecture Group Identifier An Enterprise Data Architecture Group Identifier is a unique value that represents a certain collection of individuals within the group INTEGER No Yes Yes
  Staff Identifier A Staff Identifier is a unique value assigned to represent a particular person within the organization. INTEGER No Yes Yes
 
Calendar Event  Code
A Calendar Event Code is a combination of letters and/or numbers that represents a unique kind of temporal thing. VARCHAR(10) No Yes Yes
STAFF EVENT  
  Attribute Name Attribute Definition Attribute Datatype Attribute Is PK Attribute Required Attribute Is FK
  Staff Event Identifier   INTEGER Yes Yes No
  Staff Identifier A Staff Identifier is a unique value assigned to represent a particular person within the organization. INTEGER No No Yes
  Event Identifier An Event Identifier is a unique value assigned to represent a temporal incident that occured for a given Application Database. INTEGER No No Yes
  Start Timestamp   TIMESTAMP No No No
  End Timestamp   TIMESTAMP No No No
STAFF ROLE A Staff Role is a particular job function being fulfilled by a person within the organization
  Attribute Name Attribute Definition Attribute Datatype Attribute Is PK Attribute Required Attribute Is FK
  Staff Role Code A Staff Role Code is an alphanumeric code that is used to represent a particular set of functions and responsibilities that an individual in the organization fulfills. VARCHAR(10) Yes Yes No
  Staff Role Description A Staff Role Description is the free form text that further clarifies a Staff Role Code. VARCHAR(150) No Yes No
TEAM A Team is a group of individuals within the organization that perform similar operations / functions for a specific combination of hardware and software
  Attribute Name Attribute Definition Attribute Datatype Attribute Is PK Attribute Required Attribute Is FK
  Team Code A Team Code is an alphanumeric representation of a particalur collection of Staff who either perform the same function or work on the same DBMS. VARCHAR(10) Yes Yes No
  Team Name A Team Name is the word or words by which a given group of the Staff is commonly known by. VARCHAR(50) No No No
TECHNOLOGY EVENT TYPE A Technology Event Type classifies a specific kind of thing that occured in relation to a given set of hardware and software
  Attribute Name Attribute Definition Attribute Datatype Attribute Is PK Attribute Required Attribute Is FK
  Technology Event Type Identifier A Technology Event Type Identifier is a unique value that represents kind of computer / software occurence that may be planned or unexpected. INTEGER Yes Yes No
  Technology Event Type Description A Technology Event Type Description is the free form text that further defines or clarifies a something that happens in the context of a computer or technology setting. VARCHAR(150) No Yes No
  Planned Indicator A Planned Indicator is a binary representation of whether or not a particular occurrence was preplanned ("Y") or if it was spontaneous ("N"). CHAR(1) No Yes No