Table Detail Report

RLN_SPECIMEN_OEF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Reference Lab Network - Specimen Order Entry Format
Definition: This table will store the relationship between specimen types and order entry formats for each connected partner lab.
Table Type: REFERENCE





Column Detail - RLN_SPECIMEN_OEF


Column Name Type Null? Definition
ACCESSION_CLASS_CD DOUBLE N The accession class associated with the specimen type.
ACTION_TYPE_CD DOUBLE N The action this format is built for.
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
COLLECTION_METHOD_CD DOUBLE N The collection method associated with a specimen type.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
OEF_ID DOUBLE N Along with the action_type_cd, uniquely identifies the related order entry format.
ORIG_RLN_SPECIMEN_OEF_ID DOUBLE N Used to track versions of the specimen and order entry format information. This field will always point back to the original value created. This may be used to find the correct version when combined with the begin and end effective dates and times
RLN_CONTRIBUTOR_ID DOUBLE N Uniquely identifies the related contributor.
RLN_SPECIMEN_OEF_ID DOUBLE N Uniquely identifies a relationship between a specimen type and an order entry format for a given partner lab.
SPECIMEN_TYPE_CD DOUBLE N Identifies the type of specimen
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - RLN_SPECIMEN_OEF


Child Column in RLN_SPECIMEN_OEF(FK) Parent Table Name Parent Column Name
Parents: ACTION_TYPE_CD ORDER_ENTRY_FORMAT ACTION_TYPE_CD
OEF_ID ORDER_ENTRY_FORMAT OE_FORMAT_ID
RLN_CONTRIBUTOR_ID RLN_CONTRIBUTOR RLN_CONTRIBUTOR_ID
ORIG_RLN_SPECIMEN_OEF_ID RLN_SPECIMEN_OEF RLN_SPECIMEN_OEF_ID




Parent Column in RLN_SPECIMEN_OEF (PK) Child Table Name Child Column Name
Children: RLN_SPECIMEN_OEF_ID RLN_SPECIMEN_OEF ORIG_RLN_SPECIMEN_OEF_ID