Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: AFRCTYP Advancement
SGHE Banner Operational Data Store Composite View Source: AFRCTYP - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
AFRCTYP_ACTIVITY_DATE AFACSLT COMPOSITE VIEW

AA_SOLICITOR_ASSIGNMENT

SOLICITOR_ASSIGN_ACTIVITY_DATE

 
AFRCTYP_ASK_AMOUNT AFACSLT COMPOSITE VIEW

AA_SOLICITOR_ASSIGNMENT

ASK_AMOUNT

 
AFRCTYP_ASK_DATE AFACSLT COMPOSITE VIEW

AA_SOLICITOR_ASSIGNMENT

ASK_DATE

 
AFRCTYP_ASSSIGN_DATE AFACSLT COMPOSITE VIEW

AA_SOLICITOR_ASSIGNMENT

ASSIGN_DATE

 
AFRCTYP_CAMPAIGN AFACSLT COMPOSITE VIEW

AA_SOLICITOR_ASSIGNMENT

CAMPAIGN

 
AFRCTYP_COMMENT AFACSLT COMPOSITE VIEW

AA_SOLICITOR_ASSIGNMENT

ASSIGNMENT_COMMENT

 
AFRCTYP_CONSTITUENT_PIDM AFACSLT COMPOSITE VIEW

AA_SOLICITOR_ASSIGNMENT

ENTITY_UID

 
AFRCTYP_DCYR_CODE AGAGIFT COMPOSITE VIEW

AA_SOLICITOR_ASSIGNMENT

SOLICITATION_YEAR

 
AFRCTYP_PIDM AFACSLT COMPOSITE VIEW

AA_SOLICITOR_ASSIGNMENT

SOLICITOR_UID

 
AFRCTYP_RATER_PIDM AFACSLT COMPOSITE VIEW

AA_SOLICITOR_ASSIGNMENT

RATER_UID

 
AFRCTYP_RATE_CODE AFACSLT COMPOSITE VIEW

AA_SOLICITOR_ASSIGNMENT

RATING

 
AFRCTYP_RSCR_CODE AFACSLT COMPOSITE VIEW

AA_SOLICITOR_ASSIGNMENT

SCREENING

 
AFRCTYP_SEQ_NO AFACSLT COMPOSITE VIEW

AA_SOLICITOR_ASSIGNMENT

ASSIGNMENT_SEQUENCE_NUMBER

 
AFRCTYP_SOLC_CODE AFACSLT COMPOSITE VIEW

AA_SOLICITOR_ASSIGNMENT

SOLICITATION_TYPE

 
AFRCTYP_SOL_ORG AFACSLT COMPOSITE VIEW

AA_SOLICITOR_ASSIGNMENT

SOLICITOR_ORGANIZATION

 
AFRCTYP_USER AFACSLT COMPOSITE VIEW

AA_SOLICITOR_ASSIGNMENT

SOLICITOR_ASSIGN_USER_ID

 
DECODE (AFRCTYP_PIDM, NULL, 'N', 'Y' TBD        
DECODE (AFRCTYP_PIDM, NULL, 'N', 'Y') TBD        
DECODE (AFRCTYP_PIDM, NULL, 'N) TBD COMPOSITE VIEW

AA_SOLICITOR_ASSIGNMENT

SOLICITOR_ASSIGNED_IND

 


Ver: