Populating the CS-Person Profile
The base table for the CS-Person profile is CS_PERS_DATA_SA. The values for the fields in this table are supplied through a number of Enterprise Integration Points (EIPs):
PERSON_BASIC_SYNC.
PERSON_DISABILITY_SYNC.
PERSON_DIVERSITY_SYNC.
SCC_PERSON_SYNC.
The subscription code for PERSON_BASIC_SYNC updates the CS-Person field values for fields published through this message. Additionally, CRM subscribes to the following EIPs to populate the rest of the fields for the CS-Person Profile and the CS-Person Ethnicity profile:
PERSON_DIVERSITY_SYNC.
PERSON_DISABILITY_SYNC.
ETHNIC_GRP_SYNC.
ETHNIC_GRP_FULLSYNC.
PERSON_DIVERSITY_FULLSYNC.
The following figure depicts the EIPs that update the CS-Person and CS-Person Ethnic profiles.
The following fields in the CS-Person profile (table CS_PERS_DATA_SA) are populated through PERSON_BASIC_SYNC. If PERSON_BASIC_SYNC is bringing over a new person, a row in CS_PERS_DATA_SA is created only if the person has both an EMPLID and a value for at least one of the other fields described in the following table.
|
Field in CS_PERSON_DATA_SA |
Field in PERSON_BASIC_SYNC |
|---|---|
|
EMPLID |
EMPLID |
|
BIRTHPLACE |
BIRTHPLACE |
|
BIRTHCOUNTRY |
BIRTHCOUNTRY |
|
BIRTHSTATE |
BIRTHSTATE |
|
DT_OF_DEATH |
DT_OF_DEATH |
|
HIGHEST_EDUC_LVL |
HIGHEST_EDUC_LVL |
|
FT_STUDENT |
FT_STUDENT |
|
PER_TYPE |
Left blank; this field does not exist in PERSON_BASIC_SYNC |
|
MAR_STATUS |
MAR_STATUS |
|
MILITARY_STATUS |
MILITARY_STATUS |
|
CITIZEN_PROOF1 |
CITIZEN_PROOF1 |
|
CITIZEN_PROOF2 |
CITIZEN_PROOF2 |
The PERSON_DISABILITY_SYNC EIP publishes changes to a person's disability-related information for a person. CRM subscribes to PERSON_DISABILITY_SYNC to populate the following disability related fields in CS_PERS_DATA_SA:
|
Field in CS_PERSON_DATA_SA |
Field in PERSON_DISABILITY_SYNC |
|---|---|
|
DISABLED |
DISABILITY DISABLED |
|
DISABLED_VET |
DISABILITY DISABLED_VET |
One of the fields in the CS-Person profile, CS_ETHNIC_GROUP, does not come directly through any of the EIPs. To set this field in CRM, a control table (ETHNIC_GRP_TBL) and its data from CS is required in CRM.
CS publishes ETHNIC_GRP_FULLSYNC to distribute all the data for this table and ETHNIC_GRP_SYNC for any incremental data changes.
In CRM, the table ETHNIC_GRP_TBL (identical to the one in CS) exists and subscribes to ETHNIC_GRP_FULLSYNC and ETHNIC_GRP_SYNC messages to populate it.
Initially, the Full Sync should be used to move all the data for ETHNIC_GRP_TBL from CS to CRM. Any addition/modification later are synchronized through the incremental sync.
These topics discuss:
Updating the CS-Person profile.
Updating the CS-Person Ethnicity profile.
Updating the CS-Person Profile
The PERSON_DIVERSITY_SYNC is designed by CS to publish any changes made to a person's diversity-related information. CRM subscribes to PERSON_DIVERSITY_SYNPERSON_DIVERSITY_SYNCC (VERSION_2) to populate the Diversity (Ethnicity) related fields in CS_PERS_DATA_SA that are shown in the following table:
|
Field in CS_PERSON_DATA_SA |
Field in PERSON_DIVERSITY_SYNC |
Comments |
|---|---|---|
|
CS_WAIVE_DATA_PROT |
WAIVE_DATA_PROTECT |
|
|
CS_CAN_ABORIGINAL |
CAN_ABORIGINAL |
|
|
CS_CAN_VIS_MINOR |
CAN_VISBL_MINORITY |
|
|
CS_ETHNIC_GROUP |
To populate this field, use the ETHNIC_GROUP_CD and SETID fields coming through this message to retrieve the values of ETHNIC_GROUP or ETHNIC_CATEGORY |
To populate this field, use the ETHNIC_GROUP_CD and SETID fields to retrieve the value for CS_ETHNIC_GROUP: If SETID is USA, retrieve the value of field ETHNIC_GROUP from ETHNIC_GRP_TBL to set CS_ETHNIC_GROUP. If SETID is Not USA, retrieve the value of field ETHNIC_CATEGORY from ETHNIC_GRP_TBL to set CS_ETHNIC_GROUP. (Note: General effective dated logic applies. Based on Effective Date, the ETHNIC_GRP_CD/SETID map to one and only one ETHNIC_GROUP and ETHNIC_CATEGORY |
Updating the CS-Person Ethnicity Profile
CRM subscribes to PERSON_DIVERSITY_SYNC and publishes all the fields that are required to populate the CS-Person Ethnicity profile (Table CS_PERS_ETHNIC). The subscription code updates the CS-Person Ethnicity profile. The following table describes the field mapping:
|
Field in CS_PERS_ETHNIC |
Field in PERSON_DIVERSITY_SYNC |
Comments |
|---|---|---|
|
BO_ID |
Use EMPLID to derive BO_ID |
The EIP brings EMPLID, which is used to identify the BO_ID in CRM. |
|
CS_ETHNIC_GROUP_CD |
ETHNIC_GROUP_CD |
|
|
CS_ETHNIC_SETID |
SETID |
|
|
PRIMARY_INDICATOR |
PRIMARY_INDICATOR |
|
|
HISP_LATINO |
Set to Y or N based on ETHNIC_GROUP and ETHNIC_CATEGORY |
Based on ETHNIC_GROUP_CD and SETID fields, retrieve the value of ETHNIC_GROUP or ETHNIC_CATEGORY For SETID USA, if the ETHNIC_GROUP = 3 or D, set HISP_LATINO to Y, otherwise set it to N. For SETID <> USA, if the ETHNIC_CATEGORY = 3, set HISP_LATINO to Y, otherwise set it to N. |
Because CS publishes PERSON_DIVERSITY_FULLSYNC, CRM subscribes to this full sync as well. Initially, it is used to move all the data for the CS-Person Ethnicity profile from CS to CRM, and then any incremental changes is synchronized through PERSON_DIVERSITY_SYNC. Information about one of the fields in CS-Person profile (field CS_ETHNIC_GROUP) also comes through the PERSON_DIVERSITY_FULLSYNC and PERSON_DIVERSITY_SYNC EIPs.
The following table describes the CS-Person profile field mappings with the respective Full Sync and Incremental Sync messages:
|
Field Name |
Full Sync Source |
Incremental Sync Source |
|---|---|---|
|
BO_ID |
Identified based on EMPLID |
Identified based on EMPLID |
|
RA_ATTRIB_SEQ |
Sequence number |
Sequence number |
|
EMPLID |
CS_PERS_DATA_EXTEND_FULLSYNC |
PERSON_BASIC_SYNC |
|
BIRTHPLACE |
CS_PERS_DATA_EXTEND_FULLSYNC |
PERSON_BASIC_SYNC |
|
BIRTHCOUNTRY |
CS_PERS_DATA_EXTEND_FULLSYNC |
PERSON_BASIC_SYNC |
|
BIRTHSTATE |
CS_PERS_DATA_EXTEND_FULLSYNC |
PERSON_BASIC_SYNC |
|
DT_OF_DEATH |
CS_PERS_DATA_EXTEND_FULLSYNC |
PERSON_BASIC_SYNC |
|
HIGHEST_EDUC_LVL |
CS_PERS_DATA_EXTEND_FULLSYNC |
PERSON_BASIC_SYNC |
|
FT_STUDENT |
CS_PERS_DATA_EXTEND_FULLSYNC |
PERSON_BASIC_SYNC |
|
MAR_STATUS |
CS_PERS_DATA_EXTEND_FULLSYNC |
PERSON_BASIC_SYNC |
|
MILITARY_STATUS |
CS_PERS_DATA_EXTEND_FULLSYNC |
PERSON_BASIC_SYNC |
|
CITIZEN_PROOF1 |
CS_PERS_DATA_EXTEND_FULLSYNC |
PERSON_BASIC_SYNC |
|
CITIZEN_PROOF2 |
CS_PERS_DATA_EXTEND_FULLSYNC |
PERSON_BASIC_SYNC |
|
CS_CAMPUS_ID |
CS_PERS_DATA_EXTEND_FULLSYNC |
SCC_PERSON_SYNC |
|
CS_DEATH_CERT_NBR |
CS_PERS_DATA_EXTEND_FULLSYNC |
SCC_PERSON_SYNC |
|
CS_FERPA |
CS_PERS_DATA_EXTEND_FULLSYNC |
SCC_PERSON_SYNC |
|
CS_PLACE_OF_DEATH |
CS_PERS_DATA_EXTEND_FULLSYNC |
SCC_PERSON_SYNC |
|
DISABLED |
CS_PERS_DATA_EXTEND_FULLSYNC |
PERSON_DISABILITY_SYNC |
|
DISABLED_VET |
CS_PERS_DATA_EXTEND_FULLSYNC |
PERSON_DISABILITY_SYNC |
|
CS_WAIVE_DATA_PROT |
CS_PERS_DATA_EXTEND_FULLSYNC |
PERSON_DIVERSITY_SYNC |
|
CS_CAN_ABORIGINAL |
CS_PERS_DATA_EXTEND_FULLSYNC |
PERSON_DIVERSITY_SYNC |
|
CS_CAN_VIS_MINOR |
CS_PERS_DATA_EXTEND_FULLSYNC |
PERSON_DIVERSITY_SYNC |
|
CS_ETHNIC_GROUP |
PERSON_DIVERSITY_FULLSYNC |
PERSON_DIVERSITY_SYNC |
The following table describes the CS-Person Ethnicity profile field mappings with the respective Full Sync and Incremental Sync messages:
|
Field Name |
Full Sync Source |
Incremental Sync Source |
|---|---|---|
|
BO_ID |
Identified based on EMPLID |
Identified based on EMPLID |
|
RA_ATTRIB_SEQ |
Sequence number |
Sequence number |
|
CS_ETHNIC_GRP_CD |
PERSON_DIVERSITY_FULLSYNC |
PERSON_DIVERSITY_SYNC |
|
CS_ETHNIC_SETID |
PERSON_DIVERSITY_FULLSYNC |
PERSON_DIVERSITY_SYNC |
|
HISP_LATINO |
PERSON_DIVERSITY_FULLSYNC |
PERSON_DIVERSITY_SYNC |
|
PRIMARY_INDICATOR |
PERSON_DIVERSITY_FULLSYNC |
PERSON_DIVERSITY_SYNC |