| Tracking Identifier |
| Base Entity | IPTS Project Tracking |
| Attribute Name | Tracking Identifier |
| Logical Rolename | |
| ColumnName | TRACK_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Tracking Identifier Logical Attribute Properties |
| Logical Attribute Name | Tracking Identifier |
| Datatype | NUMERIC(38, 0) |
| Nullable | NO |
| Tracking Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Tracking Identifier Security Types |
| Name | Current Value |
| Tracking Identifier Bound Attachments |
| Name | Current Value |
| Tracking Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Tracking Identifier 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 |
| Tracking Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Tracking Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Tracking Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Tracking Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TASK_ID |
| Base Entity | IPTS Project Tracking |
| Attribute Name | TASK_ID |
| Logical Rolename | |
| ColumnName | TASK_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| TASK_ID Logical Attribute Properties |
| Logical Attribute Name | TASK_ID |
| Datatype | VARCHAR(12) |
| Nullable | YES |
| 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 |
| Description |
| Base Entity | IPTS Project Tracking |
| Attribute Name | Description |
| Logical Rolename | |
| ColumnName | DESCR |
| RoleName | |
| Domain | Description |
| Logical Only | NO |
| Definition | |
| Note |
| Description Logical Attribute Properties |
| Logical Attribute Name | Description |
| Datatype | VARCHAR(4000) |
| Nullable | YES |
| Description Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Description Security Types |
| Name | Current Value |
| Description Bound Attachments |
| Name | Current Value |
| Description Data Movement Rules |
| Name | Type | Rule Text/Value |
| Description 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 |
| Description Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Description Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Description Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Description Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Priority |
| Base Entity | IPTS Project Tracking |
| Attribute Name | Priority |
| Logical Rolename | |
| ColumnName | PRIORITY |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Priority Logical Attribute Properties |
| Logical Attribute Name | Priority |
| Datatype | NUMERIC(1, 0) |
| Nullable | YES |
| 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 |
| Modified By Badge Number |
| Base Entity | IPTS Project Tracking |
| Attribute Name | Modified By Badge Number |
| Logical Rolename | |
| ColumnName | MOD_BY_BN |
| RoleName | |
| Domain | Modied By Badge Number |
| Logical Only | NO |
| Definition | |
| Note |
| Modified By Badge Number Logical Attribute Properties |
| Logical Attribute Name | Modified By Badge Number |
| Datatype | VARCHAR(10) |
| Nullable | YES |
| Modified By Badge Number Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Modified By Badge Number Security Types |
| Name | Current Value |
| Modified By Badge Number Bound Attachments |
| Name | Current Value |
| Modified By Badge Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Modified By Badge Number 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 |
| Modified By Badge Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modified By Badge Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modified By Badge Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modified By Badge Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Enter Date |
| Base Entity | IPTS Project Tracking |
| Attribute Name | Enter Date |
| Logical Rolename | |
| ColumnName | ENTER_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | |
| Note |
| Enter Date Logical Attribute Properties |
| Logical Attribute Name | Enter Date |
| Datatype | DATE |
| Nullable | YES |
| Enter Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Enter Date Security Types |
| Name | Current Value |
| Enter Date Bound Attachments |
| Name | Current Value |
| Enter Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Enter Date 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 Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Enter Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Enter Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Enter Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Complete Date |
| Base Entity | IPTS Project Tracking |
| Attribute Name | Complete Date |
| Logical Rolename | |
| ColumnName | CMPLT_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | |
| Note |
| Complete Date Logical Attribute Properties |
| Logical Attribute Name | Complete Date |
| Datatype | DATE |
| Nullable | YES |
| Complete Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Complete Date Security Types |
| Name | Current Value |
| Complete Date Bound Attachments |
| Name | Current Value |
| Complete Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Complete Date 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 |
| Complete Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Complete Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Complete Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Complete Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Release Identifier |
| Base Entity | IPTS Project Tracking |
| Attribute Name | Release Identifier |
| Logical Rolename | |
| ColumnName | REL_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Release Identifier Logical Attribute Properties |
| Logical Attribute Name | Release Identifier |
| Datatype | VARCHAR(20) |
| Nullable | YES |
| Release Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Release Identifier Security Types |
| Name | Current Value |
| Release Identifier Bound Attachments |
| Name | Current Value |
| Release Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Release Identifier 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 |
| Release Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Release Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Release Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Release Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DUE_DTE |
| Base Entity | IPTS Project Tracking |
| Attribute Name | DUE_DTE |
| Logical Rolename | |
| ColumnName | DUE_DTE |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| DUE_DTE Logical Attribute Properties |
| Logical Attribute Name | DUE_DTE |
| Datatype | DATE |
| Nullable | YES |
| 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 Entity | IPTS Project Tracking |
| Attribute Name | DEVL_CMPLT_DTE |
| Logical Rolename | |
| ColumnName | DEVL_CMPLT_DTE |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| DEVL_CMPLT_DTE Logical Attribute Properties |
| Logical Attribute Name | DEVL_CMPLT_DTE |
| Datatype | DATE |
| Nullable | YES |
| 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 Entity | IPTS Project Tracking |
| Attribute Name | DEVL_STAT |
| Logical Rolename | |
| ColumnName | DEVL_STAT |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| DEVL_STAT Logical Attribute Properties |
| Logical Attribute Name | DEVL_STAT |
| Datatype | VARCHAR(max) |
| Nullable | YES |
| 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 |