Model General Person

Model Label : ERD for Banner Student General Person Module (SP% Tables )
Path : BANNER DEV/Student/General_Person/General_Person_ERD/General Person

List of Objects

Object Name	Object Type	Layer Name
GTVSDAX	TABLE	Links
PEREACC	TABLE	Links
SFBETRM	TABLE	Links
SPRAPIN	TABLE	Tables
SPRCMNT	TABLE	Tables
SPRCOLR	TABLE	Tables
SPREMRG	TABLE	Tables
SPRHOLD	TABLE	Tables
SPRINTL	TABLE	Tables
SPRMEDI	TABLE	Tables
SPRTELE	TABLE	Tables
SPTADDR	TABLE	Tables
SPTIDEN	TABLE	Tables
SPTPERS	TABLE	Tables
STVADMR	TABLE	Links
STVATYP	TABLE	Links
STVCMTT	TABLE	Links
STVCTYP	TABLE	Links
STVDISA	TABLE	Links
STVEMPT	TABLE	Links
STVHLDD	TABLE	Links
STVLANG	TABLE	Links
STVMDEQ	TABLE	Links
STVMEDI	TABLE	Links
STVNATN	TABLE	Links
STVORIG	TABLE	Links
STVPENT	TABLE	Links
STVRELT	TABLE	Links
STVSPON	TABLE	Links
STVSPSR	TABLE	Links
STVSTAT	TABLE	Links
STVTELE	TABLE	Links

Comments

Model View

Table GTVSDAX

Schema Name GENERAL
Label GTVSDAX
Server name MALDEV8_B60
Creation Date 04/28/2003 16:18:08:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_EXTERNAL_CODE	GTVSDAX_EXTERNAL_CODE	VARCHAR2(15)	No	*
GTVSDAX_INTERNAL_CODE	GTVSDAX_INTERNAL_CODE	VARCHAR2(10)	No	*
GTVSDAX_INTERNAL_CODE	GTVSDAX_INTERNAL_CODE	VARCHAR2(10)	No	*
GTVSDAX_REPORTING_DATE	GTVSDAX_REPORTING_DATE	DATE	Yes
GTVSDAX_TRANSLATION_CODE	GTVSDAX_TRANSLATION_CODE	VARCHAR2(15)	Yes
GTVSDAX_INTERNAL_CODE_SEQNO	GTVSDAX_INTERNAL_CODE_SEQNO	NUMBER(2,0)	Yes
GTVSDAX_INTERNAL_CODE_GROUP	GTVSDAX_INTERNAL_CODE_GROUP	VARCHAR2(20)	No
GTVSDAX_DESC	GTVSDAX_DESC	VARCHAR2(30)	No
GTVSDAX_SYSREQ_IND	GTVSDAX_SYSREQ_IND	VARCHAR2(1)	Yes
GTVSDAX_ACTIVITY_DATE	GTVSDAX_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GTVSDAX_EXTERNAL_CODE	SSBSECT_SSTS_CODE	SSBSECT
GTVSDAX_INTERNAL_CODE	SORPCOL_SBGI_CODE	SORPCOL
GTVSDAX_INTERNAL_CODE	SPRMEDI_MEDI_CODE	SPRMEDI
GTVSDAX_EXTERNAL_CODE	PERJTOT_EARN_CODE	PERJTOT
GTVSDAX_EXTERNAL_CODE	SRBRECR_LEVL_CODE	SRBRECR
GTVSDAX_EXTERNAL_CODE	SARADAP_LEVL_CODE	SARADAP
GTVSDAX_EXTERNAL_CODE	SFRRSTS_RSTS_CODE	SFRRSTS
GTVSDAX_EXTERNAL_CODE	SARAPPD_APDC_CODE	SARAPPD
GTVSDAX_EXTERNAL_CODE	SORBCHR_BCHR_CODE	SORBCHR
GTVSDAX_EXTERNAL_CODE	SORTEST_TESC_CODE	SORTEST

Index

Index Name	Index Type	Column Name
GTVSDAX_KEY_INDEX	Unique	GTVSDAX_INTERNAL_CODE_GROUP
GTVSDAX_KEY_INDEX	Unique	GTVSDAX_INTERNAL_CODE
GTVSDAX_KEY_INDEX	Unique	GTVSDAX_EXTERNAL_CODE
GTVSDAX_KEY_INDEX	Unique	GTVSDAX_INTERNAL_CODE_SEQNO

