Model Emergency Contact View Update

Model Label : Web General Emergency Contact View and Update
Path : Default Folder/B70/Web General/Emergency_Contact_View_Update

List of Objects

Object Name	Object Type	Layer Name
SPREMRG	TABLE	Default
STVATYP	TABLE	Default
STVNATN	TABLE	Default
STVRELT	TABLE	Default
STVSTAT	TABLE	Default

Comments

Model View

Table SPREMRG

Schema Name SATURN
Label SPREMRG
Server name S4B70
Creation Date 04/26/2004 14:36:29: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		*
SPREMRG_DATA_ORIGIN	SPREMRG_DATA_ORIGIN	VARCHAR2(30)	Yes
SPREMRG_USER_ID	SPREMRG_USER_ID	VARCHAR2(30)	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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SPREMRG	SYNONYM	S4B70.PUBLIC	Rely on ()
SPREMRG	Forms DataBlock	BANNER7_FORMS.GOQCLIB	Rely on () Use(insert,update,delete,select )
SPREMRG	Forms DataBlock	BANNER7_FORMS.GOQOLIB	Rely on () Use(insert,update,delete,select )
SPREMRG	Forms DataBlock	BANNER7_FORMS_10G.GOQCLIB	Rely on () Use(insert,update,delete,select )
EMERGENCY_CONTACT_REC	Package Type	S4B70.BANINST1.GB_EMERGENCY_CONTACT	Rely on ()
P_OVERLAY_VALIDATION_REC	Package procedure	S4B70.BANINST1.GB_EMERGENCY_CONTACT	Rely on ()
SPREMRGC	Package cursor	S4B70.BANINST1.BWGKOEMR	Use(select )
SPREMRGCONTACTC	Package cursor	S4B70.BANINST1.BWGKOEMR	Use(select )
SPREMRGMAXPRIORITYC	Package cursor	S4B70.BANINST1.BWGKOEMR	Use(select )
SPREMRG_REC	Package variable	S4B70.BANINST1.BWGKOEMR	Rely on ()
SPREMRG_REC	Package variable	S4B70.BANINST1.BWGKOEMR	Rely on ()
F_BUILD_SPREMRG_REC	Package function	S4B70.BANINST1.GB_EMERGENCY_CONTACT	Rely on ()
F_BUILD_SPREMRG_REC	Package function	S4B70.BANINST1.GB_EMERGENCY_CONTACT	Rely on ()
P_ADDRESS_RULE	Package procedure	S4B70.BANINST1.GB_EMERGENCY_CONTACT_RULES	Rely on ()
P_ADDRESS_RULE	Package procedure	S4B70.BANINST1.GB_EMERGENCY_CONTACT_RULES	Rely on ()
P_CREATE	Package procedure	S4B70.BANINST1.GB_EMERGENCY_CONTACT	Rely on ()
P_CREATE	Package procedure	S4B70.BANINST1.GB_EMERGENCY_CONTACT	Rely on ()
P_DELETE	Package procedure	S4B70.BANINST1.GB_EMERGENCY_CONTACT	Rely on ()
P_DELETE	Package procedure	S4B70.BANINST1.GB_EMERGENCY_CONTACT	Rely on ()
P_DELETE	Package procedure	S4B70.BANINST1.DML_SPREMRG	Use(delete )
P_GET_TERM_ACCT_SUMMARY	Package procedure	S4B70.BANINST1.BWSCBREF	Rely on ()
P_INSERT	Package procedure	S4B70.BANINST1.DML_SPREMRG	Rely on () Use(insert )
P_LOCK	Package procedure	S4B70.BANINST1.GB_EMERGENCY_CONTACT	Rely on ()
P_LOCK	Package procedure	S4B70.BANINST1.GB_EMERGENCY_CONTACT	Use(select )
P_REGISTER_ENTITY	Package procedure	S4B70.BANINST1.GB_EMERGENCY_CONTACT_RULES	Rely on ()
P_UPDATE	Package procedure	S4B70.BANINST1.GB_EMERGENCY_CONTACT	Rely on ()
P_UPDATE	Package procedure	S4B70.BANINST1.DML_SPREMRG	Rely on ()
P_UPDATE	Package procedure	S4B70.BANINST1.GB_EMERGENCY_CONTACT	Rely on ()
P_VALIDATE	Package procedure	S4B70.BANINST1.GB_EMERGENCY_CONTACT_RULES	Rely on ()
F_EXISTS	Package function	S4B70.BANINST1.GB_EMERGENCY_CONTACT	Rely on ()
F_EXISTS	Package function	S4B70.BANINST1.GB_EMERGENCY_CONTACT	Use(select )
F_QUERY_ALL	Package function	S4B70.BANINST1.GB_EMERGENCY_CONTACT	Rely on ()
F_QUERY_ALL	Package function	S4B70.BANINST1.GB_EMERGENCY_CONTACT	Use(select )
F_QUERY_BY_ROWID	Package function	S4B70.BANINST1.GB_EMERGENCY_CONTACT	Use(select )
F_QUERY_ONE	Package function	S4B70.BANINST1.GB_EMERGENCY_CONTACT	Rely on ()
F_QUERY_ONE	Package function	S4B70.BANINST1.GB_EMERGENCY_CONTACT	Use(select )
F_QUERY_ONE_LOCK	Package function	S4B70.BANINST1.GB_EMERGENCY_CONTACT	Rely on ()
F_QUERY_ONE_LOCK	Package function	S4B70.BANINST1.GB_EMERGENCY_CONTACT	Use(select )
SPREMRG	Forms DataBlock	BANNER7_FORMS.PPAIDEN	Rely on () Use(insert,update,delete,select )
SPREMRG	Forms DataBlock	BANNER7_FORMS_10G.PPAIDEN	Rely on () Use(insert,update,delete,select )
SPREMRG	Forms DataBlock	BANNER7_FORMS.SPAEMRG	Rely on () Use(insert,update,delete,select )
SPREMRG	Forms DataBlock	BANNER7_FORMS.SPAIDEN	Rely on () Use(insert,update,delete,select )
SPREMRG	Forms DataBlock	BANNER7_FORMS_10G.FOAIDEN	Rely on () Use(insert,update,delete,select )
SPREMRG	Forms DataBlock	BANNER7_FORMS_10G.SPAIDEN	Rely on () Use(insert,update,delete,select )
SPREMRG	Forms DataBlock	BANNER7_FORMS_10G.SPAEMRG	Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_SPREMRG	INDEX	S4B70.SATURN	Rely on ()
STVATYP	TABLE	S4B70.SATURN	Refer( No Action )
STVNATN	TABLE	S4B70.SATURN	Refer( No Action )
STVRELT	TABLE	S4B70.SATURN	Refer( No Action )
STVSTAT	TABLE	S4B70.SATURN	Refer( No Action )

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.

Columns Comments for SPREMRG_DATA_ORIGIN (19)

Source Code Comments

DATA ORIGIN: Source system that created or updated the row

Columns Comments for SPREMRG_USER_ID (20)

Source Code Comments

USER ID: User who inserted or last update the data

Table STVATYP

Schema Name SATURN
Label STVATYP
Server name S4B70
Creation Date 09/29/2003 12:10:14:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
STVATYP_CODE	STVATYP_CODE	VARCHAR2(2)	No	*
STVATYP_DESC	STVATYP_DESC	VARCHAR2(30)	Yes
STVATYP_ACTIVITY_DATE	STVATYP_ACTIVITY_DATE	DATE	No
STVATYP_SYSTEM_REQ_IND	STVATYP_SYSTEM_REQ_IND	VARCHAR2(1)	Yes
STVATYP_TELE_CODE	STVATYP_TELE_CODE	VARCHAR2(4)	Yes		*
STVATYP_UPDATE_WEB_IND	STVATYP_UPDATE_WEB_IND	RAW(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
STVATYP_TELE_CODE	STVTELE_CODE	STVTELE

Index

Index Name	Index Type	Column Name
PK_STVATYP	Unique	STVATYP_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
validate_address_type	C/C++ Function	[F:\BANNER\C\SHREDIY.PC]	Use(select )
validate_parm_address_type	C/C++ Function	[F:\BANNER\C\SLRBACS.PC]	Use(select )
BAA7	Cobol Paragraph	[F:\banner\cobol].RCBCT00.BAA-CHECK-PARMS-SECT	Use(select )
BAA7	Cobol Paragraph	[F:\banner\cobol].RCBCT01.BAA-CHECK-PARMS-SECT	Use(select )
BAA7	Cobol Paragraph	[F:\banner\cobol].RCBTP05.BAA-CHECK-PARMS-SECT	Use(select )
BAA7	Cobol Paragraph	[F:\banner\cobol].RCBTP04.BAA-CHECK-PARMS-SECT	Use(select )
BAA7	Cobol Paragraph	[F:\banner\cobol].RCBCT04.BAA-CHECK-PARMS-SECT	Use(select )
BAA7	Cobol Paragraph	[F:\banner\cobol].RCBTP03.BAA-CHECK-PARMS-SECT	Use(select )
BAA7	Cobol Paragraph	[F:\banner\cobol].RCBTP00.BAA-CHECK-PARMS-SECT	Use(select )
BAA7	Cobol Paragraph	[F:\banner\cobol].RCBTP01.BAA-CHECK-PARMS-SECT	Use(select )
BAA7	Cobol Paragraph	[F:\banner\cobol].RCBCT05.BAA-CHECK-PARMS-SECT	Use(select )
BAA7	Cobol Paragraph	[F:\banner\cobol].RCBTP02.BAA-CHECK-PARMS-SECT	Use(select )
BAA7	Cobol Paragraph	[F:\banner\cobol].RCBCT03.BAA-CHECK-PARMS-SECT	Use(select )
BAA7	Cobol Paragraph	[F:\banner\cobol].RCBCT02.BAA-CHECK-PARMS-SECT	Use(select )
BAA8	Cobol Paragraph	[F:\banner\cobol].RCBCT00.BAA-CHECK-PARMS-SECT	Use()
BAA8	Cobol Paragraph	[F:\banner\cobol].RCBTP03.BAA-CHECK-PARMS-SECT	Use()
BAA8	Cobol Paragraph	[F:\banner\cobol].RCBTP00.BAA-CHECK-PARMS-SECT	Use()
BAA8	Cobol Paragraph	[F:\banner\cobol].RCBCT04.BAA-CHECK-PARMS-SECT	Use()
BAA8	Cobol Paragraph	[F:\banner\cobol].RCBTP01.BAA-CHECK-PARMS-SECT	Use()
BAA8	Cobol Paragraph	[F:\banner\cobol].RCBTP04.BAA-CHECK-PARMS-SECT	Use()
BAA8	Cobol Paragraph	[F:\banner\cobol].RCBCT05.BAA-CHECK-PARMS-SECT	Use()
BAA8	Cobol Paragraph	[F:\banner\cobol].RCBTP02.BAA-CHECK-PARMS-SECT	Use()
BAA8	Cobol Paragraph	[F:\banner\cobol].RCBTP05.BAA-CHECK-PARMS-SECT	Use()
BAA8	Cobol Paragraph	[F:\banner\cobol].RCBCT03.BAA-CHECK-PARMS-SECT	Use()
BAA8	Cobol Paragraph	[F:\banner\cobol].RCBCT01.BAA-CHECK-PARMS-SECT	Use()
BAA8	Cobol Paragraph	[F:\banner\cobol].RCBCT02.BAA-CHECK-PARMS-SECT	Use()
C06D-UNSTRING-ADDR-TYPE	Cobol Paragraph	[F:\banner\cobol].GLBLSEL.A01-INIT-EXIT-ORACLE	Use(select )
check_atyp	C/C++ Function	[F:\BANNER\C\SLRDADD.PC]	Use(select )
frcgrnt_body	C/C++ Function	[F:\BANNER\C\FRPGINF.PC]	Use(select )
frcgrpi_body	C/C++ Function	[F:\BANNER\C\FRPGINF.PC]	Use(select )
get_job_parameters	C/C++ Function	[F:\BANNER\C\AGPMATC.PC]	Use(select )
get_job_parameters	C/C++ Function	[F:\BANNER\C\APPDEXT.PC]	Use(select )
get_parameters	C/C++ Function	[F:\BANNER\C\PCRRATE.PC]	Use(select )
get_phone	C/C++ Function	[F:\BANNER\C\FARVALP.PC]	Use(select )
get_phone	C/C++ Function	[F:\BANNER\C\FARVNUM.PC]	Use(select )
getatyp	C/C++ Function	[F:\BANNER\C\ASPSORL.PC]	Use(select )
sel_address	C/C++ Function	[F:\BANNER\C\FARVALP.PC]	Use(select )
sel_address	C/C++ Function	[F:\BANNER\C\FARVNUM.PC]	Use(select )
sel_option1	C/C++ Function	[F:\BANNER\C\PORAUDT.PC]	Use(select )
sel_validate_atyp_code	C/C++ Function	[F:\BANNER\C\PCRCORT.PC]	Use(select )
sel_validate_atyp_code	C/C++ Function	[F:\BANNER\C\PERCAF7.PC]	Use(select )
sel_validate_par_add_type	C/C++ Function	[F:\BANNER\C\PERROEC.PC]	Use(select )
selatyp	C/C++ Function	[F:\BANNER\C\SPRPDIR.PC]	Use(select )
valid_local_addr_type_code	C/C++ Function	[F:\BANNER\C\RPRLORC.PC]	Use(select )
valid_perm_addr_type_code	C/C++ Function	[F:\BANNER\C\RPRLORC.PC]	Use(select )
validate_atyp	C/C++ Function	[F:\BANNER\C\SFRSSCR.PC]	Use(select )
validate_atyp	C/C++ Function	[F:\BANNER\C\SAPAMAL.PC]	Use(select )
validate_atyp_code	C/C++ Function	[F:\BANNER\C\PXRROEC.PC]	Use(select )
validate_locl_type	C/C++ Function	[F:\BANNER\C\RPBLMID.PC]	Use(select )
validate_parms	C/C++ Function	[F:\BANNER\C\APPCUPD.PC]	Use()
validate_perm_type	C/C++ Function	[F:\BANNER\C\RPBLMID.PC]	Use(select )
RCBCT00	Cobol Program	F:\banner\cobol	Use()
RCBCT01	Cobol Program	F:\banner\cobol	Use()
RCBCT02	Cobol Program	F:\banner\cobol	Use()
RCBCT03	Cobol Program	F:\banner\cobol	Use()
RCBCT04	Cobol Program	F:\banner\cobol	Use()
RCBCT05	Cobol Program	F:\banner\cobol	Use()
RCBTP00	Cobol Program	F:\banner\cobol	Use()
RCBTP01	Cobol Program	F:\banner\cobol	Use()
RCBTP02	Cobol Program	F:\banner\cobol	Use()
RCBTP03	Cobol Program	F:\banner\cobol	Use()
RCBTP04	Cobol Program	F:\banner\cobol	Use()
RCBTP05	Cobol Program	F:\banner\cobol	Use()
AABDINS	TABLE	S4B70.ALUMNI	Refer( No Action )
AARMEMB	TABLE	S4B70.ALUMNI	Refer( No Action )
AGRGASC	TABLE	S4B70.ALUMNI	Refer( No Action )
AGRPASC	TABLE	S4B70.ALUMNI	Refer( No Action )
AMBMAIL	TABLE	S4B70.ALUMNI	Refer( No Action )
AOBORGN	TABLE	S4B70.ALUMNI	Refer( No Action )
AORCONT	TABLE	S4B70.ALUMNI	Refer( No Action )
APBCONS	TABLE	S4B70.ALUMNI	Refer( No Action )
APBWIDN	TABLE	S4B70.ALUMNI	Refer( No Action )
APRCHLD	TABLE	S4B70.ALUMNI	Refer( No Action )
APRMAIL	TABLE	S4B70.ALUMNI	Refer( No Action )
ASBSORG	TABLE	S4B70.ALUMNI	Refer( No Action )
ASRSORG	TABLE	S4B70.ALUMNI	Refer( No Action )
GERATTD	TABLE	S4B70."GENERAL"	Refer( No Action )
GERPART	TABLE	S4B70."GENERAL"	Refer( No Action )
GOBSEVS	TABLE	S4B70."GENERAL"	Refer( No Action )
GORADRL	TABLE	S4B70."GENERAL"	Join
GORCMSC	TABLE	S4B70."GENERAL"	Refer( No Action )
GORSVAS	TABLE	S4B70."GENERAL"	Refer( No Action )
GORSVEI	TABLE	S4B70."GENERAL"	Refer( No Action )
GURAPAY	TABLE	S4B70."GENERAL"	Refer( No Action )
PXR1099	TABLE	S4B70.PAYROLL	Refer( No Action )
PXRMTTN	TABLE	S4B70.PAYROLL	Refer( No Action )
RHRRQST	TABLE	S4B70.FAISMGR	Refer( No Action )
SARWAPP	TABLE	S4B70.SATURN	Refer( No Action )
SORFOLK	TABLE	S4B70.SATURN	Refer( No Action )
SORMSTA	TABLE	S4B70.SATURN	Refer( No Action )
SPRADDR	TABLE	S4B70.SATURN	Refer( No Action )
SPREMRG	TABLE	S4B70.SATURN	Refer( No Action )
SPRTELE	TABLE	S4B70.SATURN	Refer( No Action )
SRBWPRO	TABLE	S4B70.SATURN	Refer( No Action )
SRTADDR	TABLE	S4B70.SATURN	Refer( No Action )
SRTTELE	TABLE	S4B70.SATURN	Refer( No Action )
AG_GEOGRAPHIC_REGION	VIEW	S4B70.BANINST1	Use(select )
APVADRS	VIEW	S4B70.BANINST1	Use(select )
AS_ADDRESS	VIEW	S4B70.BANINST1	Use(select )
PPVADRS	VIEW	S4B70.BANINST1	Use(select )
RPVADDR	VIEW	S4B70.BANINST1	Use(select )
RPVADRS	VIEW	S4B70.BANINST1	Use(select )
RPVFDRS	VIEW	S4B70.BANINST1	Use(select )
SAVADRS	VIEW	S4B70.BANINST1	Use(select )
SGVADRS	VIEW	S4B70.BANINST1	Use(select )
SPVADDF	VIEW	S4B70.BANINST1	Use(select )
SPVADDI	VIEW	S4B70.BANINST1	Use(select )
SPVADDS	VIEW	S4B70.BANINST1	Use(select )
SPVADRS	VIEW	S4B70.BANINST1	Use(select )
SRVADRS	VIEW	S4B70.BANINST1	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.PTRINST.PTRINST.PTRINST_ATYP_CODE_1PAY	Rely on ()
POST-CHANGE	Forms Trigger	BANNER7_FORMS.AOAORGN.AORCONT.AORCONT_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.APACRVW.APRCRVW.APRCRVW_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.AOAORGN.AORCONT.AORCONT_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.APACHLD.APRCHLD.APRCHLD_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.APAMAIL.APRMAIL.APRMAIL_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.APAIDEN.SPRTELE.SPRTELE_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.APAIDEN.SPRADDR.SPRADDR_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.PPATELE.SPRTELE.SPRTELE_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.PTRINST.PTRINST.PTRINST_ATYP_CODE_1PAY	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.PPAIDEN.SPREMRG.SPREMRG_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.PPAIDEN.SPRADDR.SPRADDR_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GOAADDR.SPRADDR.SPRADDR_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GOASEVS.GORSVEI.GORSVEI_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GOASEVS.GORSVAS.GORSVAS_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.FTMFMGR.SPRADDR.SPRADDR_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GOASEVS.GOBSEVS.GOBSEVS_ATYP_CODE_ACT_SITE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SOAFOLK.SORFOLK.SORFOLK_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SRAQUIK.DEFAULT_PAGE.DEFAULT_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SRAQUIK.SPRADDR.SPRADDR_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SPATELE.SPRTELE.SPRTELE_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SPAIDEN.SPRTELE.SPRTELE_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SHAMDIP.KEY_BLOCK.SHADIPL_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SPAIDEN.SPREMRG.SPREMRG_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SPAIDEN.SPRADDR.SPRADDR_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SPAEMRG.SPREMRG.SPREMRG_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.APACHLD.APRCHLD.APRCHLD_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.APAMAIL.APRMAIL.APRMAIL_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SRAQUIK.SPRADDR.SPRADDR_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SPATELE.SPRTELE.SPRTELE_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SRAQUIK.DEFAULT_PAGE.DEFAULT_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SOAFOLK.SORFOLK.SORFOLK_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SPAEMRG.SPREMRG.SPREMRG_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SPAIDEN.SPRTELE.SPRTELE_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SPAIDEN.SPRADDR.SPRADDR_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SPAIDEN.SPREMRG.SPREMRG_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SHAMDIP.KEY_BLOCK.SHADIPL_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SAAQUIK.SPRADDR.SPRADDR_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SAAWAPP.SARWAPP.SARWAPP_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.SFARQST.SFRENRL.SFARQST_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.FPAAGRD.FPBAGRH_BLOCK.FPBAGRH_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.FPAREQN.FPBREQH.FPBREQH_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.FPAPURR.FPBPOHD.FPBPOHD_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.FAAINVT.FABINVT.FABINVT_VEND_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.FTMPAYM.FTVPAYM.FTVPAYM_ADDR_TYPE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GOQOLIB.SPREMRG.SPREMRG_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GOQOLIB.SPRADDR.SPRADDR_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.FPAREQN.FPBREQH.FPBREQH_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GOQOLIB.SPRTELE.SPRTELE_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.FPAPURR.FPBPOHD.FPBPOHD_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.FAAINVT.FABINVT.FABINVT_VEND_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.ASASORG.ASRSORG.ASRSORG_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.ASASORG.ASBSORG.ASBSORG_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GOADIRO.GORDADD.GORDADD_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.TGARRAS.TBRRRAS.TBRRRAS_ATYP_SEQNO	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.TSAMISC.TBBMISC.TBBMISC_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SAAQUIK.SPRADDR.SPRADDR_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SAAWAPP.SARWAPP.SARWAPP_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.SFARQST.SFRENRL.SFARQST_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.FTMVEND.FTVVEND.FTVVEND_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.FTMVEND.SPRADDR.SPRADDR_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.FTMAGCY.SPRADDR.SPRADDR_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.FTMAGCY.FTVAGCY.FTVAGCY_ADDR_TYPE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.TSAMISC.TBBMISC.TBBMISC_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.TGARRAS.TBRRRAS.TBRRRAS_ATYP_SEQNO	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.PTRINST.PTRINST.PTRINST_ATYP_CODE_1PAY	Rely on ()
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.PTRINST.PTRINST.PTRINST_ATYP_CODE_1PAY	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.PPATELE.SPRTELE.SPRTELE_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.PPAIDEN.SPREMRG.SPREMRG_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.PPAIDEN.SPRADDR.SPRADDR_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GOAADDR.SPRADDR.SPRADDR_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GOASEVS.GORSVAS.GORSVAS_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GOASEVS.GOBSEVS.GOBSEVS_ATYP_CODE_ACT_SITE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GOADIRO.GORDADD.GORDADD_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.FTMAGCY.SPRADDR.SPRADDR_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.FTMAGCY.FTVAGCY.FTVAGCY_ADDR_TYPE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.FTMFMGR.SPRADDR.SPRADDR_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.FTMPAYM.FTVPAYM.FTVPAYM_ADDR_TYPE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.FRAPROP.FRBPROP.FRBPROP_AGENCY_ADDR_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GOQCLIB.SPREMRG.SPREMRG_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GOQCLIB.SPRADDR.SPRADDR_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.GOQCLIB.SPRTELE.SPRTELE_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.APACRVW.APRCRVW.APRCRVW_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.APAIDEN.SPRADDR.SPRADDR_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.APAIDEN.SPRTELE.SPRTELE_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.FTMVEND.SPRADDR.SPRADDR_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.FTMVEND.FTVVEND.FTVVEND_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.FTMCUST.SPRADDR.SPRADDR_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.FRAGRNT.FRBGRNT.FRBGRNT_AGENCY_ADDR_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.FRAGRNT.FRBGBIL.FRBGBIL_ADDR_TYPE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.FPACHAR.FPBPOHD.FPBPOHD_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.FOAIDEN.SPRADDR.SPRADDR_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.FOAIDEN.SPREMRG.SPREMRG_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.FPABLAR.FPBPOHD.FPBPOHD_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.FOAIDEN.SPRTELE.SPRTELE_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.ASASORG.ASBSORG.ASBSORG_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS_10G.ASASORG.ASRSORG.ASRSORG_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.FPAAGRD.FPBAGRH_BLOCK.FPBAGRH_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.FOAIDEN.SPRADDR.SPRADDR_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.FRAGRNT.FRBGRNT.FRBGRNT_AGENCY_ADDR_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.FPABLAR.FPBPOHD.FPBPOHD_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.FRAPROP.FRBPROP.FRBPROP_AGENCY_ADDR_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.FRAGRNT.FRBGBIL.FRBGBIL_ADDR_TYPE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.FPACHAR.FPBPOHD.FPBPOHD_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.FTMCUST.SPRADDR.SPRADDR_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GOQCLIB.SPREMRG.SPREMRG_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GOQCLIB.SPRADDR.SPRADDR_ATYP_CODE	Use(select )
POST-CHANGE	Forms Trigger	BANNER7_FORMS.GOQCLIB.SPRTELE.SPRTELE_ATYP_CODE	Use(select )
POST-TEXT-ITEM	Forms Trigger	BANNER7_FORMS_10G.FAAINVT.FABINVT.FABINVT_VEND_ATYP_CODE	Use(select )
POST-TEXT-ITEM	Forms Trigger	BANNER7_FORMS.FAAINVT.FABINVT.FABINVT_VEND_ATYP_CODE	Use(select )
STVATYP	Forms Trigger	BANNER7_FORMS.SOAXREF.SORXREF.SORXREF_BANNER_VALUE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.ADADESG.ADRDIDS.ADRDIDS_ATYP_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.GOAADRL.GORADRL.GORADRL_ATYP_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.GEAPART.GERPART.GERPART_ATYP_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.SOAMATL.STATE_RULE.SORMSTA_ATYP_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.SRAWPRO.SRBWPRO.SRBWPRO_ATYP_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.SMARQCM.SMRPRRQ.SHARQST_ATYP_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.SHARQTC.SHTTRAN.SHARQST_ATYP_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.ADADESG.ADRDIDS.ADRDIDS_ATYP_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.SHARQTC.SHTTRAN.SHARQST_ATYP_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.SMACACT.SMTPRRQ.SHARQST_ATYP_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.SRAWPRO.SRBWPRO.SRBWPRO_ATYP_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.SOAMATL.STATE_RULE.SORMSTA_ATYP_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.SMARQCM.SMRPRRQ.SHARQST_ATYP_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.PEAHIRE.NEW_ADDRESS.ATYP_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.GOASEGC.GORVSVR.GORVSVR_VTBL_VALUE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.APASRVW.APRSRVW.APRSRVW_ATYP_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.PEAHIRE.NEW_ADDRESS.ATYP_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.GOASEGC.GORVSVR.GORVSVR_VTBL_VALUE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.GOASEVS.GORSVEI.GORSVEI_ATYP_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.GOAADRL.GORADRL.GORADRL_ATYP_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.GEAPART.GERPART.GERPART_ATYP_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.APASRVW.APRSRVW.APRSRVW_ATYP_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS.FPAPRBD.KEY_BLOCK.KEYBLOK_ATYP_CODE	Use(select )
WHEN-VALIDATE-ITEM	Forms Trigger	BANNER7_FORMS_10G.FPAPRBD.KEY_BLOCK.KEYBLOK_ATYP_CODE	Use(select )
WHEN_VALIDATE_ITEM	Forms Trigger	BANNER7_FORMS.TSAMISC.TBBMISC.TBBMISC_ATYP_CODE	Use(select )
WHEN_VALIDATE_ITEM	Forms Trigger	BANNER7_FORMS_10G.TSAMISC.TBBMISC.TBBMISC_ATYP_CODE	Use(select )
XPOST_CHANGE