Penn Computing

University of Pennsylvania
Penn Computing << go backback

Data Elements    Penn Community Details

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


Data Elements    Penn Community Details

Documentation Contact: penncommda@isc.upenn.edu

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