Comments

Source Code Comments

SDA crosswalk/conversion table

Columns Comments for GTVSDAX_EXTERNAL_CODE (1)

Source Code Comments

Banner/concept code for to be retrieved

Columns Comments for GTVSDAX_INTERNAL_CODE (2)

Source Code Comments

The pre-determined SDA retrieval code

Columns Comments for GTVSDAX_REPORTING_DATE (3)

Source Code Comments

The date column used for various reporting needs

Columns Comments for GTVSDAX_TRANSLATION_CODE (4)

Source Code Comments

The hard-coded translation of the user defined external code, eg. Freshman, PUB for Public School, etc

Columns Comments for GTVSDAX_INTERNAL_CODE_SEQNO (5)

Source Code Comments

The sequence number for internal codes requiring multiple values

Columns Comments for GTVSDAX_INTERNAL_CODE_GROUP (6)

Source Code Comments

The group typing for translated or crosswalked values to specifically identify which grouping each series of codes belongs too

Columns Comments for GTVSDAX_DESC (7)

Source Code Comments

The description of the SDA code/concept

Columns Comments for GTVSDAX_SYSREQ_IND (8)

Source Code Comments

A Y in this field indicates that this row is required for production processing

Columns Comments for GTVSDAX_ACTIVITY_DATE (9)

Source Code Comments

The last activity date for this row of data

Table PEREACC

Schema Name PAYROLL
Label PEREACC
Server name MALDEV8_B60
Creation Date 04/15/2003 11:17:25:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
PEREACC_PIDM	PEREACC_PIDM	NUMBER(8,0)	No	*	*
PEREACC_POSN	PEREACC_POSN	VARCHAR2(6)	No	*
PEREACC_SUFF	PEREACC_SUFF	VARCHAR2(2)	No	*
PEREACC_REQUEST_DATE	PEREACC_REQUEST_DATE	DATE	No	*
PEREACC_RQST_CODE	PEREACC_RQST_CODE	VARCHAR2(4)	No		*
PEREACC_MEDI_CODE	PEREACC_MEDI_CODE	VARCHAR2(2)	No	*	*
PEREACC_MEDI_CODE	PEREACC_MEDI_CODE	VARCHAR2(2)	No	*	*
PEREACC_VERIFY_IND	PEREACC_VERIFY_IND	VARCHAR2(1)	No
PEREACC_MDEQ_CODE	PEREACC_MDEQ_CODE	VARCHAR2(3)	No	*	*
PEREACC_USER_ID	PEREACC_USER_ID	VARCHAR2(30)	No
PEREACC_ACTIVITY_DATE	PEREACC_ACTIVITY_DATE	DATE	No
PEREACC_ACST_CODE	PEREACC_ACST_CODE	VARCHAR2(4)	Yes		*
PEREACC_DISA_CODE	PEREACC_DISA_CODE	VARCHAR2(2)	Yes		*
PEREACC_BEGIN_DATE	PEREACC_BEGIN_DATE	DATE	Yes
PEREACC_END_DATE	PEREACC_END_DATE	DATE	Yes
PEREACC_COMMENT	PEREACC_COMMENT	VARCHAR2(2000)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
PEREACC_ACST_CODE	PTVACST_CODE	PTVACST
PEREACC_RQST_CODE	PTVRQST_CODE	PTVRQST
PEREACC_MEDI_CODE	STVMEDI_CODE	STVMEDI
PEREACC_DISA_CODE	STVDISA_CODE	STVDISA
PEREACC_PIDM	SPRMEDI_PIDM	SPRMEDI
PEREACC_MEDI_CODE	SPRMEDI_MEDI_CODE	SPRMEDI
PEREACC_MDEQ_CODE	STVMDEQ_CODE	STVMDEQ

Index

Index Name	Index Type	Column Name
PK_PEREACC	Unique	PEREACC_PIDM
PK_PEREACC	Unique	PEREACC_POSN
PK_PEREACC	Unique	PEREACC_SUFF
PK_PEREACC	Unique	PEREACC_REQUEST_DATE
PK_PEREACC	Unique	PEREACC_MEDI_CODE
PK_PEREACC	Unique	PEREACC_MDEQ_CODE

Comments

Source Code Comments

Employee Accommodation Tracking Table

Columns Comments for PEREACC_PIDM (1)

Source Code Comments

PIDM: Internal Person ID Number.

Columns Comments for PEREACC_POSN (2)

Source Code Comments

POSITION: Position code associated with the job assignment.

Columns Comments for PEREACC_SUFF (3)

Source Code Comments

SUFFIX: The suffix associated with the position.

Columns Comments for PEREACC_REQUEST_DATE (4)

Source Code Comments

REQUEST_DATE: It is the date the information was initiated on behalf of the staff member by the department to provide the accommodation.

Columns Comments for PEREACC_RQST_CODE (5)

Source Code Comments

RQST_CODE: Request Status is the status of the request and indicates whether accommodation will be provided or not.

Columns Comments for PEREACC_MEDI_CODE (6)

Source Code Comments

MEDICAL_CODE: Med Code is associated with the persons medical condition/physical impairment.

Columns Comments for PEREACC_VERIFY_IND (7)

Source Code Comments

VERIFY_IND: An indicator to determine whether medical verification has been received.

Columns Comments for PEREACC_MDEQ_CODE (8)

Source Code Comments

EQUIPMENT_CODE: Indicates which equipment is necessary to respond to the medical conditions identified on this table.

Columns Comments for PEREACC_USER_ID (9)

Source Code Comments

USER ID: User ID of the User who created or last updated the record.

Columns Comments for PEREACC_ACTIVITY_DATE (10)

Source Code Comments

ACTIVITY DATE: The date the record was created or last updated.

Columns Comments for PEREACC_ACST_CODE (11)

Source Code Comments

ACST_CODE: It is the status of the accommodation for this job, example is Active.

Columns Comments for PEREACC_DISA_CODE (12)

Source Code Comments

DISA_CODE: The codes utilized here identify the nature of a disability.

Columns Comments for PEREACC_BEGIN_DATE (13)

Source Code Comments

BEGIN_DATE: The beginning date the institution provided the accommodation to the staff member.

Columns Comments for PEREACC_END_DATE (14)

Source Code Comments

END_DATE: The end date of the accommodation.

Columns Comments for PEREACC_COMMENT (15)

Source Code Comments

COMMENTS: Comments for the accommodation.

Table SFBETRM

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SFBETRM_TERM_CODE	SFBETRM_TERM_CODE	VARCHAR2(6)	No	*	*
SFBETRM_TERM_CODE	SFBETRM_TERM_CODE	VARCHAR2(6)	No	*	*
SFBETRM_PIDM	SFBETRM_PIDM	NUMBER(8,0)	No	*	*
SFBETRM_ESTS_CODE	SFBETRM_ESTS_CODE	VARCHAR2(2)	No		*
SFBETRM_ESTS_DATE	SFBETRM_ESTS_DATE	DATE	Yes
SFBETRM_MHRS_OVER	SFBETRM_MHRS_OVER	NUMBER(9,3)	No
SFBETRM_AR_IND	SFBETRM_AR_IND	VARCHAR2(1)	No
SFBETRM_ASSESSMENT_DATE	SFBETRM_ASSESSMENT_DATE	DATE	Yes
SFBETRM_ADD_DATE	SFBETRM_ADD_DATE	DATE	No
SFBETRM_ACTIVITY_DATE	SFBETRM_ACTIVITY_DATE	DATE	No
SFBETRM_RGRE_CODE	SFBETRM_RGRE_CODE	VARCHAR2(2)	Yes		*
SFBETRM_TMST_CODE	SFBETRM_TMST_CODE	VARCHAR2(2)	Yes		*
SFBETRM_TMST_DATE	SFBETRM_TMST_DATE	DATE	Yes
SFBETRM_TMST_MAINT_IND	SFBETRM_TMST_MAINT_IND	VARCHAR2(1)	Yes
SFBETRM_USER	SFBETRM_USER	VARCHAR2(30)	Yes
SFBETRM_REFUND_DATE	SFBETRM_REFUND_DATE	DATE	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SFBETRM_RGRE_CODE	STVRGRE_CODE	STVRGRE
SFBETRM_TERM_CODE	STVTERM_CODE	STVTERM
SFBETRM_ESTS_CODE	STVESTS_CODE	STVESTS
SFBETRM_TMST_CODE	STVTMST_CODE	STVTMST
SFBETRM_PIDM	SRBRECR_PIDM	SRBRECR
SFBETRM_TERM_CODE	SRBRECR_TERM_CODE	SRBRECR

Index

Index Name	Index Type	Column Name
PK_SFBETRM	Unique	SFBETRM_PIDM
PK_SFBETRM	Unique	SFBETRM_TERM_CODE
SFBETRM_KEY_INDEX2		SFBETRM_TERM_CODE

Comments

Source Code Comments

Student Registration Table

Impact job : SFBETRM_ESTS_CODE SFBETRM_ESTS_CODE

Columns Comments for SFBETRM_TERM_CODE (1)

Source Code Comments

This field identifies term associated with this registration.

Columns Comments for SFBETRM_PIDM (2)

Source Code Comments

Internal Identification Number of the person registered .

Columns Comments for SFBETRM_ESTS_CODE (3)

Source Code Comments

This field identifies the student enrollment status code.

Columns Comments for SFBETRM_ESTS_DATE (4)

Source Code Comments

This field identifies the date associated with the student enrollment status code.

Columns Comments for SFBETRM_MHRS_OVER (5)

Source Code Comments

This field identifies the maximum hours override for this term.

Columns Comments for SFBETRM_AR_IND (6)

Source Code Comments

This field identifies the term charges acceptance indicator.

Columns Comments for SFBETRM_ASSESSMENT_DATE (7)

Source Code Comments

This field identifies the date of the assessment for this term.

Columns Comments for SFBETRM_ADD_DATE (8)

Source Code Comments

This field identifies the date of the initial registration for this term.

Columns Comments for SFBETRM_ACTIVITY_DATE (9)

Source Code Comments

This field specifies the most current date the record was created or updated.

Columns Comments for SFBETRM_RGRE_CODE (10)

Source Code Comments

Student Registration Reason Code.

Columns Comments for SFBETRM_TMST_CODE (11)

Source Code Comments

Most recently calculated time status code.

Columns Comments for SFBETRM_TMST_DATE (12)

Source Code Comments

Date change in time status occurred.

Columns Comments for SFBETRM_TMST_MAINT_IND (13)

Source Code Comments

Flag indicating whether the change in time status was calculated by the system or overridden and updated by a user.

Columns Comments for SFBETRM_USER (14)

Source Code Comments

The ID of the user who updated or created the record.

Columns Comments for SFBETRM_REFUND_DATE (15)

Source Code Comments

Refund by total refund date used in performing fee assessment. Date is needed for refund by total processing to determine the refund period used in the last assessment.

Table SPRAPIN

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

Table Columns information

Column Name	Label	Column Type	Allow NULL
SPRAPIN_TERM_CODE	SPRAPIN_TERM_CODE	VARCHAR2(6)	No
SPRAPIN_PIDM	SPRAPIN_PIDM	NUMBER(8,0)	No
SPRAPIN_PROCESS_NAME	SPRAPIN_PROCESS_NAME	VARCHAR2(15)	No
SPRAPIN_PIN	SPRAPIN_PIN	VARCHAR2(6)	No
SPRAPIN_ACTIVITY_DATE	SPRAPIN_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
SPRAPIN_KEY_INDEX	Unique	SPRAPIN_TERM_CODE
SPRAPIN_KEY_INDEX	Unique	SPRAPIN_PIDM
SPRAPIN_KEY_INDEX	Unique	SPRAPIN_PROCESS_NAME

Comments

Source Code Comments

Student Alternate PIN Table

Columns Comments for SPRAPIN_TERM_CODE (1)

Source Code Comments

Term code for which this alternate PIN is valid.

Columns Comments for SPRAPIN_PIDM (2)

Source Code Comments

PIDM which will use this alternate PIN.

Columns Comments for SPRAPIN_PROCESS_NAME (3)

Source Code Comments

Process name which will utilize this alternate PIN.

Columns Comments for SPRAPIN_PIN (4)

Source Code Comments

The assigned alternate PIN which will be used for the this individual for the named process.

Columns Comments for SPRAPIN_ACTIVITY_DATE (5)

Source Code Comments

Date of this record's creation or last update.

Table SPRCMNT

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SPRCMNT_PIDM	SPRCMNT_PIDM	NUMBER(8,0)	No
SPRCMNT_CMTT_CODE	SPRCMNT_CMTT_CODE	VARCHAR2(3)	No	*
SPRCMNT_TEXT	SPRCMNT_TEXT	VARCHAR2(4000)	Yes
SPRCMNT_TEXT_NAR	SPRCMNT_TEXT_NAR	CLOB	Yes
SPRCMNT_CONFIDENTIAL_IND	SPRCMNT_CONFIDENTIAL_IND	VARCHAR2(1)	Yes
SPRCMNT_DATE	SPRCMNT_DATE	DATE	Yes
SPRCMNT_ORIG_CODE	SPRCMNT_ORIG_CODE	VARCHAR2(4)	Yes	*
SPRCMNT_ACTIVITY_DATE	SPRCMNT_ACTIVITY_DATE	DATE	No
SPRCMNT_CTYP_CODE	SPRCMNT_CTYP_CODE	VARCHAR2(4)	Yes	*
SPRCMNT_CONTACT_DATE	SPRCMNT_CONTACT_DATE	DATE	Yes
SPRCMNT_USER_ID	SPRCMNT_USER_ID	VARCHAR2(30)	Yes
SPRCMNT_CONTACT_FROM_TIME	SPRCMNT_CONTACT_FROM_TIME	NUMBER(4,0)	Yes
SPRCMNT_CONTACT_TO_TIME	SPRCMNT_CONTACT_TO_TIME	NUMBER(4,0)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SPRCMNT_CMTT_CODE	STVCMTT_CODE	STVCMTT
SPRCMNT_CTYP_CODE	STVCTYP_CODE	STVCTYP
SPRCMNT_ORIG_CODE	STVORIG_CODE	STVORIG

Index

Index Name	Index Type	Column Name
SPRCMNT_INDEX		SPRCMNT_PIDM
SPRCMNT_INDEX		SPRCMNT_CMTT_CODE

Comments

Source Code Comments

Person Comments Repeating Table

Columns Comments for SPRCMNT_PIDM (1)

Source Code Comments

Internal identification number of person.

Columns Comments for SPRCMNT_CMTT_CODE (2)

Source Code Comments

This field identifies the comment type associated with person record.

Columns Comments for SPRCMNT_TEXT (3)

Source Code Comments

This field maintains the text of the comment associated with person record.

Columns Comments for SPRCMNT_TEXT_NAR (4)

Source Code Comments

This field maintains large narrative comment associated with person record.

Columns Comments for SPRCMNT_CONFIDENTIAL_IND (5)

Source Code Comments

A Y value in this field indicates that the comment associated with person record is confidential.

Columns Comments for SPRCMNT_DATE (6)

Source Code Comments

This field indicates the date comment was added to the person record.

Columns Comments for SPRCMNT_ORIG_CODE (7)

Source Code Comments

This field identifies originator of the comment associated with person record.

Columns Comments for SPRCMNT_ACTIVITY_DATE (8)

Source Code Comments

This field defines the most current date the record is added or changed. This field does not display on the screen.

Columns Comments for SPRCMNT_CTYP_CODE (9)

Source Code Comments

Contact code how the comment's contents originated.

Columns Comments for SPRCMNT_CONTACT_DATE (10)

Source Code Comments

Contact date/time when the comment's contents originated.

Columns Comments for SPRCMNT_USER_ID (11)

Source Code Comments

This field identifies the most recent user that updated the record.

Columns Comments for SPRCMNT_CONTACT_FROM_TIME (12)

Source Code Comments

Appointment from time if the comment refers back to an appointment.

Columns Comments for SPRCMNT_CONTACT_TO_TIME (13)

Source Code Comments

Appointment tom time if the comment refers back to an appointment.

Table SPRCOLR

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

Table Columns information

Column Name	Label	Column Type	Allow NULL
SPRCOLR_SESSIONID	SPRCOLR_SESSIONID	VARCHAR2(30)	No
SPRCOLR_TYPE	SPRCOLR_TYPE	VARCHAR2(1)	Yes
SPRCOLR_VALUE_DATE	SPRCOLR_VALUE_DATE	DATE	Yes
SPRCOLR_VALUE_ATYP	SPRCOLR_VALUE_ATYP	VARCHAR2(30)	Yes
SPRCOLR_ACTIVITY_DATE	SPRCOLR_ACTIVITY_DATE	DATE	No
SPRCOLR_JOB	SPRCOLR_JOB	VARCHAR2(30)	Yes
SPRCOLR_PARM_NUMBER	SPRCOLR_PARM_NUMBER	VARCHAR2(2)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
SPRCOLR_KEY_INDEX		SPRCOLR_SESSIONID

Comments

Source Code Comments

Person Collector Table

Columns Comments for SPRCOLR_SESSIONID (1)

Source Code Comments

Unique session identifier for collector file. Does not display on-line.

Columns Comments for SPRCOLR_TYPE (2)

Source Code Comments

Date identifier for a parameter type. Does not display on-line.

Columns Comments for SPRCOLR_VALUE_DATE (3)

Source Code Comments

Date used as parameter. Does not display on-line.

Columns Comments for SPRCOLR_VALUE_ATYP (4)

Source Code Comments

Parameter value (other than date). Does not display on-line.

Columns Comments for SPRCOLR_ACTIVITY_DATE (5)

Source Code Comments

Date record created. Does not display on-line.

Columns Comments for SPRCOLR_JOB (6)

Source Code Comments

Name of the job. Does not display on-line.

Columns Comments for SPRCOLR_PARM_NUMBER (7)

Source Code Comments

Unique job parameter number. Does not display on-line.

Table SPREMRG

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SPREMRG_PIDM	SPREMRG_PIDM	NUMBER(8,0)	No	*
SPREMRG_PRIORITY	SPREMRG_PRIORITY	VARCHAR2(1)	No	*
SPREMRG_LAST_NAME	SPREMRG_LAST_NAME	VARCHAR2(25)	No
SPREMRG_FIRST_NAME	SPREMRG_FIRST_NAME	VARCHAR2(15)	No
SPREMRG_MI	SPREMRG_MI	VARCHAR2(1)	Yes
SPREMRG_STREET_LINE1	SPREMRG_STREET_LINE1	VARCHAR2(30)	Yes
SPREMRG_STREET_LINE2	SPREMRG_STREET_LINE2	VARCHAR2(30)	Yes
SPREMRG_STREET_LINE3	SPREMRG_STREET_LINE3	VARCHAR2(30)	Yes
SPREMRG_CITY	SPREMRG_CITY	VARCHAR2(20)	Yes
SPREMRG_STAT_CODE	SPREMRG_STAT_CODE	VARCHAR2(3)	Yes		*
SPREMRG_NATN_CODE	SPREMRG_NATN_CODE	VARCHAR2(5)	Yes		*
SPREMRG_ZIP	SPREMRG_ZIP	VARCHAR2(10)	Yes
SPREMRG_PHONE_AREA	SPREMRG_PHONE_AREA	VARCHAR2(3)	Yes
SPREMRG_PHONE_NUMBER	SPREMRG_PHONE_NUMBER	VARCHAR2(7)	Yes
SPREMRG_PHONE_EXT	SPREMRG_PHONE_EXT	VARCHAR2(4)	Yes
SPREMRG_RELT_CODE	SPREMRG_RELT_CODE	VARCHAR2(1)	Yes		*
SPREMRG_ACTIVITY_DATE	SPREMRG_ACTIVITY_DATE	DATE	No
SPREMRG_ATYP_CODE	SPREMRG_ATYP_CODE	VARCHAR2(2)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
SPREMRG_ATYP_CODE	STVATYP_CODE	STVATYP
SPREMRG_RELT_CODE	STVRELT_CODE	STVRELT
SPREMRG_STAT_CODE	STVSTAT_CODE	STVSTAT
SPREMRG_NATN_CODE	STVNATN_CODE	STVNATN

Index

Index Name	Index Type	Column Name
PK_SPREMRG	Unique	SPREMRG_PIDM
PK_SPREMRG	Unique	SPREMRG_PRIORITY

Comments

Source Code Comments

Emergency Contact Repeating Table

Columns Comments for SPREMRG_PIDM (1)

Source Code Comments

Internal identification number of person.

Columns Comments for SPREMRG_PRIORITY (2)

Source Code Comments

Priority indicator associated with emergency address of person record.

Columns Comments for SPREMRG_LAST_NAME (3)

Source Code Comments

Last name of person associated with emergency address information.

Columns Comments for SPREMRG_FIRST_NAME (4)

Source Code Comments

First name of person associated with emergency address information.

Columns Comments for SPREMRG_MI (5)

Source Code Comments

Middle name of person associated with emergency address information.

Columns Comments for SPREMRG_STREET_LINE1 (6)

Source Code Comments

Line one of emergency adddress.

Columns Comments for SPREMRG_STREET_LINE2 (7)

Source Code Comments

Line two of emergency address.

Columns Comments for SPREMRG_STREET_LINE3 (8)

Source Code Comments

Line three of emergency address.

Columns Comments for SPREMRG_CITY (9)

Source Code Comments

City associated with emergency address.

Columns Comments for SPREMRG_STAT_CODE (10)

Source Code Comments

State associated with emergency address.

Columns Comments for SPREMRG_NATN_CODE (11)

Source Code Comments

Nation/country associated with emergency address.

Columns Comments for SPREMRG_ZIP (12)

Source Code Comments

Zip code associated with emergency address.

Columns Comments for SPREMRG_PHONE_AREA (13)

Source Code Comments

Area code of phone number associated with emergency address.

Columns Comments for SPREMRG_PHONE_NUMBER (14)

Source Code Comments

Phone number associated with emergency address.

Columns Comments for SPREMRG_PHONE_EXT (15)

Source Code Comments

Extension of phone number associated with emergency address.

Columns Comments for SPREMRG_RELT_CODE (16)

Source Code Comments

This field identifies the relationship between emergency contact person and and the person record.

Columns Comments for SPREMRG_ACTIVITY_DATE (17)

Source Code Comments

Most current date that the record was created or changed. This field does not display on screen.

Columns Comments for SPREMRG_ATYP_CODE (18)

Source Code Comments

The address type associated with the emergency address.

Table SPRHOLD

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
SPRHOLD_PIDM	SPRHOLD_PIDM	NUMBER(8,0)	No	*
SPRHOLD_PIDM	SPRHOLD_PIDM	NUMBER(8,0)	No	*
SPRHOLD_HLDD_CODE	SPRHOLD_HLDD_CODE	VARCHAR2(2)	No	*
SPRHOLD_USER	SPRHOLD_USER	VARCHAR2(30)	No
SPRHOLD_FROM_DATE	SPRHOLD_FROM_DATE	DATE	No
SPRHOLD_TO_DATE	SPRHOLD_TO_DATE	DATE	No
SPRHOLD_RELEASE_IND	SPRHOLD_RELEASE_IND	VARCHAR2(1)	No
SPRHOLD_REASON	SPRHOLD_REASON	VARCHAR2(30)	Yes
SPRHOLD_AMOUNT_OWED	SPRHOLD_AMOUNT_OWED	NUMBER(7,2)	Yes
SPRHOLD_ORIG_CODE	SPRHOLD_ORIG_CODE	VARCHAR2(4)	Yes	*
SPRHOLD_ACTIVITY_DATE	SPRHOLD_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
SPRHOLD_HLDD_CODE	STVHLDD_CODE	STVHLDD
SPRHOLD_ORIG_CODE	STVORIG_CODE	STVORIG
SPRHOLD_PIDM	SPRIDEN_PIDM	SPRIDEN
SPRHOLD_PIDM	SFBETRM_PIDM	SFBETRM

Index

Index Name	Index Type	Column Name
SPRHOLD_KEY_INDEX		SPRHOLD_PIDM
SPRHOLD_KEY_INDEX		SPRHOLD_HLDD_CODE
SPRHOLD_KEY_INDEX		SPRHOLD_USER
SPRHOLD_KEY_INDEX		SPRHOLD_FROM_DATE
SPRHOLD_KEY_INDEX		SPRHOLD_TO_DATE

Comments

Source Code Comments

Person Related Holds Repeating Table

Columns Comments for SPRHOLD_PIDM (1)

Source Code Comments

Internal identification number of the person.

Columns Comments for SPRHOLD_HLDD_CODE (2)

Source Code Comments

This field identifies the type of hold on person record.

Columns Comments for SPRHOLD_USER (3)

Source Code Comments

This field identifies the system user signon id initiating hold.

Columns Comments for SPRHOLD_FROM_DATE (4)

Source Code Comments

This field identifies the effective begin date of hold.

Columns Comments for SPRHOLD_TO_DATE (5)

Source Code Comments

This field identifies the end date hold expires.

Columns Comments for SPRHOLD_RELEASE_IND (6)

Source Code Comments

This field indicates that only the system user who entered the hold may release the hold. Valid value is: Y - allow only system user to release hold.

Columns Comments for SPRHOLD_REASON (7)

Source Code Comments

Free format field which identifies the reason hold was placed.

Columns Comments for SPRHOLD_AMOUNT_OWED (8)

Source Code Comments

This field identifies a dollar amount associated with hold.

Columns Comments for SPRHOLD_ORIG_CODE (9)

Source Code Comments

This field identifies person/office who authorized hold status.

Columns Comments for SPRHOLD_ACTIVITY_DATE (10)

Source Code Comments

This field defines most current date record is created or changed.

Table SPRINTL

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
SPRINTL_PIDM	SPRINTL_PIDM	NUMBER(8,0)	No	*
SPRINTL_VTYP_CODE_CURRENT	SPRINTL_VTYP_CODE_CURRENT	VARCHAR2(2)	No	*	*
SPRINTL_VISA_NUMBER	SPRINTL_VISA_NUMBER	VARCHAR2(11)	Yes
SPRINTL_VISA_ISSUE_DATE	SPRINTL_VISA_ISSUE_DATE	DATE	Yes
SPRINTL_VISA_EXPIRE_DATE	SPRINTL_VISA_EXPIRE_DATE	DATE	Yes
SPRINTL_SPON_CODE	SPRINTL_SPON_CODE	VARCHAR2(3)	Yes		*
SPRINTL_NATN_CODE_BIRTH	SPRINTL_NATN_CODE_BIRTH	VARCHAR2(5)	Yes		*
SPRINTL_NATN_CODE_LEGAL	SPRINTL_NATN_CODE_LEGAL	VARCHAR2(5)	Yes		*
SPRINTL_PASSPORT_ID	SPRINTL_PASSPORT_ID	VARCHAR2(15)	Yes
SPRINTL_PASSPORT_EXP_DATE	SPRINTL_PASSPORT_EXP_DATE	DATE	Yes
SPRINTL_ALIEN_REG_NUMBER	SPRINTL_ALIEN_REG_NUMBER	VARCHAR2(11)	Yes
SPRINTL_I20_ID_NUMBER	SPRINTL_I20_ID_NUMBER	VARCHAR2(11)	Yes
SPRINTL_I94_STATUS	SPRINTL_I94_STATUS	VARCHAR2(3)	Yes
SPRINTL_I94_DATE	SPRINTL_I94_DATE	DATE	Yes
SPRINTL_VTYP_CODE_ENTRY	SPRINTL_VTYP_CODE_ENTRY	VARCHAR2(2)	Yes		*
SPRINTL_ENTRY_DATE	SPRINTL_ENTRY_DATE	DATE	Yes
SPRINTL_ENTRY_EXP_DATE	SPRINTL_ENTRY_EXP_DATE	DATE	Yes
SPRINTL_PENT_CODE	SPRINTL_PENT_CODE	VARCHAR2(3)	Yes		*
SPRINTL_NO_ENTRIES	SPRINTL_NO_ENTRIES	VARCHAR2(2)	Yes
SPRINTL_ACTIVITY_DATE	SPRINTL_ACTIVITY_DATE	DATE	No
SPRINTL_ADMR_CODE	SPRINTL_ADMR_CODE	VARCHAR2(4)	Yes		*
SPRINTL_RECV_DATE	SPRINTL_RECV_DATE	DATE	Yes
SPRINTL_I20_DATE	SPRINTL_I20_DATE	DATE	Yes
SPRINTL_LANG_CODE	SPRINTL_LANG_CODE	VARCHAR2(3)	Yes		*
SPRINTL_I20_IND	SPRINTL_I20_IND	VARCHAR2(1)	Yes
SPRINTL_SPOUSE_IND	SPRINTL_SPOUSE_IND	VARCHAR2(1)	Yes
SPRINTL_CHILD_NUMBER	SPRINTL_CHILD_NUMBER	NUMBER(2,0)	Yes
SPRINTL_EMPT_CODE	SPRINTL_EMPT_CODE	VARCHAR2(3)	Yes		*
SPRINTL_SIGNATURE_IND	SPRINTL_SIGNATURE_IND	VARCHAR2(1)	Yes
SPRINTL_FOREIGN_SSN	SPRINTL_FOREIGN_SSN	VARCHAR2(9)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SPRINTL_EMPT_CODE	STVEMPT_CODE	STVEMPT
SPRINTL_LANG_CODE	STVLANG_CODE	STVLANG
SPRINTL_PENT_CODE	STVPENT_CODE	STVPENT
SPRINTL_ADMR_CODE	STVADMR_CODE	STVADMR
SPRINTL_SPON_CODE	STVSPON_CODE	STVSPON

Index

Index Name	Index Type	Column Name
PK_SPRINTL	Unique	SPRINTL_PIDM
PK_SPRINTL	Unique	SPRINTL_VTYP_CODE_CURRENT