CREATE_DTE |
Base Object | TGT_BEAM_PARM |
Attribute Name | Create Date |
ColumnName | CREATE_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
CREATE_DTE Column Properties |
Datatype | DATE |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CREATE_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
CREATE_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
CREATE_DTE Security Types |
Name | Current Value |
CREATE_DTE Bound Attachments |
Name | Current Value |
CREATE_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
CREATE_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Target Beam Parameters Create Date |
NO | ||
OPER (Oracle) TGT_BEAM_PARM CREATE_DTE |
NO |
CREATE_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CREATE_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CREATE_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CREATE_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BN |
Base Object | TGT_BEAM_PARM |
Attribute Name | Badge Number |
ColumnName | BN |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
BN Column Properties |
Datatype | VARCHAR2(10) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
BN Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
BN Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BN Security Types |
Name | Current Value |
BN Bound Attachments |
Name | Current Value |
BN Data Movement Rules |
Name | Type | Rule Text/Value |
BN Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Target Beam Parameters Badge Number |
NO | ||
OPER (Oracle) TGT_BEAM_PARM BN |
NO |
BN Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BN Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BN Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BN Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Beam_Energy |
Base Object | TGT_BEAM_PARM |
Attribute Name | Beam Energy on Target |
ColumnName | Beam_Energy |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Energy: Beam energy on target in MeV. |
Note |
Beam_Energy Column Properties |
Datatype | BINARY_DOUBLE |
Nullable | YES |
Not Null Constraint |
Beam_Energy Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 9 |
Percent Null | 0 |
Beam_Energy Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Beam_Energy Security Types |
Name | Current Value |
Beam_Energy Bound Attachments |
Name | Current Value |
Beam_Energy Data Movement Rules |
Name | Type | Rule Text/Value |
Beam_Energy Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Target Beam Parameters Beam Energy on Target |
NO | ||
OPER (Oracle) TGT_BEAM_PARM Beam_Energy |
NO |
Beam_Energy Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Beam_Energy Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Beam_Energy Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Beam_Energy Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PROTON_PULSE |
Base Object | TGT_BEAM_PARM |
Attribute Name | Proton Per Pulse |
ColumnName | PROTON_PULSE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Proton Per Pulse: Number of protons per pulse. |
Note |
PROTON_PULSE Column Properties |
Datatype | BINARY_DOUBLE |
Nullable | YES |
Not Null Constraint |
PROTON_PULSE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 9 |
Percent Null | 0 |
PROTON_PULSE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PROTON_PULSE Security Types |
Name | Current Value |
PROTON_PULSE Bound Attachments |
Name | Current Value |
PROTON_PULSE Data Movement Rules |
Name | Type | Rule Text/Value |
PROTON_PULSE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Target Beam Parameters Proton Per Pulse |
NO | ||
OPER (Oracle) TGT_BEAM_PARM PROTON_PULSE |
NO |
PROTON_PULSE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PROTON_PULSE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PROTON_PULSE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PROTON_PULSE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
REP_RATE |
Base Object | TGT_BEAM_PARM |
Attribute Name | Rep Rate |
ColumnName | REP_RATE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
REP_RATE Column Properties |
Datatype | BINARY_DOUBLE |
Nullable | YES |
Not Null Constraint |
REP_RATE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 9 |
Percent Null | 0 |
REP_RATE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
REP_RATE Security Types |
Name | Current Value |
REP_RATE Bound Attachments |
Name | Current Value |
REP_RATE Data Movement Rules |
Name | Type | Rule Text/Value |
REP_RATE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Target Beam Parameters Rep Rate |
NO | ||
OPER (Oracle) TGT_BEAM_PARM REP_RATE |
NO |
REP_RATE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
REP_RATE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
REP_RATE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
REP_RATE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PEAK_P_DEN_TGT |
Base Object | TGT_BEAM_PARM |
Attribute Name | Peak Proton Density Target |
ColumnName | PEAK_P_DEN_TGT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Peak Proton Desnisty on Target: protons/mm^2/ pulse |
Note |
PEAK_P_DEN_TGT Column Properties |
Datatype | BINARY_DOUBLE |
Nullable | YES |
Not Null Constraint |
PEAK_P_DEN_TGT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 9 |
Percent Null | 0 |
PEAK_P_DEN_TGT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PEAK_P_DEN_TGT Security Types |
Name | Current Value |
PEAK_P_DEN_TGT Bound Attachments |
Name | Current Value |
PEAK_P_DEN_TGT Data Movement Rules |
Name | Type | Rule Text/Value |
PEAK_P_DEN_TGT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Target Beam Parameters Peak Proton Density Target |
NO | ||
OPER (Oracle) TGT_BEAM_PARM PEAK_P_DEN_TGT |
NO |
PEAK_P_DEN_TGT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PEAK_P_DEN_TGT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PEAK_P_DEN_TGT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PEAK_P_DEN_TGT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PEAK_P_DEN_BEAM_WIN |
Base Object | TGT_BEAM_PARM |
Attribute Name | Peak Proton Density Proton Beam Window |
ColumnName | PEAK_P_DEN_BEAM_WIN |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Peak proton density on Proton Beam Window: protons/ mm^2 / pulse. |
Note |
PEAK_P_DEN_BEAM_WIN Column Properties |
Datatype | BINARY_DOUBLE |
Nullable | YES |
Not Null Constraint |
PEAK_P_DEN_BEAM_WIN Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 9 |
Percent Null | 0 |
PEAK_P_DEN_BEAM_WIN Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PEAK_P_DEN_BEAM_WIN Security Types |
Name | Current Value |
PEAK_P_DEN_BEAM_WIN Bound Attachments |
Name | Current Value |
PEAK_P_DEN_BEAM_WIN Data Movement Rules |
Name | Type | Rule Text/Value |
PEAK_P_DEN_BEAM_WIN Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Target Beam Parameters Peak Proton Density Proton Beam Window |
NO | ||
OPER (Oracle) TGT_BEAM_PARM PEAK_P_DEN_BEAM_WIN |
NO |
PEAK_P_DEN_BEAM_WIN Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PEAK_P_DEN_BEAM_WIN Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PEAK_P_DEN_BEAM_WIN Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PEAK_P_DEN_BEAM_WIN Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PEAK_FACTOR_TGT |
Base Object | TGT_BEAM_PARM |
Attribute Name | Peaking Factor Target |
ColumnName | PEAK_FACTOR_TGT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Peaking Factor Target: Normalized Peaking Factor on Target. |
Note |
PEAK_FACTOR_TGT Column Properties |
Datatype | BINARY_DOUBLE |
Nullable | YES |
Not Null Constraint |
PEAK_FACTOR_TGT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 9 |
Percent Null | 0 |
PEAK_FACTOR_TGT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PEAK_FACTOR_TGT Security Types |
Name | Current Value |
PEAK_FACTOR_TGT Bound Attachments |
Name | Current Value |
PEAK_FACTOR_TGT Data Movement Rules |
Name | Type | Rule Text/Value |
PEAK_FACTOR_TGT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Target Beam Parameters Peaking Factor Target |
NO | ||
OPER (Oracle) TGT_BEAM_PARM PEAK_FACTOR_TGT |
NO |
PEAK_FACTOR_TGT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PEAK_FACTOR_TGT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PEAK_FACTOR_TGT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PEAK_FACTOR_TGT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RMS_WD_TGT |
Base Object | TGT_BEAM_PARM |
Attribute Name | RMS Width Target |
ColumnName | RMS_WD_TGT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | RMS Width Target: RMS width on target in millimeters. |
Note |
RMS_WD_TGT Column Properties |
Datatype | BINARY_DOUBLE |
Nullable | YES |
Not Null Constraint |
RMS_WD_TGT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 9 |
Percent Null | 8 |
RMS_WD_TGT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RMS_WD_TGT Security Types |
Name | Current Value |
RMS_WD_TGT Bound Attachments |
Name | Current Value |
RMS_WD_TGT Data Movement Rules |
Name | Type | Rule Text/Value |
RMS_WD_TGT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Target Beam Parameters RMS Width Target |
NO | ||
OPER (Oracle) TGT_BEAM_PARM RMS_WD_TGT |
NO |
RMS_WD_TGT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RMS_WD_TGT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RMS_WD_TGT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RMS_WD_TGT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RMS_HGT_TGT |
Base Object | TGT_BEAM_PARM |
Attribute Name | RMS Height Target |
ColumnName | RMS_HGT_TGT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | RMS Height Target: RMS height on target in millimeters. |
Note |
RMS_HGT_TGT Column Properties |
Datatype | BINARY_DOUBLE |
Nullable | YES |
Not Null Constraint |
RMS_HGT_TGT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 9 |
Percent Null | 8 |
RMS_HGT_TGT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RMS_HGT_TGT Security Types |
Name | Current Value |
RMS_HGT_TGT Bound Attachments |
Name | Current Value |
RMS_HGT_TGT Data Movement Rules |
Name | Type | Rule Text/Value |
RMS_HGT_TGT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Target Beam Parameters RMS Height Target |
NO | ||
OPER (Oracle) TGT_BEAM_PARM RMS_HGT_TGT |
NO |
RMS_HGT_TGT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RMS_HGT_TGT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RMS_HGT_TGT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RMS_HGT_TGT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RMS_WD_HARP |
Base Object | TGT_BEAM_PARM |
Attribute Name | RMS Width Harp |
ColumnName | RMS_WD_HARP |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | RMS Width Harp: Horizontal RMS width on Harp in mm. |
Note |
RMS_WD_HARP Column Properties |
Datatype | BINARY_DOUBLE |
Nullable | YES |
Not Null Constraint |
RMS_WD_HARP Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 9 |
Percent Null | 5 |
RMS_WD_HARP Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RMS_WD_HARP Security Types |
Name | Current Value |
RMS_WD_HARP Bound Attachments |
Name | Current Value |
RMS_WD_HARP Data Movement Rules |
Name | Type | Rule Text/Value |
RMS_WD_HARP Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Target Beam Parameters RMS Width Harp |
NO | ||
OPER (Oracle) TGT_BEAM_PARM RMS_WD_HARP |
NO |
RMS_WD_HARP Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RMS_WD_HARP Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RMS_WD_HARP Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RMS_WD_HARP Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RMS_HGT_HARP |
Base Object | TGT_BEAM_PARM |
Attribute Name | RMS Height Harp |
ColumnName | RMS_HGT_HARP |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | RMS Height Harp: Vertical RMS width on Harp in mm. |
Note |
RMS_HGT_HARP Column Properties |
Datatype | BINARY_DOUBLE |
Nullable | YES |
Not Null Constraint |
RMS_HGT_HARP Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 9 |
Percent Null | 5 |
RMS_HGT_HARP Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RMS_HGT_HARP Security Types |
Name | Current Value |
RMS_HGT_HARP Bound Attachments |
Name | Current Value |
RMS_HGT_HARP Data Movement Rules |
Name | Type | Rule Text/Value |
RMS_HGT_HARP Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Target Beam Parameters RMS Height Harp |
NO | ||
OPER (Oracle) TGT_BEAM_PARM RMS_HGT_HARP |
NO |
RMS_HGT_HARP Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RMS_HGT_HARP Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RMS_HGT_HARP Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RMS_HGT_HARP Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
HOR_CENT_TGT |
Base Object | TGT_BEAM_PARM |
Attribute Name | Horizontal Center Target |
ColumnName | HOR_CENT_TGT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Horizontal Center Target: Horizontal Center on target in millimeters. |
Note |
HOR_CENT_TGT Column Properties |
Datatype | BINARY_DOUBLE |
Nullable | YES |
Not Null Constraint |
HOR_CENT_TGT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 9 |
Percent Null | 11 |
HOR_CENT_TGT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
HOR_CENT_TGT Security Types |
Name | Current Value |
HOR_CENT_TGT Bound Attachments |
Name | Current Value |
HOR_CENT_TGT Data Movement Rules |
Name | Type | Rule Text/Value |
HOR_CENT_TGT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Target Beam Parameters Horizontal Center Target |
NO | ||
OPER (Oracle) TGT_BEAM_PARM HOR_CENT_TGT |
NO |
HOR_CENT_TGT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
HOR_CENT_TGT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
HOR_CENT_TGT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
HOR_CENT_TGT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
VERT_CENT_TGT |
Base Object | TGT_BEAM_PARM |
Attribute Name | Vertical Center Target |
ColumnName | VERT_CENT_TGT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Vertical Center Target: Vertical Center on target in millimeters. |
Note |
VERT_CENT_TGT Column Properties |
Datatype | BINARY_DOUBLE |
Nullable | YES |
Not Null Constraint |
VERT_CENT_TGT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 9 |
Percent Null | 11 |
VERT_CENT_TGT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
VERT_CENT_TGT Security Types |
Name | Current Value |
VERT_CENT_TGT Bound Attachments |
Name | Current Value |
VERT_CENT_TGT Data Movement Rules |
Name | Type | Rule Text/Value |
VERT_CENT_TGT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Target Beam Parameters Vertical Center Target |
NO | ||
OPER (Oracle) TGT_BEAM_PARM VERT_CENT_TGT |
NO |
VERT_CENT_TGT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
VERT_CENT_TGT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
VERT_CENT_TGT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
VERT_CENT_TGT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CMNT |
Base Object | TGT_BEAM_PARM |
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 | 35 |
Percent Null | 30 |
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 Target Beam Parameters Comment |
NO | ||
OPER (Oracle) TGT_BEAM_PARM 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 |