RETURN TO STUDENT META DATA REPORTS |
Source Name | Data Element | Mapped Target | Mapped Target Column |
---|---|---|---|
SPRIDEN | SPRIDEN_PIDM | ENTITY_UID ENTITY_UID ENTITY_UID PERSON_UID AGENCY_UID_LEVEL_3 ENTITY_UID AGENCY_UID_LEVEL_2 AGENCY_UID_LEVEL_4 ENTITY_UID PERSON_UID AGENCY_UID_LEVEL_3 AGENCY_UID_LEVEL_1 AGENCY_UID_LEVEL_4 AGENCY_UID_LEVEL_2 AGENCY_UID_LEVEL_1 AGENCY_ID |
|
SPRIDEN | SPRIDEN_ID | ADMINISTRATOR_ID PRIMARY_ADVISOR_ID ADVISOR_ID FUND_FINANCIAL_MANAGER_ID FINANCIAL_MANAGER_ID AGENCY_ID_LEVEL_1 AGENCY_ID_LEVEL_3 PRINCIPAL_INVESTIGATOR_ID FUND_FINANCIAL_MANAGER_ID AGENCY_ID_LEVEL_4 AGENCY_ID_LEVEL_3 AGENCY_ID_LEVEL_2 AGENCY_ID_LEVEL_1 SOLICITOR_ID ID FINANCIAL_MANAGER_ID ID ORGN_FINANCIAL_MANAGER_ID ID SOLICITOR_ID PRIMARY_INSTRUCTOR_ID RELATED_ID RECRUITER_ID ID VENDOR_ID AGENCY_ID_LEVEL_4 AGENCY_ID_LEVEL_2 SOLICITOR_ID PERSON_ID THIRD_PARTY_ID ORGN_FINANCIAL_MANAGER_ID |
|
SPRIDEN | SPRIDEN_LAST_NAME | ADMINISTRATOR_LAST_NAME FMGR_LAST_NAME MATCH_EMPLOYER_NAME NAME ORGN_FMGR_LAST_NAME FUND_FMGR_LAST_NAME VENDOR_NAME PRINCIPAL_INVESTIGATOR_LNAME AGENCY_NAME_LEVEL_4 AGENCY_NAME_LEVEL_3 AGENCY_NAME_LEVEL_2 AGENCY_NAME_LEVEL_1 NAME BANK_NAME SOLICITOR_LAST_NAME PRIMARY_INSTRUCTOR_LAST_NAME RELATED_LAST_NAME CARRIER_NAME LAST_NAME AGENCY_NAME_LEVEL_4 AGENCY_NAME_LEVEL_3 AGENCY_NAME_LEVEL_2 AGENCY_NAME_LEVEL_1 MATCH_EMPLOYER_NAME SOLICITOR_LAST_NAME LAST_NAME FMGR_LAST_NAME SOLICITOR_LAST_NAME EMPLOYER_NAME ADVISOR_LAST_NAME FUND_FMGR_LAST_NAME THIRD_PARTY_NAME ORGN_FMGR_LAST_NAME PRIMARY_ADVISOR_LAST_NAME |
|
SPRIDEN | SPRIDEN_FIRST_NAME | ADMINISTRATOR_FIRST_NAME PRIMARY_ADVISOR_FIRST_NAME ADVISOR_FIRST_NAME FMGR_FIRST_NAME SOLICITOR_FIRST_NAME ORGN_FMGR_FIRST_NAME FUND_FMGR_FIRST_NAME PRINCIPAL_INVESTIGATOR_FNAME ORGN_FMGR_FIRST_NAME SOLICITOR_FIRST_NAME PRIMARY_INSTRUCTOR_FIRST_NAME RELATED_FIRST_NAME FIRST_NAME SOLICITOR_FIRST_NAME FIRST_NAME FMGR_FIRST_NAME FUND_FMGR_FIRST_NAME |
|
SPRIDEN | SPRIDEN_MI | FUND_FMGR_MIDDLE_NAME ORGN_FMGR_MIDDLE_NAME FUND_FMGR_MIDDLE_NAME ORGN_FMGR_MIDDLE_NAME PRINCIPAL_INVESTIGATOR_MNAME FMGR_MIDDLE_NAME FMGR_MIDDLE_NAME MIDDLE_NAME MIDDLE_NAME |
|
SPRIDEN | SPRIDEN_ENTITY_IND | VENDOR_ENTITY ACCOUNT_ENTITY_IND ENTITY_TYPE |
|
SPRIDEN | SPRIDEN_NTYP_CODE | NAME_TYPE |
|
SPRIDEN | ? | APPOINTMENT_RECRUITER |
|
SPRIDEN | F_FORMAT_NAME | AGENCY_NAME |
|
SPRIDEN | NOT AVAILABLE | RELATED_SUFFIX |
|
SPRIDEN | SPBPERS_PIDM | PERSON_UID |
|
SPRIDEN | SUBSTR(SPRIDEN_MI 1) | MIDDLE_INITIAL |
|
SPRIDEN | SPRIDEN_ID | CARRIER_ID |
|
SPRIDEN | SPBPERS_PIDM | PERSON_UID |
|
SPRIDEN | SPBPERS_SSN | TAX_ID |
|
SPRIDEN | SPRIDEN NAME FUNCTION | ADVISOR_NAME_FMIL APPOINTMENT_RECRUITER_DESC INTERVIEWER_NAME |
|
SPRIDEN | SPRIDEN NAME FUNCTION? | ADVISOR_NAME_LFMI |
|
SPRIDEN | SPRIDEN_BIRTH_DATE | RELATED_BIRTH_DATE |