Shared Data Table

Table of Contents
Home
Expand all   Collapse all

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
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.