Model Recruiting

Model Label : ERD For Banner Student Recruiting Module ( SR% Tables )
Path : BANNER DEV/Student/Recruiting/Recruiting_ERD/Recruiting

List of Objects

Object Name	Object Type	Layer Name
GTVEMAL	TABLE	links
GTVNTYP	TABLE	links
SMRPRLE	TABLE	links
SORMATT	TABLE	links
SORMSRC	TABLE	links
SPBPERS	TABLE	links
SPRIDEN	TABLE	links
SRBPRED	TABLE	Default
SRBWPDS	TABLE	Default
SRBWPRO	TABLE	Default
SRRCHRT	TABLE	Default
SRRLEND	TABLE	Default
SRRRATT	TABLE	Default
SRRRCMT	TABLE	Default
SRRRSRC	TABLE	Default
SRRVIST	TABLE	Default
SRRWACK	TABLE	Default
SRTADDR	TABLE	Default
SRTEMAL	TABLE	Default
SRTHSCH	TABLE	Default
SRTIDEN	TABLE	Default
SRTINTL	TABLE	Default
SRTINTS	TABLE	Default
SRTLEND	TABLE	Default
SRTMATL	TABLE	Default
SRTPCOL	TABLE	Default
SRTPERS	TABLE	Default
SRTRECR	TABLE	Default
SRTTELE	TABLE	Default
SRTTEST	TABLE	Default
SRTTPFD	TABLE	Default
STVADMT	TABLE	links
STVATTS	TABLE	links
STVATYP	TABLE	links
STVCAMP	TABLE	links
STVCHRT	TABLE	links
STVCITZ	TABLE	links
STVCNTY	TABLE	links
STVCOLL	TABLE	links
STVCTYP	TABLE	links
STVDEGC	TABLE	links
STVDEPT	TABLE	links
STVDPLM	TABLE	links
STVEGOL	TABLE	links
STVETHN	TABLE	links
STVINTS	TABLE	links
STVLEND	TABLE	links
STVLEVL	TABLE	links
STVLGCY	TABLE	links
STVMAJR	TABLE	links
STVMATL	TABLE	links
STVMRTL	TABLE	links
STVNATN	TABLE	links
STVORIG	TABLE	links
STVPREL	TABLE	links
STVRECR	TABLE	links
STVRELG	TABLE	links
STVRSTA	TABLE	links
STVRTYP	TABLE	links
STVSBGI	TABLE	links
STVSTAT	TABLE	links
STVSTYP	TABLE	links
STVTADM	TABLE	links
STVTELE	TABLE	links
STVTERM	TABLE	links
STVTESC	TABLE	links
STVTSRC	TABLE	links
STVVTYP	TABLE	links
STVWACK	TABLE	links

Comments

Model View

Table GTVEMAL

Schema Name GENERAL
Label GTVEMAL
Server name MALDEV8_B60
Creation Date 05/08/2003 12:42:16:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
GTVEMAL_CODE	GTVEMAL_CODE	VARCHAR2(4)	No	*
GTVEMAL_DESC	GTVEMAL_DESC	VARCHAR2(60)	Yes
GTVEMAL_ACTIVITY_DATE	GTVEMAL_ACTIVITY_DATE	DATE	No
GTVEMAL_DISP_WEB_IND	GTVEMAL_DISP_WEB_IND	VARCHAR2(1)	No
GTVEMAL_URL_IND	GTVEMAL_URL_IND	VARCHAR2(1)	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVEMAL	Unique	GTVEMAL_CODE

Comments

Source Code Comments

The GTVEMAL table contains the valid e-mail type codes.

Columns Comments for GTVEMAL_CODE (1)

Source Code Comments

A code identifying the type of e-mail address.

Columns Comments for GTVEMAL_DESC (2)

Source Code Comments

The description of the e-mail address.

Columns Comments for GTVEMAL_ACTIVITY_DATE (3)

Source Code Comments

The date on which the row was added or modified.

Columns Comments for GTVEMAL_DISP_WEB_IND (4)

Source Code Comments

Display on Web Indicator, Y indicates this type of email should display

Columns Comments for GTVEMAL_URL_IND (5)

Source Code Comments

URL Indicator, Y indicates that this email record is actually a URL.

Table GTVNTYP

Schema Name GENERAL
Label GTVNTYP
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:34:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
GTVNTYP_CODE	GTVNTYP_CODE	VARCHAR2(4)	No	*
GTVNTYP_DESC	GTVNTYP_DESC	VARCHAR2(30)	No
GTVNTYP_ACTIVITY_DATE	GTVNTYP_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVNTYP	Unique	GTVNTYP_CODE

Comments

Columns Comments for GTVNTYP_CODE (1)

Source Code Comments

Name Type Code

Columns Comments for GTVNTYP_DESC (2)

Source Code Comments

Name Type Code Description.

Table SMRPRLE

Schema Name SATURN
Label SMRPRLE
Server name MALDEV8_B60
Creation Date 04/28/2003 16:17:56:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SMRPRLE_PROGRAM	SMRPRLE_PROGRAM	VARCHAR2(12)	No	*
SMRPRLE_PROGRAM_DESC	SMRPRLE_PROGRAM_DESC	VARCHAR2(30)	No
SMRPRLE_ACTIVITY_DATE	SMRPRLE_ACTIVITY_DATE	DATE	No
SMRPRLE_LEVL_CODE	SMRPRLE_LEVL_CODE	VARCHAR2(2)	No		*
SMRPRLE_CURR_IND	SMRPRLE_CURR_IND	VARCHAR2(1)	No
SMRPRLE_LOCKED_IND	SMRPRLE_LOCKED_IND	VARCHAR2(1)	No
SMRPRLE_CURR_RULE_IND	SMRPRLE_CURR_RULE_IND	VARCHAR2(1)	No
SMRPRLE_CAMP_CODE	SMRPRLE_CAMP_CODE	VARCHAR2(3)	Yes		*
SMRPRLE_COLL_CODE	SMRPRLE_COLL_CODE	VARCHAR2(2)	Yes		*
SMRPRLE_DEGC_CODE	SMRPRLE_DEGC_CODE	VARCHAR2(6)	Yes		*
SMRPRLE_PIDM	SMRPRLE_PIDM	NUMBER(8,0)	Yes
SMRPRLE_LEVL_CODE_STU	SMRPRLE_LEVL_CODE_STU	VARCHAR2(2)	No		*
SMRPRLE_WEB_IND	SMRPRLE_WEB_IND	VARCHAR2(1)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SMRPRLE_CAMP_CODE	STVCAMP_CODE	STVCAMP
SMRPRLE_COLL_CODE	STVCOLL_CODE	STVCOLL
SMRPRLE_DEGC_CODE	STVDEGC_CODE	STVDEGC

Index

Index Name	Index Type	Column Name
PK_SMRPRLE	Unique	SMRPRLE_PROGRAM

Comments

Source Code Comments

Program Rules Table

Columns Comments for SMRPRLE_PROGRAM (1)

Source Code Comments

A program code which will represent a specific university program.

Columns Comments for SMRPRLE_PROGRAM_DESC (2)

Source Code Comments

Program description which further describes program code.

Columns Comments for SMRPRLE_ACTIVITY_DATE (3)

Source Code Comments

Date of most recent activity.

Columns Comments for SMRPRLE_LEVL_CODE (4)

Source Code Comments

Course Level Code.

Columns Comments for SMRPRLE_CURR_IND (5)

Source Code Comments

Curriculum indicator.

Columns Comments for SMRPRLE_LOCKED_IND (6)

Source Code Comments

Program locked indicator.

Columns Comments for SMRPRLE_CURR_RULE_IND (7)

Source Code Comments

Curriculum rules attachment. Value will be (Y) if program is on SOACURR, and (N) if program is not on SOACURR.

Columns Comments for SMRPRLE_CAMP_CODE (8)

Source Code Comments

Campus code.

Columns Comments for SMRPRLE_COLL_CODE (9)

Source Code Comments

Required if program is curriculum dependent.

Columns Comments for SMRPRLE_DEGC_CODE (10)

Source Code Comments

Required if program is curriculum dependent.

Columns Comments for SMRPRLE_PIDM (11)

Source Code Comments

Unique student identifier which may be present if this program has been designated as unique to a particular student

Columns Comments for SMRPRLE_LEVL_CODE_STU (12)

Source Code Comments

Student Level Code.

Columns Comments for SMRPRLE_WEB_IND (13)

Source Code Comments

SMRPRLE_WEB_IND : This field indicates whether the Program code and/or description can be displayed on the web for what-if or degree shopping fucntionality.

Table SORMATT

Schema Name SATURN
Label SORMATT
Server name MALDEV8_B60
Creation Date 04/15/2002 18:12:33:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SORMATT_MATL_CODE	SORMATT_MATL_CODE	VARCHAR2(4)	No	*	*
SORMATT_ATTR_CODE	SORMATT_ATTR_CODE	VARCHAR2(4)	No	*	*
SORMATT_ATTR_CODE	SORMATT_ATTR_CODE	VARCHAR2(4)	No	*	*
SORMATT_ACTIVITY_DATE	SORMATT_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SORMATT_MATL_CODE	STVMATL_CODE	STVMATL
SORMATT_ATTR_CODE	SARAATT_ATTS_CODE	SARAATT
SORMATT_ATTR_CODE	SRRRATT_ATTS_CODE	SRRRATT

Index

Index Name	Index Type	Column Name
PK_SORMATT	Unique	SORMATT_MATL_CODE
PK_SORMATT	Unique	SORMATT_ATTR_CODE

Comments

Source Code Comments

Material Attribute Repeating Table

Columns Comments for SORMATT_MATL_CODE (1)

Source Code Comments

Material code associated with attribute.

Columns Comments for SORMATT_ATTR_CODE (2)

Source Code Comments

Attribute associated with material.

Columns Comments for SORMATT_ACTIVITY_DATE (3)

Source Code Comments

The date the record was created or last updated.

Table SORMSRC

Schema Name SATURN
Label SORMSRC
Server name MALDEV8_B60
Creation Date 08/29/2002 07:22:05:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SORMSRC_MATL_CODE	SORMSRC_MATL_CODE	VARCHAR2(4)	No	*	*
SORMSRC_SBGI_CODE	SORMSRC_SBGI_CODE	VARCHAR2(6)	No	*	*
SORMSRC_SBGI_CODE	SORMSRC_SBGI_CODE	VARCHAR2(6)	No	*	*
SORMSRC_SBGI_CODE	SORMSRC_SBGI_CODE	VARCHAR2(6)	No	*	*
SORMSRC_ACTIVITY_DATE	SORMSRC_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SORMSRC_MATL_CODE	STVMATL_CODE	STVMATL
SORMSRC_SBGI_CODE	STVSBGI_CODE	STVSBGI
SORMSRC_SBGI_CODE	SRRRSRC_SBGI_CODE	SRRRSRC
SORMSRC_SBGI_CODE	SARRSRC_SBGI_CODE	SARRSRC

Index

Index Name	Index Type	Column Name
PK_SORMSRC	Unique	SORMSRC_MATL_CODE
PK_SORMSRC	Unique	SORMSRC_SBGI_CODE

Comments

Source Code Comments

Material codes for application/recruit source code.

Columns Comments for SORMSRC_MATL_CODE (1)

Source Code Comments

Material code associated with application/recruit source code.

Columns Comments for SORMSRC_SBGI_CODE (2)

Source Code Comments

Source/Background Institution code associated with material.

Columns Comments for SORMSRC_ACTIVITY_DATE (3)

Source Code Comments

This field identifies the most recent date a record was created

Table SPBPERS

Schema Name SATURN
Label SPBPERS
Server name MALDEV8_B60
Creation Date 07/09/2003 16:26:02:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SPBPERS_PIDM	SPBPERS_PIDM	NUMBER(8,0)	No	*	*
SPBPERS_PIDM	SPBPERS_PIDM	NUMBER(8,0)	No	*	*
SPBPERS_PIDM	SPBPERS_PIDM	NUMBER(8,0)	No	*	*
SPBPERS_PIDM	SPBPERS_PIDM	NUMBER(8,0)	No	*	*
SPBPERS_PIDM	SPBPERS_PIDM	NUMBER(8,0)	No	*	*
SPBPERS_PIDM	SPBPERS_PIDM	NUMBER(8,0)	No	*	*
SPBPERS_PIDM	SPBPERS_PIDM	NUMBER(8,0)	No	*	*
SPBPERS_PIDM	SPBPERS_PIDM	NUMBER(8,0)	No	*	*
SPBPERS_PIDM	SPBPERS_PIDM	NUMBER(8,0)	No	*	*
SPBPERS_PIDM	SPBPERS_PIDM	NUMBER(8,0)	No	*	*
SPBPERS_PIDM	SPBPERS_PIDM	NUMBER(8,0)	No	*	*
SPBPERS_PIDM	SPBPERS_PIDM	NUMBER(8,0)	No	*	*
SPBPERS_PIDM	SPBPERS_PIDM	NUMBER(8,0)	No	*	*
SPBPERS_PIDM	SPBPERS_PIDM	NUMBER(8,0)	No	*	*
SPBPERS_PIDM	SPBPERS_PIDM	NUMBER(8,0)	No	*	*
SPBPERS_PIDM	SPBPERS_PIDM	NUMBER(8,0)	No	*	*
SPBPERS_PIDM	SPBPERS_PIDM	NUMBER(8,0)	No	*	*
SPBPERS_PIDM	SPBPERS_PIDM	NUMBER(8,0)	No	*	*
SPBPERS_PIDM	SPBPERS_PIDM	NUMBER(8,0)	No	*	*
SPBPERS_PIDM	SPBPERS_PIDM	NUMBER(8,0)	No	*	*
SPBPERS_PIDM	SPBPERS_PIDM	NUMBER(8,0)	No	*	*
SPBPERS_PIDM	SPBPERS_PIDM	NUMBER(8,0)	No	*	*
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_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

Foreign Key information

Column name	is Foreign Key For Column	on Table
SPBPERS_RELG_CODE	STVRELG_CODE	STVRELG
SPBPERS_CITZ_CODE	STVCITZ_CODE	STVCITZ
SPBPERS_MRTL_CODE	STVMRTL_CODE	STVMRTL
SPBPERS_LGCY_CODE	STVLGCY_CODE	STVLGCY
SPBPERS_ETHN_CODE	STVETHN_CODE	STVETHN
SPBPERS_NATN_CODE_DRIVER	STVNATN_CODE	STVNATN
SPBPERS_PIDM	SGBSTDN_PIDM	SGBSTDN
SPBPERS_PIDM	TBRISTL_PIDM	TBRISTL
SPBPERS_PIDM	RPRATRM_PIDM	RPRATRM
SPBPERS_PIDM	SHRTTRM_PIDM	SHRTTRM
SPBPERS_PIDM	TBRACCD_PIDM	TBRACCD
SPBPERS_PIDM	TBRDEPO_PIDM	TBRDEPO
SPBPERS_PIDM	GORSEVD_DEP_PIDM	GORSEVD
SPBPERS_PIDM	GOBSEVS_PIDM	GOBSEVS
SPBPERS_PIDM	APRCHIS_PIDM	APRCHIS
SPBPERS_PIDM	PEBEMPL_PIDM	PEBEMPL
SPBPERS_PIDM	NBRBJOB_PIDM	NBRBJOB
SPBPERS_PIDM	APRXREF_XREF_PIDM	APRXREF
SPBPERS_PIDM	SPRMEDI_PIDM	SPRMEDI
SPBPERS_PIDM	APRACYR_PIDM	APRACYR
SPBPERS_PIDM	SHRLGPA_PIDM	SHRLGPA
SPBPERS_PIDM	SARADAP_PIDM	SARADAP
SPBPERS_PIDM	RORSTAT_PIDM	RORSTAT
SPBPERS_PIDM	SFBETRM_PIDM	SFBETRM
SPBPERS_PIDM	SRBRECR_PIDM	SRBRECR
SPBPERS_CITZ_CODE	SARDCSN_CITZ_CODE	SARDCSN
SPBPERS_PIDM	SIBINST_PIDM	SIBINST
SPBPERS_PIDM	SRRRSRC_PIDM	SRRRSRC
SPBPERS_PIDM	APRDHIS_PIDM	APRDHIS
SPBPERS_PIDM	SLRRMAT_PIDM	SLRRMAT

Index

Index Name	Index Type	Column Name
PK_SPBPERS	Unique	SPBPERS_PIDM
SPBPERS_SSN_INDEX		SPBPERS_SSN

Comments

Source Code Comments

Basic Person Base Table

Impact job : SPBPERS_COLUMN SPBPERS_column2

Columns Comments for SPBPERS_PIDM (1)

Source Code Comments

Internal Identification Number of Person.

Columns Comments for SPBPERS_SSN (2)

Source Code Comments

This field maintains person social security number.

Columns Comments for SPBPERS_BIRTH_DATE (3)

Source Code Comments

This field maintains person birth date.

Columns Comments for SPBPERS_LGCY_CODE (4)

Source Code Comments

This field maintains legacy code associated with person.

Columns Comments for SPBPERS_ETHN_CODE (5)

Source Code Comments

This field maintains ethnicity code associated with person.

Columns Comments for SPBPERS_MRTL_CODE (6)

Source Code Comments

This field maintains martial status associated with person.

Columns Comments for SPBPERS_RELG_CODE (7)

Source Code Comments

This field maintains religious affiliation associated with person.

Columns Comments for SPBPERS_SEX (8)

Source Code Comments

This field maintains the sex of person. Valid values are: M - Male, F - Female, N - Unknown.

Columns Comments for SPBPERS_CONFID_IND (9)

Source Code Comments

This field identifies if a person record is confidential Valid value is: Y - confidential.

Columns Comments for SPBPERS_DEAD_IND (10)

Source Code Comments

This field indicates if a person is deceased. Valid value is: Y - deceased.

Columns Comments for SPBPERS_VETC_FILE_NUMBER (11)

Source Code Comments

This field maintains veteran identification number associated with person.

Columns Comments for SPBPERS_LEGAL_NAME (12)

Source Code Comments

This field maintains legal name associated with person.

Columns Comments for SPBPERS_PREF_FIRST_NAME (13)

Source Code Comments

This field maintains the preferred first name associated with person.

Columns Comments for SPBPERS_NAME_PREFIX (14)

Source Code Comments

This field maintains the prefix (Mr, Mrs, etc) used before person name.

Columns Comments for SPBPERS_NAME_SUFFIX (15)

Source Code Comments

This field maintains the suffix (Jr, Sr, etc) used after person name.

Columns Comments for SPBPERS_ACTIVITY_DATE (16)

Source Code Comments

This field defines the most current date a record is added or changed.

Columns Comments for SPBPERS_VERA_IND (17)

Source Code Comments

Veteran Category. None, (O)ther Protected Veteran Only, (V)ietnam Veteran only, (B)oth Vietnam and Other Eligible Veteran.

Columns Comments for SPBPERS_CITZ_IND (18)

Source Code Comments

Citizen Indicator.

Columns Comments for SPBPERS_DEAD_DATE (19)

Source Code Comments

Person Deceased Date.

Columns Comments for SPBPERS_PIN (20)

Source Code Comments

Person Identification Number. This column is obsolete, now gobtpac_pin

Columns Comments for SPBPERS_CITZ_CODE (21)

Source Code Comments

Person Citizen Type

Columns Comments for SPBPERS_HAIR_CODE (22)

Source Code Comments

The hair color of the person being defined.

Columns Comments for SPBPERS_EYES_CODE (23)

Source Code Comments

The eye color of the person being defined.

Columns Comments for SPBPERS_CITY_BIRTH (24)

Source Code Comments

The city where the person was born.

Columns Comments for SPBPERS_STAT_CODE_BIRTH (25)

Source Code Comments

The state in which the person was born.

Columns Comments for SPBPERS_DRIVER_LICENSE (26)

Source Code Comments

The Driver License Number as it appears on the actual license.

Columns Comments for SPBPERS_STAT_CODE_DRIVER (27)

Source Code Comments

The State code describing the state the driver license was issued.

Columns Comments for SPBPERS_NATN_CODE_DRIVER (28)

Source Code Comments

The Nation code associated with the Nation the Driver license was issued.

Columns Comments for SPBPERS_UOMS_CODE_HEIGHT (29)

Source Code Comments

The Unit of Measure describing the height value.

Columns Comments for SPBPERS_HEIGHT (30)

Source Code Comments

The number value describing the height of the person.

Columns Comments for SPBPERS_UOMS_CODE_WEIGHT (31)

Source Code Comments

The Unit of Measure describing the weight value.

Columns Comments for SPBPERS_WEIGHT (32)

Source Code Comments

The number value describing the weight of the person.

Columns Comments for SPBPERS_SDVET_IND (33)

Source Code Comments

Indicator to identify an individual as a special disabled veteran.

Columns Comments for SPBPERS_LICENSE_ISSUED_DATE (34)

Source Code Comments

The issue date of the individuals driver license.

Columns Comments for SPBPERS_LICENSE_EXPIRES_DATE (35)

Source Code Comments

The expiration date of the individuals driver license.

Columns Comments for SPBPERS_INCAR_IND (36)

Source Code Comments

The indication of the individuals incarceration.

Columns Comments for SPBPERS_WEBID (37)

Source Code Comments

Web identification session token is now obsolete.

Columns Comments for SPBPERS_WEB_LAST_ACCESS (38)

Source Code Comments

Web last access time stamp is now obsolete.

Columns Comments for SPBPERS_PIN_DISABLED_IND (39)

Source Code Comments

Indicates whether or not the PIN number is disabled. This column is obsolete, now gobtpac_pin_disabled_ind

Columns Comments for SPBPERS_ITIN (40)

Source Code Comments

The international tax id number.

Columns Comments for SPBPERS_ACTIVE_DUTY_SEPR_DATE (41)

Source Code Comments

Active Duty Separation Date: The Date that the person was separated from active duty.

Table SPRIDEN

Schema Name SATURN
Label SPRIDEN
Server name MALDEV8_B60
Creation Date 08/01/2003 10:01:36:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No	*
SPRIDEN_PIDM	SPRIDEN_PIDM	NUMBER(8,0)	No