Model Directory Profile
| Object Name | Object Type | Layer Name |
|---|---|---|
| APBCONS | TABLE | Default |
| GOBDIRO | TABLE | Default |
| GORDADD | TABLE | Default |
| GORDPRF | TABLE | Default |
| GOREMAL | TABLE | Default |
| GTVDIRO | TABLE | Default |
| GTVEMAL | TABLE | Default |
| GUBINST | TABLE | Default |
| NBRBJOB | TABLE | Default |
| NBRJOBS | TABLE | Default |
| SGBSTDN | TABLE | Default |
| SPRADDR | TABLE | Default |
| SPRTELE | TABLE | Default |
| STVCOLL | TABLE | Default |
| STVNATN | TABLE | Default |

Table APBCONS
Table Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| APBCONS_PIDM | APBCONS_PIDM | NUMBER(8,0) | No | * | |
| APBCONS_PREF_LAST_NAME | APBCONS_PREF_LAST_NAME | VARCHAR2(25) | Yes | ||
| APBCONS_PREF_FIRST_NAME | APBCONS_PREF_FIRST_NAME | VARCHAR2(15) | Yes | ||
| APBCONS_PREF_MI | APBCONS_PREF_MI | VARCHAR2(1) | Yes | ||
| APBCONS_NICKNAME | APBCONS_NICKNAME | VARCHAR2(40) | Yes | ||
| APBCONS_GRAD_NAME | APBCONS_GRAD_NAME | VARCHAR2(60) | Yes | ||
| APBCONS_PARENTS_NAME | APBCONS_PARENTS_NAME | VARCHAR2(50) | Yes | ||
| APBCONS_MAIDEN_LAST_NAME | APBCONS_MAIDEN_LAST_NAME | VARCHAR2(25) | Yes | ||
| APBCONS_PREF_CLAS | APBCONS_PREF_CLAS | VARCHAR2(4) | No | ||
| APBCONS_COLL_CODE_PREF | APBCONS_COLL_CODE_PREF | VARCHAR2(2) | Yes | * | |
| APBCONS_HOME_CITY | APBCONS_HOME_CITY | VARCHAR2(20) | Yes | ||
| APBCONS_STAT_CODE_HOME | APBCONS_STAT_CODE_HOME | VARCHAR2(3) | Yes | * | |
| APBCONS_NATN_CODE_HOME | APBCONS_NATN_CODE_HOME | VARCHAR2(5) | Yes | * | |
| APBCONS_CM_NAME | APBCONS_CM_NAME | VARCHAR2(50) | Yes | ||
| APBCONS_ATYP_CODE_CM | APBCONS_ATYP_CODE_CM | VARCHAR2(2) | Yes | * | |
| APBCONS_DOTT_CODE | APBCONS_DOTT_CODE | VARCHAR2(4) | Yes | * | |
| APBCONS_INCM_CODE | APBCONS_INCM_CODE | VARCHAR2(2) | Yes | * | |
| APBCONS_ATYP_CODE_PREF | APBCONS_ATYP_CODE_PREF | VARCHAR2(2) | Yes | * | |
| APBCONS_ADDR_NAME | APBCONS_ADDR_NAME | VARCHAR2(35) | Yes | ||
| APBCONS_ACTIVITY_DATE | APBCONS_ACTIVITY_DATE | DATE | No | ||
| APBCONS_ATYP_CODE_GEOR | APBCONS_ATYP_CODE_GEOR | VARCHAR2(2) | Yes | * | |
| APBCONS_SOCIETY_NAME | APBCONS_SOCIETY_NAME | VARCHAR2(60) | Yes | ||
| APBCONS_DATA_ORIGIN | APBCONS_DATA_ORIGIN | VARCHAR2(30) | Yes | ||
| APBCONS_USER_ID | APBCONS_USER_ID | VARCHAR2(30) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| APBCONS_ATYP_CODE_PREF | STVATYP_CODE | STVATYP |
| APBCONS_COLL_CODE_PREF | STVCOLL_CODE | STVCOLL |
| APBCONS_NATN_CODE_HOME | STVNATN_CODE | STVNATN |
| APBCONS_STAT_CODE_HOME | STVSTAT_CODE | STVSTAT |
| APBCONS_ATYP_CODE_CM | STVATYP_CODE | STVATYP |
| APBCONS_ATYP_CODE_GEOR | STVATYP_CODE | STVATYP |
| APBCONS_INCM_CODE | ATVINCM_CODE | ATVINCM |
| APBCONS_DOTT_CODE | ATVDOTT_CODE | ATVDOTT |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| APBCONS_KEY_INDEX2 | APBCONS_PREF_CLAS | |
| APBCONS_KEY_INDEX3 | APBCONS_COLL_CODE_PREF | |
| PK_APBCONS | Unique | APBCONS_PIDM |