| Application Name |
| Base Entity | ICS Application Software |
| Attribute Name | Application Name |
| Logical Rolename | |
| ColumnName | APPL_NM |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Application Name: The ICS software application name. |
| Note |
| Application Name Logical Attribute Properties |
| Logical Attribute Name | Application Name |
| Datatype | VARCHAR(128) |
| Nullable | NO |
| Application Name Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Application Name Security Types |
| Name | Current Value |
| Application Name Bound Attachments |
| Name | Current Value |
| Application Name Data Movement Rules |
| Name | Type | Rule Text/Value |
| Application Name Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical ICS Application Software Application Name |
NO | ||
| ICS_SFTW_APPL (Oracle) ICS_APPL_SFTW APPL_NM |
NO |
| Application Name Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Application Name Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Application Name Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Application Name Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Software Maintainer Badge Number |
| Base Entity | ICS Application Software |
| Attribute Name | Badge Number |
| Logical Rolename | Software Maintainer Badge Number |
| ColumnName | SFTW_MAINT_BN |
| RoleName | SFTW_MAINT_BN |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Software Maintainer Badge Number Logical Attribute Properties |
| Logical Attribute Name | Badge Number |
| Datatype | VARCHAR(10) |
| Nullable | NO |
| Software Maintainer Badge Number Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Software Maintainer Badge Number Security Types |
| Name | Current Value |
| Software Maintainer Badge Number Bound Attachments |
| Name | Current Value |
| Software Maintainer Badge Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Software Maintainer Badge Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical ICS Application Software Badge Number |
NO | ||
| ICS_SFTW_APPL (Oracle) ICS_APPL_SFTW SFTW_MAINT_BN |
NO |
| Software Maintainer Badge Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Software Maintainer Badge Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Software Maintainer Badge Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Software Maintainer Badge Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Application Description |
| Base Entity | ICS Application Software |
| Attribute Name | Application Description |
| Logical Rolename | |
| ColumnName | APPL_DESCR |
| RoleName | |
| Domain | Description |
| Logical Only | NO |
| Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
| Note |
| Application Description Logical Attribute Properties |
| Logical Attribute Name | Application Description |
| Datatype | VARCHAR(255) |
| Nullable | NO |
| Application Description Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Application Description Security Types |
| Name | Current Value |
| Application Description Bound Attachments |
| Name | Current Value |
| Application Description Data Movement Rules |
| Name | Type | Rule Text/Value |
| Application Description Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical ICS Application Software Application Description |
NO | ||
| ICS_SFTW_APPL (Oracle) ICS_APPL_SFTW APPL_DESCR |
NO |
| Application Description Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Application Description Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Application Description Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Application Description Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Status Code |
| Base Entity | ICS Application Software |
| Attribute Name | Status Code |
| Logical Rolename | |
| ColumnName | STATUS_CD |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Status Code: The development status of the software application. |
| Note |
| Status Code Logical Attribute Properties |
| Logical Attribute Name | Status Code |
| Datatype | CHAR(1) |
| Nullable | NO |
| Status Code Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | 'C' | ||
| Bound Default |
| Status Code Security Types |
| Name | Current Value |
| Status Code Bound Attachments |
| Name | Current Value |
| Status Code Data Movement Rules |
| Name | Type | Rule Text/Value |
| Status Code Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical ICS Application Software Status Code |
NO | ||
| ICS_SFTW_APPL (Oracle) ICS_APPL_SFTW STATUS_CD |
NO |
| Status Code Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Status Code Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Status Code Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Status Code Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Web Indicator |
| Base Entity | ICS Application Software |
| Attribute Name | Web Indicator |
| Logical Rolename | |
| ColumnName | WEB_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | Web Indicator: Indicates if the sotware application is web based. |
| Note |
| Web Indicator Logical Attribute Properties |
| Logical Attribute Name | Web Indicator |
| Datatype | CHAR(1) |
| Nullable | NO |
| Web Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Web Indicator Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| Web Indicator Security Types |
| Name | Current Value |
| Web Indicator Bound Attachments |
| Name | Current Value |
| Web Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Web Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical ICS Application Software Web Indicator |
NO | ||
| ICS_SFTW_APPL (Oracle) ICS_APPL_SFTW WEB_IND |
NO |
| Web Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Web Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Web Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Web Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Special Requirements |
| Base Entity | ICS Application Software |
| Attribute Name | Special Requirements |
| Logical Rolename | |
| ColumnName | SPEC_REQT |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Requirements: Additional software, system privileges, etc. reequired by the application. |
| Note |
| Special Requirements Logical Attribute Properties |
| Logical Attribute Name | Special Requirements |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| Special Requirements Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Special Requirements Security Types |
| Name | Current Value |
| Special Requirements Bound Attachments |
| Name | Current Value |
| Special Requirements Data Movement Rules |
| Name | Type | Rule Text/Value |
| Special Requirements Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical ICS Application Software Special Requirements |
NO | ||
| ICS_SFTW_APPL (Oracle) ICS_APPL_SFTW SPEC_REQT |
NO |
| Special Requirements Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Special Requirements Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Special Requirements Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Special Requirements Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Server Name |
| Base Entity | ICS Application Software |
| Attribute Name | Server Name |
| Logical Rolename | |
| ColumnName | SRV_NM |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Server Name: The ICS server name which conforms to the ICS network name standard. |
| Note |
| Server Name Logical Attribute Properties |
| Logical Attribute Name | Server Name |
| Datatype | VARCHAR(75) |
| Nullable | YES |
| Server Name Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Server Name Security Types |
| Name | Current Value |
| Server Name Bound Attachments |
| Name | Current Value |
| Server Name Data Movement Rules |
| Name | Type | Rule Text/Value |
| Server Name Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical ICS Application Software Server Name |
NO | ||
| ICS_SFTW_APPL (Oracle) ICS_APPL_SFTW SRV_NM |
NO |
| Server Name Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Server Name Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Server Name Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Server Name Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Directory Location |
| Base Entity | ICS Application Software |
| Attribute Name | Directory Location |
| Logical Rolename | |
| ColumnName | DIR_LOC |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Directory Location: The application software directory location on server. |
| Note |
| Directory Location Logical Attribute Properties |
| Logical Attribute Name | Directory Location |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| Directory Location Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Directory Location Security Types |
| Name | Current Value |
| Directory Location Bound Attachments |
| Name | Current Value |
| Directory Location Data Movement Rules |
| Name | Type | Rule Text/Value |
| Directory Location Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical ICS Application Software Directory Location |
NO | ||
| ICS_SFTW_APPL (Oracle) ICS_APPL_SFTW DIR_LOC |
NO |
| Directory Location Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Directory Location Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Directory Location Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Directory Location Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Data Input Repository Identifier |
| Base Entity | ICS Application Software |
| Attribute Name | Repository Identiifer |
| Logical Rolename | Data Input Repository Identifier |
| ColumnName | DATA_INPUT_REPOS_ID |
| RoleName | DATA_INPUT_REPOS_ID |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Data Input Repository Identifier Logical Attribute Properties |
| Logical Attribute Name | Repository Identiifer |
| Datatype | VARCHAR(50) |
| Nullable | NO |
| Data Input Repository Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Data Input Repository Identifier Security Types |
| Name | Current Value |
| Data Input Repository Identifier Bound Attachments |
| Name | Current Value |
| Data Input Repository Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Data Input Repository Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical ICS Application Software Repository Identiifer |
NO | ||
| ICS_SFTW_APPL (Oracle) ICS_APPL_SFTW DATA_INPUT_REPOS_ID |
NO |
| Data Input Repository Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Data Input Repository Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Data Input Repository Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Data Input Repository Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Data Output Repository Identifier |
| Base Entity | ICS Application Software |
| Attribute Name | Repository Identiifer |
| Logical Rolename | Data Output Repository Identifier |
| ColumnName | DATA_OUPUT_REPOS_ID |
| RoleName | DATA_OUPUT_REPOS_ID |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Data Output Repository Identifier Logical Attribute Properties |
| Logical Attribute Name | Repository Identiifer |
| Datatype | VARCHAR(50) |
| Nullable | NO |
| Data Output Repository Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Data Output Repository Identifier Security Types |
| Name | Current Value |
| Data Output Repository Identifier Bound Attachments |
| Name | Current Value |
| Data Output Repository Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Data Output Repository Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical ICS Application Software Repository Identiifer |
NO | ||
| ICS_SFTW_APPL (Oracle) ICS_APPL_SFTW DATA_OUPUT_REPOS_ID |
NO |
| Data Output Repository Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Data Output Repository Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Data Output Repository Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Data Output Repository Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| User Interface Identifier |
| Base Entity | ICS Application Software |
| Attribute Name | User Interface Identifier |
| Logical Rolename | |
| ColumnName | USER_INTFC_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | User Interface name: The type of user access to the sotware system. |
| Note |
| User Interface Identifier Logical Attribute Properties |
| Logical Attribute Name | User Interface Identifier |
| Datatype | VARCHAR(50) |
| Nullable | NO |
| User Interface Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| User Interface Identifier Security Types |
| Name | Current Value |
| User Interface Identifier Bound Attachments |
| Name | Current Value |
| User Interface Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| User Interface Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical ICS Application Software User Interface Identifier |
NO | ||
| ICS_SFTW_APPL (Oracle) ICS_APPL_SFTW USER_INTFC_ID |
NO |
| User Interface Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| User Interface Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| User Interface Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| User Interface Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |