| Institute Identifier |
| Base Entity | Institute |
| Attribute Name | Institute Identifier |
| Logical Rolename | |
| ColumnName | INST_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Institute Identifer: Abbreviated identifier for a institute. |
| Note |
| Institute Identifier Logical Attribute Properties |
| Logical Attribute Name | Institute Identifier |
| Datatype | INTEGER |
| Nullable | NO |
| Institute Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Institute Identifier Security Types |
| Name | Current Value |
| Institute Identifier Bound Attachments |
| Name | Current Value |
| Institute Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Institute Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Institute Institute Identifier |
NO | ||
| CNMS_PRPSL (Oracle) INST INST_ID |
NO | ||
| ENGA (Oracle) INST INST_ID |
NO | ||
| PUBL (Oracle) INST INST_ID |
NO | ||
| XF_ADMIN (Oracle) INST INST_ID |
NO |
| Institute Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Institute Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Institute Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Institute Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Institute Name |
| Base Entity | Institute |
| Attribute Name | Institute Name |
| Logical Rolename | |
| ColumnName | INST_NM |
| RoleName | |
| Domain | Name |
| Logical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| Institute Name Logical Attribute Properties |
| Logical Attribute Name | Institute Name |
| Datatype | VARCHAR(120) |
| Nullable | NO |
| Institute Name Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Institute Name Security Types |
| Name | Current Value |
| Institute Name Bound Attachments |
| Name | Current Value |
| Institute Name Data Movement Rules |
| Name | Type | Rule Text/Value |
| Institute Name Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Institute Institute Name |
NO | ||
| CNMS_PRPSL (Oracle) INST INST_NM |
NO | ||
| ENGA (Oracle) INST INST_NM |
NO | ||
| PUBL (Oracle) INST INST_NM |
NO | ||
| XF_ADMIN (Oracle) INST INST_NM |
NO |
| Institute Name Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Institute Name Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Institute Name Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Institute Name Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Street |
| Base Entity | Institute |
| Attribute Name | Street |
| Logical Rolename | |
| ColumnName | ST |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Street: Street address of institute. |
| Note |
| Street Logical Attribute Properties |
| Logical Attribute Name | Street |
| Datatype | VARCHAR(100) |
| Nullable | NO |
| Street Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Street Security Types |
| Name | Current Value |
| Street Bound Attachments |
| Name | Current Value |
| Street Data Movement Rules |
| Name | Type | Rule Text/Value |
| Street Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Institute Street |
NO | ||
| CNMS_PRPSL (Oracle) INST ST |
NO | ||
| ENGA (Oracle) INST ST |
NO | ||
| PUBL (Oracle) INST ST |
NO | ||
| XF_ADMIN (Oracle) INST ST |
NO |
| Street Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Street Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Street Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Street Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| City |
| Base Entity | Institute |
| Attribute Name | City |
| Logical Rolename | |
| ColumnName | CITY |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | City: City the institute is located. |
| Note |
| City Logical Attribute Properties |
| Logical Attribute Name | City |
| Datatype | VARCHAR(100) |
| Nullable | NO |
| City Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| City Security Types |
| Name | Current Value |
| City Bound Attachments |
| Name | Current Value |
| City Data Movement Rules |
| Name | Type | Rule Text/Value |
| City Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Institute City |
NO | ||
| CNMS_PRPSL (Oracle) INST CITY |
NO | ||
| ENGA (Oracle) INST CITY |
NO | ||
| PUBL (Oracle) INST CITY |
NO | ||
| XF_ADMIN (Oracle) INST CITY |
NO |
| City Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| City Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| City Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| City Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| State |
| Base Entity | Institute |
| Attribute Name | State |
| Logical Rolename | |
| ColumnName | STATE |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | State: State or provience the institute is located. |
| Note |
| State Logical Attribute Properties |
| Logical Attribute Name | State |
| Datatype | VARCHAR(100) |
| Nullable | NO |
| State Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| State Security Types |
| Name | Current Value |
| State Bound Attachments |
| Name | Current Value |
| State Data Movement Rules |
| Name | Type | Rule Text/Value |
| State Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Institute State |
NO | ||
| CNMS_PRPSL (Oracle) INST STATE |
NO | ||
| ENGA (Oracle) INST STATE |
NO | ||
| PUBL (Oracle) INST STATE |
NO | ||
| XF_ADMIN (Oracle) INST STATE |
NO |
| State Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| State Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| State Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| State Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Postal Code |
| Base Entity | Institute |
| Attribute Name | Postal Code |
| Logical Rolename | |
| ColumnName | POSTAL_CD |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Postal Code: Postal code of the institute. |
| Note |
| Postal Code Logical Attribute Properties |
| Logical Attribute Name | Postal Code |
| Datatype | VARCHAR(20) |
| Nullable | NO |
| Postal Code Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Postal Code Security Types |
| Name | Current Value |
| Postal Code Bound Attachments |
| Name | Current Value |
| Postal Code Data Movement Rules |
| Name | Type | Rule Text/Value |
| Postal Code Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Institute Postal Code |
NO | ||
| CNMS_PRPSL (Oracle) INST POSTAL_CD |
NO | ||
| ENGA (Oracle) INST POSTAL_CD |
NO | ||
| PUBL (Oracle) INST POSTAL_CD |
NO | ||
| XF_ADMIN (Oracle) INST POSTAL_CD |
NO |
| Postal Code Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Postal Code Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Postal Code Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Postal Code Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Universal Resource Locator |
| Base Entity | Institute |
| Attribute Name | Universal Resource Locator |
| Logical Rolename | |
| ColumnName | URL |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Universail Resource Locator: The URL for the institutes web site. |
| Note |
| Universal Resource Locator Logical Attribute Properties |
| Logical Attribute Name | Universal Resource Locator |
| Datatype | VARCHAR(256) |
| Nullable | YES |
| Universal Resource Locator Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Universal Resource Locator Security Types |
| Name | Current Value |
| Universal Resource Locator Bound Attachments |
| Name | Current Value |
| Universal Resource Locator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Universal Resource Locator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Institute Universal Resource Locator |
NO | ||
| CNMS_PRPSL (Oracle) INST URL |
NO | ||
| ENGA (Oracle) INST URL |
NO | ||
| PUBL (Oracle) INST URL |
NO | ||
| XF_ADMIN (Oracle) INST URL |
NO |
| Universal Resource Locator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Universal Resource Locator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Universal Resource Locator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Universal Resource Locator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Techology Transfer User Agreement Number |
| Base Entity | Institute |
| Attribute Name | Techology Transfer User Agreement Number |
| Logical Rolename | |
| ColumnName | TT_USER_AGREE_NBR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Techology Transfer User Agreement Number: Every institution must have a technology transfer agreement which is assigned by the Office of Technology Transfer. |
| Note |
| Techology Transfer User Agreement Number Logical Attribute Properties |
| Logical Attribute Name | Techology Transfer User Agreement Number |
| Datatype | VARCHAR(15) |
| Nullable | YES |
| Techology Transfer User Agreement Number Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Techology Transfer User Agreement Number Security Types |
| Name | Current Value |
| Techology Transfer User Agreement Number Bound Attachments |
| Name | Current Value |
| Techology Transfer User Agreement Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Techology Transfer User Agreement Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Institute Techology Transfer User Agreement Number |
NO | ||
| CNMS_PRPSL (Oracle) INST TT_USER_AGREE_NBR |
NO | ||
| ENGA (Oracle) INST TT_USER_AGREE_NBR |
NO | ||
| PUBL (Oracle) INST TT_USER_AGREE_NBR |
NO | ||
| XF_ADMIN (Oracle) INST TT_USER_AGREE_NBR |
NO |
| Techology Transfer User Agreement Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Techology Transfer User Agreement Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Techology Transfer User Agreement Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Techology Transfer User Agreement Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Techology Transfer User Agreement Expiration Date |
| Base Entity | Institute |
| Attribute Name | Techology Transfer User Agreement Expiration Date |
| Logical Rolename | |
| ColumnName | TT_USER_AGREE_EXP_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| Techology Transfer User Agreement Expiration Date Logical Attribute Properties |
| Logical Attribute Name | Techology Transfer User Agreement Expiration Date |
| Datatype | DATE |
| Nullable | YES |
| Techology Transfer User Agreement Expiration Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Techology Transfer User Agreement Expiration Date Security Types |
| Name | Current Value |
| Techology Transfer User Agreement Expiration Date Bound Attachments |
| Name | Current Value |
| Techology Transfer User Agreement Expiration Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Techology Transfer User Agreement Expiration Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Institute Techology Transfer User Agreement Expiration Date |
NO | ||
| CNMS_PRPSL (Oracle) INST TT_USER_AGREE_EXP_DTE |
NO | ||
| ENGA (Oracle) INST TT_USER_AGREE_EXP_DTE |
NO | ||
| PUBL (Oracle) INST TT_USER_AGREE_EXP_DTE |
NO | ||
| XF_ADMIN (Oracle) INST TT_USER_AGREE_EXP_DTE |
NO |
| Techology Transfer User Agreement Expiration Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Techology Transfer User Agreement Expiration Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Techology Transfer User Agreement Expiration Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Techology Transfer User Agreement Expiration Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Category Identifier |
| Base Entity | Institute |
| Attribute Name | Category Identifier |
| Logical Rolename | |
| ColumnName | CAT_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Category Identifier Logical Attribute Properties |
| Logical Attribute Name | Category Identifier |
| Datatype | VARCHAR(25) |
| Nullable | NO |
| Category Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Category Identifier Security Types |
| Name | Current Value |
| Category Identifier Bound Attachments |
| Name | Current Value |
| Category Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Category Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Institute Category Identifier |
NO | ||
| CNMS_PRPSL (Oracle) INST CAT_ID |
NO | ||
| ENGA (Oracle) INST CAT_ID |
NO | ||
| PUBL (Oracle) INST CAT_ID |
NO | ||
| XF_ADMIN (Oracle) INST CAT_ID |
NO |
| Category Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Category Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Category Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Category Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Institute Name Alias |
| Base Entity | Institute |
| Attribute Name | Institute Name Alias |
| Logical Rolename | |
| ColumnName | INST_NM_ALIAS |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
| Note |
| Institute Name Alias Logical Attribute Properties |
| Logical Attribute Name | Institute Name Alias |
| Datatype | VARCHAR(4000) |
| Nullable | YES |
| Institute Name Alias Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Institute Name Alias Security Types |
| Name | Current Value |
| Institute Name Alias Bound Attachments |
| Name | Current Value |
| Institute Name Alias Data Movement Rules |
| Name | Type | Rule Text/Value |
| Institute Name Alias Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Institute Institute Name Alias |
NO | ||
| CNMS_PRPSL (Oracle) INST INST_NM_ALIAS |
NO | ||
| ENGA (Oracle) INST INST_NM_ALIAS |
NO | ||
| PUBL (Oracle) INST INST_NM_ALIAS |
NO | ||
| XF_ADMIN (Oracle) INST INST_NM_ALIAS |
NO |
| Institute Name Alias Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Institute Name Alias Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Institute Name Alias Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Institute Name Alias Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Comment |
| Base Entity | Institute |
| Attribute Name | Comment |
| Logical Rolename | |
| ColumnName | CMNT |
| RoleName | |
| Domain | Comment |
| Logical Only | NO |
| Definition | Comment: General comments. |
| Note |
| Comment Logical Attribute Properties |
| Logical Attribute Name | Comment |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| Comment Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Comment Security Types |
| Name | Current Value |
| Comment Bound Attachments |
| Name | Current Value |
| Comment Data Movement Rules |
| Name | Type | Rule Text/Value |
| Comment Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Institute Comment |
NO | ||
| CNMS_PRPSL (Oracle) INST CMNT |
NO | ||
| ENGA (Oracle) INST CMNT |
NO | ||
| PUBL (Oracle) INST CMNT |
NO | ||
| XF_ADMIN (Oracle) INST CMNT |
NO |
| Comment Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Comment Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Comment Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Comment Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |