Penn Computing

University of Pennsylvania
Penn Computing << go backback

Back to Clickable Table Diagram

Source-Affiliation Crossref Table - Data Element Index

The Source-Affiliation Crossref table describes which Affiliation Codes are allowed to be supplied by which data Source(s)).

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

Data element Definition
AFFILIATION_CODE

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

Code for the allowed affiliation.

 

top

SOURCE

Indexed - no
Format - varchar2 (10)
May be null? yes

Source of the affiliation. Values could be online entry, or from a batch feed from SRS, Payroll, or UPHS.

 

top

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