LAB_SETTINGS |
Default Table Name | LAB_SETTINGS |
Definition |
LAB_SETTINGS Columns |
ColumnName | Domain | Datatype | NULL | Definition |
STD_RATES_FL | VARCHAR2(1) | NO | ||
STD_RATES_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
DFLT_PAY_TYPE | VARCHAR2(3) | YES | ||
WORK_YR_HRS_NO | NUMBER(5, 0) | NO | ||
ACCR_SAL_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
MIN_HRLY_AMT | NUMBER(19, 4) | NO | ||
DFLT_TS_PD_CD | VARCHAR2(4) | YES | ||
COMPANY_ID![]() |
VARCHAR2(10) | NO | ||
MOS_REVIEW_NO | NUMBER(5, 0) | NO | ||
DFLT_WORK_COMP_CD | VARCHAR2(6) | YES | ||
PT_RESTRIC_FL | VARCHAR2(1) | YES | ||
BATCH_CNTL_FL | VARCHAR2(1) | YES | ||
S_WAGE_OVRIDE_CD | VARCHAR2(1) | YES | ||
WORK_COMP_REQD_FL | VARCHAR2(1) | YES | ||
WORK_COMP_CHNG_FL | VARCHAR2(1) | YES | ||
LAB_LOC_FL | VARCHAR2(1) | YES | ||
GN_LAB_CAT_CHNG_FL | VARCHAR2(1) | YES | ||
S_EDIT_MTHD_CD | VARCHAR2(1) | YES | ||
UNION_PR_FL | VARCHAR2(1) | YES | ||
SSN_VAL_FL | VARCHAR2(1) | YES | ||
USE_REF_DT_FL | VARCHAR2(1) | YES | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
LOC_FRNG_CEIL_FL | VARCHAR2(1) | YES | ||
MO_ORG_DFLT_MTHD | VARCHAR2(1) | NO | ||
MO_ACCT_DFLT_MTHD | VARCHAR2(1) | NO | ||
EFFBILLDT_MTHD | VARCHAR2(1) | YES | ||
EFFBILLDT_REF_FL | VARCHAR2(1) | YES | ||
PRORATE_EMPL_FL | VARCHAR2(1) | YES | ||
PRORATE_CALC_MTHD | VARCHAR2(1) | YES | ||
TC_WORK_SCHED_CD | VARCHAR2(10) | YES | ||
S_ZERO_TS_MTHD_CD | VARCHAR2(1) | YES | ||
USE_TC_CONNECTION | VARCHAR2(10) | YES | ||
CORR_TS_DATE_CD | VARCHAR2(4) | YES | ||
AUTO_PRORATE_FL | VARCHAR2(1) | YES | ||
MO_ACCT_VAL_MTHD | VARCHAR2(2) | YES | ||
MULTICURRENCY_FL | VARCHAR2(1) | YES | ||
DFLT_COMPANY_FL | VARCHAR2(1) | YES | ||
DFLT_COMPANY_JOB_FL | VARCHAR2(1) | YES | ||
EMPL_ID_AUTOGEN_FL | VARCHAR2(1) | NO | ||
EMPLOYMENT_HISTORY_METHOD | VARCHAR2(15) | NO | ||
AUDIT_BASIC_FL | VARCHAR2(1) | NO | ||
AUDIT_SAL_INFO_FL | VARCHAR2(1) | NO | ||
S_RQ_NO_MTHD_CD | VARCHAR2(1) | NO | ||
REQ_AUTO_APPRV_FL | VARCHAR2(1) | NO | ||
ORG_REQ_FL | VARCHAR2(1) | NO | ||
APPRVL_EMPL_ID | VARCHAR2(12) | YES | ||
GENERATE_NEG_LWOP_FL | VARCHAR2(1) | NO | ||
NEG_LWOP_OPTION_FL | VARCHAR2(1) | NO |
LAB_SETTINGS Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0136 | PrimaryKey | COMPANY_ID |
LAB_SETTINGS Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
ACCT | Non-Identifying | Zero or One to Zero or More | F02180 | STD_RATES_ACCT_ID | NO | NO | NO | ||
ACCT | Non-Identifying | Zero or One to Zero or More | F02200 | ACCR_SAL_ACCT_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |