Organizational Database

Easytrieve Plus Considerations

The Easytrieve Plus file descriptions for the Organizational Database tables are as follows:

Table Description	Table Name	Easytrieve Plus Name
Division Table	ORG_DIV	LIBODBDV
College Table	ORG_COL	LIBODBCL
School Table	ORG_SCHL	LIBODBSC
Department Table	ORG_DEPT	LIBODBDP
Sub-Department Table	ORG_SUBDEPT	LIBODBSD

In addition, a MACRO variable is needed to be able to specify the table ownership prefix of either AUP51 (for test tables) of AUP52 (for production tables). Use the ORGVER MACRO variable for this specification. It should be used as follows:


SELECT ...                                                             +
       ...                                                             +
FROM   &ORGVER.ORG_...                                                 +
WHERE  ...                                                             +

OIT--Applications Support

Last Modified: Thursday, 05-Oct-2000 08:00:32 CDT