USERID |
Base Object | JERI_USR_PROP |
Attribute Name | USERID |
ColumnName | USERID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
USERID Column Properties |
Datatype | VARCHAR2(64) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
USERID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 5 |
Percent Null | 0 |
USERID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
USERID Security Types |
Name | Current Value |
USERID Bound Attachments |
Name | Current Value |
USERID Data Movement Rules |
Name | Type | Rule Text/Value |
USERID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
EPICS (Oracle) JERI_USR_PROP USERID |
NO |
USERID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
USERID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
USERID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
USERID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PROP_CD |
Base Object | JERI_USR_PROP |
Attribute Name | PROP_CD |
ColumnName | PROP_CD |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Property Code: Inidicates what type of information is stored in this record. (i.e. Filter, Java Property) |
Note |
PROP_CD Column Properties |
Datatype | CHAR(2) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PROP_CD Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2 |
Percent Null | 0 |
PROP_CD Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PROP_CD Security Types |
Name | Current Value |
PROP_CD Bound Attachments |
Name | Current Value |
PROP_CD Data Movement Rules |
Name | Type | Rule Text/Value |
PROP_CD Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
EPICS (Oracle) JERI_USR_PROP PROP_CD |
NO |
PROP_CD Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PROP_CD Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PROP_CD Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PROP_CD Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
FLTR_NM |
Base Object | JERI_USR_PROP |
Attribute Name | FLTR_NM |
ColumnName | FLTR_NM |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Filter Name: The named assgined by the user to a saved data filter. |
Note |
FLTR_NM Column Properties |
Datatype | VARCHAR2(100) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
FLTR_NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 41 |
FLTR_NM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
FLTR_NM Security Types |
Name | Current Value |
FLTR_NM Bound Attachments |
Name | Current Value |
FLTR_NM Data Movement Rules |
Name | Type | Rule Text/Value |
FLTR_NM Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
EPICS (Oracle) JERI_USR_PROP FLTR_NM |
NO |
FLTR_NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
FLTR_NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
FLTR_NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
FLTR_NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
FLTR_CONT |
Base Object | JERI_USR_PROP |
Attribute Name | FLTR_CONT |
ColumnName | FLTR_CONT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Filter Contents: The data filter saved by the Jeri user under the name in the Fltr Nm attribute. |
Note |
FLTR_CONT Column Properties |
Datatype | CHAR(2000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
FLTR_CONT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2000 |
Percent Null | 42 |
FLTR_CONT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
FLTR_CONT Security Types |
Name | Current Value |
FLTR_CONT Bound Attachments |
Name | Current Value |
FLTR_CONT Data Movement Rules |
Name | Type | Rule Text/Value |
FLTR_CONT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
EPICS (Oracle) JERI_USR_PROP FLTR_CONT |
NO |
FLTR_CONT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
FLTR_CONT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
FLTR_CONT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
FLTR_CONT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
JAVA_PROP |
Base Object | JERI_USR_PROP |
Attribute Name | JAVA_PROP |
ColumnName | JAVA_PROP |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Java Properties: The contents of the Java Properties class of the Jeri user's session upon last exit. |
Note |
JAVA_PROP Column Properties |
Datatype | CLOB |
Nullable | YES |
Not Null Constraint |
JAVA_PROP Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 36 |
Percent Null | 59 |
JAVA_PROP Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
JAVA_PROP Security Types |
Name | Current Value |
JAVA_PROP Bound Attachments |
Name | Current Value |
JAVA_PROP Data Movement Rules |
Name | Type | Rule Text/Value |
JAVA_PROP Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
EPICS (Oracle) JERI_USR_PROP JAVA_PROP |
NO |
JAVA_PROP Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
JAVA_PROP Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
JAVA_PROP Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
JAVA_PROP Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
FLTR_TBL |
Base Object | JERI_USR_PROP |
Attribute Name | FLTR_TBL |
ColumnName | FLTR_TBL |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
FLTR_TBL Column Properties |
Datatype | VARCHAR2(32) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
FLTR_TBL Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 6 |
Percent Null | 40 |
FLTR_TBL Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
FLTR_TBL Security Types |
Name | Current Value |
FLTR_TBL Bound Attachments |
Name | Current Value |
FLTR_TBL Data Movement Rules |
Name | Type | Rule Text/Value |
FLTR_TBL Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
EPICS (Oracle) JERI_USR_PROP FLTR_TBL |
NO |
FLTR_TBL Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
FLTR_TBL Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
FLTR_TBL Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
FLTR_TBL Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |