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 | 20 |
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 | 10 |
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 | Release Identifier |
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 |