FIS_ER.SH_STATE_T - Electronic Research Administration

Shared State Table

This is a table in tablespace FIS_ER.

Purpose:

Schema

name	human readable name	primary	type	size	scale	null	default	indexed	comment
POSTAL_STATE_CD	Postal State Code		VARCHAR2	2		No		Yes
POSTAL_STATE_NM	Postal State Name		VARCHAR2	30		Yes		No

Potential Foreign Key Relationships

No relationships detected

Indexes

name	colunm name	column position	direction
SH_STATE_TP1	POSTAL_STATE_CD	1	ASC

Source Code References

file name	line number	quote
erasrc/ERA/src/edu/iu/uis/fps/er/data/global/GB_StateDomainS uper.java	63	this.setTableName("FIS_ER.SH_STATE_T");

DDL SQL

CREATE TABLE "FIS_ER"."SH_STATE_T" ("POSTAL_STATE_CD" VARCHAR2(2 
    byte) NOT NULL, "POSTAL_STATE_NM" VARCHAR2(30 byte))  
    TABLESPACE "FIS_ER" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 
    255 
    STORAGE ( INITIAL 160K NEXT 0K MINEXTENTS 1 MAXEXTENTS 
    2147483645 PCTINCREASE 0)