UC_REF - Static List of columns where specific Objects can be referenced. This mapping is needed by the Usage search

Name	Type MSSql	Type Oracle	Type DB2	Type Postgresql	Nullable	Description
REF_OType	varchar (10)	VARCHAR2 (10 CHAR)	varchar(10)	varchar (10)	false	Object Type that can be referenced
REF_Table	varchar (10)	VARCHAR2 (10 CHAR)	varchar(10)	varchar (10)	false	Table where the reference is placed
REF_Column	varchar (18)	VARCHAR2 (18 CHAR)	varchar(18)	varchar (18)	false	Column where the reference is placed
REF_Id	int	NUMBER(38,0)	int	int	false	MLS number to identify the reference within the Object Type. Offset to 4009500
REF_Insert	varchar (18)	VARCHAR2 (18 CHAR)	varchar(18)	varchar (18)	true	Additional column that yields information about the reference (e.g. LNR for tasks)

Name	Fields	Primary	Unique	Clustered	Nonclustered
PK_REF	REF_OTYPE, REF_Table, REF_COLUMN	true	true	true	false

Name	Local References	Foreign References

Return to the Index File