Email Addr |
Base Entity | Feedback |
Attribute Name | Email Addr |
Logical Rolename | |
ColumnName | EMAIL_ADDR |
RoleName | |
Domain | Email Addr |
Logical Only | NO |
Definition | Email Address: |
Note |
Email Addr Logical Attribute Properties |
Logical Attribute Name | Email Addr |
Datatype | VARCHAR(75) |
Nullable | NO |
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 Feedback Email Addr |
NO | ||
IPTSv5 (Oracle) FEEDBACK EMAIL_ADDR |
NO | ||
PRPSL (Oracle) FEEDBACK EMAIL_ADDR |
NO | ||
PUBL (Oracle) FEEDBACK 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 |
User Comment |
Base Entity | Feedback |
Attribute Name | User Comment |
Logical Rolename | |
ColumnName | USER_CMNT |
RoleName | |
Domain | Comment |
Logical Only | NO |
Definition | Comment: General comments. |
Note |
User Comment Logical Attribute Properties |
Logical Attribute Name | User Comment |
Datatype | VARCHAR(2000) |
Nullable | YES |
User Comment Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
User Comment Security Types |
Name | Current Value |
User Comment Bound Attachments |
Name | Current Value |
User Comment Data Movement Rules |
Name | Type | Rule Text/Value |
User Comment Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Feedback User Comment |
NO | ||
IPTSv5 (Oracle) FEEDBACK USER_CMNT |
NO | ||
PRPSL (Oracle) FEEDBACK USER_CMNT |
NO | ||
PUBL (Oracle) FEEDBACK USER_CMNT |
NO |
User Comment Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
User Comment Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
User Comment Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
User Comment Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Administrator Comment |
Base Entity | Feedback |
Attribute Name | Administrator Comment |
Logical Rolename | |
ColumnName | ADMIN_CMNT |
RoleName | |
Domain | Comment |
Logical Only | NO |
Definition | Comment: General comments. |
Note |
Administrator Comment Logical Attribute Properties |
Logical Attribute Name | Administrator Comment |
Datatype | VARCHAR(2000) |
Nullable | YES |
Administrator Comment Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Administrator Comment Security Types |
Name | Current Value |
Administrator Comment Bound Attachments |
Name | Current Value |
Administrator Comment Data Movement Rules |
Name | Type | Rule Text/Value |
Administrator Comment Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Feedback Administrator Comment |
NO | ||
IPTSv5 (Oracle) FEEDBACK ADMIN_CMNT |
NO | ||
PRPSL (Oracle) FEEDBACK ADMIN_CMNT |
NO | ||
PUBL (Oracle) FEEDBACK ADMIN_CMNT |
NO |
Administrator Comment Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Administrator Comment Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Administrator Comment Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Administrator Comment Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifier |
Base Entity | Feedback |
Attribute Name | Status Identifier |
Logical Rolename | |
ColumnName | STAT_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
Status Identifier Logical Attribute Properties |
Logical Attribute Name | Status Identifier |
Datatype | NUMERIC(38, 0) |
Nullable | NO |
Status Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Status Identifier Security Types |
Name | Current Value |
Status Identifier Bound Attachments |
Name | Current Value |
Status Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Status Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Feedback Status Identifier |
NO | ||
IPTSv5 (Oracle) FEEDBACK STAT_ID |
NO | ||
PRPSL (Oracle) FEEDBACK STAT_ID |
NO | ||
PUBL (Oracle) FEEDBACK STAT_ID |
NO |
Status Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Create Date |
Base Entity | Feedback |
Attribute Name | Create Date |
Logical Rolename | |
ColumnName | CRT_DTE |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
Create Date Logical Attribute Properties |
Logical Attribute Name | Create Date |
Datatype | DATE |
Nullable | NO |
Create Date Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
Create Date Security Types |
Name | Current Value |
Create Date Bound Attachments |
Name | Current Value |
Create Date Data Movement Rules |
Name | Type | Rule Text/Value |
Create Date Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Feedback Create Date |
NO | ||
IPTSv5 (Oracle) FEEDBACK CRT_DTE |
NO | ||
PRPSL (Oracle) FEEDBACK CRT_DTE |
NO | ||
PUBL (Oracle) FEEDBACK CRT_DTE |
NO |
Create Date Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Create Date Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Create Date Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Create Date Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Modify Date |
Base Entity | Feedback |
Attribute Name | Modify Date |
Logical Rolename | |
ColumnName | MOD_DTE |
RoleName | |
Domain | Modify Date |
Logical Only | NO |
Definition | Modify Date: The date the entity values were were created or modified. |
Note |
Modify Date Logical Attribute Properties |
Logical Attribute Name | Modify Date |
Datatype | DATE |
Nullable | NO |
Modify Date Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Modify Date Security Types |
Name | Current Value |
Modify Date Bound Attachments |
Name | Current Value |
Modify Date Data Movement Rules |
Name | Type | Rule Text/Value |
Modify Date Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Feedback Modify Date |
NO | ||
IPTSv5 (Oracle) FEEDBACK MOD_DTE |
NO | ||
PRPSL (Oracle) FEEDBACK MOD_DTE |
NO | ||
PUBL (Oracle) FEEDBACK MOD_DTE |
NO |
Modify Date Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Modify Date Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Modify Date Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Modify Date Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Mod By Uid |
Base Entity | Feedback |
Attribute Name | Mod By Uid |
Logical Rolename | |
ColumnName | Mod By Uid |
RoleName | |
Domain | Mod By Uid |
Logical Only | NO |
Definition | Modified by Userid: The database userid of the person who inserted or update a record in the table. |
Note |
Mod By Uid Logical Attribute Properties |
Logical Attribute Name | Mod By Uid |
Datatype | VARCHAR(64) |
Nullable | NO |
Mod By Uid Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Mod By Uid Security Types |
Name | Current Value |
Mod By Uid Bound Attachments |
Name | Current Value |
Mod By Uid Data Movement Rules |
Name | Type | Rule Text/Value |
Mod By Uid Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Feedback Mod By Uid |
NO | ||
IPTSv5 (Oracle) FEEDBACK Mod By Uid |
NO | ||
PRPSL (Oracle) FEEDBACK Mod By Uid |
NO | ||
PUBL (Oracle) FEEDBACK Mod By Uid |
NO |
Mod By Uid Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Mod By Uid Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Mod By Uid Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Mod By Uid Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |