Using Staging Tables
There are two types of staging tables:
Constituent staging records.
Transaction-specific staging records.
The constituent staging records are reusable across all transactions and therefore delivered with your system as part of CTM. The transaction-specific staging records must be created based on the transaction you want to perform.
A staging record is modeled after the corresponding production record, but its structure varies slightly:
It is keyed by Temporary ID (SCC_TEMP_ID) instead of ID (EMPLID).
It is never effective-dated (even if the matching production record is effective-dated). This is because the data entered in staging records can be updated, modified many times prior to be posted to production. Only at that time, the data is current and therefore the production record gets set with the date the data is posted.
The constituent data is saved in the delivered constituent staging records (see the following list of delivered constituent staging records). The transaction-specific data is stored in the transaction staging records. These staging records are either delivered with your system in the case of fully implemented delivered CTM consumers transactions (such as the AAWS admission transaction) or created by you for the transaction of your choice.
See Developer Reference for Creating a New CTM Consumer, “Step 1: Creating or Extending Staging Tables.”
The following constituent staging records are delivered for the matching production records:
|
Staging Record Definitions |
Staging Record Names |
Production Record Names |
|---|---|---|
|
Academic History * |
SCC_STG_ACADHST |
ACAD_HISTORY |
|
Academic Interests Header * |
SCC_STG_ADMIHD |
ADM_INTRST_HDR |
|
Address |
SCC_STG_ADDR |
HCR_PER_ADDR_I |
|
CHESSN (AUS) |
SCC_CHSNAUS_STG |
SCC_CHESSN_AUS |
|
CHESSN Prior HEP (AUS) |
SCC_PRHEPAU_STG |
SCC_PRV_HEP_AUS |
|
CHESSN Year 12 (AUS) |
SCC_YR12_AU_STG |
SCC_YEAR12_AUS |
|
Citizenship |
SCC_STG_CITZN |
SCC_CITIZSHIP_I |
|
Citizenship History (AUS) |
SCC_CITZHST_STG |
SCC_CITIZ_HIST |
|
Disability |
SCC_STG_DISBLTY |
HCR_DISABL_I |
|
Diversity |
SCC_STG_DIVRSTY |
SCC_DIVERS_I |
|
Drivers License |
SCC_STG_DRV_LIC |
SCC_DRVR_LIC_I |
|
Email Address |
SCC_STG_EMAIL |
HCR_PER_EMAIL_I |
|
Emergency Contact |
SCC_STG_EMG_CNT |
SCC_EMERG_CNT_2 |
|
External System Key |
SCC_STG_EXT_SKY |
EXTERNAL_SYSKEY |
|
Extracurricular Activity |
SCC_STG_EXTRACU |
EXTRACUR_ACTVTY |
|
General Materials * |
SAD_STG_GEN_MAT |
GENL_MATERIALS |
|
HESA Person (UK) |
SCC_HE_PERS_STG |
SCC_HE_PERSON |
|
Higher Ed Student Data (NLD) |
SSR_STD_NLD_STG |
SSR_STUDENT_NLD |
|
Honors and Awards |
SCC_STG_HON_AWD |
HONOR_AWARD_CS |
|
Language |
SCC_STG_LANG |
SCC_LANGUAG_TBL |
|
Licenses and Certificates |
SCC_STG_LICCERT |
SCC_LICCERT_TBL |
|
Memberships |
SCC_STG_MBRSHP |
SCC_MBERSHP_TBL |
|
Names |
SCC_STG_NAMES |
SCC_PER_NAME_I2 |
|
National ID |
SCC_STG_NID |
HCR_PER_NID_I |
|
Person Data (CAN) |
SCC_PDECAN_STG |
HCR_PER_CAN_I |
|
Person Data (NZL) |
SCC_PER_NZL_STG |
SCC_PERSONL_NZL |
|
Person Data (USA) |
SCC_STG_PRSDATU |
HCR_PER_USA_I |
|
Person Data Effdt |
SCC_STG_PDE |
SCC_PER_EFF_H |
|
Person Relationship |
SCC_STG_RLSHIPS |
RELATIONSHIPS |
|
Person SA |
SCC_STG_PERSSA |
PERSON_SA |
|
Personal Details |
SCC_STG_PERSBIO |
SCC_PERS_BIOG |
|
Phone |
SCC_STG_PHONE |
HCR_PER_PHONE_I |
|
Port of Entry Data |
SCC_STG_SEVPOED |
SEV_POE_DATA |
|
Publications |
SCC_STG_PUBLIC |
SCC_PUBL_I |
|
Religious Preference |
SCC_STG_RELPREF |
RELIGIOUS_PREF |
|
Residency Official |
SCC_STG_RES_OFF |
RESIDENCY_OFF |
|
Residency Self |
SCC_STG_RES_SLF |
RESIDENCY_SELF |
|
Scholarship Data (NLD) |
SSR_SCL_NLD_STG |
SSR_SCHOLAR_NLD |
|
Staged User Preference |
SCC_STG_ENT_WRK |
SCC_PRD_ENT_WRK |
|
Student Bank Account (NLD) |
SSF_BNK_NLD_STG |
SSF_BANKACC_NLD |
|
Student Career (Constituent) |
SCC_STG_STD_CAR |
STDNT_CAREER |
|
Student Correspondence (NLD) |
SSR_COR_NLD_STG |
SSR_CORRSPN_NLD |
|
Student Data (AUS) |
SSR_STD_DAT_STG |
SSR_STDNT_DATA |
|
Student Information (NLD) |
SSR_INF_NLD_STG |
SSR_STD_INF_NLD |
|
Student Names (NLD) |
SSR_NME_NLD_STG |
SSR_NAMES_NLD |
|
Student Nationalities (NLD) |
SSR_NAT_NLD_STG |
SSR_EMP_NAT_NLD |
|
Student Prior Education (NLD) |
SSR_EDU_NLD_STG |
SSR_STD_EDU_NLD |
|
Student Report (CAN) |
SSR_STG_CNRP_ST |
CAN_RPT_STDNT |
|
Test Score * |
SCC_STG_TEST |
STDNT_TEST |
|
Tribal Affiliation (NZL) |
SCC_IWI_TBL_STG |
SCC_IWI_TBL |
|
Visa Permit Data |
SCC_STG_VISPMTD |
SCC_VISA_PMT_I |
|
Visa Permit Data (NLD) |
SCC_STG_VP_NLD |
SCC_VISAPMT_NLD |
|
Visa Permit Support |
SCC_STG_SUP_NLD |
SCC_VISA_SUP_I |
|
Visa Permit Support (NLD) |
SCC_STG_VIS_SUP |
SCC_VISAPMT_NLD |
|
Work Experience |
SCC_STG_WORKEXP |
SCC_PRIORWORK |
* For coding purposes, this Recruiting and Admissions record is a child of the Constituent entity. The record is not displayed in the Constituent Staging component and cannot be configured for data update rule.
Note: You can extend this list or modify an existing staging record.
The following table is a comparison of the structure of the address staging record with the structure of its matching production record.
|
Production Record (HCR_PER_ADDR_I) |
Staging Record (SCC_STG_ADDR) |
|---|---|
|
EMPLID - Key |
SCC_TEMP_ID - Key |
|
ADDRESS_TYPE - Key |
ADDRESS_TYPE - Key |
|
EFFDT - Key |
SCC_ADDRESSAREA |
|
EFF_STATUS |
ADDR_TYPE_DESCR |
|
ADDRESS_NPC_SBR |
ADDRESS_SBR |
|
COUNTRY |
COUNTRY |
|
ADDRESS1 |
ADDRESS1 |
|
ADDRESS2 |
ADDRESS2 |
|
ADDRESS3 |
ADDRESS3 |
|
ADDRESS4 |
ADDRESS4 |
|
CITY |
CITY |
|
NUM1 |
NUM1 |
|
NUM2 |
NUM2 |
|
HOUSE_TYPE |
HOUSE_TYPE |
|
ADDR_FIELD1 |
ADDR_FIELD1 |
|
ADDR_FIELD2 |
ADDR_FIELD2 |
|
ADDR_FIELD3 |
ADDR_FIELD3 |
|
COUNTY |
COUNTY |
|
STATE |
STATE |
|
POSTAL |
POSTAL |
|
GEO_CODE |
GEO_CODE |
|
IN_CITY_LIMIT |
IN_CITY_LIMIT |
|
ADDRESS1_AC |
ADDRESS1_AC |
|
ADDRESS2_AC |
ADDRESS2_AC |
|
ADDRESS3_AC |
ADDRESS3_AC |
|
CITY_AC |
CITY_AC |
|
REG_REGION |
REG_REGION |
|
SCC_AUDIT_SBR |
|
|
SCC_ROW_ADD_OPRID |
|
|
SCC_ROW_ADD_DTTM |
|
|
SCC_ROW_UPD_OPRID |
|
|
SCC_ROW_UPD_DTTM |
Campus Solutions provides transaction staging tables only for out-of-the-box transactions like AAWS admissions, Delegated Access (DA), and so on. So if you create a transaction related to admissions data, you could use those staging tables. However, If you create a new consumer of CTM, you need to create your own transaction staging tables based on the production records used by the transaction you want to integrate with CTM. For example, if you want to create an Online Donation transaction, you will need to create staging tables for the production tables used when entering a donation.
The following table is a comparison of the structure of the admissions academic interest staging record with the structure of its matching production record.
|
Production Record (ADM_INTERESTS) |
Staging Record (SCC_STG_ADMINT) |
|---|---|
|
EMPLID - Key |
SCC_TEMP_ID - Key |
|
ACAD_CAREER - Key |
ACAD_CAREER - Key |
|
EFFDT - Key |
|
|
SEQNUM - Key |
SEQNUM - Key |
|
EXT_SUBJECT_AREA |
EXT_SUBJECT_AREA |
|
DESCR |
DESCR |
|
LS_DATA_SOURCE |
LS_DATA_SOURCE |
|
PRIORITY |
PRIORITY |
|
SCC_AUDIT_SBR |
|
|
SCC_ROW_ADD_OPRID |
|
|
SCC_ROW_ADD_DTTM |
|
|
SCC_ROW_UPD_OPRID |
|
|
SCC_ROW_UPD_DTTM |