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 |