Model Answer A Survey

Model Label : Web General Answer A Survey
Path : BANNER DEV/Web General/Answer_A_Survey/Answer A Survey

List of Objects

Object Name	Object Type	Layer Name
GLBEXTR	TABLE	Default
GLVEXTR	VIEW	Default
GOBSRVR	TABLE	Default
GORSRVR	TABLE	Default
GUBSRVY	TABLE	Default
GURSRVQ	TABLE	Default
GURSVRL	TABLE	Default
SPRIDEN	TABLE	Default

Comments

Model View

Table GLBEXTR

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GLBEXTR_APPLICATION	GLBEXTR_APPLICATION	VARCHAR2(30)	No	*	*
GLBEXTR_SELECTION	GLBEXTR_SELECTION	VARCHAR2(30)	No	*	*
GLBEXTR_CREATOR_ID	GLBEXTR_CREATOR_ID	VARCHAR2(30)	No	*	*
GLBEXTR_USER_ID	GLBEXTR_USER_ID	VARCHAR2(30)	No	*
GLBEXTR_KEY	GLBEXTR_KEY	VARCHAR2(80)	No	*
GLBEXTR_ACTIVITY_DATE	GLBEXTR_ACTIVITY_DATE	DATE	No
GLBEXTR_SYS_IND	GLBEXTR_SYS_IND	VARCHAR2(1)	No
GLBEXTR_SLCT_IND	GLBEXTR_SLCT_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GLBEXTR_APPLICATION	GLBSLCT_APPLICATION	GLBSLCT
GLBEXTR_SELECTION	GLBSLCT_SELECTION	GLBSLCT
GLBEXTR_CREATOR_ID	GLBSLCT_CREATOR_ID	GLBSLCT

Index

Index Name	Index Type	Column Name
PK_GLBEXTR	Unique	GLBEXTR_APPLICATION
PK_GLBEXTR	Unique	GLBEXTR_SELECTION
PK_GLBEXTR	Unique	GLBEXTR_CREATOR_ID
PK_GLBEXTR	Unique	GLBEXTR_USER_ID
PK_GLBEXTR	Unique	GLBEXTR_KEY

Comments

Source Code Comments

Population Selection Extract Base Table

Columns Comments for GLBEXTR_APPLICATION (1)

Source Code Comments

APPLICATION: The name of the Application that the Population Selection Identifier belongs to.

Columns Comments for GLBEXTR_SELECTION (2)

Source Code Comments

SELECTION: The name of the Population Selection Identifier that was used to create this Report Extract record.

Columns Comments for GLBEXTR_CREATOR_ID (3)

Source Code Comments

CREATOR ID: The ID of the creator of this Population Selection Identifier.

Columns Comments for GLBEXTR_USER_ID (4)

Source Code Comments

USER ID: The logon ID of the user who entered or last updated the record in this table.

Columns Comments for GLBEXTR_ACTIVITY_DATE (6)

Source Code Comments

ACTIVITY DATE: The date that information for this record in the table was entered or last updated

Columns Comments for GLBEXTR_SYS_IND (7)

Source Code Comments

SYSTEM INDICATOR: Indicates source of the record. Values are (S)ystem-generated by the GLBDATA process; (M)anually entered on the GLAEXTR form.

Columns Comments for GLBEXTR_SLCT_IND (8)

Source Code Comments

SELECT INDICATOR: This field is used by the Batch Group Process and indicates whether the student has been processed already.

Table GOBSRVR

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
GOBSRVR_PIDM	GOBSRVR_PIDM	NUMBER(8,0)	No	*
GOBSRVR_NAME	GOBSRVR_NAME	VARCHAR2(15)	No	*
GOBSRVR_ACTIVITY_DATE	GOBSRVR_ACTIVITY_DATE	DATE	No
GOBSRVR_USER	GOBSRVR_USER	VARCHAR2(30)	No
GOBSRVR_DECLINED_IND	GOBSRVR_DECLINED_IND	VARCHAR2(1)	No
GOBSRVR_COMPLETE_IND	GOBSRVR_COMPLETE_IND	VARCHAR2(1)	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GOBSRVR	Unique	GOBSRVR_PIDM
PK_GOBSRVR	Unique	GOBSRVR_NAME

Comments

Source Code Comments

Survey Response Header Table. This table contains one row for each person who responds to the survey.

Columns Comments for GOBSRVR_PIDM (1)

Source Code Comments

Internal Identification Number of the person who responded to the survey.

Columns Comments for GOBSRVR_NAME (2)

Source Code Comments

Survey Name.

Columns Comments for GOBSRVR_ACTIVITY_DATE (3)

Source Code Comments

The date that the person last responded to the survey.

Columns Comments for GOBSRVR_USER (4)

Source Code Comments

The User ID(Oracle) of the person who responded to the survey.

Columns Comments for GOBSRVR_DECLINED_IND (5)

Source Code Comments

Declined Indicator. Y = user declined to answer the survey.

Columns Comments for GOBSRVR_COMPLETE_IND (6)

Source Code Comments

Complete Indicator. Y indicates complete, N indicates incomplete.

Table GORSRVR

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GORSRVR_PIDM	GORSRVR_PIDM	NUMBER(8,0)	No	*	*
GORSRVR_NAME	GORSRVR_NAME	VARCHAR2(15)	No	*	*
GORSRVR_QUESTION_NO	GORSRVR_QUESTION_NO	NUMBER(3,0)	No	*
GORSRVR_ACTIVITY_DATE	GORSRVR_ACTIVITY_DATE	DATE	No
GORSRVR_USER	GORSRVR_USER	VARCHAR2(30)	No
GORSRVR_RESPONSE_1	GORSRVR_RESPONSE_1	VARCHAR2(1)	Yes
GORSRVR_RESPONSE_2	GORSRVR_RESPONSE_2	VARCHAR2(1)	Yes
GORSRVR_RESPONSE_3	GORSRVR_RESPONSE_3	VARCHAR2(1)	Yes
GORSRVR_RESPONSE_4	GORSRVR_RESPONSE_4	VARCHAR2(1)	Yes
GORSRVR_RESPONSE_5	GORSRVR_RESPONSE_5	VARCHAR2(1)	Yes
GORSRVR_COMMENTS	GORSRVR_COMMENTS	VARCHAR2(2000)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORSRVR_PIDM	GOBSRVR_PIDM	GOBSRVR
GORSRVR_NAME	GOBSRVR_NAME	GOBSRVR

Index

Index Name	Index Type	Column Name
PK_GORSRVR	Unique	GORSRVR_PIDM
PK_GORSRVR	Unique	GORSRVR_NAME
PK_GORSRVR	Unique	GORSRVR_QUESTION_NO

Comments

Source Code Comments

Survey Repsonses Repeating Table. This tables store the individual responses.

Columns Comments for GORSRVR_PIDM (1)

Source Code Comments

Internal Identification Number of the person who responded to the survey.

Columns Comments for GORSRVR_NAME (2)

Source Code Comments

Survey Name.

Columns Comments for GORSRVR_QUESTION_NO (3)

Source Code Comments

Survey Response Question Number.

Columns Comments for GORSRVR_ACTIVITY_DATE (4)

Source Code Comments

The date that the response was created or last updated.

Columns Comments for GORSRVR_USER (5)

Source Code Comments

The User ID which created or last updated the response.

Columns Comments for GORSRVR_RESPONSE_1 (6)

Source Code Comments

First possible response. Y indicates yes, N indicates no.

Columns Comments for GORSRVR_RESPONSE_2 (7)

Source Code Comments

Second possible response. Y indicates yes, N indicates no.

Columns Comments for GORSRVR_RESPONSE_3 (8)

Source Code Comments

Third possible response. Y indicates yes, N indicates no.

Columns Comments for GORSRVR_RESPONSE_4 (9)

Source Code Comments

Fourth possible response. Y indicates yes, N indicates no.

Columns Comments for GORSRVR_RESPONSE_5 (10)

Source Code Comments

Fifth possible response. Y indicates yes, N indicates no.

Columns Comments for GORSRVR_COMMENTS (11)

Source Code Comments

Free form text entered as comments by the respondent.

