Penn Computing

University of Pennsylvania
Penn Computing << go backback

Back to Clickable Table Diagram

Dependent Host-Affiliation Crossref Table - Data Element Index

The Dependent Host-Affiliation Crossref table describes which Host Affiliation Codes are allowed to have which Dependent Affiliations. Example: A Faculty Affiliation may be allowed to have a Dependent Affiliation of 'SPSE' (Spouse).

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

Data element Definition
DEPENDENT_AFFILIATION_CODE

Indexed - no
Format - varchar2 (4)
May be null? no

Affiliation Code of the Dependent affiliation (such as 'Spouse' or 'Child').

 

top

HOST_AFFILIATION_CODE

Indexed - no
Format - varchar2 (4)
May be null? no

Affiliation code for the Host (such as Faculty or Staff).

 

top

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania