PROC_ID |
Base Object | PROC_PARA |
Attribute Name | Procedure Identifier |
ColumnName | PROC_ID |
Logical Rolename | Procedure Identifier |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
PROC_ID Column Properties |
Datatype | VARCHAR2(75) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PROC_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 75 |
Percent Null | 0 |
PROC_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PROC_ID Security Types |
Name | Current Value |
PROC_ID Bound Attachments |
Name | Current Value |
PROC_ID Data Movement Rules |
Name | Type | Rule Text/Value |
PROC_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Procedure Paragraph Procedure Identifier |
NO | ||
PROC (Oracle) PROC_PARA PROC_ID |
NO |
PROC_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PROC_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PROC_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PROC_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
REV_ID |
Base Object | PROC_PARA |
Attribute Name | Revision Identifier |
ColumnName | REV_ID |
Logical Rolename | Revision Identifier |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
REV_ID Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
REV_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
REV_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
REV_ID Security Types |
Name | Current Value |
REV_ID Bound Attachments |
Name | Current Value |
REV_ID Data Movement Rules |
Name | Type | Rule Text/Value |
REV_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Procedure Paragraph Revision Identifier |
NO | ||
PROC (Oracle) PROC_PARA REV_ID |
NO |
REV_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
REV_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
REV_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
REV_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SECTION_ID |
Base Object | PROC_PARA |
Attribute Name | Section Identifier |
ColumnName | SECTION_ID |
Logical Rolename | Section Identifier |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
SECTION_ID Column Properties |
Datatype | VARCHAR2(10) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SECTION_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
SECTION_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SECTION_ID Security Types |
Name | Current Value |
SECTION_ID Bound Attachments |
Name | Current Value |
SECTION_ID Data Movement Rules |
Name | Type | Rule Text/Value |
SECTION_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Procedure Paragraph Section Identifier |
NO | ||
PROC (Oracle) PROC_PARA SECTION_ID |
NO |
SECTION_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SECTION_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SECTION_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SECTION_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PARA_ID |
Base Object | PROC_PARA |
Attribute Name | Paragraph Identifier |
ColumnName | PARA_ID |
Logical Rolename | |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
PARA_ID Column Properties |
Datatype | NUMBER(3, 2) |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PARA_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2 |
Percent Null | 0 |
PARA_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PARA_ID Security Types |
Name | Current Value |
PARA_ID Bound Attachments |
Name | Current Value |
PARA_ID Data Movement Rules |
Name | Type | Rule Text/Value |
PARA_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Procedure Paragraph Paragraph Identifier |
NO | ||
PROC (Oracle) PROC_PARA PARA_ID |
NO |
PARA_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PARA_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PARA_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PARA_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TITLE |
Base Object | PROC_PARA |
Attribute Name | Title |
ColumnName | TITLE |
Logical Rolename | |
RoleName | |
Domain | Title |
Physical Only | NO |
Definition | |
Note |
TITLE Column Properties |
Datatype | VARCHAR2(255) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
TITLE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 255 |
Percent Null | 0 |
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 Paragraph Title |
NO | ||
PROC (Oracle) PROC_PARA 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 |
TEXT |
Base Object | PROC_PARA |
Attribute Name | Text |
ColumnName | TEXT |
Logical Rolename | |
RoleName | |
Domain | Text |
Physical Only | NO |
Definition | |
Note |
TEXT Column Properties |
Datatype | VARCHAR2(4000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
TEXT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4000 |
Percent Null | 0 |
TEXT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TEXT Security Types |
Name | Current Value |
TEXT Bound Attachments |
Name | Current Value |
TEXT Data Movement Rules |
Name | Type | Rule Text/Value |
TEXT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Procedure Paragraph Text |
NO | ||
PROC (Oracle) PROC_PARA TEXT |
NO |
TEXT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TEXT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TEXT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TEXT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CMNT |
Base Object | PROC_PARA |
Attribute Name | Comment |
ColumnName | CMNT |
Logical Rolename | |
RoleName | |
Domain | Comment |
Physical Only | NO |
Definition | Comment: General comments. |
Note |
CMNT Column Properties |
Datatype | VARCHAR2(2000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CMNT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2000 |
Percent Null | 0 |
CMNT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CMNT Security Types |
Name | Current Value |
CMNT Bound Attachments |
Name | Current Value |
CMNT Data Movement Rules |
Name | Type | Rule Text/Value |
CMNT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Procedure Paragraph Comment |
NO | ||
PROC (Oracle) PROC_PARA CMNT |
NO |
CMNT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CMNT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CMNT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CMNT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |