DVC_ID |
Base Object | DVC_OUTAGE |
Attribute Name | DVC_ID |
ColumnName | DVC_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
DVC_ID Column Properties |
Datatype | VARCHAR2(40) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DVC_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 18 |
Percent Null | 0 |
DVC_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DVC_ID Security Types |
Name | Current Value |
DVC_ID Bound Attachments |
Name | Current Value |
DVC_ID Data Movement Rules |
Name | Type | Rule Text/Value |
DVC_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Device Outage Device Identifer |
NO | ||
OPER (Oracle) DVC_OUTAGE DVC_ID |
NO |
DVC_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DVC_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DVC_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DVC_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
OUTAGE_DTE |
Base Object | DVC_OUTAGE |
Attribute Name | OUTAGE_DTE |
ColumnName | OUTAGE_DTE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
OUTAGE_DTE Column Properties |
Datatype | DATE |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
OUTAGE_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
OUTAGE_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
OUTAGE_DTE Security Types |
Name | Current Value |
OUTAGE_DTE Bound Attachments |
Name | Current Value |
OUTAGE_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
OUTAGE_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Device Outage Outage Dte |
NO | ||
OPER (Oracle) DVC_OUTAGE OUTAGE_DTE |
NO |
OUTAGE_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
OUTAGE_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
OUTAGE_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
OUTAGE_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PROJ_OUTAGE |
Base Object | DVC_OUTAGE |
Attribute Name | PROJ_OUTAGE |
ColumnName | PROJ_OUTAGE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PROJ_OUTAGE Column Properties |
Datatype | NUMBER(4, 1) |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PROJ_OUTAGE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 3 |
Percent Null | 0 |
PROJ_OUTAGE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PROJ_OUTAGE Security Types |
Name | Current Value |
PROJ_OUTAGE Bound Attachments |
Name | Current Value |
PROJ_OUTAGE Data Movement Rules |
Name | Type | Rule Text/Value |
PROJ_OUTAGE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Device Outage Proj Outage |
NO | ||
OPER (Oracle) DVC_OUTAGE PROJ_OUTAGE |
NO |
PROJ_OUTAGE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PROJ_OUTAGE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PROJ_OUTAGE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PROJ_OUTAGE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ACT_OUTAGE |
Base Object | DVC_OUTAGE |
Attribute Name | ACT_OUTAGE |
ColumnName | ACT_OUTAGE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
ACT_OUTAGE Column Properties |
Datatype | NUMBER(4, 1) |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ACT_OUTAGE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 3 |
Percent Null | 0 |
ACT_OUTAGE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ACT_OUTAGE Security Types |
Name | Current Value |
ACT_OUTAGE Bound Attachments |
Name | Current Value |
ACT_OUTAGE Data Movement Rules |
Name | Type | Rule Text/Value |
ACT_OUTAGE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Device Outage Act Outage |
NO | ||
OPER (Oracle) DVC_OUTAGE ACT_OUTAGE |
NO |
ACT_OUTAGE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ACT_OUTAGE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ACT_OUTAGE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ACT_OUTAGE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CMNT |
Base Object | DVC_OUTAGE |
Attribute Name | CMNT |
ColumnName | CMNT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
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 | 84 |
Percent Null | 5 |
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 Device Outage Comment |
NO | ||
OPER (Oracle) DVC_OUTAGE 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 |
MOD_BY_BN |
Base Object | DVC_OUTAGE |
Attribute Name | MOD_BY_BN |
ColumnName | MOD_BY_BN |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
MOD_BY_BN Column Properties |
Datatype | VARCHAR2(10) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
MOD_BY_BN Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
MOD_BY_BN Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MOD_BY_BN Security Types |
Name | Current Value |
MOD_BY_BN Bound Attachments |
Name | Current Value |
MOD_BY_BN Data Movement Rules |
Name | Type | Rule Text/Value |
MOD_BY_BN Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Device Outage Modified By Badge Number |
NO | ||
OPER (Oracle) DVC_OUTAGE MOD_BY_BN |
NO |
MOD_BY_BN Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_BY_BN Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_BY_BN Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_BY_BN Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_BY_DTE |
Base Object | DVC_OUTAGE |
Attribute Name | MOD_BY_DTE |
ColumnName | MOD_BY_DTE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
MOD_BY_DTE Column Properties |
Datatype | DATE |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
MOD_BY_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
MOD_BY_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
MOD_BY_DTE Security Types |
Name | Current Value |
MOD_BY_DTE Bound Attachments |
Name | Current Value |
MOD_BY_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
MOD_BY_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Device Outage MOD_BY_DTE |
NO | ||
OPER (Oracle) DVC_OUTAGE MOD_BY_DTE |
NO |
MOD_BY_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_BY_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_BY_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_BY_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CAN_IND |
Base Object | DVC_OUTAGE |
Attribute Name | CAN_IND |
ColumnName | CAN_IND |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Cancelled Indicator: Indicates that the scheduled device outage was canceled. |
Note |
CAN_IND Column Properties |
Datatype | CHAR(1) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CAN_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
CAN_IND Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
CAN_IND Security Types |
Name | Current Value |
CAN_IND Bound Attachments |
Name | Current Value |
CAN_IND Data Movement Rules |
Name | Type | Rule Text/Value |
CAN_IND Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Device Outage Canceled Indicator |
NO | ||
OPER (Oracle) DVC_OUTAGE CAN_IND |
NO |
CAN_IND Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CAN_IND Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CAN_IND Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CAN_IND Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |