Model Electronic Approvals

Model Label : Banner HR Electronic Approvals Module
Path : BANNER DEV/HR/Electronic Approvals

List of Objects

Object Name	Object Type	Layer Name
NOBTRAN	TABLE	Default
NORROUT	TABLE	Default
NORTERN	TABLE	Default
NORTLBD	TABLE	nobtran
NORTRAN	TABLE	Default
NTVACAT	TABLE	nobtran
SPRIDEN	TABLE	Default

Comments

Model View

Table NOBTRAN

Schema Name POSNCTL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:15:15:000

Table Columns informations

Column Name	Label	Column Type	Allow NULL	PK	FK
NOBTRAN_TRANSACTION_NO	NOBTRAN_TRANSACTION_NO	NUMBER(15,0)	No	*
NOBTRAN_PIDM	NOBTRAN_PIDM	NUMBER(8,0)	Yes
NOBTRAN_EFFECTIVE_DATE	NOBTRAN_EFFECTIVE_DATE	DATE	Yes
NOBTRAN_ACAT_CODE	NOBTRAN_ACAT_CODE	VARCHAR2(6)	No		*
NOBTRAN_TRANS_STATUS_IND	NOBTRAN_TRANS_STATUS_IND	VARCHAR2(1)	No
NOBTRAN_SUBMITTOR_USER_ID	NOBTRAN_SUBMITTOR_USER_ID	VARCHAR2(30)	Yes
NOBTRAN_CREATED_DATE	NOBTRAN_CREATED_DATE	DATE	No
NOBTRAN_ORIGINATOR_USER_ID	NOBTRAN_ORIGINATOR_USER_ID	VARCHAR2(30)	No
NOBTRAN_SUBMISSION_DATE	NOBTRAN_SUBMISSION_DATE	DATE	Yes
NOBTRAN_APPLY_IND	NOBTRAN_APPLY_IND	VARCHAR2(1)	No
NOBTRAN_APPLY_DATE	NOBTRAN_APPLY_DATE	DATE	Yes
NOBTRAN_APPLY_USER_ID	NOBTRAN_APPLY_USER_ID	VARCHAR2(30)	Yes
NOBTRAN_ACTIVITY_DATE	NOBTRAN_ACTIVITY_DATE	DATE	No
NOBTRAN_COMMENTS	NOBTRAN_COMMENTS	LONG	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
NOBTRAN_ACAT_CODE	NTVACAT_CODE	NTVACAT

Index

Index Name	Index Type	Column Name
NOBTRAN_KEY2_INDEX		NOBTRAN_APPLY_IND
NOBTRAN_KEY2_INDEX		NOBTRAN_APPLY_USER_ID
NOBTRAN_KEY3_INDEX		NOBTRAN_TRANS_STATUS_IND
NOBTRAN_KEY3_INDEX		NOBTRAN_SUBMISSION_DATE
NOBTRAN_KEY_INDEX		NOBTRAN_PIDM
PK_NOBTRAN	Unique	NOBTRAN_TRANSACTION_NO

Comments

Source Code Comments

Transaction Approvals Base Table

Columns Comments for NOBTRAN_TRANSACTION_NO (1)

Source Code Comments

TRANSACTION NUMBER: A number that is system generated for approval transactions.

Columns Comments for NOBTRAN_PIDM (2)

Source Code Comments

PIDM: Internal Id number.

Columns Comments for NOBTRAN_EFFECTIVE_DATE (3)

Source Code Comments

EFFECTIVE DATE: The Date that the approval transaction record becomes effective.

Columns Comments for NOBTRAN_ACAT_CODE (4)

Source Code Comments

APPROVAL CATEGORY CODE: This code represents the purpose of the personnel action.

Columns Comments for NOBTRAN_TRANS_STATUS_IND (5)

Source Code Comments

TRANSACTION STATUS INDICATOR: The status of the approval transaction.

Columns Comments for NOBTRAN_SUBMITTOR_USER_ID (6)

Source Code Comments

SUBMITTOR USER ID: The user id of the submittor of the approval transaction.

Columns Comments for NOBTRAN_CREATED_DATE (7)

Source Code Comments

CREATED DATE: The date the approval transaction is created.

Columns Comments for NOBTRAN_ORIGINATOR_USER_ID (8)

Source Code Comments

ORIGINATOR USER ID: The user id of the person who creates the transaction.

Columns Comments for NOBTRAN_SUBMISSION_DATE (9)

Source Code Comments

SUBMISSION DATE: The date the transaction is submitted to start the transaction through the approval queue.

Columns Comments for NOBTRAN_APPLY_IND (10)

Source Code Comments

APPLY INDICATOR: The indicator to apply transactions to the database.

Columns Comments for NOBTRAN_APPLY_DATE (11)

Source Code Comments

APPLICATION DATE: The date the transaction is applied.

Columns Comments for NOBTRAN_APPLY_USER_ID (12)

Source Code Comments

APPLY USER ID: The user id of the person who applies the transaction.

Columns Comments for NOBTRAN_ACTIVITY_DATE (13)

Source Code Comments

ACTIVITY DATE: Date of last activity on this record.

Columns Comments for NOBTRAN_COMMENTS (14)

Source Code Comments

COMMENTS: Comments with regards to the action taken on the Approvals transaction.

Table NORROUT

Schema Name POSNCTL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:15:15:000

Table Columns informations

Column Name	Label	Column Type	Allow NULL	FK
NORROUT_TRANSACTION_NO	NORROUT_TRANSACTION_NO	NUMBER(15,0)	No
NORROUT_RECIPIENT_USER_ID	NORROUT_RECIPIENT_USER_ID	VARCHAR2(30)	Yes
NORROUT_ACTION_USER_ID	NORROUT_ACTION_USER_ID	VARCHAR2(30)	Yes
NORROUT_ALVL_CODE	NORROUT_ALVL_CODE	VARCHAR2(6)	No	*
NORROUT_ALVL_CODE	NORROUT_ALVL_CODE	VARCHAR2(6)	No	*
NORROUT_ACTION_IND	NORROUT_ACTION_IND	VARCHAR2(1)	No
NORROUT_QUEUE_STATUS_IND	NORROUT_QUEUE_STATUS_IND	VARCHAR2(1)	No
NORROUT_STATUS_DATE_TIME	NORROUT_STATUS_DATE_TIME	DATE	No
NORROUT_ACTIVITY_DATE	NORROUT_ACTIVITY_DATE	DATE	No
NORROUT_LEVEL_NO	NORROUT_LEVEL_NO	NUMBER(5,2)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
NORROUT_ALVL_CODE	NTRALVL_CODE	NTRALVL
NORROUT_ALVL_CODE	NTRLVID_ALVL_CODE	NTRLVID

Index

Index Name	Index Type	Column Name
NORROUT_KEY2_INDEX		NORROUT_RECIPIENT_USER_ID
NORROUT_KEY2_INDEX		NORROUT_QUEUE_STATUS_IND
NORROUT_KEY_INDEX		NORROUT_TRANSACTION_NO

Comments

Source Code Comments

Transaction Routing Repeating Table

Columns Comments for NORROUT_TRANSACTION_NO (1)

Source Code Comments

TRANSACTION NUMBER: A number that is system generated for approval transactions.

Columns Comments for NORROUT_RECIPIENT_USER_ID (2)

Source Code Comments

RECIPIENT USER ID: The user id of the approver.

Columns Comments for NORROUT_ACTION_USER_ID (3)

Source Code Comments

ACTION USER ID: The user id of the person who took action.

Columns Comments for NORROUT_ALVL_CODE (4)

Source Code Comments

LEVEL CODE: A code to identify the level of approval.

Columns Comments for NORROUT_ACTION_IND (5)

Source Code Comments

ACTION INDICATOR: The indicator for the type of action to be taken by the approver.

Columns Comments for NORROUT_QUEUE_STATUS_IND (6)

Source Code Comments

QUEUE STATUS IND: The indicator for the queue status of the approver.

Columns Comments for NORROUT_STATUS_DATE_TIME (7)

Source Code Comments

STATUS DATE TIME: The status date/time of the approver"s action in the queue.

Columns Comments for NORROUT_ACTIVITY_DATE (8)

Source Code Comments

ACTIVITY DATE: Date of last activity on this record.

Columns Comments for NORROUT_LEVEL_NO (9)

Source Code Comments

LEVEL NO: Display the level codes in the approval transaction by this level no.

Table NORTERN

Schema Name POSNCTL
Server name MALDEV8_B60
Creation Date 07/14/2003 15:11:57:000

Table Columns informations

Column Name	Label	Column Type	Allow NULL	PK
NORTERN_TRANSACTION_NO	NORTERN_TRANSACTION_NO	NUMBER(15,0)	No	*
NORTERN_APTY_CODE	NORTERN_APTY_CODE	VARCHAR2(6)	No	*
NORTERN_POSN	NORTERN_POSN	VARCHAR2(6)	No	*
NORTERN_SUFF	NORTERN_SUFF	VARCHAR2(2)	No	*
NORTERN_EFFECTIVE_DATE	NORTERN_EFFECTIVE_DATE	DATE	No	*
NORTERN_EARN_CODE	NORTERN_EARN_CODE	VARCHAR2(3)	No	*
NORTERN_HRS	NORTERN_HRS	NUMBER(6,2)	Yes
NORTERN_SPECIAL_RATE	NORTERN_SPECIAL_RATE	NUMBER(12,6)	Yes
NORTERN_SHIFT	NORTERN_SHIFT	VARCHAR2(1)	No
NORTERN_CANCEL_DATE	NORTERN_CANCEL_DATE	DATE	Yes
NORTERN_ACTIVITY_DATE	NORTERN_ACTIVITY_DATE	DATE	No
NORTERN_APPLY_STATUS_IND	NORTERN_APPLY_STATUS_IND	VARCHAR2(1)	No
NORTERN_DEEMED_HRS	NORTERN_DEEMED_HRS	NUMBER(6,2)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_NORTERN	Unique	NORTERN_TRANSACTION_NO
PK_NORTERN	Unique	NORTERN_APTY_CODE
PK_NORTERN	Unique	NORTERN_POSN
PK_NORTERN	Unique	NORTERN_SUFF
PK_NORTERN	Unique	NORTERN_EFFECTIVE_DATE
PK_NORTERN	Unique	NORTERN_EARN_CODE

Comments

Source Code Comments

Transaction Approvals Default Earnings Table

Columns Comments for NORTERN_TRANSACTION_NO (1)

Source Code Comments

TRANSACTION NUMBER: A number that is system generated for approval transactions.

Columns Comments for NORTERN_APTY_CODE (2)

Source Code Comments

APPROVAL TYPE CODE: Code tied to the approval category.

Columns Comments for NORTERN_POSN (3)

Source Code Comments

POSITION: The position number the approval transaction is attached to.

Columns Comments for NORTERN_SUFF (4)

Source Code Comments

SUFFIX. Job suffix.

Columns Comments for NORTERN_EFFECTIVE_DATE (5)

Source Code Comments

EFFECTIVE DATE: The Date that the approval transaction record becomes effective. This field is overridable.

Columns Comments for NORTERN_EARN_CODE (6)

Source Code Comments

EARNINGS CODE: A code which identifies the transaction approval default earnings.

Columns Comments for NORTERN_HRS (7)

Source Code Comments

HOURS/UNITS: The hours or units to default for this earnings code.

Columns Comments for NORTERN_SPECIAL_RATE (8)

Source Code Comments

SPECIAL RATE: The special rate to be used for this earnings code.

Columns Comments for NORTERN_SHIFT (9)

Source Code Comments

SHIFT: The shift associated with earnings code.

Columns Comments for NORTERN_CANCEL_DATE (10)

Source Code Comments

CANCEL DATE: The ended as of date of the earnings code.

Columns Comments for NORTERN_ACTIVITY_DATE (11)

Source Code Comments

ACTIVITY DATE: Date the record was inserted or last modified.

Columns Comments for NORTERN_APPLY_STATUS_IND (12)

Source Code Comments

APPLY STATUS INDICATOR: Indicates whether this record has been applied to the database.

Columns Comments for NORTERN_DEEMED_HRS (13)

Source Code Comments

DEEMED HOURS: Reportable hours for Canadian Employment Insurance.

Table NORTLBD

Schema Name POSNCTL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:15:15:000

Table Columns informations

Column Name	Label	Column Type	Allow NULL	FK
NORTLBD_TRANSACTION_NO	NORTLBD_TRANSACTION_NO	NUMBER(15,0)	No	*
NORTLBD_APTY_CODE	NORTLBD_APTY_CODE	VARCHAR2(6)	No	*
NORTLBD_POSN	NORTLBD_POSN	VARCHAR2(6)	No
NORTLBD_SUFF	NORTLBD_SUFF	VARCHAR2(2)	No
NORTLBD_EFFECTIVE_DATE	NORTLBD_EFFECTIVE_DATE	DATE	No
NORTLBD_COAS_CODE	NORTLBD_COAS_CODE	VARCHAR2(1)	Yes
NORTLBD_ACCI_CODE	NORTLBD_ACCI_CODE	VARCHAR2(6)	Yes
NORTLBD_FUND_CODE	NORTLBD_FUND_CODE	VARCHAR2(6)	Yes
NORTLBD_ORGN_CODE	NORTLBD_ORGN_CODE	VARCHAR2(6)	Yes
NORTLBD_ACCT_CODE	NORTLBD_ACCT_CODE	VARCHAR2(6)	Yes
NORTLBD_PROG_CODE	NORTLBD_PROG_CODE	VARCHAR2(6)	Yes
NORTLBD_ACTV_CODE	NORTLBD_ACTV_CODE	VARCHAR2(6)	Yes
NORTLBD_LOCN_CODE	NORTLBD_LOCN_CODE	VARCHAR2(6)	Yes
NORTLBD_PROJ_CODE	NORTLBD_PROJ_CODE	VARCHAR2(8)	Yes
NORTLBD_CTYP_CODE	NORTLBD_CTYP_CODE	VARCHAR2(2)	Yes
NORTLBD_ACCT_CODE_EXTERNAL	NORTLBD_ACCT_CODE_EXTERNAL	VARCHAR2(60)	Yes
NORTLBD_PERCENT	NORTLBD_PERCENT	NUMBER(5,2)	No
NORTLBD_ACTIVITY_DATE	NORTLBD_ACTIVITY_DATE	DATE	No
NORTLBD_APPLY_STATUS_IND	NORTLBD_APPLY_STATUS_IND	VARCHAR2(1)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
NORTLBD_APTY_CODE	NTVAPTY_CODE	NTVAPTY
NORTLBD_TRANSACTION_NO	NOBTRAN_TRANSACTION_NO	NOBTRAN

Index

Index Name	Index Type	Column Name
NORTLBD_KEY2_INDEX		NORTLBD_TRANSACTION_NO
NORTLBD_KEY2_INDEX		NORTLBD_APTY_CODE
NORTLBD_KEY2_INDEX		NORTLBD_POSN
NORTLBD_KEY2_INDEX		NORTLBD_SUFF
NORTLBD_KEY_INDEX		NORTLBD_FUND_CODE
NORTLBD_KEY_INDEX		NORTLBD_ORGN_CODE
NORTLBD_KEY_INDEX		NORTLBD_ACCT_CODE
NORTLBD_KEY_INDEX		NORTLBD_PROG_CODE
NORTLBD_KEY_INDEX		NORTLBD_ACTV_CODE
NORTLBD_KEY_INDEX		NORTLBD_LOCN_CODE

Comments

Source Code Comments

Transaction Approvals Labor Distributions Table

Columns Comments for NORTLBD_TRANSACTION_NO (1)

Source Code Comments

TRANSACTION NUMBER: A number that is system generated for approval transactions.

Columns Comments for NORTLBD_APTY_CODE (2)

Source Code Comments

APPROVAL TYPE CODE: Code tied to the approval category.

Columns Comments for NORTLBD_POSN (3)

Source Code Comments

APPROVAL TRANSACTION: The APPROVAL TRANSACTION number the approval transaction is attached to.

Columns Comments for NORTLBD_SUFF (4)

Source Code Comments

SUFFIX. Job suffix.

Columns Comments for NORTLBD_EFFECTIVE_DATE (5)

Source Code Comments

EFFECTIVE DATE: The Date that the approval transaction record becomes effective. This field is overridable.

Columns Comments for NORTLBD_COAS_CODE (6)

Source Code Comments

CHART OF ACCOUNTS CODE: The BANNER FINANCE system defined Chart of Accounts Code under which this APPROVAL TRANSACTION is to be charged.

Columns Comments for NORTLBD_ACCI_CODE (7)

Source Code Comments

APPROVAL TRANSACTION ACCOUNT INDEX CODE: An index code that is used to default the account distribution to which this APPROVAL TRANSACTION should be charged.

Columns Comments for NORTLBD_FUND_CODE (8)

Source Code Comments

APPROVAL TRANSACTION FUND CODE: BANNER FINANCE system defined code that identifies the fund to which this APPROVAL TRANSACTION should be charged.

Columns Comments for NORTLBD_ORGN_CODE (9)

Source Code Comments

APPROVAL TRANSACTION ORGANIZATION CODE: BANNER FINANCE system defined code that identifies the Organization to which this APPROVAL TRANSACTION should be charged.

Columns Comments for NORTLBD_ACCT_CODE (10)

Source Code Comments

APPROVAL TRANSACTION ACCOUNT CODE : BANNER FINANCE system defined code which identifies the APPROVAL TRANSACTION account to be charged.

Columns Comments for NORTLBD_PROG_CODE (11)

Source Code Comments

APPROVAL TRANSACTION PROGRAM CODE: BANNER FINANCE system defined code that identifies the Program to which this APPROVAL TRANSACTION should be charged.

Columns Comments for NORTLBD_ACTV_CODE (12)

Source Code Comments

APPROVAL TRANSACTION ACTIVITY CODE: BANNER FINANCE system defined code that identifies the activity to which the APPROVAL TRANSACTION should be charged.

Columns Comments for NORTLBD_LOCN_CODE (13)

Source Code Comments

APPROVAL TRANSACTION LOCATION CODE: BANNER FINANCE system defined code that identifies the Program to which this APPROVAL TRANSACTION should be charged.

Columns Comments for NORTLBD_PROJ_CODE (14)

Source Code Comments

PROJECT CODE: Project within Finance Cost Accounting Module.

Columns Comments for NORTLBD_CTYP_CODE (15)

Source Code Comments

COST TYPE CODE: Cost Type within Finance Cost Accounting Module.

Columns Comments for NORTLBD_ACCT_CODE_EXTERNAL (16)

Source Code Comments

APPROVAL TRANSACTION EXTERNAL ACCOUNT CODE: A NON-BANNER FINANCE System Account Distribution Code to which this position should be charged.

Columns Comments for NORTLBD_PERCENT (17)

Source Code Comments

APPROVAL TRANSACTION LABOR DISTRIBUTION PERCENT: Percent of Position's Budget to be applied to this labor distribution.

Columns Comments for NORTLBD_ACTIVITY_DATE (18)

Source Code Comments

ACTIVITY DATE: Date the record was inserted or last modified.

Columns Comments for NORTLBD_APPLY_STATUS_IND (19)

Source Code Comments

APPLY STATUS INDICATOR: Indicates whether this record has been applied to the database.

Table NORTRAN

Schema Name POSNCTL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:15:15:000

Table Columns informations

Column Name	Label	Column Type	Allow NULL	PK	FK
NORTRAN_TRANSACTION_NO	NORTRAN_TRANSACTION_NO	NUMBER(15,0)	No	*
NORTRAN_APTY_CODE	NORTRAN_APTY_CODE	VARCHAR2(6)	No	*	*
NORTRAN_POSN	NORTRAN_POSN	VARCHAR2(6)	Yes
NORTRAN_SUFF	NORTRAN_SUFF	VARCHAR2(2)	Yes
NORTRAN_AUFM_CODE	NORTRAN_AUFM_CODE	VARCHAR2(7)	No	*	*
NORTRAN_AUBK_CODE	NORTRAN_AUBK_CODE	VARCHAR2(30)	No	*	*
NORTRAN_AUFD_CODE	NORTRAN_AUFD_CODE	VARCHAR2(30)	No	*	*
NORTRAN_VALUE	NORTRAN_VALUE	VARCHAR2(60)	Yes
NORTRAN_APPLY_STATUS_IND	NORTRAN_APPLY_STATUS_IND	VARCHAR2(1)	No
NORTRAN_ACTIVITY_DATE	NORTRAN_ACTIVITY_DATE	DATE	No
NORTRAN_DISPLAY_SEQ_NO	NORTRAN_DISPLAY_SEQ_NO	NUMBER(5,2)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
NORTRAN_APTY_CODE	NTRAPFD_APTY_CODE	NTRAPFD
NORTRAN_AUFM_CODE	NTRAPFD_AUFM_CODE	NTRAPFD
NORTRAN_AUBK_CODE	NTRAPFD_AUBK_CODE	NTRAPFD
NORTRAN_AUFD_CODE	NTRAPFD_AUFD_CODE	NTRAPFD

Index

Index Name	Index Type	Column Name
PK_NORTRAN	Unique	NORTRAN_TRANSACTION_NO
PK_NORTRAN	Unique	NORTRAN_APTY_CODE
PK_NORTRAN	Unique	NORTRAN_AUFM_CODE
PK_NORTRAN	Unique	NORTRAN_AUBK_CODE
PK_NORTRAN	Unique	NORTRAN_AUFD_CODE

Comments

Source Code Comments

Transaction Approvals Repeating Table

Columns Comments for NORTRAN_TRANSACTION_NO (1)

Source Code Comments

TRANSACTION NUMBER: A number that is system generated for approval transactions.

Columns Comments for NORTRAN_APTY_CODE (2)

Source Code Comments

APPROVAL TYPE CODE: Code tied to the approval category.

Columns Comments for NORTRAN_POSN (3)

Source Code Comments

POSITION: The position number the approval transaction is attached to.

Columns Comments for NORTRAN_SUFF (4)

Source Code Comments

SUFFIX. Job suffix.

Columns Comments for NORTRAN_AUFM_CODE (5)

Source Code Comments

FORM CODE: The form that will be sent through the approval process.

Columns Comments for NORTRAN_AUBK_CODE (6)

Source Code Comments

BLOCK CODE: The block that will be sent through the approval process.

Columns Comments for NORTRAN_AUFD_CODE (7)

Source Code Comments

FIELD CODE: The field that will be sent through the approval process.

Columns Comments for NORTRAN_VALUE (8)

Source Code Comments

NEW VALUE: The new value entered for the field.

Columns Comments for NORTRAN_APPLY_STATUS_IND (9)

Source Code Comments

APPLY STATUS INDICATOR: The indicator for the status of the transaction.

Columns Comments for NORTRAN_ACTIVITY_DATE (10)

Source Code Comments

ACTIVITY DATE: Date of last activity on this record.

Columns Comments for NORTRAN_DISPLAY_SEQ_NO (11)

Source Code Comments

DISPLAY SEQUENCE NO: Display the field items in the approval transaction by this sequence no.

Table NTVACAT

Schema Name POSNCTL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:15:19:000

Table Columns informations

Column Name	Label	Column Type	Allow NULL	PK
NTVACAT_CODE	NTVACAT_CODE	VARCHAR2(6)	No	*
NTVACAT_DESC	NTVACAT_DESC	VARCHAR2(30)	No
NTVACAT_ACTIVITY_DATE	NTVACAT_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_NTVACAT	Unique	NTVACAT_CODE

Comments

Source Code Comments

Approval Category Code Validation Form

Columns Comments for NTVACAT_CODE (1)

Source Code Comments

CODE: Approval Category Code

Columns Comments for NTVACAT_DESC (2)

Source Code Comments

Description of Category

Columns Comments for NTVACAT_ACTIVITY_DATE (3)

Source Code Comments

Activity Date: Date the action was initiated

Table SPRIDEN

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

Table Columns informations

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

Foreign Key information

Column name	is Foreign Key For Column	on Table
SPRIDEN_PIDM	SGBSTDN_PIDM	SGBSTDN
SPRIDEN_PIDM	PEBEMPL_PIDM	PEBEMPL
SPRIDEN_PIDM	SORPCOL_PIDM	SORPCOL
SPRIDEN_PIDM	TBRISTL_PIDM	TBRISTL
SPRIDEN_PIDM	RPRATRM_PIDM	RPRATRM
SPRIDEN_PIDM	RPRAWRD_PIDM	RPRAWRD
SPRIDEN_PIDM	TBRCOLC_PIDM	TBRCOLC
SPRIDEN_PIDM	ASRSORG_PIDM	ASRSORG
SPRIDEN_PIDM	SHRTTRM_PIDM	SHRTTRM
SPRIDEN_PIDM	SMBSLIB_PIDM	SMBSLIB
SPRIDEN_PIDM	APRCHLD_CHLD_PIDM	APRCHLD
SPRIDEN_PIDM	APREHIS_EMPR_PIDM	APREHIS
SPRIDEN_PIDM	PERBARG_PIDM	PERBARG
SPRIDEN_PIDM	PARAPIN_PIDM	PARAPIN
SPRIDEN_PIDM	TBRACCD_PIDM	TBRACCD
SPRIDEN_PIDM	PDRBDED_PIDM	PDRBDED
SPRIDEN_PIDM	SORAROL_PIDM	SORAROL
SPRIDEN_PIDM	SIRASGN_PIDM	SIRASGN
SPRIDEN_PIDM	FTVFMGR_FMGR_CODE_PIDM	FTVFMGR
SPRIDEN_PIDM	TBRDEPO_PIDM	TBRDEPO
SPRIDEN_PIDM	FPBPOHD_VEND_PIDM	FPBPOHD
SPRIDEN_PIDM	SLBEVNT_AGENCY_PIDM	SLBEVNT
SPRIDEN_PIDM	FTVVEND_PIDM	FTVVEND
SPRIDEN_PIDM	RNRTMNT_PIDM	RNRTMNT
SPRIDEN_PIDM	SHBHEAD_PIDM	SHBHEAD
SPRIDEN_PIDM </