Entity Registry and SOLA
This table lists the records and their corresponding entities that are populated through Constituent Staging and Application Transactions staging tables from SOLA:
Entity ID |
Entity Name |
Staging Record |
---|---|---|
SCC_ENTITY_20090521054417 |
Constituent |
SCC_STG_CONSTIT |
SCC_ENTITY_20090520155540 |
Person Data Effdt |
SCC_STG_PDE |
SCC_ENTITY_20090521053330 |
Names |
SCC_STG_NAMES |
SCC_ENTITY_20090520155755 |
Address |
SCC_STG_ADDR |
SCC_ENTITY_20090520155634 |
Phone |
SCC_STG_PHONE |
SCC_ENTITY_20090521044252 |
Email Address |
SCC_STG_EMAIL |
SCC_ENTITY_20090520155342 |
National ID |
SCC_STG_NID |
SCC_ENTITY_20090519160928 |
Citizenship |
SCC_STG_CITZN |
SCC_ENTITY_20090520035051 |
Person Data (USA) |
SCC_STG_PRSDATU |
SCC_ENTITY_20090723101739 |
Emergency Contact |
SCC_STG_EMG_CNT |
SCC_ENTITY_20090723101507 |
Emergency Phone |
SCC_STG_EMG_PHN |
SCC_ENTITY_20090521094345 |
Application |
SAD_APL_DAT_STG |
SCC_ENTITY_20090521094125 |
Career Sequence |
SAD_APP_CSQ_STG |
SCC_ENTITY_20090521093827 |
Academic Program |
SAD_APL_PRG_STG |
SCC_ENTITY_20090521093651 |
Academic Plan |
SAD_APL_PLN_STG |
SCC_ENTITY_20090520153020 |
Student Career (Constituent) |
SCC_STG_STD_CAR |
SCC_ENTITY_20090521090104 |
Application Attachment |
SAD_APLATCH_STG |
SCC_ENTITY_20090521084930 |
File Attachment |
SCC_FATTACH_WRK |
SCC_ENTITY_20090521043203 |
Academic History |
SCC_STG_ACADHST |
SCC_ENTITY_20090520160401 |
External Academic Data |
SCC_STG_EXACDDT |
SCC_ENTITY_20090521042406 |
External Degree |
SCC_STG_EXTDEGR |
SCC_ENTITY_20090625090929 |
Q&A Application Extension |
SCC_EXTN_STG |
N/A |
N/A |
SCC_SL_TRNMAP (Records a mapping between the Transaction Manager constituent and any transaction the constituent has participated.) |