Data Model Report

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