CRDT_DBT_GARN_SET |
Default Table Name | CRDT_DBT_GARN_SET |
Definition |
CRDT_DBT_GARN_SET Columns |
ColumnName | Domain | Datatype | NULL | Definition |
STATE_CD![]() |
VARCHAR2(2) | NO | ||
MIN_WAGE_HRS | NUMBER(5, 0) | NO | ||
EXMPT_AMT | NUMBER(5, 2) | NO | ||
DEP_EXMPT_AMT | NUMBER(5, 2) | NO | ||
MIN_WGE_FED_ST_CD | VARCHAR2(1) | NO | ||
DISP_INC_MTHD_CD | VARCHAR2(1) | NO | ||
GARN_RT_CD | VARCHAR2(1) | NO | ||
HH_STATUS_RT | NUMBER(10, 4) | NO | ||
OTHR_STATUS_RT | NUMBER(10, 4) | NO | ||
AK_RES_NO_FAM_AMT | NUMBER(5, 2) | NO | ||
AK_RES_SUP_FAM_AMT | NUMBER(5, 2) | NO | ||
AK_NR_MAX_DI_RT | NUMBER(10, 4) | NO | ||
AK_NR_MIN_WAGE_HRS | NUMBER(5, 0) | NO | ||
HI_WKLY_DI_AMT | NUMBER(5, 2) | NO | ||
HI_BWKLY_DI_AMT | NUMBER(5, 2) | NO | ||
HI_SMNTHY_DI_AMT | NUMBER(5, 2) | NO | ||
HI_MNTHY_DI_AMT | NUMBER(5, 2) | NO | ||
DISP_INC_100_RT | NUMBER(10, 4) | NO | ||
DISP_INC_200_RT | NUMBER(10, 4) | NO | ||
OVR_200_DISP_RT | NUMBER(10, 4) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
ROWVERSION | NUMBER(10, 0) | NO |
CRDT_DBT_GARN_SET Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_7082 | PrimaryKey | STATE_CD |
CRDT_DBT_GARN_SET Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
STATE | Identifying | One To Zero or More | F21705 | STATE_CD | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |