| TRACK_ID |
| Base Object | IPTS_PROJ_TRACK |
| Attribute Name | Tracking Identifier |
| ColumnName | TRACK_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| TRACK_ID Column Properties |
| Datatype | NUMBER(38, 0) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| TRACK_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 6 |
| Percent Null | 0 |
| TRACK_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TRACK_ID Security Types |
| Name | Current Value |
| TRACK_ID Bound Attachments |
| Name | Current Value |
| TRACK_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| TRACK_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical IPTS Project Tracking Tracking Identifier |
NO | ||
| IPTSv5 (Oracle) IPTS_PROJ_TRACK TRACK_ID |
NO | ||
| PRPSL (Oracle) IPTS_PROJ_TRACK TRACK_ID |
NO |
| TRACK_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TRACK_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TRACK_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TRACK_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TASK_ID |
| Base Object | IPTS_PROJ_TRACK |
| Attribute Name | TASK_ID |
| ColumnName | TASK_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| TASK_ID Column Properties |
| Datatype | VARCHAR2(12) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| TASK_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 12 |
| Percent Null | 0 |
| TASK_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TASK_ID Security Types |
| Name | Current Value |
| TASK_ID Bound Attachments |
| Name | Current Value |
| TASK_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| TASK_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical IPTS Project Tracking TASK_ID |
NO | ||
| IPTSv5 (Oracle) IPTS_PROJ_TRACK TASK_ID |
NO | ||
| PRPSL (Oracle) IPTS_PROJ_TRACK TASK_ID |
NO |
| TASK_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TASK_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TASK_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TASK_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DESCR |
| Base Object | IPTS_PROJ_TRACK |
| Attribute Name | Description |
| ColumnName | DESCR |
| Logical Rolename | |
| RoleName | |
| Domain | Description |
| Physical Only | NO |
| Definition | |
| Note |
| DESCR Column Properties |
| Datatype | VARCHAR2(4000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DESCR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4000 |
| Percent Null | 0 |
| DESCR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DESCR Security Types |
| Name | Current Value |
| DESCR Bound Attachments |
| Name | Current Value |
| DESCR Data Movement Rules |
| Name | Type | Rule Text/Value |
| DESCR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical IPTS Project Tracking Description |
NO | ||
| IPTSv5 (Oracle) IPTS_PROJ_TRACK DESCR |
NO | ||
| PRPSL (Oracle) IPTS_PROJ_TRACK DESCR |
NO |
| DESCR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DESCR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DESCR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DESCR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PRIORITY |
| Base Object | IPTS_PROJ_TRACK |
| Attribute Name | Priority |
| ColumnName | PRIORITY |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| PRIORITY Column Properties |
| Datatype | NUMBER(1, 0) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PRIORITY Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| PRIORITY Domain Restrictions |
| CheckConstraint | priority IN (1,2,3) |
| Check Constraint Name | SYS_C0018362 |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PRIORITY Security Types |
| Name | Current Value |
| PRIORITY Bound Attachments |
| Name | Current Value |
| PRIORITY Data Movement Rules |
| Name | Type | Rule Text/Value |
| PRIORITY Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical IPTS Project Tracking Priority |
NO | ||
| IPTSv5 (Oracle) IPTS_PROJ_TRACK PRIORITY |
NO | ||
| PRPSL (Oracle) IPTS_PROJ_TRACK PRIORITY |
NO |
| PRIORITY Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PRIORITY Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PRIORITY Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PRIORITY Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_BY_BN |
| Base Object | IPTS_PROJ_TRACK |
| Attribute Name | Modified By Badge Number |
| ColumnName | MOD_BY_BN |
| Logical Rolename | |
| RoleName | |
| Domain | Modied By Badge Number |
| Physical Only | NO |
| Definition | |
| Note |
| MOD_BY_BN Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| MOD_BY_BN Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 6 |
| Percent Null | 0 |
| MOD_BY_BN Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MOD_BY_BN Security Types |
| Name | Current Value |
| MOD_BY_BN Bound Attachments |
| Name | Current Value |
| MOD_BY_BN Data Movement Rules |
| Name | Type | Rule Text/Value |
| MOD_BY_BN Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical IPTS Project Tracking Modified By Badge Number |
NO | ||
| IPTSv5 (Oracle) IPTS_PROJ_TRACK MOD_BY_BN |
NO | ||
| PRPSL (Oracle) IPTS_PROJ_TRACK MOD_BY_BN |
NO |
| MOD_BY_BN Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_BY_BN Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_BY_BN Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_BY_BN Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ENTER_DTE |
| Base Object | IPTS_PROJ_TRACK |
| Attribute Name | Enter Date |
| ColumnName | ENTER_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | |
| Note |
| ENTER_DTE Column Properties |
| Datatype | DATE |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ENTER_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| ENTER_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| ENTER_DTE Security Types |
| Name | Current Value |
| ENTER_DTE Bound Attachments |
| Name | Current Value |
| ENTER_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| ENTER_DTE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical IPTS Project Tracking Enter Date |
NO | ||
| IPTSv5 (Oracle) IPTS_PROJ_TRACK ENTER_DTE |
NO | ||
| PRPSL (Oracle) IPTS_PROJ_TRACK ENTER_DTE |
NO |
| ENTER_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ENTER_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ENTER_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ENTER_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CMPLT_DTE |
| Base Object | IPTS_PROJ_TRACK |
| Attribute Name | Complete Date |
| ColumnName | CMPLT_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | |
| Note |
| CMPLT_DTE Column Properties |
| Datatype | DATE |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CMPLT_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| CMPLT_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| CMPLT_DTE Security Types |
| Name | Current Value |
| CMPLT_DTE Bound Attachments |
| Name | Current Value |
| CMPLT_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| CMPLT_DTE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical IPTS Project Tracking Complete Date |
NO | ||
| IPTSv5 (Oracle) IPTS_PROJ_TRACK CMPLT_DTE |
NO | ||
| PRPSL (Oracle) IPTS_PROJ_TRACK CMPLT_DTE |
NO |
| CMPLT_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CMPLT_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CMPLT_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CMPLT_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| REL_ID |
| Base Object | IPTS_PROJ_TRACK |
| Attribute Name | Release Identifier |
| ColumnName | REL_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| REL_ID Column Properties |
| Datatype | VARCHAR2(20) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| REL_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| REL_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| REL_ID Security Types |
| Name | Current Value |
| REL_ID Bound Attachments |
| Name | Current Value |
| REL_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| REL_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical IPTS Project Tracking Release Identifier |
NO | ||
| IPTSv5 (Oracle) IPTS_PROJ_TRACK REL_ID |
NO | ||
| PRPSL (Oracle) IPTS_PROJ_TRACK REL_ID |
NO |
| REL_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| REL_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| REL_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| REL_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DUE_DTE |
| Base Object | IPTS_PROJ_TRACK |
| Attribute Name | DUE_DTE |
| ColumnName | DUE_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| DUE_DTE Column Properties |
| Datatype | DATE |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DUE_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| DUE_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DUE_DTE Security Types |
| Name | Current Value |
| DUE_DTE Bound Attachments |
| Name | Current Value |
| DUE_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| DUE_DTE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical IPTS Project Tracking DUE_DTE |
NO | ||
| IPTSv5 (Oracle) IPTS_PROJ_TRACK DUE_DTE |
NO | ||
| PRPSL (Oracle) IPTS_PROJ_TRACK DUE_DTE |
NO |
| DUE_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DUE_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DUE_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DUE_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DEVL_CMPLT_DTE |
| Base Object | IPTS_PROJ_TRACK |
| Attribute Name | DEVL_CMPLT_DTE |
| ColumnName | DEVL_CMPLT_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| DEVL_CMPLT_DTE Column Properties |
| Datatype | DATE |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DEVL_CMPLT_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| DEVL_CMPLT_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DEVL_CMPLT_DTE Security Types |
| Name | Current Value |
| DEVL_CMPLT_DTE Bound Attachments |
| Name | Current Value |
| DEVL_CMPLT_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| DEVL_CMPLT_DTE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical IPTS Project Tracking DEVL_CMPLT_DTE |
NO | ||
| IPTSv5 (Oracle) IPTS_PROJ_TRACK DEVL_CMPLT_DTE |
NO | ||
| PRPSL (Oracle) IPTS_PROJ_TRACK DEVL_CMPLT_DTE |
NO |
| DEVL_CMPLT_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DEVL_CMPLT_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DEVL_CMPLT_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DEVL_CMPLT_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DEVL_STAT |
| Base Object | IPTS_PROJ_TRACK |
| Attribute Name | DEVL_STAT |
| ColumnName | DEVL_STAT |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| DEVL_STAT Column Properties |
| Datatype | VARCHAR2(4000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DEVL_STAT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4000 |
| Percent Null | 0 |
| DEVL_STAT Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DEVL_STAT Security Types |
| Name | Current Value |
| DEVL_STAT Bound Attachments |
| Name | Current Value |
| DEVL_STAT Data Movement Rules |
| Name | Type | Rule Text/Value |
| DEVL_STAT Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical IPTS Project Tracking DEVL_STAT |
NO | ||
| IPTSv5 (Oracle) IPTS_PROJ_TRACK DEVL_STAT |
NO | ||
| PRPSL (Oracle) IPTS_PROJ_TRACK DEVL_STAT |
NO |
| DEVL_STAT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DEVL_STAT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DEVL_STAT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DEVL_STAT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |