|
Table of Contents
Home
|
SHARED DATA ISSUES
1. DATA SHARED BY ALL SYSTEMS
- NAMES
- ADDRESSES (USING ADDRESS TYPES) *
- TELEPHONE NUMBERS (USING TELEPHONE TYPES)
- ID
- SSN (COULD BE AN ID)
- BIRTHDATE
- CONFIDENTIALITY INDICATOR
- ETHNICITY
- RELIGION
- SEX
- DECEASED INDICATOR *
2. VALIDATION CODES SHARED BY ALL SYSTEMS
- ADDRESS TYPE *
- TELEPHONE TYPE *
- ADDRESS SOURCE
- STATE
- NATION
- COUNTY
- RELIGION
- ETHNICITY
3. VALIDATION CODES SHARED BY MULTIPLE SYSTEMS
- LEVEL *
- DEGREE *
- MAJOR *
- ACTIVITIES
4. DATA ENTRY AND PROCESS STANDARDS
- NAMES
- ADDRESSES
- UNLISTED NUMBERS
- DECEASED PROCESSING
Banner Shared Fields and Validation Tables
FIELD NAME |
TECHNICAL NAME |
VALIDATION |
| ID |
SPRIDEN_ID |
|
| NAME TYPE CODE |
SPRIDEN_NTYP_CODE |
GTVNTYP |
| FIRST NAME |
SPRIDEN_LAST_NAME |
|
| LAST NAME |
SPRIDEN_FIRST_NAME |
|
| MIDDLE NAME |
SPRIDEN_MIDDLE_NAME |
|
| PREFIX |
SPBPERS_NAME_PREFIX |
|
| SUFFIX |
SPBPERS_NAME_SUFFIX |
|
| MARITAL STATUS CODE |
SPBPERS_MRTL_CODE |
STVMRTL |
| ADDRESS TYPE CODE |
SPRADDR_ATYP_CODE |
STVATYP |
| ADDRESS STREET 1 |
SPRADDR_STREET_LINE1 |
|
| ADDRESS STREET 2 |
SPRADDR_STREET_LINE2 |
|
| ADDRESS STREET 3 |
SPRADDR_STREET_LINE3 |
|
| CITY |
SPRADDR_CITY |
|
| STATE CODE |
SPRADDR_STAT_CODE |
STVSTAT |
| ZIP/POSTAL CODE |
SPRADDR_ZIPC_CODE |
GTVZIPC |
| COUNTY CODE |
SPRADDR_CNTY_CODE |
STVCNTY |
| NATION CODE |
SPRADDR_NATN_CODE |
STVNATN |
| TELEPHONE TYPE CODE |
SPRTELE_TELE_CODE |
STVTELE |
| TELEPHONE AREA CODE |
SPRTELE |
|
| TELEPHONE NUMBER |
SPRTELE_ |
|
| ADDRESS SOURCE CODE |
SPRADDR_ASRC_CODE |
STVASRC |
| ADDRESS INACTIVE INDICATOR |
SPRADDR_ADDR_IND |
|
| ADDRESS START/END DATE |
SPRADDR_ADDR_START_DATE |
|
| E MAIL TYPE CODE |
|
GTVEMAL |
| E MAIL ADDRESS |
|
|
| E MAIL COMMENT |
|
|
| SSN |
SPBPERS_ |
|
| BIRTHDATE |
SPBPERS_BIRTH_DATE |
|
| CONFIDENTIALITY INDICATOR |
SPBPERS |
|
| CITIZENSHIP CODE |
SPBPERS_CITZ_CODE |
STVCITZ |
| ETHNICITY CODE |
SPBPERS_ETHN_CODE |
STVETHN |
| RELIGION CODE |
SPBPERS_RELG_CODE |
STVRELN |
| LEGACY CODE |
SPBPERS_LGCY_CODE |
STVLGCY |
| SEX |
SPBPERS_SEX |
|
| DECEASED INDICATOR * |
SPBPERS_DEAD_IND |
|
| DECEASED DATE |
SPBPERS_ |
|
| VETERAN CODE |
SPBPERS_ |
|
| QUIK FLOW CODE |
GUAQUIK |
GTVQUIK |
| GEOGRAPHIC DIVISION |
GOVGEOR_GEOD_CODE |
GTVGEOD |
| GEOGRAPHIC REGION |
GOVGEOR_GEOR_CODE |
GTVGEOR |
|
SHARED VALIDATION TABLES
- STVATYP
- STVTELE
- STVSTAT
- STVCNTY
- STVNATN
- STVASRC
- STVMRTL
- STVETHN
- STVCITZ
- STVLGCY
- STVRELN
- GTVZIPC
- GTVNTYP
- GTVEMAL
STUDENT TABLES SHARED WITH OTHER SYSTEMS
- STVLEVL
- STVMAJR
- STVDEGC
- STVCOLL
- STVDEPT
|