Geography
Entity Relationship Diagram
|
Tip: |
Right click the attachment to view Entity Relationship Diagram for Geography in a new tab. |
List of Objects
| DB Object Name | Object Business Name | Object Description | DB Attribute Name | Attribute Business Name | Ordinal Position | Data Type Name | Data Type Size | Numeric Scale | Is Identity | Is Nullable | Primary Key | Mandatory |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| GORG_GRP_C | Geography Group | Geography Group | GORG_GRP_TYP_SYS_KEY_C | GORG GRP TYP SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| GORG_GRP_C | Geography Group | Geography Group | GORG_GRP_TYP_BUS_KEY_C | GORG GRP TYP BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| GORG_GRP_C | Geography Group | Geography Group | GORG_GRP_TYPE_CD_C | GORG GRP TYPE CD C | 3 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| GORG_GRP_C | Geography Group | Geography Group | GORG_GRP_TYPE_NM_C | GORG GRP TYPE NM C | 4 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| GORG_GRP_C | Geography Group | Geography Group | CTRY_CD_C | CTRY CD C | 5 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| GORG_GRP_C | Geography Group | Geography Group | ACTV_IND_C | ACTV IND C | 6 | VARCHAR | 16777216 | NO | YES | FALSE | FALSE | |
| GORG_GRP_C | Geography Group | Geography Group | SYS_CRT_DTT_C | SYS CRT DTT C | 7 | DATE | NO | YES | FALSE | FALSE | ||
| GORG_GRP_C | Geography Group | Geography Group | SYS_CRT_BY_C | SYS CRT BY C | 8 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| GORG_GRP_C | Geography Group | Geography Group | SYS_EFF_DTT_C | SYS EFF DTT C | 9 | DATE | NO | YES | FALSE | FALSE | ||
| GORG_GRP_C | Geography Group | Geography Group | SYS_UPDT_DTT_C | SYS UPDT DTT C | 10 | DATE | NO | YES | FALSE | FALSE | ||
| GORG_GRP_C | Geography Group | Geography Group | SYS_UPDT_BY_C | SYS UPDT BY C | 11 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| GORG_GRP_C | Geography Group | Geography Group | SYS_END_DTT_C | SYS END DTT C | 12 | DATE | NO | YES | FALSE | FALSE | ||
| GORG_HIER_C | GeographyHierarchy | GeographyHierarchy | GORG_HIER_SYS_KEY_C | GORG HIER SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| GORG_HIER_C | GeographyHierarchy | GeographyHierarchy | GORG_HIER_BUS_KEY_C | GORG HIER BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| GORG_HIER_C | GeographyHierarchy | GeographyHierarchy | PRNT_GORG_SYS_KEY_C | PRNT GORG SYS KEY C | 3 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| GORG_HIER_C | GeographyHierarchy | GeographyHierarchy | PRNT_GORG_TYPE_CD_C | PRNT GORG TYPE CD C | 4 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| GORG_HIER_C | GeographyHierarchy | GeographyHierarchy | CHLD_GORG_SYS_KEY_C | CHLD GORG SYS KEY C | 5 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| GORG_HIER_C | GeographyHierarchy | GeographyHierarchy | CHLD_GORG_TYPE_CD_C | CHLD GORG TYPE CD C | 6 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| GORG_HIER_C | GeographyHierarchy | GeographyHierarchy | CTRY_CD_C | CTRY CD C | 7 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| GORG_HIER_C | GeographyHierarchy | GeographyHierarchy | SYS_CRT_DTT_C | SYS CRT DTT C | 8 | DATE | NO | YES | FALSE | FALSE | ||
| GORG_HIER_C | GeographyHierarchy | GeographyHierarchy | SYS_CRT_BY_C | SYS CRT BY C | 9 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| GORG_HIER_C | GeographyHierarchy | GeographyHierarchy | SYS_EFF_DTT_C | SYS EFF DTT C | 10 | DATE | NO | YES | FALSE | FALSE | ||
| GORG_HIER_C | GeographyHierarchy | GeographyHierarchy | SYS_UPDT_DTT_C | SYS UPDT DTT C | 11 | DATE | NO | YES | FALSE | FALSE | ||
| GORG_HIER_C | GeographyHierarchy | GeographyHierarchy | SYS_UPDT_BY_C | SYS UPDT BY C | 12 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| GORG_HIER_C | GeographyHierarchy | GeographyHierarchy | SYS_END_DTT_C | SYS END DTT C | 13 | DATE | NO | YES | FALSE | FALSE | ||
| GORG_REF_C | Geography Reference | Geography Reference | GORG_SYS_KEY_C | GORG SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | TRUE | TRUE | |
| GORG_REF_C | Geography Reference | Geography Reference | GORG_BUS_KEY_C | GORG BUS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| GORG_REF_C | Geography Reference | Geography Reference | SRC_SYS_CD_C | SRC SYS CD C | 3 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| GORG_REF_C | Geography Reference | Geography Reference | CTRY_CD_C | CTRY CD C | 4 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| GORG_REF_C | Geography Reference | Geography Reference | GORG_SRC_ID_C | GORG SRC ID C | 5 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| GORG_REF_C | Geography Reference | Geography Reference | GORG_GRP_TYPE_SYS_KEY_C | GORG GRP TYPE SYS KEY C | 6 | VARCHAR | 16777216 | NO | YES | FALSE | FALSE | |
| GORG_REF_C | Geography Reference | Geography Reference | GORG_TYPE_CD_C | GORG TYPE CD C | 7 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| GORG_REF_C | Geography Reference | Geography Reference | GORG_LVL_NBR_C | GORG LVL NBR C | 8 | NUMERIC | 38 | 0 | NO | YES | FALSE | FALSE |
| GORG_REF_C | Geography Reference | Geography Reference | GORG_CD_C | GORG CD C | 9 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| GORG_REF_C | Geography Reference | Geography Reference | GORG_NM_C | GORG NM C | 10 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| GORG_REF_C | Geography Reference | Geography Reference | GORG_ALT_NM_C | GORG ALT NM C | 11 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| GORG_REF_C | Geography Reference | Geography Reference | SYS_CRT_DTT_C | SYS CRT DTT C | 12 | DATE | NO | YES | FALSE | FALSE | ||
| GORG_REF_C | Geography Reference | Geography Reference | SYS_CRT_BY_C | SYS CRT BY C | 13 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| GORG_REF_C | Geography Reference | Geography Reference | SYS_EFF_DTT_C | SYS EFF DTT C | 14 | DATE | NO | YES | FALSE | FALSE | ||
| GORG_REF_C | Geography Reference | Geography Reference | SYS_UPDT_DTT_C | SYS UPDT DTT C | 15 | DATE | NO | YES | FALSE | FALSE | ||
| GORG_REF_C | Geography Reference | Geography Reference | SYS_UPDT_BY_C | SYS UPDT BY C | 16 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| GORG_REF_C | Geography Reference | Geography Reference | SYS_END_DTT_C | SYS END DTT C | 17 | DATE | NO | YES | FALSE | FALSE |