Table GUBSRVY

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
GUBSRVY_NAME	GUBSRVY_NAME	VARCHAR2(15)	No	*
GUBSRVY_TITLE	GUBSRVY_TITLE	VARCHAR2(60)	No
GUBSRVY_DISP_WEB_IND	GUBSRVY_DISP_WEB_IND	VARCHAR2(1)	No
GUBSRVY_ACTIVITY_DATE	GUBSRVY_ACTIVITY_DATE	DATE	No
GUBSRVY_USER	GUBSRVY_USER	VARCHAR2(30)	No
GUBSRVY_FROM_DATE	GUBSRVY_FROM_DATE	DATE	Yes
GUBSRVY_TO_DATE	GUBSRVY_TO_DATE	DATE	Yes
GUBSRVY_EXTR_APPLICATION	GUBSRVY_EXTR_APPLICATION	VARCHAR2(30)	Yes
GUBSRVY_EXTR_SELECTION	GUBSRVY_EXTR_SELECTION	VARCHAR2(30)	Yes
GUBSRVY_EXTR_CREATOR_ID	GUBSRVY_EXTR_CREATOR_ID	VARCHAR2(30)	Yes
GUBSRVY_EXTR_USER_ID	GUBSRVY_EXTR_USER_ID	VARCHAR2(30)	Yes
GUBSRVY_INFO	GUBSRVY_INFO	VARCHAR2(2000)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GUBSRVY	Unique	GUBSRVY_NAME

Comments

Source Code Comments

Survey Header Table. This tables defines the header information for surveys.

Columns Comments for GUBSRVY_NAME (1)

Source Code Comments

Survey Name.

Columns Comments for GUBSRVY_TITLE (2)

Source Code Comments

Title of the survey.

Columns Comments for GUBSRVY_DISP_WEB_IND (3)

Source Code Comments

Display on the Web Indicator, Y = display, N = do not display.

Columns Comments for GUBSRVY_ACTIVITY_DATE (4)

Source Code Comments

The date that the Survey was created or last changed.

Columns Comments for GUBSRVY_USER (5)

Source Code Comments

The User who created or last modified the Survey.

Columns Comments for GUBSRVY_FROM_DATE (6)

Source Code Comments

The date from which the Survey should be available for responses.

Columns Comments for GUBSRVY_TO_DATE (7)

Source Code Comments

The date until which the Survey should be available for responses.

Columns Comments for GUBSRVY_EXTR_APPLICATION (8)

Source Code Comments

The Population Selection Application that can respond to the Survey.

Columns Comments for GUBSRVY_EXTR_SELECTION (9)

Source Code Comments

The Population Selection Selection that can respond to the Survey.

Columns Comments for GUBSRVY_EXTR_CREATOR_ID (10)

Source Code Comments

The Population Selection Creator ID.

Columns Comments for GUBSRVY_EXTR_USER_ID (11)

Source Code Comments

The Population Selection User ID.

Columns Comments for GUBSRVY_INFO (12)

Source Code Comments

Free form text which describes the Survey and is displayed on the web.

Table GURSRVQ

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GURSRVQ_NAME	GURSRVQ_NAME	VARCHAR2(15)	No	*	*
GURSRVQ_QUESTION_NO	GURSRVQ_QUESTION_NO	NUMBER(3,0)	No	*
GURSRVQ_ACTIVITY_DATE	GURSRVQ_ACTIVITY_DATE	DATE	No
GURSRVQ_USER	GURSRVQ_USER	VARCHAR2(30)	No
GURSRVQ_MULT_RESP_IND	GURSRVQ_MULT_RESP_IND	VARCHAR2(1)	No
GURSRVQ_TEXT	GURSRVQ_TEXT	VARCHAR2(1000)	No
GURSRVQ_ALLOW_COMMENTS_IND	GURSRVQ_ALLOW_COMMENTS_IND	VARCHAR2(1)	No
GURSRVQ_RESPONSE_1_TEXT	GURSRVQ_RESPONSE_1_TEXT	VARCHAR2(60)	Yes
GURSRVQ_RESPONSE_2_TEXT	GURSRVQ_RESPONSE_2_TEXT	VARCHAR2(60)	Yes
GURSRVQ_RESPONSE_3_TEXT	GURSRVQ_RESPONSE_3_TEXT	VARCHAR2(60)	Yes
GURSRVQ_RESPONSE_4_TEXT	GURSRVQ_RESPONSE_4_TEXT	VARCHAR2(60)	Yes
GURSRVQ_RESPONSE_5_TEXT	GURSRVQ_RESPONSE_5_TEXT	VARCHAR2(60)	Yes
GURSRVQ_COMMENTS_TEXT	GURSRVQ_COMMENTS_TEXT	VARCHAR2(60)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GURSRVQ_NAME	GUBSRVY_NAME	GUBSRVY

Index

Index Name	Index Type	Column Name
PK_GURSRVQ	Unique	GURSRVQ_NAME
PK_GURSRVQ	Unique	GURSRVQ_QUESTION_NO

Comments

Source Code Comments

Survey Questions Repeating Table. This tables defines the survey questions.

Columns Comments for GURSRVQ_NAME (1)

Source Code Comments

Survey Name.

Columns Comments for GURSRVQ_QUESTION_NO (2)

Source Code Comments

Survey Question Number.

Columns Comments for GURSRVQ_ACTIVITY_DATE (3)

Source Code Comments

The date that the question was created or last updated.

Columns Comments for GURSRVQ_USER (4)

Source Code Comments

The User ID which created or last updated the question.

Columns Comments for GURSRVQ_MULT_RESP_IND (5)

Source Code Comments

Allow multiple responses per question indicator.

Columns Comments for GURSRVQ_TEXT (6)

Source Code Comments

Free form text which defines the question.

Columns Comments for GURSRVQ_ALLOW_COMMENTS_IND (7)

Source Code Comments

Allow Comments Indicator. Y = allow comments, N = do not allow comments.

Columns Comments for GURSRVQ_RESPONSE_1_TEXT (8)

Source Code Comments

Free form text which describes the first possible response.

Columns Comments for GURSRVQ_RESPONSE_2_TEXT (9)

Source Code Comments

Free form text which describes the second possible response.

Columns Comments for GURSRVQ_RESPONSE_3_TEXT (10)

Source Code Comments

Free form text which describes the third possible response.

Columns Comments for GURSRVQ_RESPONSE_4_TEXT (11)

Source Code Comments

Free form text which describes the fourth possible response.

Columns Comments for GURSRVQ_RESPONSE_5_TEXT (12)

Source Code Comments

Free form text which describes the fifth possible response.

Columns Comments for GURSRVQ_COMMENTS_TEXT (13)

Source Code Comments

Free form text which define text display before the comment box on the web.

Table GURSVRL

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GURSVRL_NAME	GURSVRL_NAME	VARCHAR2(15)	No	*	*
GURSVRL_ROLE	GURSVRL_ROLE	VARCHAR2(30)	No	*
GURSVRL_ACTIVITY_DATE	GURSVRL_ACTIVITY_DATE	DATE	No
GURSVRL_USER	GURSVRL_USER	VARCHAR2(30)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GURSVRL_NAME	GUBSRVY_NAME	GUBSRVY

Index

Index Name	Index Type	Column Name
PK_GURSVRL	Unique	GURSVRL_NAME
PK_GURSVRL	Unique	GURSVRL_ROLE

Comments

Source Code Comments

Survey Roles Repeating Table. This tables defines which roles may respond.

Columns Comments for GURSVRL_NAME (1)

Source Code Comments

Survey Name.

Columns Comments for GURSVRL_ROLE (2)

Source Code Comments

Survey Role.

Columns Comments for GURSVRL_ACTIVITY_DATE (3)

Source Code Comments

The date that the role restriction was created or last updated.

Columns Comments for GURSVRL_USER (4)

Source Code Comments

The User ID which created or last updated the role restriction.

Table SPRIDEN

Schema Name SATURN
Label SPRIDEN
Server name MALDEV8_B60
Creation Date 11/10/2003 13:52:02: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	*
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	*
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_ID	SPRIDEN_ID	VARCHAR2(9)	No	*
SPRIDEN_LAST_NAME	SPRIDEN_LAST_NAME	VARCHAR2(60)	No
SPRIDEN_FIRST_NAME	SPRIDEN_FIRST_NAME	VARCHAR2(15)	Yes
SPRIDEN_MI	SPRIDEN_MI	VARCHAR2(15)	Yes
SPRIDEN_CHANGE_IND	SPRIDEN_CHANGE_IND	VARCHAR2(1)	Yes
SPRIDEN_ENTITY_IND	SPRIDEN_ENTITY_IND	VARCHAR2(1)	Yes
SPRIDEN_ACTIVITY_DATE	SPRIDEN_ACTIVITY_DATE	DATE	No
SPRIDEN_USER	SPRIDEN_USER	VARCHAR2(30)	Yes
SPRIDEN_ORIGIN	SPRIDEN_ORIGIN	VARCHAR2(30)	Yes
SPRIDEN_SEARCH_LAST_NAME	SPRIDEN_SEARCH_LAST_NAME	VARCHAR2(60)	Yes
SPRIDEN_SEARCH_FIRST_NAME	SPRIDEN_SEARCH_FIRST_NAME	VARCHAR2(15)	Yes
SPRIDEN_SEARCH_MI	SPRIDEN_SEARCH_MI	VARCHAR2(15)	Yes
SPRIDEN_SOUNDEX_LAST_NAME	SPRIDEN_SOUNDEX_LAST_NAME	CHAR(4)	Yes
SPRIDEN_SOUNDEX_FIRST_NAME	SPRIDEN_SOUNDEX_FIRST_NAME	CHAR(4)	Yes
SPRIDEN_NTYP_CODE	SPRIDEN_NTYP_CODE	VARCHAR2(4)	Yes
SPRIDEN_CREATE_USER	SPRIDEN_CREATE_USER	VARCHAR2(30)	Yes
SPRIDEN_CREATE_DATE	SPRIDEN_CREATE_DATE	DATE	Yes
SPRIDEN_DATA_ORIGIN	SPRIDEN_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
SPRIDEN_PIDM	APRDHIS_PIDM	APRDHIS
SPRIDEN_PIDM	APBCONS_PIDM	APBCONS
SPRIDEN_PIDM	APRXREF_XREF_PIDM	APRXREF
SPRIDEN_PIDM	AGBMGID_EMPR_PIDM	AGBMGID
SPRIDEN_PIDM	AGBMGID_EMPL_PIDM	AGBMGID
SPRIDEN_PIDM	AMRINFO_PIDM	AMRINFO
SPRIDEN_PIDM	AOBORGN_MG_PIDM	AOBORGN
SPRIDEN_PIDM	AOBORGN_PIDM	AOBORGN
SPRIDEN_PIDM	APRACYR_PIDM	APRACYR
SPRIDEN_PIDM	ASRSORG_PIDM	ASRSORG
SPRIDEN_PIDM	APREHIS_EMPR_PIDM	APREHIS
SPRIDEN_PIDM	AORJPST_EMPR_PIDM	AORJPST
SPRIDEN_PIDM	APRCHIS_PIDM	APRCHIS
SPRIDEN_PIDM	APRCHLD_CHLD_PIDM	APRCHLD
SPRIDEN_PIDM	APRCATG_PIDM	APRCATG
SPRIDEN_PIDM	ASRSSAG_PIDM	ASRSSAG
SPRIDEN_PIDM	RCRAPP1_PIDM	RCRAPP1
SPRIDEN_PIDM	RPRAWRD_PIDM	RPRAWRD
SPRIDEN_PIDM	RNRTMNT_PIDM	RNRTMNT
SPRIDEN_PIDM	RPRLAPP_LENDER_PIDM	RPRLAPP
SPRIDEN_PIDM	RPRATRM_PIDM	RPRATRM
SPRIDEN_PIDM	RORSTAT_PIDM	RORSTAT
SPRIDEN_PIDM	FPBPOHD_VEND_PIDM	FPBPOHD
SPRIDEN_PIDM	FIRPRTY_IMGR_CODE_PIDM	FIRPRTY
SPRIDEN_PIDM	FTVFUND_FMGR_CODE_PIDM	FTVFUND
SPRIDEN_PIDM	FTVVEND_PIDM	FTVVEND
SPRIDEN_PIDM	FTVIMGR_IMGR_CODE_PIDM	FTVIMGR
SPRIDEN_PIDM	FIRMMKT_IMGR_CODE_PIDM	FIRMMKT
SPRIDEN_PIDM	FIRBOND_IMGR_CODE_PIDM	FIRBOND
SPRIDEN_PIDM	FPBAGRH_VEND_PIDM	FPBAGRH
SPRIDEN_PIDM	FTVAGCY_AGCY_CODE_PIDM	FTVAGCY
SPRIDEN_PIDM	FIRCERD_IMGR_CODE_PIDM	FIRCERD
SPRIDEN_PIDM	FIRSTCK_IMGR_CODE_PIDM	FIRSTCK
SPRIDEN_PIDM	FABINVH_VEND_PIDM	FABINVH
SPRIDEN_PIDM	FABINVH_VEND_CHECK_PIDM	FABINVH
SPRIDEN_PIDM	FIRSTOP_IMGR_CODE_PIDM	FIRSTOP
SPRIDEN_PIDM	FPBREQH_VEND_PIDM	FPBREQH
SPRIDEN_PIDM	FTVCUST_PIDM	FTVCUST
SPRIDEN_PIDM	FTVFMGR_FMGR_CODE_PIDM	FTVFMGR
SPRIDEN_PIDM	FCREMPO_PIDM	FCREMPO
SPRIDEN_PIDM	GORVISA_PIDM	GORVISA
SPRIDEN_PIDM	GERPART_PIDM	GERPART
SPRIDEN_PIDM	GORSEVD_DEP_PIDM	GORSEVD
SPRIDEN_PIDM	GORSEVS_PIDM	GORSEVS
SPRIDEN_PIDM	GLBEXTR_KEY	GLBEXTR
SPRIDEN_PIDM	GOBSRVR_PIDM	GOBSRVR
SPRIDEN_PIDM	GOBEACC_PIDM	GOBEACC
SPRIDEN_PIDM	GOBSEVS_PIDM	GOBSEVS
SPRIDEN_PIDM	GERATTD_PIDM	GERATTD
SPRIDEN_PIDM	PERREVW_REVIEWER_PIDM	PERREVW
SPRIDEN_PIDM	PERJOBP_PIDM	PERJOBP
SPRIDEN_PIDM	PERJOBS_PIDM	PERJOBS
SPRIDEN_PIDM	PERBARG_PIDM	PERBARG
SPRIDEN_PIDM	PERROUT_ACTION_PIDM	PERROUT
SPRIDEN_PIDM	PERROUT_APPR_PIDM	PERROUT
SPRIDEN_PIDM	PARAPIN_PIDM	PARAPIN
SPRIDEN_PIDM	PEBEMPL_PIDM	PEBEMPL
SPRIDEN_PIDM	PETJOBS_PIDM	PETJOBS
SPRIDEN_PIDM	PDRBDED_PIDM	PDRBDED
SPRIDEN_PIDM	PERTETH_TRANS_PIDM	PERTETH
SPRIDEN_PIDM	PDRBENE_BENE_PIDM	PDRBENE
SPRIDEN_PIDM	PERHSIP_PIDM	PERHSIP
SPRIDEN_PIDM	NBRBJOB_PIDM	NBRBJOB
SPRIDEN_PIDM	NBRJOBS_PIDM	NBRJOBS
SPRIDEN_PIDM	SFRAREG_PIDM	SFRAREG
SPRIDEN_PIDM	SRRRSRC_PIDM	SRRRSRC
SPRIDEN_PIDM	SLRRMAT_PIDM	SLRRMAT
SPRIDEN_ID	SRTIDEN_ID	SRTIDEN
SPRIDEN_PIDM	SRTIDEN_PIDM	SRTIDEN
SPRIDEN_PIDM	SGRASSI_PIDM	SGRASSI
SPRIDEN_PIDM	SHRSMRK_PIDM	SHRSMRK
SPRIDEN_PIDM	SFRENRL_PIDM	SFRENRL
SPRIDEN_PIDM	SPBPERS_PIDM	SPBPERS
SPRIDEN_PIDM	SHBHEAD_PIDM	SHBHEAD
SPRIDEN_PIDM	SFRSTCR_PIDM	SFRSTCR
SPRIDEN_PIDM	SFBETRM_PIDM	SFBETRM
SPRIDEN_PIDM	SHRMRKS_PIDM	SHRMRKS
SPRIDEN_PIDM	SHRTTRM_PIDM	SHRTTRM
SPRIDEN_PIDM	SMRRQCM_ORIG_PIDM	SMRRQCM
SPRIDEN_PIDM	SMRRQCM_PIDM	SMRRQCM
SPRIDEN_PIDM	SHRDGMR_PIDM	SHRDGMR
SPRIDEN_PIDM	SABSTUD_PIDM	SABSTUD
SPRIDEN_PIDM	SORHSCH_PIDM	SORHSCH
SPRIDEN_PIDM	SORAINF_PIDM	SORAINF
SPRIDEN_PIDM	SORPCOL_PIDM	SORPCOL
SPRIDEN_PIDM	SHRLGPA_PIDM	SHRLGPA
SPRIDEN_PIDM	SRBRECR_PIDM	SRBRECR
SPRIDEN_PIDM	SGBSTDN_PIDM	SGBSTDN
SPRIDEN_PIDM	SHTTRAN_PIDM	SHTTRAN
SPRIDEN_PIDM	SMBSLIB_PIDM