Dashboard > Electronic Research Administration > SH_STATE_T
Electronic Research Administration Log In   View a printable version of the current page.
SH_STATE_T
Added by K Lars Lohn, last edited by K Lars Lohn on Sep 28, 2005  (view change)
Labels: 
(None)

Shared State Table

You can edit parts of this page
The space between any outline numbered header and the first table under that header is editable. Any cell in a table with a header of "comment" is also editable. Anything that you add to these spaces will be persistent between runs of the analysis tool

1 Database Schema

name human readable name (edit dictionary) primary type size scale null default indexed comment
OBJ_ID Object Identifier false VARCHAR ? ? true ? false  
POSTAL_STATE_CD Postal State Code true VARCHAR ? ? true ? false  
POSTAL_STATE_NM Postal State Name false VARCHAR ? ? true ? false  
VER_NBR Version Number false BIGINT ? ? true ? false  

1.1 Indexes

Indexes may be added as a future enhancement

1.2 Foreign Key Relationships

1.2.1 Out Bound Relationships
No out bound relationships found.
1.2.2 In Bound Relationships

1.2.2.1 contractsAndGrantsSubcontractorState

qualified foreign column local column comment
CG_SUBCNR_T.CG_SUBCNR_ST_CD POSTAL_STATE_CD  

1.2.2.2 state

qualified foreign column local column comment
SH_ZIP_CODE_T.POSTAL_STATE_CD POSTAL_STATE_CD  
1.2.3 One to Many Relationships

These are the relationships implemented as collections in the Java implementation of this table.

No one to many relationships found.

2 Database to Java Relationships

This table is represented by the class org.kuali.module.kra.bo.SharedState

2.1 Attribute to Column Name Mapping

column name attribute name attribute access comment
OBJ_ID objectId readwrite  
POSTAL_STATE_CD postalStateCode readwrite  
POSTAL_STATE_NM postalStateName readwrite  
VER_NBR versionNumber readwrite  

2.2 Source Code References

file name (line number) quote comment
work/src/org/kuali/module/kra/OJB-repository-kra.xml (30) <class-descriptor class="org.kuali.module.kra.bo.SharedState" table="SH_STATE_T">  
work/web-root/WEB-INF/classes/org/kuali/module/kra/OJB-repository-kra.xml (30) <class-descriptor class="org.kuali.module.kra.bo.SharedState" table="SH_STATE_T">  
build/web-root/WEB-INF/classes/org/kuali/module/kra/OJB-repository-kra.xml (30) <class-descriptor class="org.kuali.module.kra.bo.SharedState" table="SH_STATE_T">  
build/test-root/classes/org/kuali/module/kra/OJB-repository-kra.xml (30) <class-descriptor class="org.kuali.module.kra.bo.SharedState" table="SH_STATE_T">  

2.3 Diagram

Site powered by a free Open Source Project / Non-profit License (more) of Confluence - the Enterprise wiki.
Learn more or evaluate Confluence for your organisation.
Powered by Atlassian Confluence, the Enterprise Wiki. (Version: 2.2.7 Build:#524 Jul 28, 2006) - Bug/feature request - Contact Administrators