The CNAC_CODES Table - Data Element Index


			<< go back

Select a data element to view its definition and its indexed, format, and null values.

Data element	Definition
EMPLID Indexed - Yes Format - VARCHAR2 Nullable - N	" Unique identifier for individual (non-org) records.
EXT_ORG_ID Indexed - Yes Format - VARCHAR2 Nullable - N	" unique identifier for org (non-individual) records
SEQNO Indexed - Yes Format - NUMBER Nullable - N
UP_FOR_AREA Indexed - Yes Format - VARCHAR2 Nullable - N
UP_BY_AREA Indexed - No Format - VARCHAR2 Nullable - N
UP_CONTACT_EXCL Indexed - Yes Format - VARCHAR2 Nullable - N
UP_EXCLUSION_REASN Indexed - Yes Format - VARCHAR2 Nullable - N
START_DT Indexed - No Format - DATE Nullable - N
END_DT Indexed - No Format - DATE Nullable - Y
DESCR254 Indexed - No Format - VARCHAR2 Nullable - N	" Notes on contact exclusion. Usually conversion explanation.
OPRID Indexed - No Format - VARCHAR2 Nullable - N
OPRID2 Indexed - No Format - VARCHAR2 Nullable - N
CREATION_DT Indexed - No Format - DATE Nullable - Y
DATETIME_UPDATED Indexed - No Format - DATE Nullable - Y

Questions about this page? Email us at da-staff@isc.upenn.edu