| FORMATS: | TABULAR | HIERARCHICAL |
| Table |
| Table |
| 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 |