Procedure Identifier |
Base Entity | Procedure |
Attribute Name | Procedure Identifier |
Logical Rolename | |
ColumnName | PROC_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
Procedure Identifier Logical Attribute Properties |
Logical Attribute Name | Procedure Identifier |
Datatype | VARCHAR(75) |
Nullable | NO |
Procedure Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Procedure Identifier Security Types |
Name | Current Value |
Procedure Identifier Bound Attachments |
Name | Current Value |
Procedure Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Procedure Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Procedure Procedure Identifier |
NO | ||
PROC (Oracle) PROCEDURE PROC_ID |
NO |
Procedure Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Procedure Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Procedure Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Procedure Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Title |
Base Entity | Procedure |
Attribute Name | Title |
Logical Rolename | |
ColumnName | TITLE |
RoleName | |
Domain | Title |
Logical Only | NO |
Definition | |
Note |
Title Logical Attribute Properties |
Logical Attribute Name | Title |
Datatype | VARCHAR(255) |
Nullable | NO |
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 Procedure Title |
NO | ||
PROC (Oracle) PROCEDURE 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 |
Status Identifier |
Base Entity | Procedure |
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 | VARCHAR(25) |
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 Procedure Status Identifier |
NO | ||
PROC (Oracle) PROCEDURE 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 |
Current Revision Number |
Base Entity | Procedure |
Attribute Name | Current Revision Number |
Logical Rolename | |
ColumnName | CUR_REV_NBR |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Current Revision Number Logical Attribute Properties |
Logical Attribute Name | Current Revision Number |
Datatype | NUMERIC(38, 0) |
Nullable | NO |
Current Revision Number Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Current Revision Number Security Types |
Name | Current Value |
Current Revision Number Bound Attachments |
Name | Current Value |
Current Revision Number Data Movement Rules |
Name | Type | Rule Text/Value |
Current Revision Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Procedure Current Revision Number |
NO | ||
PROC (Oracle) PROCEDURE CUR_REV_NBR |
NO |
Current Revision Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Current Revision Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Current Revision Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Current Revision Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Revision Start Date |
Base Entity | Procedure |
Attribute Name | Revision Start Date |
Logical Rolename | |
ColumnName | REV_STRT_DTE |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
Revision Start Date Logical Attribute Properties |
Logical Attribute Name | Revision Start Date |
Datatype | DATE |
Nullable | YES |
Revision Start Date Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
Revision Start Date Security Types |
Name | Current Value |
Revision Start Date Bound Attachments |
Name | Current Value |
Revision Start Date Data Movement Rules |
Name | Type | Rule Text/Value |
Revision Start Date Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Procedure Revision Start Date |
NO | ||
PROC (Oracle) PROCEDURE REV_STRT_DTE |
NO |
Revision Start Date Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Revision Start Date Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Revision Start Date Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Revision Start Date Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Scheduled Completion Date |
Base Entity | Procedure |
Attribute Name | Scheduled Completion Date |
Logical Rolename | |
ColumnName | SCHED_CMPLT_DTE |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
Scheduled Completion Date Logical Attribute Properties |
Logical Attribute Name | Scheduled Completion Date |
Datatype | DATE |
Nullable | YES |
Scheduled Completion Date Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
Scheduled Completion Date Security Types |
Name | Current Value |
Scheduled Completion Date Bound Attachments |
Name | Current Value |
Scheduled Completion Date Data Movement Rules |
Name | Type | Rule Text/Value |
Scheduled Completion Date Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Procedure Scheduled Completion Date |
NO | ||
PROC (Oracle) PROCEDURE SCHED_CMPLT_DTE |
NO |
Scheduled Completion Date Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Scheduled Completion Date Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Scheduled Completion Date Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Scheduled Completion Date Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Issue Date |
Base Entity | Procedure |
Attribute Name | Issue Date |
Logical Rolename | |
ColumnName | ISSUE_DTE |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
Issue Date Logical Attribute Properties |
Logical Attribute Name | Issue Date |
Datatype | DATE |
Nullable | YES |
Issue Date Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
Issue Date Security Types |
Name | Current Value |
Issue Date Bound Attachments |
Name | Current Value |
Issue Date Data Movement Rules |
Name | Type | Rule Text/Value |
Issue Date Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Procedure Issue Date |
NO | ||
PROC (Oracle) PROCEDURE ISSUE_DTE |
NO |
Issue Date Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Issue Date Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Issue Date Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Issue Date Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Author Badge Number |
Base Entity | Procedure |
Attribute Name | Author Badge Number |
Logical Rolename | |
ColumnName | AUTHOR_BN |
RoleName | |
Domain | Badge Number |
Logical Only | NO |
Definition | |
Note |
Author Badge Number Logical Attribute Properties |
Logical Attribute Name | Author Badge Number |
Datatype | VARCHAR(10) |
Nullable | NO |
Author Badge Number Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Author Badge Number Security Types |
Name | Current Value |
Author Badge Number Bound Attachments |
Name | Current Value |
Author Badge Number Data Movement Rules |
Name | Type | Rule Text/Value |
Author Badge Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Procedure Author Badge Number |
NO | ||
PROC (Oracle) PROCEDURE AUTHOR_BN |
NO |
Author Badge Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Author Badge Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Author Badge Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Author Badge Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sponsor Badge Number |
Base Entity | Procedure |
Attribute Name | Sponsor Badge Number |
Logical Rolename | |
ColumnName | SPONSOR_BN |
RoleName | |
Domain | Badge Number |
Logical Only | NO |
Definition | |
Note |
Sponsor Badge Number Logical Attribute Properties |
Logical Attribute Name | Sponsor Badge Number |
Datatype | VARCHAR(10) |
Nullable | YES |
Sponsor Badge Number Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Sponsor Badge Number Security Types |
Name | Current Value |
Sponsor Badge Number Bound Attachments |
Name | Current Value |
Sponsor Badge Number Data Movement Rules |
Name | Type | Rule Text/Value |
Sponsor Badge Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Procedure Sponsor Badge Number |
NO | ||
PROC (Oracle) PROCEDURE SPONSOR_BN |
NO |
Sponsor Badge Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sponsor Badge Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sponsor Badge Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sponsor Badge Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Comment |
Base Entity | Procedure |
Attribute Name | Comment |
Logical Rolename | |
ColumnName | CMNT |
RoleName | |
Domain | Comment |
Logical Only | NO |
Definition | Comment: General comments. |
Note |
Comment Logical Attribute Properties |
Logical Attribute Name | Comment |
Datatype | VARCHAR(2000) |
Nullable | YES |
Comment Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Comment Security Types |
Name | Current Value |
Comment Bound Attachments |
Name | Current Value |
Comment Data Movement Rules |
Name | Type | Rule Text/Value |
Comment Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Procedure Comment |
NO | ||
PROC (Oracle) PROCEDURE CMNT |
NO |
Comment Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Comment Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Comment Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Comment Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |