| ID |
| Base Object | INDUS_CONT |
| Attribute Name | Identifier |
| ColumnName | ID |
| Logical Rolename | |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| ID Column Properties |
| Datatype | NUMBER(38, 0) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ID Security Types |
| Name | Current Value |
| ID Bound Attachments |
| Name | Current Value |
| ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Industry Contact Identifier |
NO | ||
| PRPSL (Oracle) INDUS_CONT ID |
NO |
| ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| COMP_NM |
| Base Object | INDUS_CONT |
| Attribute Name | Company Name |
| ColumnName | COMP_NM |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| COMP_NM Column Properties |
| Datatype | VARCHAR2(120) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| COMP_NM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 120 |
| Percent Null | 0 |
| COMP_NM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| COMP_NM Security Types |
| Name | Current Value |
| COMP_NM Bound Attachments |
| Name | Current Value |
| COMP_NM Data Movement Rules |
| Name | Type | Rule Text/Value |
| COMP_NM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Industry Contact Company Name |
NO | ||
| PRPSL (Oracle) INDUS_CONT COMP_NM |
NO |
| COMP_NM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| COMP_NM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| COMP_NM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| COMP_NM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIRST_NM |
| Base Object | INDUS_CONT |
| Attribute Name | First Name |
| ColumnName | FIRST_NM |
| Logical Rolename | |
| RoleName | |
| Domain | Name |
| Physical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| FIRST_NM Column Properties |
| Datatype | VARCHAR2(120) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| FIRST_NM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 120 |
| Percent Null | 0 |
| FIRST_NM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FIRST_NM Security Types |
| Name | Current Value |
| FIRST_NM Bound Attachments |
| Name | Current Value |
| FIRST_NM Data Movement Rules |
| Name | Type | Rule Text/Value |
| FIRST_NM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Industry Contact First Name |
NO | ||
| PRPSL (Oracle) INDUS_CONT FIRST_NM |
NO |
| FIRST_NM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIRST_NM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIRST_NM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIRST_NM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LAST_NM |
| Base Object | INDUS_CONT |
| Attribute Name | Last Name |
| ColumnName | LAST_NM |
| Logical Rolename | |
| RoleName | |
| Domain | Name |
| Physical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| LAST_NM Column Properties |
| Datatype | VARCHAR2(120) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| LAST_NM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 120 |
| Percent Null | 0 |
| LAST_NM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LAST_NM Security Types |
| Name | Current Value |
| LAST_NM Bound Attachments |
| Name | Current Value |
| LAST_NM Data Movement Rules |
| Name | Type | Rule Text/Value |
| LAST_NM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Industry Contact Last Name |
NO | ||
| PRPSL (Oracle) INDUS_CONT LAST_NM |
NO |
| LAST_NM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LAST_NM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LAST_NM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LAST_NM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TITLE |
| Base Object | INDUS_CONT |
| Attribute Name | Title |
| ColumnName | TITLE |
| Logical Rolename | |
| RoleName | |
| Domain | Title |
| Physical Only | NO |
| Definition | |
| Note |
| TITLE Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| TITLE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| TITLE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TITLE Security Types |
| Name | Current Value |
| TITLE Bound Attachments |
| Name | Current Value |
| TITLE Data Movement Rules |
| Name | Type | Rule Text/Value |
| TITLE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Industry Contact Title |
NO | ||
| PRPSL (Oracle) INDUS_CONT TITLE |
NO |
| TITLE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TITLE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TITLE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TITLE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PHONE |
| Base Object | INDUS_CONT |
| Attribute Name | Phone |
| ColumnName | PHONE |
| Logical Rolename | |
| RoleName | |
| Domain | Phone |
| Physical Only | NO |
| Definition | |
| Note |
| PHONE Column Properties |
| Datatype | VARCHAR2(20) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PHONE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| PHONE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PHONE Security Types |
| Name | Current Value |
| PHONE Bound Attachments |
| Name | Current Value |
| PHONE Data Movement Rules |
| Name | Type | Rule Text/Value |
| PHONE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Industry Contact Phone |
NO | ||
| PRPSL (Oracle) INDUS_CONT PHONE |
NO |
| PHONE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PHONE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PHONE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PHONE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_ADDR |
| Base Object | INDUS_CONT |
| Attribute Name | Email Addr |
| ColumnName | EMAIL_ADDR |
| Logical Rolename | |
| RoleName | |
| Domain | Email Addr |
| Physical Only | NO |
| Definition | Email Address: |
| Note |
| EMAIL_ADDR Column Properties |
| Datatype | VARCHAR2(75) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| EMAIL_ADDR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 75 |
| Percent Null | 0 |
| EMAIL_ADDR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| EMAIL_ADDR Security Types |
| Name | Current Value |
| EMAIL_ADDR Bound Attachments |
| Name | Current Value |
| EMAIL_ADDR Data Movement Rules |
| Name | Type | Rule Text/Value |
| EMAIL_ADDR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Industry Contact Email Addr |
NO | ||
| PRPSL (Oracle) INDUS_CONT EMAIL_ADDR |
NO |
| EMAIL_ADDR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_ADDR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_ADDR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_ADDR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CNTRY_ID |
| Base Object | INDUS_CONT |
| Attribute Name | Country Identifier |
| ColumnName | CNTRY_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Country Identifier: Abbreviated identrifier for a country. |
| Note |
| CNTRY_ID Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CNTRY_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| CNTRY_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CNTRY_ID Security Types |
| Name | Current Value |
| CNTRY_ID Bound Attachments |
| Name | Current Value |
| CNTRY_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| CNTRY_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Industry Contact Country Identifier |
NO | ||
| PRPSL (Oracle) INDUS_CONT CNTRY_ID |
NO |
| CNTRY_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CNTRY_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CNTRY_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CNTRY_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| INVL_DESCR |
| Base Object | INDUS_CONT |
| Attribute Name | Involvement Description |
| ColumnName | INVL_DESCR |
| Logical Rolename | |
| RoleName | |
| Domain | Description |
| Physical Only | NO |
| Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
| Note |
| INVL_DESCR Column Properties |
| Datatype | VARCHAR2(4000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| INVL_DESCR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4000 |
| Percent Null | 0 |
| INVL_DESCR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| INVL_DESCR Security Types |
| Name | Current Value |
| INVL_DESCR Bound Attachments |
| Name | Current Value |
| INVL_DESCR Data Movement Rules |
| Name | Type | Rule Text/Value |
| INVL_DESCR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Industry Contact Involvement Description |
NO | ||
| PRPSL (Oracle) INDUS_CONT INVL_DESCR |
NO |
| INVL_DESCR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| INVL_DESCR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| INVL_DESCR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| INVL_DESCR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PROJ_TYPE |
| Base Object | INDUS_CONT |
| Attribute Name | Project Type |
| ColumnName | PROJ_TYPE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| PROJ_TYPE Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PROJ_TYPE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| PROJ_TYPE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PROJ_TYPE Security Types |
| Name | Current Value |
| PROJ_TYPE Bound Attachments |
| Name | Current Value |
| PROJ_TYPE Data Movement Rules |
| Name | Type | Rule Text/Value |
| PROJ_TYPE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Industry Contact Project Type |
NO | ||
| PRPSL (Oracle) INDUS_CONT PROJ_TYPE |
NO |
| PROJ_TYPE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PROJ_TYPE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PROJ_TYPE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PROJ_TYPE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RSCH_AREA |
| Base Object | INDUS_CONT |
| Attribute Name | Research Area |
| ColumnName | RSCH_AREA |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| RSCH_AREA Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| RSCH_AREA Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| RSCH_AREA Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RSCH_AREA Security Types |
| Name | Current Value |
| RSCH_AREA Bound Attachments |
| Name | Current Value |
| RSCH_AREA Data Movement Rules |
| Name | Type | Rule Text/Value |
| RSCH_AREA Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Industry Contact Research Area |
NO | ||
| PRPSL (Oracle) INDUS_CONT RSCH_AREA |
NO |
| RSCH_AREA Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RSCH_AREA Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RSCH_AREA Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RSCH_AREA Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RSCH_AREA_OTHER |
| Base Object | INDUS_CONT |
| Attribute Name | Research Area Other |
| ColumnName | RSCH_AREA_OTHER |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| RSCH_AREA_OTHER Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| RSCH_AREA_OTHER Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| RSCH_AREA_OTHER Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RSCH_AREA_OTHER Security Types |
| Name | Current Value |
| RSCH_AREA_OTHER Bound Attachments |
| Name | Current Value |
| RSCH_AREA_OTHER Data Movement Rules |
| Name | Type | Rule Text/Value |
| RSCH_AREA_OTHER Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Industry Contact Research Area Other |
NO | ||
| PRPSL (Oracle) INDUS_CONT RSCH_AREA_OTHER |
NO |
| RSCH_AREA_OTHER Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RSCH_AREA_OTHER Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RSCH_AREA_OTHER Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RSCH_AREA_OTHER Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| REQ_TECH |
| Base Object | INDUS_CONT |
| Attribute Name | Requested Technique |
| ColumnName | REQ_TECH |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| REQ_TECH Column Properties |
| Datatype | VARCHAR2(200) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| REQ_TECH Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 200 |
| Percent Null | 0 |
| REQ_TECH Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| REQ_TECH Security Types |
| Name | Current Value |
| REQ_TECH Bound Attachments |
| Name | Current Value |
| REQ_TECH Data Movement Rules |
| Name | Type | Rule Text/Value |
| REQ_TECH Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Industry Contact Requested Technique |
NO | ||
| PRPSL (Oracle) INDUS_CONT REQ_TECH |
NO |
| REQ_TECH Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| REQ_TECH Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| REQ_TECH Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| REQ_TECH Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| REQ_TECH_OTHER |
| Base Object | INDUS_CONT |
| Attribute Name | Requested Technique Other |
| ColumnName | REQ_TECH_OTHER |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| REQ_TECH_OTHER Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| REQ_TECH_OTHER Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| REQ_TECH_OTHER Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| REQ_TECH_OTHER Security Types |
| Name | Current Value |
| REQ_TECH_OTHER Bound Attachments |
| Name | Current Value |
| REQ_TECH_OTHER Data Movement Rules |
| Name | Type | Rule Text/Value |
| REQ_TECH_OTHER Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Industry Contact Requested Technique Other |
NO | ||
| PRPSL (Oracle) INDUS_CONT REQ_TECH_OTHER |
NO |
| REQ_TECH_OTHER Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| REQ_TECH_OTHER Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| REQ_TECH_OTHER Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| REQ_TECH_OTHER Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| INSTR_STAFF |
| Base Object | INDUS_CONT |
| Attribute Name | Instrument Staff |
| ColumnName | INSTR_STAFF |
| Logical Rolename | |
| RoleName | |
| Domain | Name |
| Physical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| INSTR_STAFF Column Properties |
| Datatype | VARCHAR2(120) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| INSTR_STAFF Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 120 |
| Percent Null | 0 |
| INSTR_STAFF Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| INSTR_STAFF Security Types |
| Name | Current Value |
| INSTR_STAFF Bound Attachments |
| Name | Current Value |
| INSTR_STAFF Data Movement Rules |
| Name | Type | Rule Text/Value |
| INSTR_STAFF Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Industry Contact Instrument Staff |
NO | ||
| PRPSL (Oracle) INDUS_CONT INSTR_STAFF |
NO |
| INSTR_STAFF Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| INSTR_STAFF Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| INSTR_STAFF Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| INSTR_STAFF Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PROJ_CMPLT_DTE |
| Base Object | INDUS_CONT |
| Attribute Name | Projected Completion Date |
| ColumnName | PROJ_CMPLT_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| PROJ_CMPLT_DTE Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PROJ_CMPLT_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| PROJ_CMPLT_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PROJ_CMPLT_DTE Security Types |
| Name | Current Value |
| PROJ_CMPLT_DTE Bound Attachments |
| Name | Current Value |
| PROJ_CMPLT_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| PROJ_CMPLT_DTE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Industry Contact Projected Completion Date |
NO | ||
| PRPSL (Oracle) INDUS_CONT PROJ_CMPLT_DTE |
NO |
| PROJ_CMPLT_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PROJ_CMPLT_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PROJ_CMPLT_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PROJ_CMPLT_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PROJ_CMPLT_DTE_OTHER |
| Base Object | INDUS_CONT |
| Attribute Name | Projected Completion Date Other |
| ColumnName | PROJ_CMPLT_DTE_OTHER |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| PROJ_CMPLT_DTE_OTHER Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PROJ_CMPLT_DTE_OTHER Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| PROJ_CMPLT_DTE_OTHER Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PROJ_CMPLT_DTE_OTHER Security Types |
| Name | Current Value |
| PROJ_CMPLT_DTE_OTHER Bound Attachments |
| Name | Current Value |
| PROJ_CMPLT_DTE_OTHER Data Movement Rules |
| Name | Type | Rule Text/Value |
| PROJ_CMPLT_DTE_OTHER Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Industry Contact Projected Completion Date Other |
NO | ||
| PRPSL (Oracle) INDUS_CONT PROJ_CMPLT_DTE_OTHER |
NO |
| PROJ_CMPLT_DTE_OTHER Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PROJ_CMPLT_DTE_OTHER Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PROJ_CMPLT_DTE_OTHER Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PROJ_CMPLT_DTE_OTHER Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| GEN_DESCR |
| Base Object | INDUS_CONT |
| Attribute Name | General Description |
| ColumnName | GEN_DESCR |
| Logical Rolename | |
| RoleName | |
| Domain | Description |
| Physical Only | NO |
| Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
| Note |
| GEN_DESCR Column Properties |
| Datatype | VARCHAR2(4000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| GEN_DESCR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4000 |
| Percent Null | 0 |
| GEN_DESCR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| GEN_DESCR Security Types |
| Name | Current Value |
| GEN_DESCR Bound Attachments |
| Name | Current Value |
| GEN_DESCR Data Movement Rules |
| Name | Type | Rule Text/Value |
| GEN_DESCR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Industry Contact General Description |
NO | ||
| PRPSL (Oracle) INDUS_CONT GEN_DESCR |
NO |
| GEN_DESCR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| GEN_DESCR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| GEN_DESCR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| GEN_DESCR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PREF_CONT_METH_ID |
| Base Object | INDUS_CONT |
| Attribute Name | Preferred Contact Method Identifier |
| ColumnName | PREF_CONT_METH_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| PREF_CONT_METH_ID Column Properties |
| Datatype | VARCHAR2(8) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PREF_CONT_METH_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 8 |
| Percent Null | 0 |
| PREF_CONT_METH_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PREF_CONT_METH_ID Security Types |
| Name | Current Value |
| PREF_CONT_METH_ID Bound Attachments |
| Name | Current Value |
| PREF_CONT_METH_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| PREF_CONT_METH_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Industry Contact Preferred Contact Method Identifier |
NO | ||
| PRPSL (Oracle) INDUS_CONT PREF_CONT_METH_ID |
NO |
| PREF_CONT_METH_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PREF_CONT_METH_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PREF_CONT_METH_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PREF_CONT_METH_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| URL |
| Base Object | INDUS_CONT |
| Attribute Name | Uniform Resource Locator |
| ColumnName | URL |
| Logical Rolename | |
| RoleName | |
| Domain | URL |
| Physical Only | NO |
| Definition | Universal Resource Locator: The global address of documents and other resources on the web. |
| Note |
| URL Column Properties |
| Datatype | VARCHAR2(2048) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| URL Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2048 |
| Percent Null | 0 |
| URL Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| URL Security Types |
| Name | Current Value |
| URL Bound Attachments |
| Name | Current Value |
| URL Data Movement Rules |
| Name | Type | Rule Text/Value |
| URL Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Industry Contact Uniform Resource Locator |
NO | ||
| PRPSL (Oracle) INDUS_CONT URL |
NO |
| URL Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| URL Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| URL Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| URL Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |