LOCALITY |
Default Table Name | LOCALITY |
Definition |
LOCALITY Columns |
ColumnName | Domain | Datatype | NULL | Definition |
LOCAL_CD![]() |
VARCHAR2(6) | NO | ||
LOCAL_NAME | VARCHAR2(25) | NO | ||
LOCAL_WH_ACCT_ID![]() |
VARCHAR2(15) | YES | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
STATE_CD![]() |
VARCHAR2(2) | YES | ||
CTS_SUP_CD![]() |
VARCHAR2(6) | YES | ||
CTS_LOCAL_CD | VARCHAR2(4) | YES | ||
COUNTY_CD | VARCHAR2(6) | YES | ||
NJ_SDI_FL | VARCHAR2(1) | YES | ||
SCHOOL_CD | VARCHAR2(20) | YES | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
NY_LOCAL_CD | VARCHAR2(1) | YES | ||
FLI_TYPE | VARCHAR2(1) | YES | ||
LOCAL_ACCR_ACCT_ID | VARCHAR2(15) | YES | ||
LOCAL_EXP_ACCT_ID | VARCHAR2(15) | YES | ||
TAX_PAID_CD | VARCHAR2(1) | YES | ||
OH_TCA_CD | VARCHAR2(1) | YES | ||
CHAR_CITY_CD | VARCHAR2(25) | YES | ||
LOC_TAX_SVC_CD | VARCHAR2(25) | YES |
LOCALITY Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0526 | PrimaryKey | LOCAL_CD |
LOCALITY 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 | F08360 | LOCAL_WH_ACCT_ID | NO | NO | NO | ||
STATE | Non-Identifying | Zero or One to Zero or More | F20622 | STATE_CD | NO | NO | NO | ||
S_CTS_SUP_CD | Non-Identifying | Zero or One to Zero or More | F21534 | CTS_SUP_CD | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
DED_LOC_TXBL | Identifying | One To Zero or More | F08381 | NO | NO | NO | |||
LOCAL_TAX_HS | Identifying | One To Zero or More | F08540 | NO | NO | NO | |||
LOCAL_TAX_TBL | Identifying | One To Zero or More | F08550 | NO | NO | NO | |||
LOC_STD_DED | Identifying | One To Zero or More | F08560 | NO | NO | NO | |||
PAY_TYPE_LOC_TXBL | Identifying | One To Zero or More | F08570 | NO | NO | NO | |||
EMPL_TAX | Non-Identifying | One To Zero or More | F09063 | NO | NO | NO | |||
EMPL_TAX | Non-Identifying | One To Zero or More | F09064 | NO | NO | NO | |||
EMPL_TAX | Non-Identifying | One To Zero or More | F09065 | NO | NO | NO | |||
EMPL_TAX | Non-Identifying | One To Zero or More | F09066 | NO | NO | NO | |||
EMPL_TAX | Non-Identifying | One To Zero or More | F09067 | NO | NO | NO | |||
LOCAL_W2_FILE | Identifying | One To Zero or More | F09983 | NO | NO | NO | |||
MULTI_CO_LOC_OVRD | Identifying | One To Zero or More | F21013 | NO | NO | NO |