Experiment Resource Identifier |
Base Entity | Experiment Resource Schedule |
Attribute Name | Experiment Resource Identifier |
Logical Rolename | |
ColumnName | EXPT_RSRC_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Experiment Resource Identifier Logical Attribute Properties |
Logical Attribute Name | Experiment Resource Identifier |
Datatype | VARCHAR(50) |
Nullable | NO |
Experiment Resource Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Experiment Resource Identifier Security Types |
Name | Current Value |
Experiment Resource Identifier Bound Attachments |
Name | Current Value |
Experiment Resource Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Experiment Resource Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Experiment Resource Schedule Experiment Resource Identifier |
NO | ||
EXPRESS (Oracle) EXPT_RSRC_SCHED EXPT_RSRC_ID |
NO | ||
IPTSv5 (Oracle) EXPT_RSRC_SCHED EXPT_RSRC_ID |
NO | ||
PRPSL (Oracle) EXPT_RSRC_SCHED EXPT_RSRC_ID |
NO |
Experiment Resource Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Experiment Resource Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Experiment Resource Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Experiment Resource Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifier |
Base Entity | Experiment Resource Schedule |
Attribute Name | Status Identifier |
Logical Rolename | |
ColumnName | STAT_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Status Identifier Logical Attribute Properties |
Logical Attribute Name | Status Identifier |
Datatype | VARCHAR(20) |
Nullable | NO |
Status Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Status Identifier Security Types |
Name | Current Value |
Status Identifier Bound Attachments |
Name | Current Value |
Status Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Status Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Experiment Resource Schedule Status Identifier |
NO | ||
EXPRESS (Oracle) EXPT_RSRC_SCHED STAT_ID |
NO | ||
IPTSv5 (Oracle) EXPT_RSRC_SCHED STAT_ID |
NO | ||
PRPSL (Oracle) EXPT_RSRC_SCHED STAT_ID |
NO |
Status Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Scheduled Start Date |
Base Entity | Experiment Resource Schedule |
Attribute Name | Scheduled Start Date |
Logical Rolename | |
ColumnName | SCHED_START_DTE |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | Scheduled Start Date: The scheduled start date for the resource. |
Note |
Scheduled Start Date Logical Attribute Properties |
Logical Attribute Name | Scheduled Start Date |
Datatype | DATE |
Nullable | NO |
Scheduled Start Date Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
Scheduled Start Date Security Types |
Name | Current Value |
Scheduled Start Date Bound Attachments |
Name | Current Value |
Scheduled Start Date Data Movement Rules |
Name | Type | Rule Text/Value |
Scheduled Start Date Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Experiment Resource Schedule Scheduled Start Date |
NO | ||
EXPRESS (Oracle) EXPT_RSRC_SCHED SCHED_START_DTE |
NO | ||
IPTSv5 (Oracle) EXPT_RSRC_SCHED SCHED_START_DTE |
NO | ||
PRPSL (Oracle) EXPT_RSRC_SCHED SCHED_START_DTE |
NO |
Scheduled Start Date Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Scheduled Start Date Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Scheduled Start Date Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Scheduled Start Date Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Scheduled End Date |
Base Entity | Experiment Resource Schedule |
Attribute Name | Scheduled End Date |
Logical Rolename | |
ColumnName | SCHED_END_DTE |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | Scheduled End Date: The scheduled ending date for the resource. |
Note |
Scheduled End Date Logical Attribute Properties |
Logical Attribute Name | Scheduled End Date |
Datatype | DATE |
Nullable | NO |
Scheduled End Date Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
Scheduled End Date Security Types |
Name | Current Value |
Scheduled End Date Bound Attachments |
Name | Current Value |
Scheduled End Date Data Movement Rules |
Name | Type | Rule Text/Value |
Scheduled End Date Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Experiment Resource Schedule Scheduled End Date |
NO | ||
EXPRESS (Oracle) EXPT_RSRC_SCHED SCHED_END_DTE |
NO | ||
IPTSv5 (Oracle) EXPT_RSRC_SCHED SCHED_END_DTE |
NO | ||
PRPSL (Oracle) EXPT_RSRC_SCHED SCHED_END_DTE |
NO |
Scheduled End Date Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Scheduled End Date Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Scheduled End Date Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Scheduled End Date Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Requested Start Date |
Base Entity | Experiment Resource Schedule |
Attribute Name | Requested Start Date |
Logical Rolename | |
ColumnName | REQ_START_DTE |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | Requested Start Date: The requested date/time for the allocation to start, including setup time. |
Note |
Requested Start Date Logical Attribute Properties |
Logical Attribute Name | Requested Start Date |
Datatype | DATE |
Nullable | NO |
Requested Start Date Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
Requested Start Date Security Types |
Name | Current Value |
Requested Start Date Bound Attachments |
Name | Current Value |
Requested Start Date Data Movement Rules |
Name | Type | Rule Text/Value |
Requested Start Date Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Experiment Resource Schedule Requested Start Date |
NO | ||
EXPRESS (Oracle) EXPT_RSRC_SCHED REQ_START_DTE |
NO | ||
IPTSv5 (Oracle) EXPT_RSRC_SCHED REQ_START_DTE |
NO | ||
PRPSL (Oracle) EXPT_RSRC_SCHED REQ_START_DTE |
NO |
Requested Start Date Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Requested Start Date Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Requested Start Date Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Requested Start Date Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Requested End Date |
Base Entity | Experiment Resource Schedule |
Attribute Name | Requested End Date |
Logical Rolename | |
ColumnName | REQ_END_DTE |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | Requested End Date: The requested date/time for the allocation to end, including time to restore base configuration. |
Note |
Requested End Date Logical Attribute Properties |
Logical Attribute Name | Requested End Date |
Datatype | DATE |
Nullable | NO |
Requested End Date Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
Requested End Date Security Types |
Name | Current Value |
Requested End Date Bound Attachments |
Name | Current Value |
Requested End Date Data Movement Rules |
Name | Type | Rule Text/Value |
Requested End Date Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Experiment Resource Schedule Requested End Date |
NO | ||
EXPRESS (Oracle) EXPT_RSRC_SCHED REQ_END_DTE |
NO | ||
IPTSv5 (Oracle) EXPT_RSRC_SCHED REQ_END_DTE |
NO | ||
PRPSL (Oracle) EXPT_RSRC_SCHED REQ_END_DTE |
NO |
Requested End Date Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Requested End Date Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Requested End Date Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Requested End Date Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Request Type Identifier |
Base Entity | Experiment Resource Schedule |
Attribute Name | Request Type Identifier |
Logical Rolename | |
ColumnName | REQ_TYPE_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Request Type Identifier: |
Note |
Request Type Identifier Logical Attribute Properties |
Logical Attribute Name | Request Type Identifier |
Datatype | VARCHAR(10) |
Nullable | NO |
Request Type Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Request Type Identifier Security Types |
Name | Current Value |
Request Type Identifier Bound Attachments |
Name | Current Value |
Request Type Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Request Type Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Experiment Resource Schedule Request Type Identifier |
NO | ||
EXPRESS (Oracle) EXPT_RSRC_SCHED REQ_TYPE_ID |
NO | ||
IPTSv5 (Oracle) EXPT_RSRC_SCHED REQ_TYPE_ID |
NO | ||
PRPSL (Oracle) EXPT_RSRC_SCHED REQ_TYPE_ID |
NO |
Request Type Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Request Type Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Request Type Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Request Type Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Description |
Base Entity | Experiment Resource Schedule |
Attribute Name | Description |
Logical Rolename | |
ColumnName | DESCR |
RoleName | |
Domain | Description |
Logical Only | NO |
Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
Note |
Description Logical Attribute Properties |
Logical Attribute Name | Description |
Datatype | VARCHAR(255) |
Nullable | YES |
Description Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Description Security Types |
Name | Current Value |
Description Bound Attachments |
Name | Current Value |
Description Data Movement Rules |
Name | Type | Rule Text/Value |
Description Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Experiment Resource Schedule Description |
NO | ||
EXPRESS (Oracle) EXPT_RSRC_SCHED DESCR |
NO | ||
IPTSv5 (Oracle) EXPT_RSRC_SCHED DESCR |
NO | ||
PRPSL (Oracle) EXPT_RSRC_SCHED DESCR |
NO |
Description Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Description Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Description Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Description Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Commitment Request Identifier |
Base Entity | Experiment Resource Schedule |
Attribute Name | Commitment Request Identifier |
Logical Rolename | |
ColumnName | COMM_REQ_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Commitment Request Identifier Logical Attribute Properties |
Logical Attribute Name | Commitment Request Identifier |
Datatype | VARCHAR(10) |
Nullable | NO |
Commitment Request Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Commitment Request Identifier Security Types |
Name | Current Value |
Commitment Request Identifier Bound Attachments |
Name | Current Value |
Commitment Request Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Commitment Request Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Experiment Resource Schedule Commitment Request Identifier |
NO | ||
EXPRESS (Oracle) EXPT_RSRC_SCHED COMM_REQ_ID |
NO | ||
IPTSv5 (Oracle) EXPT_RSRC_SCHED COMM_REQ_ID |
NO | ||
PRPSL (Oracle) EXPT_RSRC_SCHED COMM_REQ_ID |
NO |
Commitment Request Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Commitment Request Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Commitment Request Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Commitment Request Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Comment |
Base Entity | Experiment Resource Schedule |
Attribute Name | Comment |
Logical Rolename | |
ColumnName | CMNT |
RoleName | |
Domain | Comment |
Logical Only | NO |
Definition | Comment: General comments and description of any special configuration needs for an instrument, sample environment, lab, etc. |
Note |
Comment Logical Attribute Properties |
Logical Attribute Name | Comment |
Datatype | VARCHAR(2000) |
Nullable | YES |
Comment Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Comment Security Types |
Name | Current Value |
Comment Bound Attachments |
Name | Current Value |
Comment Data Movement Rules |
Name | Type | Rule Text/Value |
Comment Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Experiment Resource Schedule Comment |
NO | ||
EXPRESS (Oracle) EXPT_RSRC_SCHED CMNT |
NO | ||
IPTSv5 (Oracle) EXPT_RSRC_SCHED CMNT |
NO | ||
PRPSL (Oracle) EXPT_RSRC_SCHED CMNT |
NO |
Comment Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Comment Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Comment Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Comment Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Requested By Badge Number |
Base Entity | Experiment Resource Schedule |
Attribute Name | Badge Number |
Logical Rolename | Requested By Badge Number |
ColumnName | REQ_BY_BN |
RoleName | REQ_BY_BN |
Domain | |
Logical Only | NO |
Definition | |
Note |
Requested By Badge Number Logical Attribute Properties |
Logical Attribute Name | Badge Number |
Datatype | VARCHAR(10) |
Nullable | YES |
Requested By Badge Number Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Requested By Badge Number Security Types |
Name | Current Value |
Requested By Badge Number Bound Attachments |
Name | Current Value |
Requested By Badge Number Data Movement Rules |
Name | Type | Rule Text/Value |
Requested By Badge Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Experiment Resource Schedule Badge Number |
NO | ||
EXPRESS (Oracle) EXPT_RSRC_SCHED REQ_BY_BN |
NO | ||
IPTSv5 (Oracle) EXPT_RSRC_SCHED REQ_BY_BN |
NO | ||
PRPSL (Oracle) EXPT_RSRC_SCHED REQ_BY_BN |
NO |
Requested By Badge Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Requested By Badge Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Requested By Badge Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Requested By Badge Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Schedule in Hour |
Base Entity | Experiment Resource Schedule |
Attribute Name | Schedule in Hour |
Logical Rolename | |
ColumnName | SCHED_HOUR |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Schedule in Hour; Allow the user to specify the schedule in hours. All hours will be rounded up to whole days. |
Note |
Schedule in Hour Logical Attribute Properties |
Logical Attribute Name | Schedule in Hour |
Datatype | INTEGER |
Nullable | YES |
Schedule in Hour Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Schedule in Hour Security Types |
Name | Current Value |
Schedule in Hour Bound Attachments |
Name | Current Value |
Schedule in Hour Data Movement Rules |
Name | Type | Rule Text/Value |
Schedule in Hour Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Experiment Resource Schedule Schedule in Hour |
NO | ||
EXPRESS (Oracle) EXPT_RSRC_SCHED SCHED_HOUR |
NO | ||
IPTSv5 (Oracle) EXPT_RSRC_SCHED SCHED_HOUR |
NO | ||
PRPSL (Oracle) EXPT_RSRC_SCHED SCHED_HOUR |
NO |
Schedule in Hour Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Schedule in Hour Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Schedule in Hour Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Schedule in Hour Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |