FORMATS: TABULAR HIERARCHICAL

Table
Table Name Table Comment    
ACCT An Account represents a system account that has elevated privileges or special features/functions needed by the Staff for support.
  Column Name Column Datatype Column Comment Column Is PK Column Transform Comment
  ACCT_ID INTEGER 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. Yes  
  APP_DB_ID INTEGER An Application Database Identifier is a unique value that denotes a particular application database. No  
  USR_ID VARCHAR2(25) A User Identifier is an alphanumeric value used to depict a Staff or an Application which must access the database. No  
  PW_TXT VARCHAR2(50) The Password Text is an encrypted value that is a given account's secret code for logging onto the database. No  
  ACCT_DS VARCHAR2(150) An Account Description is the free form text that describes the Account or User Identifier No  
  CRT_BY_USR_ID VARCHAR2(50) The arbitrary character/number combination assigned to uniquely identify a person or system that accessed the database for the purpose of inserting a new record in the database. No  
  CRT_TS TIMESTAMP   No  
  UPDT_BY_USR_ID VARCHAR2(50)   No  
  UPDT_TS TIMESTAMP   No  
  Entity Name  
  ACCOUNT
    Attribute Name Attribute Rolename Attribute Datatype Attribute Definition Attribute Is PK
    Account Identifier   INTEGER 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. Yes
    Application Database Identifier   INTEGER An Application Database Identifier is a unique value that denotes a particular application database. No
    User Identifier   VARCHAR(25) A User Identifier is an alphanumeric value used to depict a Staff or an Application which must access the database. No
    Account Description   VARCHAR(150) An Account Description is the free form text that describes the Account or User Identifier No
    Password Text   VARCHAR(50) The Password Text is an encrypted value that is a given account's secret code for logging onto the database. No
APP An Application is a piece or multiple pieces of software that have been coupled together for a specific purpose.
  Column Name Column Datatype Column Comment Column Is PK Column Transform Comment
  APP_ID INTEGER An Application Identifier is a unique value assigned to represent a particular software application. Yes  
  APP_NME VARCHAR2(50) An Application Name is the word or words by which a particular piece of software is known. No  
  APP_DS VARCHAR2(150) An Application Description is the free form description that further clarifies or defines a piece of software No  
  END_DT DATE An End Date is the specific 24 hour period on the Gregorian calendar that denotes when the application ceased to be used. No  
  STR_DT DATE A Start Date is the specific 24 hour period on the Gregorian calendar that denotes when the application began active use. No  
  CRT_BY_USR_ID VARCHAR2(50) The arbitrary character/number combination assigned to uniquely identify a person or system that accessed the database for the purpose of inserting a new record in the database. No  
  CRT_TS TIMESTAMP   No  
  UPDT_BY_USR_ID VARCHAR2(50)   No  
  UPDT_TS TIMESTAMP   No  
  Entity Name  
  APPLICATION
    Attribute Name Attribute Rolename Attribute Datatype Attribute Definition Attribute Is PK
    Application Identifier   INTEGER An Application Identifier is a unique value assigned to represent a particular software application. Yes
    Application Name   VARCHAR(50) An Application Name is the word or words by which a particular piece of software is known. No
    Application Description   VARCHAR(150) An Application Description is the free form description that further clarifies or defines a piece of software No
    Start Date   DATE A Start Date is the specific 24 hour period on the Gregorian calendar that denotes when the application began active use. No
    End Date   DATE An End Date is the specific 24 hour period on the Gregorian calendar that denotes when the application ceased to be used. No
APP_DB 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.
  Column Name Column Datatype Column Comment Column Is PK Column Transform Comment
  APP_DB_ID INTEGER An Application Database Identifier is a unique value that denotes a particular application database. Yes  
  APP_ID INTEGER An Application Identifier is a unique value assigned to represent a particular software application. No  
  DB_INST_NME VARCHAR2(50) A Database Instance Name is the word or words by which a particular instance of an Application Database is known by. No  
  STR_UP_PROC_TXT VARCHAR2(4000) A Start Up Procedure Text is the free form text that describes the steps necessary to bring up the database instance. No  
  SHUT_DOWN_PROC_TXT VARCHAR2(4000) A Shut Down Procedure Text is the free form text that describes the steps necessary to bring down the database instance. No  
  LOGIN_PROC_TXT VARCHAR2(4000) 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. No  
  END_DT DATE An (Application Database) End Date is the specific 24 hour period on the Gregorian Calendar that denotes when the Application Database ceased operations. No  
  STR_DT DATE A (Application Database) Start Date is the specific 24 hour period on the Gregorian calendar that the Application Database began operations. No  
  ENV_CD VARCHAR2(10) An Environment Code is a particular set of letters and/or numbers that represents a particular software domain. No  
  SRVC_LVL_AGRMT_CD VARCHAR2(10) 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 No  
  TBLSP_NME VARCHAR2(50)
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.
No  
  CURR_SIZE_BYTES_NBR NUMBER(15,2) A Current Size Bytes Number is the numeric value in bytes that shows the current size of the entire Application Database No  
  BU_PROC_TXT VARCHAR2(4000) A Backup Procedure Text is the free form text that describes the steps necessary to backup the database. No  
  DBMS_ID INTEGER A Database Management System Identifier is a unique value assigned to represent a specific database management system and its specific version. No  
  APP_DB_STS_CD VARCHAR2(10) An Application Database Status Code is specific combination of letters and/or numbers that represents the current state of a particular Application Database. No  
  CRT_BY_USR_ID VARCHAR2(50) The arbitrary character/number combination assigned to uniquely identify a person or system that accessed the database for the purpose of inserting a new record in the database. No  
  CRT_TS TIMESTAMP   No  
  UPDT_BY_USR_ID VARCHAR2(50)   No  
  UPDT_TS TIMESTAMP   No  
  Entity Name  
  APPLICATION DATABASE
    Attribute Name Attribute Rolename Attribute Datatype Attribute Definition Attribute Is PK
    Application Database Identifier   INTEGER An Application Database Identifier is a unique value that denotes a particular application database. Yes
    Application Identifier   INTEGER An Application Identifier is a unique value assigned to represent a particular software application. No
    Database Instance Name   VARCHAR(50) A Database Instance Name is the word or words by which a particular instance of an Application Database is known by. No
    Start Up Procedure Text   VARCHAR(4000) A Start Up Procedure Text is the free form text that describes the steps necessary to bring up the database instance. No
    Shut Down Procedure Text   VARCHAR(4000) A Shut Down Procedure Text is the free form text that describes the steps necessary to bring down the database instance. No
    Login Procedure Text   VARCHAR(4000) 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. No
    Backup Procedure Text   VARCHAR(4000) A Backup Procedure Text is the free form text that describes the steps necessary to backup the database. No
    Environment Code   VARCHAR(10) An Environment Code is a particular set of letters and/or numbers that represents a particular software domain. No
    Start Date   DATE A (Application Database) Start Date is the specific 24 hour period on the Gregorian calendar that the Application Database began operations. No
    End Date   DATE An (Application Database) End Date is the specific 24 hour period on the Gregorian Calendar that denotes when the Application Database ceased operations. No
    Tablespace Name   VARCHAR(50)
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.
No
    Current Size Bytes Number   NUMBER(15,2) A Current Size Bytes Number is the numeric value in bytes that shows the current size of the entire Application Database No
    Service Level Agreement Code   VARCHAR(10) 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 No
    Database Management System Identifier   INTEGER A Database Management System Identifier is a unique value assigned to represent a specific database management system and its specific version. No
    Application Database Status Code   VARCHAR(10) An Application Database Status Code is specific combination of letters and/or numbers that represents the current state of a particular Application Database. No
APP_DB_HST An Application Database Host is the main server/computer that has a particular applications database running on it.
  Column Name Column Datatype Column Comment Column Is PK Column Transform Comment
  APP_DB_HST_ID INTEGER
An Application Database Host Identifier is a unique value that represents the assignment of  an Application Host and the related Application Database
Yes  
  APP_HST_ID INTEGER An Application Host Identifier is a unique value assigned to represent a particular computer functioning as a server. No  
  APP_DB_ID INTEGER An Application Database Identifier is a unique value that denotes a particular application database. No  
  STANDBY_IND CHAR(1) 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"). No  
  CRT_BY_USR_ID VARCHAR2(50) The arbitrary character/number combination assigned to uniquely identify a person or system that accessed the database for the purpose of inserting a new record in the database. No  
  CRT_TS TIMESTAMP   No  
  UPDT_BY_USR_ID VARCHAR2(50)   No  
  UPDT_TS TIMESTAMP   No  
  Entity Name  
  APPLICATION DATABASE HOST
    Attribute Name Attribute Rolename Attribute Datatype Attribute Definition Attribute Is PK
    Application Database Host Identifier   INTEGER
An Application Database Host Identifier is a unique value that represents the assignment of  an Application Host and the related Application Database
Yes
    Application Host Identifier   INTEGER An Application Host Identifier is a unique value assigned to represent a particular computer functioning as a server. No
    Application Database Identifier   INTEGER An Application Database Identifier is a unique value that denotes a particular application database. No
    Standby Indicator   CHAR(1) 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"). No
APP_DB_NOTE An Application Database Note is some free form text that is relevant to the application.
  Column Name Column Datatype Column Comment Column Is PK Column Transform Comment
  APP_DB_NOTE_ID INTEGER 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. Yes  
  APP_DB_ID INTEGER An Application Database Identifier is a unique value that denotes a particular application database. No  
  NOTE_TXT VARCHAR2(4000) A Note Text is the free form text that provides additional information or context for a given Application Database. No  
  CRT_BY_USR_ID VARCHAR2(50) The arbitrary character/number combination assigned to uniquely identify a person or system that accessed the database for the purpose of inserting a new record in the database. No  
  CRT_TS TIMESTAMP   No  
  UPDT_BY_USR_ID VARCHAR2(50)   No  
  UPDT_TS TIMESTAMP   No  
  Entity Name  
  APPLICATION DATABASE NOTE
    Attribute Name Attribute Rolename Attribute Datatype Attribute Definition Attribute Is PK
    Application Database Note Identifier   INTEGER 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. Yes
    Application Database Identifier   INTEGER An Application Database Identifier is a unique value that denotes a particular application database. No
    Note Text   VARCHAR(4000) A Note Text is the free form text that provides additional information or context for a given Application Database. No
APP_DB_STS An Application Database Status reflects the known state of a particular application's database.
  Column Name Column Datatype Column Comment Column Is PK Column Transform Comment
  APP_DB_STS_CD VARCHAR2(10) An Application Database Status Code is specific combination of letters and/or numbers that represents the current state of a particular Application Database. Yes  
  APP_DB_STS_DS VARCHAR2(150) An Application Database Status Description is the free form text that further clarifies or defines a particular Application Database Status. No  
  CRT_BY_USR_ID VARCHAR2(50) The arbitrary character/number combination assigned to uniquely identify a person or system that accessed the database for the purpose of inserting a new record in the database. No  
  CRT_TS TIMESTAMP   No  
  UPDT_BY_USR_ID VARCHAR2(50)   No  
  UPDT_TS TIMESTAMP   No  
  Entity Name  
  APPLICATION DATABASE STATUS
    Attribute Name Attribute Rolename Attribute Datatype Attribute Definition Attribute Is PK
    Application Database Status Code   VARCHAR(10) An Application Database Status Code is specific combination of letters and/or numbers that represents the current state of a particular Application Database. Yes
    Application Database Status Description   VARCHAR(150) An Application Database Status Description is the free form text that further clarifies or defines a particular Application Database Status. No
APP_HST A Host is a computer server that usually exists for the purpose of hosting some kind of software (web server, database, application server, etc...)
  Column Name Column Datatype Column Comment Column Is PK Column Transform Comment
  APP_HST_ID INTEGER An Application Host Identifier is a unique value assigned to represent a particular computer functioning as a server. Yes  
  APP_HST_NME VARCHAR2(256) An Application Host Name is the word or words by which a particular computer server is known by. No  
  LOC_TXT VARCHAR2(4000) A Location Text is the free form textual description of where a particular computer server resides. No  
  CPU_CORE_COUNT INTEGER A Central Processing Unit Core Count is the number of CPUs a particular host may physically have available. No  
  OS_CD VARCHAR2(10) An Operating System Code is the unique value assigned to represent a particular computer operating system and the particular version. No  
  EDA_GRP_ID INTEGER An Enterprise Data Architecture Group Identifier is a unique value that represents a certain collection of individuals within the group No  
  CRT_BY_USR_ID VARCHAR2(50) The arbitrary character/number combination assigned to uniquely identify a person or system that accessed the database for the purpose of inserting a new record in the database. No  
  CRT_TS TIMESTAMP   No  
  UPDT_BY_USR_ID VARCHAR2(50)   No  
  UPDT_TS TIMESTAMP   No  
  Entity Name  
  APPLICATION HOST
    Attribute Name Attribute Rolename Attribute Datatype Attribute Definition Attribute Is PK
    Application Host Identifier   INTEGER An Application Host Identifier is a unique value assigned to represent a particular computer functioning as a server. Yes
    Application Host Name   VARCHAR(256) An Application Host Name is the word or words by which a particular computer server is known by. No
    Location Text   VARCHAR(4000) A Location Text is the free form textual description of where a particular computer server resides. No
    Central Processing Unit Core Count   INTEGER A Central Processing Unit Core Count is the number of CPUs a particular host may physically have available. No
    Operating System Code   VARCHAR(10) An Operating System Code is the unique value assigned to represent a particular computer operating system and the particular version. No
    Enterprise Data Architecture Group Identifier   INTEGER An Enterprise Data Architecture Group Identifier is a unique value that represents a certain collection of individuals within the group No
APP_STAFF An Application Staff is the association of an individual to a particular application.
  Column Name Column Datatype Column Comment Column Is PK Column Transform Comment
  APP_STAFF_ID INTEGER 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. Yes  
  APP_ID INTEGER An Application Identifier is a unique value assigned to represent a particular software application. No  
  STAFF_ID INTEGER A Staff Identifier is a unique value assigned to represent a particular person within the organization. No  
  STAFF_ROLE_CD VARCHAR2(10) 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. No  
  STR_DT 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. No  
  END_DT 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. No  
  CRT_BY_USR_ID VARCHAR2(50) The arbitrary character/number combination assigned to uniquely identify a person or system that accessed the database for the purpose of inserting a new record in the database. No  
  CRT_TS TIMESTAMP   No  
  UPDT_BY_USR_ID VARCHAR2(50)   No  
  UPDT_TS TIMESTAMP   No  
  Entity Name  
  APPLICATION STAFF
    Attribute Name Attribute Rolename Attribute Datatype Attribute Definition Attribute Is PK
    Application Staff Identifier   INTEGER 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. Yes
    Application Identifier   INTEGER An Application Identifier is a unique value assigned to represent a particular software application. No
    Staff Identifier   INTEGER A Staff Identifier is a unique value assigned to represent a particular person within the organization. No
    Staff Role Code   VARCHAR(10) 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. No
    Start Date   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. No
    End Date   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. No
AUTHRZD_REQSTR An Authorized Requestor is an individual who is permitted to request additional resources for a piece of computer hardware
  Column Name Column Datatype Column Comment Column Is PK Column Transform Comment
  AUTHRZD_REQSTR_ID INTEGER 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. Yes  
  FRST_NME VARCHAR2(50) A (Authorized Requestor) First Name is the word or words that a particular individual is commonly addressed by. No  
  LAST_NME VARCHAR2(50) A (Authorized Requestor) Last Name is the word or words that a particular individual is known by in addition to their First Name. No  
  EMAIL_ADR VARCHAR2(320)
