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