PS_AV_CNST_TYP_TBL Table   Tables and Data Elements   ATLAS Data Warehouse Home   Data Warehouse Home

PS_AV_CNST_TYP_TBL Table

Explanation
This table list all constituent types for an entity in Atlas. Constituent types define the type of entity and its relationship to the University. Values include Alumni, Parents, Corporation, Foundations, etc.

Common Uses

Identifying all parents.

CNST_TYPE
EMPLID
EXT_ORG_ID  

      

CNST_TYPE
EMPLID
EXT_ORG_ID    

WHSE_CONSTITUENTS

• For individuals, there may be multiple constituent types.

PS_AV_CNST_TYP_TBL Table   Tables and Data Elements   ATLAS Data Warehouse Home  Data Warehouse Home