DVC_IEEE_NM |
Base Object | BARCD_ASGN_AUDIT |
Attribute Name | Dvc IEEE Nm |
ColumnName | DVC_IEEE_NM |
Logical Rolename | |
RoleName | |
Domain | Asset Identifier |
Physical Only | NO |
Definition | Device IEEE Name |
Note |
DVC_IEEE_NM Column Properties |
Datatype | VARCHAR2(30) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
DVC_IEEE_NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 11 |
Percent Null | 0 |
DVC_IEEE_NM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DVC_IEEE_NM Security Types |
Name | Current Value |
DVC_IEEE_NM Bound Attachments |
Name | Current Value |
DVC_IEEE_NM Data Movement Rules |
Name | Type | Rule Text/Value |
DVC_IEEE_NM Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Barcd Asgn Audit Dvc IEEE Nm |
NO | ||
EQUIP (Oracle) BARCD_ASGN_AUDIT DVC_IEEE_NM |
NO |
DVC_IEEE_NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DVC_IEEE_NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DVC_IEEE_NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DVC_IEEE_NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ASSGN_DTE |
Base Object | BARCD_ASGN_AUDIT |
Attribute Name | Assgn Dte |
ColumnName | ASSGN_DTE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Assignment Date: The day the barcodes were reserved. |
Note |
ASSGN_DTE Column Properties |
Datatype | DATE |
Nullable | NO |
ASSGN_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
ASSGN_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ASSGN_DTE Security Types |
Name | Current Value |
ASSGN_DTE Bound Attachments |
Name | Current Value |
ASSGN_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
ASSGN_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Barcd Asgn Audit Assgn Dte |
NO | ||
EQUIP (Oracle) BARCD_ASGN_AUDIT ASSGN_DTE |
NO |
ASSGN_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ASSGN_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ASSGN_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ASSGN_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RESRVD_UID |
Base Object | BARCD_ASGN_AUDIT |
Attribute Name | Resrvd Uid |
ColumnName | RESRVD_UID |
Logical Rolename | |
RoleName | |
Domain | Userid |
Physical Only | NO |
Definition | Reserved User Id. The person who reserved the block of barcodes. |
Note |
RESRVD_UID Column Properties |
Datatype | VARCHAR2(64) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
RESRVD_UID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 64 |
Percent Null | 0 |
RESRVD_UID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RESRVD_UID Security Types |
Name | Current Value |
RESRVD_UID Bound Attachments |
Name | Current Value |
RESRVD_UID Data Movement Rules |
Name | Type | Rule Text/Value |
RESRVD_UID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Barcd Asgn Audit Resrvd Uid |
NO | ||
EQUIP (Oracle) BARCD_ASGN_AUDIT RESRVD_UID |
NO |
RESRVD_UID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RESRVD_UID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RESRVD_UID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RESRVD_UID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RESRVD_MAX_VAL |
Base Object | BARCD_ASGN_AUDIT |
Attribute Name | Resrvd Max Val |
ColumnName | RESRVD_MAX_VAL |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Reserved Maximum Value: The highest barcode number reserved. |
Note |
RESRVD_MAX_VAL Column Properties |
Datatype | NUMBER(6, 0) |
Nullable | YES |
RESRVD_MAX_VAL Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4 |
Percent Null | 0 |
RESRVD_MAX_VAL Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RESRVD_MAX_VAL Security Types |
Name | Current Value |
RESRVD_MAX_VAL Bound Attachments |
Name | Current Value |
RESRVD_MAX_VAL Data Movement Rules |
Name | Type | Rule Text/Value |
RESRVD_MAX_VAL Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Barcd Asgn Audit Resrvd Max Val |
NO | ||
EQUIP (Oracle) BARCD_ASGN_AUDIT RESRVD_MAX_VAL |
NO |
RESRVD_MAX_VAL Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RESRVD_MAX_VAL Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RESRVD_MAX_VAL Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RESRVD_MAX_VAL Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |