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

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

REPORTING VIEW

SOLICITOR_ASSIGNMENT

SOLICITOR_ASSIGN_ACTIVITY_DATE

 
AFRCTYP_ASK_AMOUNT AFACSLT

REPORTING VIEW

SOLICITOR_ASSIGNMENT

ASK_AMOUNT

 
AFRCTYP_ASK_DATE AFACSLT

REPORTING VIEW

SOLICITOR_ASSIGNMENT

ASK_DATE

 
AFRCTYP_ASSSIGN_DATE AFACSLT

REPORTING VIEW

SOLICITOR_ASSIGNMENT

ASSIGN_DATE

 
AFRCTYP_CAMPAIGN AFACSLT

REPORTING VIEW

SOLICITOR_ASSIGNMENT

CAMPAIGN

 
AFRCTYP_COMMENT AFACSLT

REPORTING VIEW

SOLICITOR_ASSIGNMENT

ASSIGNMENT_COMMENT

 
AFRCTYP_CONSTITUENT_PIDM AFACSLT

REPORTING VIEW

SOLICITOR_ASSIGNMENT

ENTITY_UID

 
AFRCTYP_DCYR_CODE AGAGIFT

REPORTING VIEW

SOLICITOR_ASSIGNMENT

SOLICITATION_YEAR

 
AFRCTYP_PIDM AFACSLT

REPORTING VIEW

SOLICITOR_ASSIGNMENT

SOLICITOR_UID

 
AFRCTYP_RATER_PIDM AFACSLT

REPORTING VIEW

SOLICITOR_ASSIGNMENT

RATER_UID

 
AFRCTYP_RATE_CODE AFACSLT

REPORTING VIEW

SOLICITOR_ASSIGNMENT

RATING

 
AFRCTYP_RSCR_CODE AFACSLT

REPORTING VIEW

SOLICITOR_ASSIGNMENT

SCREENING

 
AFRCTYP_SEQ_NO AFACSLT

REPORTING VIEW

SOLICITOR_ASSIGNMENT

ASSIGNMENT_SEQUENCE_NUMBER

 
AFRCTYP_SOLC_CODE AFACSLT

REPORTING VIEW

SOLICITOR_ASSIGNMENT

SOLICITATION_TYPE

 
AFRCTYP_SOL_ORG AFACSLT

REPORTING VIEW

SOLICITOR_ASSIGNMENT

SOLICITOR_ORGANIZATION

 
AFRCTYP_USER AFACSLT

REPORTING VIEW

SOLICITOR_ASSIGNMENT

SOLICITOR_ASSIGN_USER_ID

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

REPORTING VIEW

SOLICITOR_ASSIGNMENT

SOLICITOR_ASSIGNED_IND

 
DECODE (AFRCTYP_PIDM, NULL, 'N) TBD        


Ver: 9.1