FORMATS: TABULAR HIERARCHICAL

Table
Table
Name Comment Column Entity
ACCT An Account represents a system account that has elevated privileges or special features/functions needed by the Staff for support.
APP An Application is a piece or multiple pieces of software that have been coupled together for a specific purpose.
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.
APP_DB_HST An Application Database Host is the main server/computer that has a particular applications database running on it.
APP_DB_NOTE An Application Database Note is some free form text that is relevant to the application.
APP_DB_STS An Application Database Status reflects the known state of a particular application's database.
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...)
APP_STAFF An Application Staff is the association of an individual to a particular application.
AUTHRZD_REQSTR An Authorized Requestor is an individual who is permitted to request additional resources for a piece of computer hardware
CAL_EVENT_TYP A Calendar Event Type classifies an event that occurs on a particular day in association with a particular staff individual.
DB_INST A Database Instance represents processes and the portion of an Oracle database that runs in memory.
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
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.
EDA_GRP The Enterprise Data Architecture Group classifies a group of people into one of the sub-categories within EDA.
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.
EVENT An Event is somethng that happens that is noteworthy or notable
OS An Operating System represents a particular collection of software programs centered around a particular kernel that runs a computer.
PROVNG A Provisioning represents one or more Provisoining Requests for additonal resources, usually disk space, but can also be CPUs and memory.
PROVNG_REQST A Provisioning Request represents a specific application for additonal resources, usually disk space, but can also be CPUs and memory.
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.
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.
STAFF A Staff is an individual who works within the organization
STAFF_CAL A Staff Calendar is representation of a series of events that occurs in relation to members of the organization.
STAFF_EVENT  
STAFF_ROLE A Staff Role is a particular job function being fulfilled by a person within the organization
TEAM A Team is a group of individuals within the organization that perform similar operations / functions for a specific combination of hardware and software
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(s) of "ACCT" Table
Name Datatype Comment Is PK 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(s) of "ACCT" Table
Name Attribute
ACCOUNT
Attribute(s) of "ACCOUNT" Entity
Name Rolename Datatype Definition 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
Column(s) of "APP" Table
Name Datatype Comment Is PK 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(s) of "APP" Table
Name Attribute
APPLICATION
Attribute(s) of "APPLICATION" Entity
Name Rolename Datatype Definition 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
Column(s) of "APP_DB" Table
Name Datatype Comment Is PK 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(s) of "APP_DB" Table
Name Attribute
APPLICATION DATABASE
Attribute(s) of "APPLICATION DATABASE" Entity
Name Rolename Datatype Definition 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
Column(s) of "APP_DB_HST" Table
Name Datatype Comment Is PK 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(s) of "APP_DB_HST" Table
Name Attribute
APPLICATION DATABASE HOST
Attribute(s) of "APPLICATION DATABASE HOST" Entity
Name Rolename Datatype Definition 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
Column(s) of "APP_DB_NOTE" Table
Name Datatype Comment Is PK 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(s) of "APP_DB_NOTE" Table
Name Attribute
APPLICATION DATABASE NOTE
Attribute(s) of "APPLICATION DATABASE NOTE" Entity
Name Rolename Datatype Definition 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
Column(s) of "APP_DB_STS" Table
Name Datatype Comment Is PK 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(s) of "APP_DB_STS" Table
Name Attribute
APPLICATION DATABASE STATUS
Attribute(s) of "APPLICATION DATABASE STATUS" Entity
Name Rolename Datatype Definition 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
Column(s) of "APP_HST" Table
Name Datatype Comment Is PK 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(s) of "APP_HST" Table
Name Attribute
APPLICATION HOST
Attribute(s) of "APPLICATION HOST" Entity
Name Rolename Datatype Definition 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
Column(s) of "APP_STAFF" Table
Name Datatype Comment Is PK 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(s) of "APP_STAFF" Table
Name Attribute
APPLICATION STAFF
Attribute(s) of "APPLICATION STAFF" Entity
Name Rolename Datatype Definition 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
Column(s) of "AUTHRZD_REQSTR" Table
Name Datatype Comment Is PK 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(s) of "AUTHRZD_REQSTR" Table
Name Attribute
AUTHORIZED REQUESTOR
Attribute(s) of "AUTHORIZED REQUESTOR" Entity
Name Rolename Datatype Definition 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
Column(s) of "CAL_EVENT_TYP" Table
Name Datatype Comment Is PK 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(s) of "CAL_EVENT_TYP" Table
Name Attribute
CALENDAR EVENT TYPE
Attribute(s) of "CALENDAR EVENT TYPE" Entity
Name Rolename Datatype Definition 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
Column(s) of "DB_INST" Table
Name Datatype Comment Is PK 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(s) of "DB_INST" Table
Name Attribute
DATABASE INSTANCE
Attribute(s) of "DATABASE INSTANCE" Entity
Name Rolename Datatype Definition 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
Column(s) of "DB_INST_SRVC" Table
Name Datatype Comment Is PK 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(s) of "DB_INST_SRVC" Table
Name Attribute
DATABASE INSTANCE SERVICE
Attribute(s) of "DATABASE INSTANCE SERVICE" Entity
Name Rolename Datatype Definition 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
Column(s) of "DBMS" Table
Name Datatype Comment Is PK 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(s) of "DBMS" Table
Name Attribute
DATABASE MANAGEMENT SYSTEM
Attribute(s) of "DATABASE MANAGEMENT SYSTEM" Entity
Name Rolename Datatype Definition 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
Column(s) of "EDA_GRP" Table
Name Datatype Comment Is PK 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(s) of "EDA_GRP" Table
Name Attribute
ENTERPRISE DATA ARCHITECTURE GROUP
Attribute(s) of "ENTERPRISE DATA ARCHITECTURE GROUP" Entity
Name Rolename Datatype Definition 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
Column(s) of "ENV" Table
Name Datatype Comment Is PK 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(s) of "ENV" Table
Name Attribute
ENVIRONMENT
Attribute(s) of "ENVIRONMENT" Entity
Name Rolename Datatype Definition 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
Column(s) of "EVENT" Table
Name Datatype Comment Is PK 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(s) of "EVENT" Table
Name Attribute
EVENT
Attribute(s) of "EVENT" Entity
Name Rolename Datatype Definition 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
Column(s) of "OS" Table
Name Datatype Comment Is PK 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(s) of "OS" Table
Name Attribute
OPERATING SYSTEM
Attribute(s) of "OPERATING SYSTEM" Entity
Name Rolename Datatype Definition 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
Column(s) of "PROVNG" Table
Name Datatype Comment Is PK 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(s) of "PROVNG" Table
Name Attribute
PROVISIONING
Attribute(s) of "PROVISIONING" Entity
Name Rolename Datatype Definition 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
Column(s) of "PROVNG_REQST" Table
Name Datatype Comment Is PK 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(s) of "PROVNG_REQST" Table
Name Attribute
PROVISIONING REQUEST
Attribute(s) of "PROVISIONING REQUEST" Entity
Name Rolename Datatype Definition 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
Column(s) of "PROVNG_REQST_TYP" Table
Name Datatype Comment Is PK 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(s) of "PROVNG_REQST_TYP" Table
Name Attribute
PROVISIONING REQUEST TYPE
Attribute(s) of "PROVISIONING REQUEST TYPE" Entity
Name Rolename Datatype Definition 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
Column(s) of "SRVC_LVL_AGRMT" Table
Name Datatype Comment Is PK 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(s) of "SRVC_LVL_AGRMT" Table
Name Attribute
SERVICE LEVEL AGREEMENT
Attribute(s) of "SERVICE LEVEL AGREEMENT" Entity
Name Rolename Datatype Definition 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
Column(s) of "STAFF" Table
Name Datatype Comment Is PK 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(s) of "STAFF" Table
Name Attribute
STAFF
Attribute(s) of "STAFF" Entity
Name Rolename Datatype Definition 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
Column(s) of "STAFF_CAL" Table
Name Datatype Comment Is PK 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(s) of "STAFF_CAL" Table
Name Attribute
STAFF CALENDAR
Attribute(s) of "STAFF CALENDAR" Entity
Name Rolename Datatype Definition 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
Column(s) of "STAFF_EVENT" Table
Name Datatype Comment Is PK 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(s) of "STAFF_EVENT" Table
Name Attribute
STAFF EVENT
Attribute(s) of "STAFF EVENT" Entity
Name Rolename Datatype Definition 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
Column(s) of "STAFF_ROLE" Table
Name Datatype Comment Is PK 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(s) of "STAFF_ROLE" Table
Name Attribute
STAFF ROLE
Attribute(s) of "STAFF ROLE" Entity
Name Rolename Datatype Definition 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
Column(s) of "TEAM" Table
Name Datatype Comment Is PK 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(s) of "TEAM" Table
Name Attribute
TEAM
Attribute(s) of "TEAM" Entity
Name Rolename Datatype Definition 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
Column(s) of "TECH_EVENT_TYP" Table
Name Datatype Comment Is PK 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(s) of "TECH_EVENT_TYP" Table
Name Attribute
TECHNOLOGY EVENT TYPE
Attribute(s) of "TECHNOLOGY EVENT TYPE" Entity
Name Rolename Datatype Definition 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