The domain-based address by which a "electronic mailbox" is referred to.
No  
  TEL_NBR VARCHAR2(14)
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).
No  
  CRT_BY_USR_ID VARCHAR2(50) The arbitrary character/number combination assigned to uniquely identify a person or system that accessed the database for the purpose of inserting a new record in the database. No  
  CRT_TS TIMESTAMP   No  
  UPDT_BY_USR_ID VARCHAR2(50)   No  
  UPDT_TS TIMESTAMP   No  
  Entity Name  
  AUTHORIZED REQUESTOR
    Attribute Name Attribute Rolename Attribute Datatype Attribute Definition Attribute Is PK
    Authorized Requestor Identifier   INTEGER 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. Yes
    First Name   VARCHAR(50) A (Authorized Requestor) First Name is the word or words that a particular individual is commonly addressed by. No
    Last Name   VARCHAR(50) A (Authorized Requestor) Last Name is the word or words that a particular individual is known by in addition to their First Name. No
    Electronic Mail Address   VARCHAR(320)
The domain-based address by which a "electronic mailbox" is referred to.
No
    Telephone Number   VARCHAR(14)
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).
No
CAL_EVENT_TYP A Calendar Event Type classifies an event that occurs on a particular day in association with a particular staff individual.
  Column Name Column Datatype Column Comment Column Is PK Column Transform Comment
  CAL_EVENT__CD VARCHAR2(10) A Calendar Event Code is a combination of letters and/or numbers that represents a unique kind of temporal thing. Yes  
  CAL_EVENT_NME VARCHAR2(50) A Calendar Event Name is the word or words by which a unique temporal thing is known by. No  
  CRT_BY_USR_ID VARCHAR2(50) The arbitrary character/number combination assigned to uniquely identify a person or system that accessed the database for the purpose of inserting a new record in the database. No  
  CRT_TS TIMESTAMP   No  
  UPDT_BY_USR_ID VARCHAR2(50)   No  
  UPDT_TS TIMESTAMP   No  
  Entity Name  
  CALENDAR EVENT TYPE
    Attribute Name Attribute Rolename Attribute Datatype Attribute Definition Attribute Is PK
   
Calendar Event  Code
  VARCHAR(10) A Calendar Event Code is a combination of letters and/or numbers that represents a unique kind of temporal thing. Yes
    Calendar Event Name   VARCHAR(50) A Calendar Event Name is the word or words by which a unique temporal thing is known by. No
DB_INST A Database Instance represents processes and the portion of an Oracle database that runs in memory.
  Column Name Column Datatype Column Comment Column Is PK Column Transform Comment
  DB_INST_ID INTEGER A Database Instance Identifier is a unique value assigned to represent a particular instance of a database. Yes  
  DB_INST_NME VARCHAR2(50) A Database Instance Name is the word or words by which an exact database instance is known by. No  
  APP_DB_HST_ID INTEGER
An Application Database Host Identifier is a unique value that represents the assignment of  an Application Host and the related Application Database
No  
  CRT_BY_USR_ID VARCHAR2(50) The arbitrary character/number combination assigned to uniquely identify a person or system that accessed the database for the purpose of inserting a new record in the database. No  
  CRT_TS TIMESTAMP   No  
  UPDT_BY_USR_ID VARCHAR2(50)   No  
  UPDT_TS TIMESTAMP   No  
  Entity Name  
  DATABASE INSTANCE
    Attribute Name Attribute Rolename Attribute Datatype Attribute Definition Attribute Is PK
    Database Instance Identifier   INTEGER A Database Instance Identifier is a unique value assigned to represent a particular instance of a database. Yes
    Database Instance Name   VARCHAR(50) A Database Instance Name is the word or words by which an exact database instance is known by. No
    Application Database Host Identifier   INTEGER
An Application Database Host Identifier is a unique value that represents the assignment of  an Application Host and the related Application Database
No
DB_INST_SRVC
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
  Column Name Column Datatype Column Comment Column Is PK Column Transform Comment
  DB_INST_SRVC_ID INTEGER A Database Instance Service Identifier is the unique value assigned to represent the Service Name running on a particular database instance. Yes  
  DB_INST_ID INTEGER A Database Instance Identifier is a unique value assigned to represent a particular instance of a database. No  
  DB_INST_SRVC_NME VARCHAR2(100) A Database Instance Service Name is the word or words by which a particular database instance is known by. No  
  CRT_BY_USR_ID VARCHAR2(50) The arbitrary character/number combination assigned to uniquely identify a person or system that accessed the database for the purpose of inserting a new record in the database. No  
  CRT_TS TIMESTAMP   No  
  UPDT_BY_USR_ID VARCHAR2(50)   No  
  UPDT_TS TIMESTAMP   No  
  Entity Name  
  DATABASE INSTANCE SERVICE
    Attribute Name Attribute Rolename Attribute Datatype Attribute Definition Attribute Is PK
    Database Instance Service Identifier   INTEGER A Database Instance Service Identifier is the unique value assigned to represent the Service Name running on a particular database instance. Yes
    Database Instance Service Name   VARCHAR(100) A Database Instance Service Name is the word or words by which a particular database instance is known by. No
    Database Instance Identifier   INTEGER A Database Instance Identifier is a unique value assigned to represent a particular instance of a database. No
DBMS
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.
  Column Name Column Datatype Column Comment Column Is PK Column Transform Comment
  DBMS_ID INTEGER A Database Management System Identifier is a unique value assigned to represent a specific database management system and its specific version. Yes  
  DBMS_NME VARCHAR2(75) 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. No  
  VER_NBR VARCHAR2(100) A (DBMS) Version Number is the alphanumeric representation of a given DBMS at particular point in time. No  
  EDA_GRP_ID INTEGER An Enterprise Data Architecture Group Identifier is a unique value that represents a certain collection of individuals within the group No  
  CRT_BY_USR_ID VARCHAR2(50) The arbitrary character/number combination assigned to uniquely identify a person or system that accessed the database for the purpose of inserting a new record in the database. No  
  CRT_TS TIMESTAMP   No  
  UPDT_BY_USR_ID VARCHAR2(50)   No  
  UPDT_TS TIMESTAMP   No  
  Entity Name  
  DATABASE MANAGEMENT SYSTEM
    Attribute Name Attribute Rolename Attribute Datatype Attribute Definition Attribute Is PK
    Database Management System Identifier   INTEGER A Database Management System Identifier is a unique value assigned to represent a specific database management system and its specific version. Yes
    Database Management System Name   VARCHAR(75) 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. No
    Version Number   VARCHAR(100) A (DBMS) Version Number is the alphanumeric representation of a given DBMS at particular point in time. No
    Enterprise Data Architecture Group Identifier   INTEGER An Enterprise Data Architecture Group Identifier is a unique value that represents a certain collection of individuals within the group No
EDA_GRP The Enterprise Data Architecture Group classifies a group of people into one of the sub-categories within EDA.
  Column Name Column Datatype Column Comment Column Is PK Column Transform Comment
  EDA_GRP_ID INTEGER An Enterprise Data Architecture Group Identifier is a unique value that represents a certain collection of individuals within the group Yes  
  EDA_GRP_NM VARCHAR2(50) 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. No  
  CRT_BY_USR_ID VARCHAR2(50) The arbitrary character/number combination assigned to uniquely identify a person or system that accessed the database for the purpose of inserting a new record in the database. No  
  CRT_TS TIMESTAMP   No  
  UPDT_BY_USR_ID VARCHAR2(50)   No  
  UPDT_TS TIMESTAMP   No  
  Entity Name  
  ENTERPRISE DATA ARCHITECTURE GROUP
    Attribute Name Attribute Rolename Attribute Datatype Attribute Definition Attribute Is PK
    Enterprise Data Architecture Group Identifier   INTEGER An Enterprise Data Architecture Group Identifier is a unique value that represents a certain collection of individuals within the group Yes
    Enterprise Data Architecture Group Name   VARCHAR(50) 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. No
ENV 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.
  Column Name Column Datatype Column Comment Column Is PK Column Transform Comment
  ENV_CD VARCHAR2(10) An Environment Code is a particular set of letters and/or numbers that represents a particular software domain. Yes  
  ENV_DS VARCHAR2(150) An Environment Description is the free form text that further clarifies or describes a software domain. No  
  CRT_BY_USR_ID VARCHAR2(50) The arbitrary character/number combination assigned to uniquely identify a person or system that accessed the database for the purpose of inserting a new record in the database. No  
  CRT_TS TIMESTAMP   No  
  UPDT_BY_USR_ID VARCHAR2(50)   No  
  UPDT_TS TIMESTAMP   No  
  Entity Name  
  ENVIRONMENT
    Attribute Name Attribute Rolename Attribute Datatype Attribute Definition Attribute Is PK
    Environment Code   VARCHAR(10) An Environment Code is a particular set of letters and/or numbers that represents a particular software domain. Yes
    Environment Description   VARCHAR(150) An Environment Description is the free form text that further clarifies or describes a software domain. No
EVENT An Event is somethng that happens that is noteworthy or notable
  Column Name Column Datatype Column Comment Column Is PK Column Transform Comment
  EVENT_ID INTEGER An Event Identifier is a unique value assigned to represent a temporal incident that occured for a given Application Database. Yes  
  APP_DB_ID INTEGER An Application Database Identifier is a unique value that denotes a particular application database. No  
  TECH_EVENT_TYP_ID INTEGER A Technology Event Type Identifier is a unique value that represents kind of computer / software occurence that may be planned or unexpected. No  
  SUMRY_TXT VARCHAR2(4000) A Summary Text is the free form text that describes something that has happened at a particular point in time No  
  STR_TS 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. No  
  END_TS TIMESTAMP An End Timestamp is a particular point within the noted 24 hour period on the Gregorian calendar that something came to an end. No  
  CRT_BY_USR_ID VARCHAR2(50) The arbitrary character/number combination assigned to uniquely identify a person or system that accessed the database for the purpose of inserting a new record in the database. No  
  CRT_TS TIMESTAMP   No  
  UPDT_BY_USR_ID VARCHAR2(50)   No  
  UPDT_TS TIMESTAMP   No  
  Entity Name  
  EVENT
    Attribute Name Attribute Rolename Attribute Datatype Attribute Definition Attribute Is PK
    Event Identifier   INTEGER An Event Identifier is a unique value assigned to represent a temporal incident that occured for a given Application Database. Yes
    Application Database Identifier   INTEGER An Application Database Identifier is a unique value that denotes a particular application database. No
    Technology Event Type Identifier   INTEGER A Technology Event Type Identifier is a unique value that represents kind of computer / software occurence that may be planned or unexpected. No
    Summary Text   VARCHAR(4000) A Summary Text is the free form text that describes something that has happened at a particular point in time No
    Start Timestamp   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. No
    End Timestamp   TIMESTAMP An End Timestamp is a particular point within the noted 24 hour period on the Gregorian calendar that something came to an end. No
OS An Operating System represents a particular collection of software programs centered around a particular kernel that runs a computer.
  Column Name Column Datatype Column Comment Column Is PK Column Transform Comment
  OS_CD VARCHAR2(10) An Operating System Code is the unique value assigned to represent a particular computer operating system and the particular version. Yes  
  OS_NME VARCHAR2(50) An Operating System Name is the word or words by which a particular kernel and related applications are known by. No  
  VER_NBR VARCHAR2(100) A Version Number is an alphanumeric representation of the Operating System at a point in time. No  
  CRT_BY_USR_ID VARCHAR2(50) The arbitrary character/number combination assigned to uniquely identify a person or system that accessed the database for the purpose of inserting a new record in the database. No  
  CRT_TS TIMESTAMP   No  
  UPDT_BY_USR_ID VARCHAR2(50)   No  
  UPDT_TS TIMESTAMP   No  
  Entity Name  
  OPERATING SYSTEM
    Attribute Name Attribute Rolename Attribute Datatype Attribute Definition Attribute Is PK
    Operating System Code   VARCHAR(10) An Operating System Code is the unique value assigned to represent a particular computer operating system and the particular version. Yes
    Operating System Name   VARCHAR(50) An Operating System Name is the word or words by which a particular kernel and related applications are known by. No
    Version Number   VARCHAR(100) A Version Number is an alphanumeric representation of the Operating System at a point in time. No
PROVNG A Provisioning represents one or more Provisoining Requests for additonal resources, usually disk space, but can also be CPUs and memory.
  Column Name Column Datatype Column Comment Column Is PK Column Transform Comment
  PROVNG_ID INTEGER A Provisioning Identifier is a unique value assigned to represent one or more requested hardware changes to an application database server. Yes  
  APP_DB_ID INTEGER An Application Database Identifier is a unique value that denotes a particular application database. No  
  AUTHRZD_REQSTR_ID INTEGER 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. No  
  PROVNG_REQST_TS 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. No  
  COMNT_TXT VARCHAR2(4000) A Commnet Text is the free form text with provides additional information regarding a particular Provisioning Request. No  
  CRT_BY_USR_ID VARCHAR2(50) The arbitrary character/number combination assigned to uniquely identify a person or system that accessed the database for the purpose of inserting a new record in the database. No  
  CRT_TS TIMESTAMP   No  
  UPDT_BY_USR_ID VARCHAR2(50)   No  
  UPDT_TS TIMESTAMP   No  
  Entity Name  
  PROVISIONING
    Attribute Name Attribute Rolename Attribute Datatype Attribute Definition Attribute Is PK
    Provisioning Identifier   INTEGER A Provisioning Identifier is a unique value assigned to represent one or more requested hardware changes to an application database server. Yes
    Application Database Identifier   INTEGER An Application Database Identifier is a unique value that denotes a particular application database. No
    Provisioning Request Timestamp   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. No
    Authorized Requestor Identifier   INTEGER 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. No
    Comment Text   VARCHAR(4000) A Commnet Text is the free form text with provides additional information regarding a particular Provisioning Request. No
PROVNG_REQST A Provisioning Request represents a specific application for additonal resources, usually disk space, but can also be CPUs and memory.
  Column Name Column Datatype Column Comment Column Is PK Column Transform Comment
  PROVNG_REQST_ID INTEGER A Provisioning Request Identifier is the unique value that represents precisely what hardware change is being requested by the Authorized Requestor. Yes  
  PROVNG_ID INTEGER A Provisioning Identifier is a unique value assigned to represent one or more requested hardware changes to an application database server. No  
  RQSTD_SIZE_COUNT NUMBER(15,2) A Requested Size Count is the numeric value of the kind of request being made. No  
  COMNT_TXT VARCHAR2(4000) A Comment Text is the free form text that further clarifies the requested resources. No  
  PROVNG_REQST_TYP_CD VARCHAR2(10) A Provisioning Request Type Code is a alphanumeric value that classifies the type of Provisioning Request being made. No  
  CRT_BY_USR_ID VARCHAR2(50) The arbitrary character/number combination assigned to uniquely identify a person or system that accessed the database for the purpose of inserting a new record in the database. No  
  CRT_TS TIMESTAMP   No  
  UPDT_BY_USR_ID VARCHAR2(50)   No  
  UPDT_TS TIMESTAMP   No  
  Entity Name  
  PROVISIONING REQUEST
    Attribute Name Attribute Rolename Attribute Datatype Attribute Definition Attribute Is PK
    Provisioning Request Identifier   INTEGER A Provisioning Request Identifier is the unique value that represents precisely what hardware change is being requested by the Authorized Requestor. Yes
    Provisioning Identifier   INTEGER A Provisioning Identifier is a unique value assigned to represent one or more requested hardware changes to an application database server. No
    Requested Size Count   NUMBER(15,2) A Requested Size Count is the numeric value of the kind of request being made. No
    Provisioning Request Type Code   VARCHAR(10) A Provisioning Request Type Code is a alphanumeric value that classifies the type of Provisioning Request being made. No
    Comment Text   VARCHAR(4000) A Comment Text is the free form text that further clarifies the requested resources. No
PROVNG_REQST_TYP
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.
  Column Name Column Datatype Column Comment Column Is PK Column Transform Comment
  PROVNG_REQST_TYP_CD VARCHAR2(10) A Provisioning Request Type Code is a alphanumeric value that classifies the type of Provisioning Request being made. Yes  
  PROVNG_REQST_TYP_DS VARCHAR2(150) A Provisioning Request Type Description is the free form text that clarifies the categorization of the request. No  
  CRT_BY_USR_ID VARCHAR2(50) The arbitrary character/number combination assigned to uniquely identify a person or system that accessed the database for the purpose of inserting a new record in the database. No  
  CRT_TS TIMESTAMP   No  
  UPDT_BY_USR_ID VARCHAR2(50)   No  
  UPDT_TS TIMESTAMP   No  
  Entity Name  
  PROVISIONING REQUEST TYPE
    Attribute Name Attribute Rolename Attribute Datatype Attribute Definition Attribute Is PK
    Provisioning Request Type Code   VARCHAR(10) A Provisioning Request Type Code is a alphanumeric value that classifies the type of Provisioning Request being made. Yes
    Provisioning Request Type Description   VARCHAR(150) A Provisioning Request Type Description is the free form text that clarifies the categorization of the request. No
SRVC_LVL_AGRMT A Service Level Agreement represents a written statement about response and resolution times for various systems varying by their importance to the business.
  Column Name Column Datatype Column Comment Column Is PK Column Transform Comment
  SRVC_LVL_AGRMT_CD VARCHAR2(10) 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 Yes  
  SRVC_LVL_AGRMT_DS VARCHAR2(150) A Service Level Agreement Description is the free form text that further clarifies or defines a particular Service Level Agreement Code. No  
  CRT_BY_USR_ID VARCHAR2(50) The arbitrary character/number combination assigned to uniquely identify a person or system that accessed the database for the purpose of inserting a new record in the database. No  
  CRT_TS TIMESTAMP   No  
  UPDT_BY_USR_ID VARCHAR2(50)   No  
  UPDT_TS TIMESTAMP   No  
  Entity Name  
  SERVICE LEVEL AGREEMENT
    Attribute Name Attribute Rolename Attribute Datatype Attribute Definition Attribute Is PK
    Service Level Agreement Code   VARCHAR(10) 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 Yes
    Service Level Agreement Description   VARCHAR(150) A Service Level Agreement Description is the free form text that further clarifies or defines a particular Service Level Agreement Code. No
STAFF A Staff is an individual who works within the organization
  Column Name Column Datatype Column Comment Column Is PK Column Transform Comment
  STAFF_ID INTEGER A Staff Identifier is a unique value assigned to represent a particular person within the organization. Yes  
  FRST_NME VARCHAR2(50) A First Name is the word by which an individual is generaly known by No  
  LAST_NME VARCHAR2(50) A Last Name is the word or words which makes up the last part of an individual's name. No  
  STAFF_ROLE_CD VARCHAR2(10) 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. No  
  END_DT 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. No  
  STR_DT DATE A Start Date denotes the specific 24 hour period on the Gregorian calendar that an individual became a part of the Staff No  
  WRK_TEL_NBR VARCHAR2(14)
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).
No  
  CELL_TEL_NBR VARCHAR2(14)
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).
No  
  TEAM_CD VARCHAR2(10) 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. No  
  EDA_GRP_ID INTEGER An Enterprise Data Architecture Group Identifier is a unique value that represents a certain collection of individuals within the group No  
  CRT_BY_USR_ID VARCHAR2(50) The arbitrary character/number combination assigned to uniquely identify a person or system that accessed the database for the purpose of inserting a new record in the database. No  
  CRT_TS TIMESTAMP   No  
  UPDT_BY_USR_ID VARCHAR2(50)   No  
  UPDT_TS TIMESTAMP   No  
  Entity Name  
  STAFF
    Attribute Name Attribute Rolename Attribute Datatype Attribute Definition Attribute Is PK
    Staff Identifier   INTEGER A Staff Identifier is a unique value assigned to represent a particular person within the organization. Yes
    First Name   VARCHAR(50) A First Name is the word by which an individual is generaly known by No
    Last Name   VARCHAR(50) A Last Name is the word or words which makes up the last part of an individual's name. No
    Staff Role Code   VARCHAR(10) 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. No
    Work Telephone Number   VARCHAR(14)
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).
No
    Cell Telephone Number   VARCHAR(14)
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).
No
    Start Date   DATE A Start Date denotes the specific 24 hour period on the Gregorian calendar that an individual became a part of the Staff No
    End Date   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. No
    Team Code   VARCHAR(10) 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. No
    Enterprise Data Architecture Group Identifier   INTEGER An Enterprise Data Architecture Group Identifier is a unique value that represents a certain collection of individuals within the group No
STAFF_CAL A Staff Calendar is representation of a series of events that occurs in relation to members of the organization.
  Column Name Column Datatype Column Comment Column Is PK Column Transform Comment
  STAFF_CAL_EVENT_ID INTEGER 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. Yes  
  EDA_GRP_ID INTEGER An Enterprise Data Architecture Group Identifier is a unique value that represents a certain collection of individuals within the group No  
  STAFF_ID INTEGER A Staff Identifier is a unique value assigned to represent a particular person within the organization. No  
  STR_EVENT_DT 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. No  
  CAL_EVENT__CD VARCHAR2(10) A Calendar Event Code is a combination of letters and/or numbers that represents a unique kind of temporal thing. No  
  END_EVENT_DT 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. No  
  CRT_BY_USR_ID VARCHAR2(50) The arbitrary character/number combination assigned to uniquely identify a person or system that accessed the database for the purpose of inserting a new record in the database. No  
  CRT_TS TIMESTAMP   No  
  UPDT_BY_USR_ID VARCHAR2(50)   No  
  UPDT_TS TIMESTAMP   No  
  Entity Name  
  STAFF CALENDAR
    Attribute Name Attribute Rolename Attribute Datatype Attribute Definition Attribute Is PK
    Staff Calendar Event Identifier   INTEGER 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. Yes
    Start Event Date   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. No
    End Event Date   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. No
    Enterprise Data Architecture Group Identifier   INTEGER An Enterprise Data Architecture Group Identifier is a unique value that represents a certain collection of individuals within the group No
    Staff Identifier   INTEGER A Staff Identifier is a unique value assigned to represent a particular person within the organization. No
   
Calendar Event  Code
  VARCHAR(10) A Calendar Event Code is a combination of letters and/or numbers that represents a unique kind of temporal thing. No
STAFF_EVENT  
  Column Name Column Datatype Column Comment Column Is PK Column Transform Comment
  STAFF_EVENT_ID INTEGER   Yes  
  STAFF_ID INTEGER A Staff Identifier is a unique value assigned to represent a particular person within the organization. No  
  EVENT_ID INTEGER An Event Identifier is a unique value assigned to represent a temporal incident that occured for a given Application Database. No  
  END_TS TIMESTAMP   No  
  STR_TS TIMESTAMP   No  
  CRT_BY_USR_ID VARCHAR2(50) The arbitrary character/number combination assigned to uniquely identify a person or system that accessed the database for the purpose of inserting a new record in the database. No  
  CRT_TS TIMESTAMP   No  
  UPDT_BY_USR_ID VARCHAR2(50)   No  
  UPDT_TS TIMESTAMP   No  
  Entity Name  
  STAFF EVENT
    Attribute Name Attribute Rolename Attribute Datatype Attribute Definition Attribute Is PK
    Staff Event Identifier   INTEGER   Yes
    Staff Identifier   INTEGER A Staff Identifier is a unique value assigned to represent a particular person within the organization. No
    Event Identifier   INTEGER An Event Identifier is a unique value assigned to represent a temporal incident that occured for a given Application Database. No
    Start Timestamp   TIMESTAMP   No
    End Timestamp   TIMESTAMP   No
STAFF_ROLE A Staff Role is a particular job function being fulfilled by a person within the organization
  Column Name Column Datatype Column Comment Column Is PK Column Transform Comment
  STAFF_ROLE_CD VARCHAR2(10) 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. Yes  
  STAFF_ROLE_DS VARCHAR2(150) A Staff Role Description is the free form text that further clarifies a Staff Role Code. No  
  CRT_BY_USR_ID VARCHAR2(50) The arbitrary character/number combination assigned to uniquely identify a person or system that accessed the database for the purpose of inserting a new record in the database. No  
  CRT_TS TIMESTAMP   No  
  UPDT_BY_USR_ID VARCHAR2(50)   No  
  UPDT_TS TIMESTAMP   No  
  Entity Name  
  STAFF ROLE
    Attribute Name Attribute Rolename Attribute Datatype Attribute Definition Attribute Is PK
    Staff Role Code   VARCHAR(10) 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. Yes
    Staff Role Description   VARCHAR(150) A Staff Role Description is the free form text that further clarifies a Staff Role Code. 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
  Column Name Column Datatype Column Comment Column Is PK Column Transform Comment
  TEAM_CD VARCHAR2(10) 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. Yes  
  TEAM_NME VARCHAR2(50) A Team Name is the word or words by which a given group of the Staff is commonly known by. No  
  CRT_BY_USR_ID VARCHAR2(50) The arbitrary character/number combination assigned to uniquely identify a person or system that accessed the database for the purpose of inserting a new record in the database. No  
  CRT_TS TIMESTAMP   No  
  UPDT_BY_USR_ID VARCHAR2(50)   No  
  UPDT_TS TIMESTAMP   No  
  Entity Name  
  TEAM
    Attribute Name Attribute Rolename Attribute Datatype Attribute Definition Attribute Is PK
    Team Code   VARCHAR(10) 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. Yes
    Team Name   VARCHAR(50) A Team Name is the word or words by which a given group of the Staff is commonly known by. No
TECH_EVENT_TYP A Technology Event Type classifies a specific kind of thing that occured in relation to a given set of hardware and software
  Column Name Column Datatype Column Comment Column Is PK Column Transform Comment
  TECH_EVENT_TYP_ID INTEGER A Technology Event Type Identifier is a unique value that represents kind of computer / software occurence that may be planned or unexpected. Yes  
  TECH_EVENT_TYP_DS VARCHAR2(150) 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. No  
  PLANNED_IND CHAR(1) A Planned Indicator is a binary representation of whether or not a particular occurrence was preplanned ("Y") or if it was spontaneous ("N"). No  
  CRT_BY_USR_ID VARCHAR2(50) The arbitrary character/number combination assigned to uniquely identify a person or system that accessed the database for the purpose of inserting a new record in the database. No  
  CRT_TS TIMESTAMP   No  
  UPDT_BY_USR_ID VARCHAR2(50)   No  
  UPDT_TS TIMESTAMP   No  
  Entity Name  
  TECHNOLOGY EVENT TYPE
    Attribute Name Attribute Rolename Attribute Datatype Attribute Definition Attribute Is PK
    Technology Event Type Identifier   INTEGER A Technology Event Type Identifier is a unique value that represents kind of computer / software occurence that may be planned or unexpected. Yes
    Technology Event Type Description   VARCHAR(150) 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. No
    Planned Indicator   CHAR(1) A Planned Indicator is a binary representation of whether or not a particular occurrence was preplanned ("Y") or if it was spontaneous ("N"). No