Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ADVANCEMENT_PROGRAM_YEAR	Program year. Used to allow the program-prospect to exist for each year of a program.	VARCHAR2(15)				NO
CLEARANCE	Indicates what type of solicitation clearance has been granted for the program prospect. Example: Cleared for solicitation, Note cleared for solicitation, Conditionally cleared for solicitation, 6-month clearance, etc.	VARCHAR2(63)				NO
CLEARANCE_LD	Clearance long description.	VARCHAR2(255)				NO
CLEARANCE_SD	Clearance short description.	VARCHAR2(255)				NO
PRIMARY_ADV_PROGRAM_IND	Indicates whether this program takes priority as the primary program if multiple programs are linked to the prospect.	NUMBER				NO
PRIMARY_ADV_PROGRAM_IND_LD	Primary program indicator long description.	VARCHAR2(255)				NO
PRIMARY_ADV_PROGRAM_IND_SD	Primary program indicator short description.	VARCHAR2(255)				NO
PROGRAM_PROSPECT_ATTRIBUTE_KEY		NUMBER				NO
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)				NO
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE				NO
USER_ATTRIBUTE_01		VARCHAR2(63)				NO
USER_ATTRIBUTE_01_LD		VARCHAR2(255)				NO
USER_ATTRIBUTE_01_SD		VARCHAR2(255)				NO
USER_ATTRIBUTE_02		VARCHAR2(63)				NO
USER_ATTRIBUTE_02_LD		VARCHAR2(255)				NO
USER_ATTRIBUTE_02_SD		VARCHAR2(255)				NO
USER_ATTRIBUTE_03		VARCHAR2(63)				NO
USER_ATTRIBUTE_03_LD		VARCHAR2(255)				NO
USER_ATTRIBUTE_03_SD		VARCHAR2(255)				NO
USER_ATTRIBUTE_04		VARCHAR2(63)				NO
USER_ATTRIBUTE_04_LD		VARCHAR2(255)				NO
USER_ATTRIBUTE_04_SD		VARCHAR2(255)				NO
USER_ATTRIBUTE_05		VARCHAR2(63)				NO
USER_ATTRIBUTE_05_LD		VARCHAR2(255)				NO
USER_ATTRIBUTE_05_SD		VARCHAR2(255)				NO

Ver: 9.0