| APPL_NM |
| Base Object | ICS_APPL_SFTW |
| Attribute Name | Application Name |
| ColumnName | APPL_NM |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Application Name: The ICS software application name. |
| Note |
| APPL_NM Column Properties |
| Datatype | VARCHAR2(128) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| APPL_NM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 128 |
| Percent Null | 0 |
| APPL_NM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| APPL_NM Security Types |
| Name | Current Value |
| APPL_NM Bound Attachments |
| Name | Current Value |
| APPL_NM Data Movement Rules |
| Name | Type | Rule Text/Value |
| APPL_NM 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 |
| APPL_NM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| APPL_NM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| APPL_NM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| APPL_NM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SFTW_MAINT_BN |
| Base Object | ICS_APPL_SFTW |
| Attribute Name | Bn |
| ColumnName | SFTW_MAINT_BN |
| Logical Rolename | |
| RoleName | SFTW_MAINT_BN |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| SFTW_MAINT_BN Column Properties |
| Datatype | VARCHAR2(6) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SFTW_MAINT_BN Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 6 |
| Percent Null | 0 |
| SFTW_MAINT_BN Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SFTW_MAINT_BN Security Types |
| Name | Current Value |
| SFTW_MAINT_BN Bound Attachments |
| Name | Current Value |
| SFTW_MAINT_BN Data Movement Rules |
| Name | Type | Rule Text/Value |
| SFTW_MAINT_BN 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 |
| SFTW_MAINT_BN Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SFTW_MAINT_BN Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SFTW_MAINT_BN Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SFTW_MAINT_BN Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| APPL_DESCR |
| Base Object | ICS_APPL_SFTW |
| Attribute Name | Application Description |
| ColumnName | APPL_DESCR |
| Logical Rolename | |
| RoleName | |
| Domain | Description |
| Physical Only | NO |
| Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
| Note |
| APPL_DESCR Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| APPL_DESCR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| APPL_DESCR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| APPL_DESCR Security Types |
| Name | Current Value |
| APPL_DESCR Bound Attachments |
| Name | Current Value |
| APPL_DESCR Data Movement Rules |
| Name | Type | Rule Text/Value |
| APPL_DESCR 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 |
| APPL_DESCR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| APPL_DESCR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| APPL_DESCR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| APPL_DESCR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| STATUS_CD |
| Base Object | ICS_APPL_SFTW |
| Attribute Name | Status Code |
| ColumnName | STATUS_CD |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Status Code: The development status of the software application. |
| Note |
| STATUS_CD Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| STATUS_CD Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| STATUS_CD Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'C' |
| Bound Default |
| STATUS_CD Security Types |
| Name | Current Value |
| STATUS_CD Bound Attachments |
| Name | Current Value |
| STATUS_CD Data Movement Rules |
| Name | Type | Rule Text/Value |
| STATUS_CD 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_CD Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| STATUS_CD Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| STATUS_CD Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| STATUS_CD Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| WEB_IND |
| Base Object | ICS_APPL_SFTW |
| Attribute Name | Web Indicator |
| ColumnName | WEB_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | Web Indicator: Indicates if the sotware application is web based. |
| Note |
| WEB_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| WEB_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| WEB_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| WEB_IND 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_IND Security Types |
| Name | Current Value |
| WEB_IND Bound Attachments |
| Name | Current Value |
| WEB_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| WEB_IND 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_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| WEB_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| WEB_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| WEB_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SPEC_REQT |
| Base Object | ICS_APPL_SFTW |
| Attribute Name | Special Requirements |
| ColumnName | SPEC_REQT |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Requirements: Additional software, system privileges, etc. reequired by the application. |
| Note |
| SPEC_REQT Column Properties |
| Datatype | VARCHAR2(2000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SPEC_REQT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2000 |
| Percent Null | 0 |
| SPEC_REQT Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SPEC_REQT Security Types |
| Name | Current Value |
| SPEC_REQT Bound Attachments |
| Name | Current Value |
| SPEC_REQT Data Movement Rules |
| Name | Type | Rule Text/Value |
| SPEC_REQT 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 |
| SPEC_REQT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SPEC_REQT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SPEC_REQT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SPEC_REQT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SRV_NM |
| Base Object | ICS_APPL_SFTW |
| Attribute Name | Server Name |
| ColumnName | SRV_NM |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Server Name: The ICS server name which conforms to the ICS network name standard. |
| Note |
| SRV_NM Column Properties |
| Datatype | VARCHAR2(75) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SRV_NM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 75 |
| Percent Null | 0 |
| SRV_NM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SRV_NM Security Types |
| Name | Current Value |
| SRV_NM Bound Attachments |
| Name | Current Value |
| SRV_NM Data Movement Rules |
| Name | Type | Rule Text/Value |
| SRV_NM 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 |
| SRV_NM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SRV_NM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SRV_NM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SRV_NM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DIR_LOC |
| Base Object | ICS_APPL_SFTW |
| Attribute Name | Directory Location |
| ColumnName | DIR_LOC |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Directory Location: The application software directory location on server. |
| Note |
| DIR_LOC Column Properties |
| Datatype | VARCHAR2(2000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DIR_LOC Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2000 |
| Percent Null | 0 |
| DIR_LOC Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DIR_LOC Security Types |
| Name | Current Value |
| DIR_LOC Bound Attachments |
| Name | Current Value |
| DIR_LOC Data Movement Rules |
| Name | Type | Rule Text/Value |
| DIR_LOC 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 |
| DIR_LOC Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DIR_LOC Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DIR_LOC Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DIR_LOC Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DATA_INPUT_REPOS_ID |
| Base Object | ICS_APPL_SFTW |
| Attribute Name | Repository Identiifer |
| ColumnName | DATA_INPUT_REPOS_ID |
| Logical Rolename | |
| RoleName | DATA_INPUT_REPOS_ID |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| DATA_INPUT_REPOS_ID Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DATA_INPUT_REPOS_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| DATA_INPUT_REPOS_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DATA_INPUT_REPOS_ID Security Types |
| Name | Current Value |
| DATA_INPUT_REPOS_ID Bound Attachments |
| Name | Current Value |
| DATA_INPUT_REPOS_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| DATA_INPUT_REPOS_ID 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_REPOS_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DATA_INPUT_REPOS_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DATA_INPUT_REPOS_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DATA_INPUT_REPOS_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DATA_OUPUT_REPOS_ID |
| Base Object | ICS_APPL_SFTW |
| Attribute Name | Repository Identiifer |
| ColumnName | DATA_OUPUT_REPOS_ID |
| Logical Rolename | |
| RoleName | DATA_OUPUT_REPOS_ID |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| DATA_OUPUT_REPOS_ID Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DATA_OUPUT_REPOS_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| DATA_OUPUT_REPOS_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DATA_OUPUT_REPOS_ID Security Types |
| Name | Current Value |
| DATA_OUPUT_REPOS_ID Bound Attachments |
| Name | Current Value |
| DATA_OUPUT_REPOS_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| DATA_OUPUT_REPOS_ID 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_OUPUT_REPOS_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DATA_OUPUT_REPOS_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DATA_OUPUT_REPOS_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DATA_OUPUT_REPOS_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| USER_INTFC_ID |
| Base Object | ICS_APPL_SFTW |
| Attribute Name | User Interface Identifier |
| ColumnName | USER_INTFC_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | User Interface name: The type of user access to the sotware system. |
| Note |
| USER_INTFC_ID Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| USER_INTFC_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| USER_INTFC_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| USER_INTFC_ID Security Types |
| Name | Current Value |
| USER_INTFC_ID Bound Attachments |
| Name | Current Value |
| USER_INTFC_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| USER_INTFC_ID 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_INTFC_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| USER_INTFC_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| USER_INTFC_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| USER_INTFC_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |