SNS Cable ID |
Base Entity | Cable Supplement |
Attribute Name | SNS Cable ID |
Logical Rolename | |
ColumnName | SNS Cable ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | SNS Cable Identifier |
Note |
SNS Cable ID Logical Attribute Properties |
Logical Attribute Name | SNS Cable ID |
Datatype | VARCHAR(50) |
Nullable | NO |
SNS Cable ID Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
SNS Cable ID Security Types |
Name | Current Value |
SNS Cable ID Bound Attachments |
Name | Current Value |
SNS Cable ID Data Movement Rules |
Name | Type | Rule Text/Value |
SNS Cable ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Cable Supplement SNS Cable ID |
NO |
SNS Cable ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SNS Cable ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SNS Cable ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SNS Cable ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Dev From Port |
Base Entity | Cable Supplement |
Attribute Name | Dev From Port |
Logical Rolename | |
ColumnName | Dev From Port |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Device From Port: The name of the connector/ jack/ etc the "from" end connects to. |
Note |
Dev From Port Logical Attribute Properties |
Logical Attribute Name | Dev From Port |
Datatype | VARCHAR(50) |
Nullable | YES |
Dev From Port Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Dev From Port Security Types |
Name | Current Value |
Dev From Port Bound Attachments |
Name | Current Value |
Dev From Port Data Movement Rules |
Name | Type | Rule Text/Value |
Dev From Port Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Cable Supplement Dev From Port |
NO |
Dev From Port Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Dev From Port Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Dev From Port Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Dev From Port Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Dev To Port |
Base Entity | Cable Supplement |
Attribute Name | Dev To Port |
Logical Rolename | |
ColumnName | Dev To Port |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Device To Port: The name of the connector/jack/etc the "to" end connects to. |
Note |
Dev To Port Logical Attribute Properties |
Logical Attribute Name | Dev To Port |
Datatype | VARCHAR(50) |
Nullable | YES |
Dev To Port Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Dev To Port Security Types |
Name | Current Value |
Dev To Port Bound Attachments |
Name | Current Value |
Dev To Port Data Movement Rules |
Name | Type | Rule Text/Value |
Dev To Port Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Cable Supplement Dev To Port |
NO |
Dev To Port Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Dev To Port Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Dev To Port Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Dev To Port Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Svc Req Ord |
Base Entity | Cable Supplement |
Attribute Name | Svc Req Ord |
Logical Rolename | |
ColumnName | Svc Req Ord |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Service Request Order: The identifier of the "service request order" associated with the installation of the cable. |
Note |
Svc Req Ord Logical Attribute Properties |
Logical Attribute Name | Svc Req Ord |
Datatype | VARCHAR(50) |
Nullable | YES |
Svc Req Ord Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Svc Req Ord Security Types |
Name | Current Value |
Svc Req Ord Bound Attachments |
Name | Current Value |
Svc Req Ord Data Movement Rules |
Name | Type | Rule Text/Value |
Svc Req Ord Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Cable Supplement Svc Req Ord |
NO |
Svc Req Ord Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Svc Req Ord Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Svc Req Ord Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Svc Req Ord Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Dte Added |
Base Entity | Cable Supplement |
Attribute Name | Dte Added |
Logical Rolename | |
ColumnName | Dte Added |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Date Added: The date the cable was added to the system. |
Note |
Dte Added Logical Attribute Properties |
Logical Attribute Name | Dte Added |
Datatype | VARCHAR(50) |
Nullable | YES |
Dte Added Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Dte Added Security Types |
Name | Current Value |
Dte Added Bound Attachments |
Name | Current Value |
Dte Added Data Movement Rules |
Name | Type | Rule Text/Value |
Dte Added Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Cable Supplement Dte Added |
NO |
Dte Added Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Dte Added Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Dte Added Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Dte Added Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Post Inst Test Ind |
Base Entity | Cable Supplement |
Attribute Name | Post Inst Test Ind |
Logical Rolename | |
ColumnName | Post Inst Test Ind |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | Post Installation Test Indication: Indicates if the cable was tested after installation. |
Note |
Post Inst Test Ind Logical Attribute Properties |
Logical Attribute Name | Post Inst Test Ind |
Datatype | CHAR(1) |
Nullable | NO |
Post Inst Test Ind Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Post Inst Test Ind Reference Value (Bound to Domain) |
Name | Standard Indicator |
Description | These are the standard values for the Indicator domain. |
Type | By List |
Value | Value Description |
Y | Yes |
N | No |
Post Inst Test Ind Security Types |
Name | Current Value |
Post Inst Test Ind Bound Attachments |
Name | Current Value |
Post Inst Test Ind Data Movement Rules |
Name | Type | Rule Text/Value |
Post Inst Test Ind Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Cable Supplement Post Inst Test Ind |
NO |
Post Inst Test Ind Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Post Inst Test Ind Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Post Inst Test Ind Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Post Inst Test Ind Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Cable Test Ind |
Base Entity | Cable Supplement |
Attribute Name | Cable Test Ind |
Logical Rolename | |
ColumnName | Cable Test Ind |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | Cable Test Indicator: Used to indicate if a test was performed on the cable. |
Note |
Cable Test Ind Logical Attribute Properties |
Logical Attribute Name | Cable Test Ind |
Datatype | CHAR(1) |
Nullable | NO |
Cable Test Ind Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Cable Test Ind Reference Value (Bound to Domain) |
Name | Standard Indicator |
Description | These are the standard values for the Indicator domain. |
Type | By List |
Value | Value Description |
Y | Yes |
N | No |
Cable Test Ind Security Types |
Name | Current Value |
Cable Test Ind Bound Attachments |
Name | Current Value |
Cable Test Ind Data Movement Rules |
Name | Type | Rule Text/Value |
Cable Test Ind Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Cable Supplement Cable Test Ind |
NO |
Cable Test Ind Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Cable Test Ind Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Cable Test Ind Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Cable Test Ind Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Start Mark Lngth |
Base Entity | Cable Supplement |
Attribute Name | Start Mark Lngth |
Logical Rolename | |
ColumnName | Start Mark Lngth |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Start Mark Length: Contains the numeric value printed on the cable at the cable origination point. Cables lengths are premarked by the manufacturer. As cables are cut the starting point may be a will be a number other than 0. |
Note |
Start Mark Lngth Logical Attribute Properties |
Logical Attribute Name | Start Mark Lngth |
Datatype | INTEGER |
Nullable | YES |
Start Mark Lngth Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Start Mark Lngth Security Types |
Name | Current Value |
Start Mark Lngth Bound Attachments |
Name | Current Value |
Start Mark Lngth Data Movement Rules |
Name | Type | Rule Text/Value |
Start Mark Lngth Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Cable Supplement Start Mark Lngth |
NO |
Start Mark Lngth Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Start Mark Lngth Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Start Mark Lngth Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Start Mark Lngth Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
End Mark Length |
Base Entity | Cable Supplement |
Attribute Name | End Mark Length |
Logical Rolename | |
ColumnName | End Mark Length |
RoleName | |
Domain | |
Logical Only | NO |
Definition | End Mark Length: Contains the numeric value printed on the cable at the cable termination point. Cables lengths are premarked by the manufacturer. As cables are cut the starting point may be a will be a number other than 0. |
Note |
End Mark Length Logical Attribute Properties |
Logical Attribute Name | End Mark Length |
Datatype | INTEGER |
Nullable | YES |
End Mark Length Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
End Mark Length Security Types |
Name | Current Value |
End Mark Length Bound Attachments |
Name | Current Value |
End Mark Length Data Movement Rules |
Name | Type | Rule Text/Value |
End Mark Length Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Cable Supplement End Mark Length |
NO |
End Mark Length Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
End Mark Length Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
End Mark Length Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
End Mark Length Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |