STATE |
Default Table Name | STATE |
Definition |
STATE Columns |
ColumnName | Domain | Datatype | NULL | Definition |
STATE_CD![]() |
VARCHAR2(2) | NO | ||
STATE_NAME | VARCHAR2(25) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
ROWVERSION | NUMBER(10, 0) | YES |
STATE Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0086 | PrimaryKey | STATE_CD |
STATE 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 |
OT_RULES_BY_STATE | Identifying | One To Zero or More | F02531 | NO | NO | NO | |||
DED_STATE_TXBL | Identifying | One To Zero or More | F08371 | NO | NO | NO | |||
LOCAL_TAX_HS | Non-Identifying | One To Zero or More | F08541 | NO | NO | NO | |||
WORK_COMP_STATE | Identifying | One To Zero or More | F08640 | NO | NO | NO | |||
EMPL_TAX | Non-Identifying | One To Zero or More | F09061 | NO | NO | NO | |||
EMPL_TAX | Non-Identifying | One To Zero or More | F09062 | NO | NO | NO | |||
PROJ_BILL_INFO | Non-Identifying | One To Zero or More | F09145 | NO | NO | NO | |||
STATE_W2_FILE | Identifying | One To Zero or More | F09980 | NO | NO | NO | |||
LOCALITY | Non-Identifying | One To Zero or More | F20622 | NO | NO | NO | |||
H_WORK_COMP_RSN | Identifying | One To Zero or More | F20793 | NO | NO | NO | |||
EMPL_PR_WC | Non-Identifying | One To Zero or More | F21166 | NO | NO | NO | |||
CREW_TS_LN | Non-Identifying | One To Zero or More | F21321 | NO | NO | NO | |||
CREW_TS_LN | Non-Identifying | One To Zero or More | F21324 | NO | NO | NO | |||
UNION_PROFLE_PROJ | Non-Identifying | Zero or One to Zero or More | F21335 | NO | NO | NO | |||
S_CTS_PD_XREF | Identifying | One To Zero or More | F21533 | NO | NO | NO | |||
S_CTS_QTR_XREF | Identifying | One To Zero or More | F21537 | NO | NO | NO | |||
STATE_RECP_TBL | Identifying | One To Zero or More | F21629 | NO | NO | NO | |||
STATE_RECP_TBL | Identifying | One To Zero or More | F21630 | NO | NO | NO | |||
STATE_RECP_INFO | Identifying | One To Zero or More | F21631 | NO | NO | NO | |||
STATE_MIN_WAGE | Identifying | One To Zero or More | F21691 | NO | NO | NO | |||
CRDT_DBT_GARN_SET | Identifying | One To Zero or More | F21705 | NO | NO | NO | |||
DISP_INC_SETUP | Identifying | One To Zero or More | F21720 | NO | NO | NO | |||
EMPL_GARN_WAGE | Non-Identifying | One To Zero or More | F21722 | NO | NO | NO | |||
CHILD_SUP_GARN_SET | Identifying | One To Zero or More | F21738 | NO | NO | NO | |||
ST_GARN_WH_LIMIT | Identifying | One To Zero or More | F21739 | NO | NO | NO | |||
SUPPORT_RULES | Identifying | One To Zero or More | F21771 | NO | NO | NO | |||
EMPL_GRN | Non-Identifying | One To Zero or More | F21774 | NO | NO | NO | |||
HS_PROJ_BILL_INFO | Non-Identifying | One To Zero or More | FK_HS_PROJ_BILL_INFO_IS_IDX | NO | NO | NO |