LAB_LOCATION |
Default Table Name | LAB_LOCATION |
Definition |
LAB_LOCATION Columns |
ColumnName | Domain | Datatype | NULL | Definition |
LAB_LOC_CD![]() |
VARCHAR2(6) | NO | ||
LAB_LOC_DESC | VARCHAR2(30) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
EXT_LAB_LOC_DESC | VARCHAR2(60) | YES | ||
LAB_LOC_TYPE_CD | VARCHAR2(20) | YES | ||
LN_1_ADR | VARCHAR2(30) | YES | ||
LN_2_ADR | VARCHAR2(30) | YES | ||
LN_3_ADR | VARCHAR2(30) | YES | ||
CITY_NAME | VARCHAR2(25) | YES | ||
MAIL_STATE_DC![]() |
VARCHAR2(15) | YES | ||
POSTAL_CD | VARCHAR2(10) | YES | ||
COUNTRY_CD![]() |
VARCHAR2(8) | YES | ||
PARENT_LAB_LOC_CD | VARCHAR2(6) | YES | ||
SITE_CONTACT | VARCHAR2(40) | YES | ||
PHONE_ID | VARCHAR2(25) | YES | ||
FAX_ID | VARCHAR2(25) | YES | ||
LAB_LOC_MISC1 | VARCHAR2(40) | YES | ||
LAB_LOC_MISC2 | VARCHAR2(40) | YES | ||
LAB_LOC_MISC3 | VARCHAR2(40) | YES | ||
LAB_LOC_MISC4 | VARCHAR2(40) | YES | ||
ACTIVE_FL | VARCHAR2(1) | YES | ||
TM_LOC_FL | VARCHAR2(1) | NO |
LAB_LOCATION Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0134 | PrimaryKey | LAB_LOC_CD |
LAB_LOCATION Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
COUNTRY | Non-Identifying | Zero or One to Zero or More | FK_LAB_LOCATION_CO_IDX | COUNTRY_CD | NO | NO | NO | ||
MAIL_STATE | Non-Identifying | Zero or One to Zero or More | FK_LAB_LOCATION_COMA_IDX | MAIL_STATE_DC, COUNTRY_CD | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
DFLT_REG_TS | Non-Identifying | One To Zero or More | F00840 | NO | NO | NO | |||
DFLT_OT_TS | Non-Identifying | One To Zero or More | F00841 | NO | NO | NO | |||
OT_RULES_BY_LOC | Identifying | One To Zero or More | F02520 | NO | NO | NO | |||
PAY_TYPE_RESTRICT | Non-Identifying | One To Zero or More | F02660 | NO | NO | NO | |||
TS_LN | Non-Identifying | One To Zero or More | F04890 | NO | NO | NO | |||
WAGE_DETERM | Identifying | One To Zero or More | F05330 | NO | NO | NO | |||
WD_FRNG_HANDLING | Identifying | One To Zero or More | F05365 | NO | NO | NO | |||
COMP_PLAN_DFLT | Non-Identifying | One To Zero or More | F09835 | NO | NO | NO | |||
H_DETL_POS_DESC | Non-Identifying | One To Zero or More | F20421 | NO | NO | NO | |||
HB_BEN_PKG_DFLT | Non-Identifying | One To Zero or More | F20917 | NO | NO | NO | |||
UNION_PROFLE | Identifying | One To Zero or More | F21326 | NO | NO | NO | |||
H_AFF_PL_LOC_CMP | Identifying | One To Zero or More | F21579 | NO | NO | NO | |||
CTM_LAB_CAT | Non-Identifying | One To Zero or More | FK_CTM_LAB_CAT_LA_IDX | NO | NO | NO | |||
CTM_LC_RESOURCE | Non-Identifying | One To Zero or More | FK_CTM_LC_RESOURCE_LA_IDX | NO | NO | NO | |||
H_POS_RQ_RQST | Non-Identifying | One To Zero or More | FK_H_POS_RQ_RQST_DFLA_IDX | NO | NO | NO | |||
LAB_LOCATION_COMPANY | Identifying | One To Zero or More | FK_LAB_LOCATION_COMPANY_LA_IDX | NO | NO | NO | |||
VE_LAB_INFO | Non-Identifying | One To Zero or More | FK_VE_LAB_INFO_LA_IDX | NO | NO | NO |