BILL_LAB_CAT |
Default Table Name | BILL_LAB_CAT |
Definition |
BILL_LAB_CAT Columns |
ColumnName | Domain | Datatype | NULL | Definition |
BILL_LAB_CAT_CD![]() |
VARCHAR2(6) | NO | ||
BILL_LAB_CAT_DESC | VARCHAR2(30) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
BILL_AVG_RT_AMT | NUMBER(19, 4) | NO | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
WORK_COMP_CD | VARCHAR2(6) | YES | ||
ACTIVE_FL | VARCHAR2(1) | YES | ||
RATE1_RATE | NUMBER(15, 5) | YES | ||
RATE2_RATE | NUMBER(15, 5) | YES |
BILL_LAB_CAT Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0269 | PrimaryKey | BILL_LAB_CAT_CD, COMPANY_ID |
BILL_LAB_CAT Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
LAB_CAT_RT_SCH | Non-Identifying | One To Zero or More | F02150 | NO | NO | NO | |||
PROJ_EMPL_RT_SCH | Non-Identifying | One To Zero or More | F03870 | NO | NO | NO | |||
PROJ_LAB_CAT | Non-Identifying | One To Zero or More | F03950 | NO | NO | NO | |||
PROJ_LAB_CAT_MAP | Non-Identifying | One To Zero or More | F03970 | NO | NO | NO | |||
PROJ_LAB_CAT_RT_SC | Non-Identifying | One To Zero or More | F03990 | NO | NO | NO | |||
PROJ_VEND_LAB_CAT | Non-Identifying | One To Zero or More | F04140 | NO | NO | NO | |||
PROJ_VEND_RT_SCH | Non-Identifying | One To Zero or More | F04180 | NO | NO | NO | |||
GENL_LAB_CAT | Non-Identifying | One To Zero or More | F06427 | NO | NO | NO | |||
ETC_PLC_HRS | Non-Identifying | One To Zero or More | F08196 | NO | NO | NO | |||
PROJ_BUD_PLC | Non-Identifying | One To Zero or More | F08212 | NO | NO | NO | |||
PROJ_TOT_BUD_PLC | Non-Identifying | One To Zero or More | F08225 | NO | NO | NO | |||
VEND_CEIL | Non-Identifying | One To Zero or More | F08233 | NO | NO | NO | |||
CEIL_DIR_HRS | Non-Identifying | One To Zero or More | F08237 | NO | NO | NO | |||
EMPL_CEIL | Non-Identifying | One To Zero or More | F08241 | NO | NO | NO | |||
BUD_CO_LN_HRS | Non-Identifying | One To Zero or More | F20971 | NO | NO | NO | |||
ALT_CEIL_DIR_HRS | Non-Identifying | One To Zero or More | FK_ALT_CEIL_DIR_HRS_BICO_IDX | NO | NO | NO | |||
ALT_EMPL_CEIL | Non-Identifying | One To Zero or More | FK_ALT_EMPL_CEIL_BICO_IDX | NO | NO | NO | |||
ALT_VEND_CEIL | Non-Identifying | One To Zero or More | FK_ALT_VEND_CEIL_BICO_IDX | NO | NO | NO | |||
CEIL_DIR_HRS_ADT | Identifying | One To Zero or More | FK_CEIL_DIR_HRS_ADT_BICO_IDX | NO | NO | NO | |||
CTM_LAB_CAT | Non-Identifying | One To Zero or More | FK_CTM_LAB_CAT_BICO_IDX | NO | NO | NO | |||
CTM_LC_RESOURCE | Non-Identifying | One To Zero or More | FK_CTM_LC_RESOURCE_BICO_IDX | NO | NO | NO | |||
EMPL_CEIL_ADT | Identifying | One To Zero or More | FK_EMPL_CEIL_ADT_BICO_IDX | NO | NO | NO | |||
VEND_CEIL_ADT | Identifying | One To Zero or More | FK_VEND_CEIL_ADT_BICO_IDX | NO | NO | NO |