Model General Person Tables
| Object Name | Object Type | Layer Name |
|---|---|---|
| SPBPERS | TABLE | Tables |
| SPRADDR | TABLE | Tables |
| SPRAPIN | TABLE | Tables |
| SPRCMNT | TABLE | Tables |
| SPRCOLR | TABLE | Tables |
| SPREMRG | TABLE | Tables |
| SPRHOLD | TABLE | Tables |
| SPRIDEN | TABLE | Tables |
| SPRINTL | TABLE | Tables |
| SPRMEDI | TABLE | Tables |
| SPRTELE | TABLE | Tables |
| SPTADDR | TABLE | Tables |
| SPTIDEN | TABLE | Tables |
| SPTPERS | TABLE | Tables |

Table SPBPERS
Table Columns information| Column Name | Label | Column Type | Allow NULL | PK | FK |
|---|---|---|---|---|---|
| SPBPERS_PIDM | SPBPERS_PIDM | NUMBER(8,0) | No | * | * |
| SPBPERS_SSN | SPBPERS_SSN | VARCHAR2(9) | Yes | ||
| SPBPERS_BIRTH_DATE | SPBPERS_BIRTH_DATE | DATE | Yes | ||
| SPBPERS_LGCY_CODE | SPBPERS_LGCY_CODE | VARCHAR2(1) | Yes | * | |
| SPBPERS_ETHN_CODE | SPBPERS_ETHN_CODE | VARCHAR2(2) | Yes | * | |
| SPBPERS_MRTL_CODE | SPBPERS_MRTL_CODE | VARCHAR2(1) | Yes | * | |
| SPBPERS_RELG_CODE | SPBPERS_RELG_CODE | VARCHAR2(2) | Yes | * | |
| SPBPERS_SEX | SPBPERS_SEX | VARCHAR2(1) | Yes | ||
| SPBPERS_CONFID_IND | SPBPERS_CONFID_IND | VARCHAR2(1) | Yes | ||
| SPBPERS_DEAD_IND | SPBPERS_DEAD_IND | VARCHAR2(1) | Yes | ||
| SPBPERS_VETC_FILE_NUMBER | SPBPERS_VETC_FILE_NUMBER | VARCHAR2(10) | Yes | ||
| SPBPERS_LEGAL_NAME | SPBPERS_LEGAL_NAME | VARCHAR2(60) | Yes | ||
| SPBPERS_PREF_FIRST_NAME | SPBPERS_PREF_FIRST_NAME | VARCHAR2(15) | Yes | ||
| SPBPERS_NAME_PREFIX | SPBPERS_NAME_PREFIX | VARCHAR2(20) | Yes | ||
| SPBPERS_NAME_SUFFIX | SPBPERS_NAME_SUFFIX | VARCHAR2(20) | Yes | ||
| SPBPERS_ACTIVITY_DATE | SPBPERS_ACTIVITY_DATE | DATE | No | ||
| SPBPERS_VERA_IND | SPBPERS_VERA_IND | VARCHAR2(1) | Yes | ||
| SPBPERS_CITZ_IND | SPBPERS_CITZ_IND | VARCHAR2(1) | Yes | ||
| SPBPERS_DEAD_DATE | SPBPERS_DEAD_DATE | DATE | Yes | ||
| SPBPERS_PIN | SPBPERS_PIN | RAW(1) | Yes | ||
| SPBPERS_CITZ_CODE | SPBPERS_CITZ_CODE | VARCHAR2(2) | Yes | * | |
| SPBPERS_HAIR_CODE | SPBPERS_HAIR_CODE | VARCHAR2(2) | Yes | ||
| SPBPERS_EYES_CODE | SPBPERS_EYES_CODE | VARCHAR2(2) | Yes | ||
| SPBPERS_CITY_BIRTH | SPBPERS_CITY_BIRTH | VARCHAR2(20) | Yes | ||
| SPBPERS_STAT_CODE_BIRTH | SPBPERS_STAT_CODE_BIRTH | VARCHAR2(3) | Yes | * | |
| SPBPERS_DRIVER_LICENSE | SPBPERS_DRIVER_LICENSE | VARCHAR2(20) | Yes | ||
| SPBPERS_STAT_CODE_DRIVER | SPBPERS_STAT_CODE_DRIVER | VARCHAR2(3) | Yes | * | |
| SPBPERS_NATN_CODE_DRIVER | SPBPERS_NATN_CODE_DRIVER | VARCHAR2(5) | Yes | * | |
| SPBPERS_UOMS_CODE_HEIGHT | SPBPERS_UOMS_CODE_HEIGHT | VARCHAR2(4) | Yes | * | |
| SPBPERS_HEIGHT | SPBPERS_HEIGHT | NUMBER(2,0) | Yes | ||
| SPBPERS_UOMS_CODE_WEIGHT | SPBPERS_UOMS_CODE_WEIGHT | VARCHAR2(4) | Yes | * | |
| SPBPERS_WEIGHT | SPBPERS_WEIGHT | NUMBER(4,0) | Yes | ||
| SPBPERS_SDVET_IND | SPBPERS_SDVET_IND | VARCHAR2(1) | Yes | ||
| SPBPERS_LICENSE_ISSUED_DATE | SPBPERS_LICENSE_ISSUED_DATE | DATE | Yes | ||
| SPBPERS_LICENSE_EXPIRES_DATE | SPBPERS_LICENSE_EXPIRES_DATE | DATE | Yes | ||
| SPBPERS_INCAR_IND | SPBPERS_INCAR_IND | VARCHAR2(1) | Yes | ||
| SPBPERS_WEBID | SPBPERS_WEBID | RAW(1) | Yes | ||
| SPBPERS_WEB_LAST_ACCESS | SPBPERS_WEB_LAST_ACCESS | RAW(1) | Yes | ||
| SPBPERS_PIN_DISABLED_IND | SPBPERS_PIN_DISABLED_IND | RAW(1) | Yes | ||
| SPBPERS_ITIN | SPBPERS_ITIN | NUMBER(9,0) | Yes | ||
| SPBPERS_ACTIVE_DUTY_SEPR_DATE | SPBPERS_ACTIVE_DUTY_SEPR_DATE | DATE | Yes | ||
| SPBPERS_DATA_ORIGIN | SPBPERS_DATA_ORIGIN | VARCHAR2(30) | Yes | ||
| SPBPERS_USER_ID | SPBPERS_USER_ID | VARCHAR2(30) | Yes |
| Column name | is Foreign Key For Column | on Table |
|---|---|---|
| SPBPERS_MRTL_CODE | STVMRTL_CODE | STVMRTL |
| SPBPERS_LGCY_CODE | STVLGCY_CODE | STVLGCY |
| SPBPERS_UOMS_CODE_WEIGHT | GTVUOMS_CODE | GTVUOMS |
| SPBPERS_UOMS_CODE_HEIGHT | GTVUOMS_CODE | GTVUOMS |
| SPBPERS_CITZ_CODE | STVCITZ_CODE | STVCITZ |
| SPBPERS_RELG_CODE | STVRELG_CODE | STVRELG |
| SPBPERS_STAT_CODE_DRIVER | STVSTAT_CODE | STVSTAT |
| SPBPERS_STAT_CODE_BIRTH | STVSTAT_CODE | STVSTAT |
| SPBPERS_ETHN_CODE | STVETHN_CODE | STVETHN |
| SPBPERS_NATN_CODE_DRIVER | STVNATN_CODE | STVNATN |
| SPBPERS_PIDM | GORSEVD_DEP_PIDM | GORSEVD |
| SPBPERS_PIDM | GOBSEVS_PIDM | GOBSEVS |
| SPBPERS_PIDM | SGBSTDN_PIDM | SGBSTDN |
| SPBPERS_CITZ_CODE | SARDCSN_CITZ_CODE | SARDCSN |
| SPBPERS_PIDM | SHRDGMR_PIDM | SHRDGMR |
| SPBPERS_PIDM | SLRRMAT_PIDM | SLRRMAT |
Index| Index Name | Index Type | Column Name |
|---|---|---|
| PK_SPBPERS | Unique | SPBPERS_PIDM |
| SPBPERS_SSN_INDEX | SPBPERS_SSN |