Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
CHART_OF_ACCOUNTS		Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(1)		FTVPROG	FTVPROG_COAS_CODE
CHART_OF_ACCOUNTS_DESC		Chart of accounts code description or title.	VARCHAR2(35)		FUNCTION	F_GET_FINANCE_DESC
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DATA_ENTRY_PERMITTED	Data Entry Permitted	Determines if the code is used for data entry (Y)es data entry permitted, or used for reporting (N)o data entry not permitted.	VARCHAR2(1)		FTVPROG	FTVPROG_DATA_ENTRY_IND
DATA_ENTRY_PERMITTED_DESC	Data Entry Permitted Description	Data entry permitted description.	VARCHAR2(25)		FUNCTION	CASE WHEN FTVPROG_DATA_ENTRY_IND
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
MIF_DESC		Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE		Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
PROGRAM		Identification accounting code use to identify the program classification structure or a subset or that structure as defined by the national council of higher education management systems.	VARCHAR2(6)		FTVPROG	FTVPROG_PROG_CODE
PROGRAM_DESC		Program code description.	VARCHAR2(35)		FTVPROG	FTVPROG_TITLE
PROGRAM_DESC_1		Retrieves description or title level 1 within this program hierarchy.	VARCHAR2(35)		FUNCTION	FOKODSF.F_GET_PROG_HIER
PROGRAM_DESC_2		Retrieves description or title level 2 within this program hierarchy.	VARCHAR2(35)		FUNCTION	FOKODSF.F_GET_PROG_HIER
PROGRAM_DESC_3		Retrieves description or title level 3 within this program hierarchy.	VARCHAR2(35)		FUNCTION	FOKODSF.F_GET_PROG_HIER
PROGRAM_DESC_4		Retrieves description or title level 4 within this program hierarchy.	VARCHAR2(35)		FUNCTION	FOKODSF.F_GET_PROG_HIER
PROGRAM_DESC_5		Retrieves description or title level 5 within this program hierarchy.	VARCHAR2(35)		FUNCTION	FOKODSF.F_GET_PROG_HIER
PROGRAM_LEVEL		Level of the program within the program hierarchy.	NUMBER		CALCULATION	LEVEL
PROGRAM_LEVEL_1		Retrieves level 1 program within this program hierarchy.	VARCHAR2(6)		FUNCTION	FOKODSF.F_GET_PROG_HIER
PROGRAM_LEVEL_2		Retrieves level 2 program within this program hierarchy.	VARCHAR2(6)		FUNCTION	FOKODSF.F_GET_PROG_HIER
PROGRAM_LEVEL_3		Retrieves level 3 program within this program hierarchy.	VARCHAR2(6)		FUNCTION	FOKODSF.F_GET_PROG_HIER
PROGRAM_LEVEL_4		Retrieves level 4 program within this program hierarchy.	VARCHAR2(6)		FUNCTION	FOKODSF.F_GET_PROG_HIER
PROGRAM_LEVEL_5		Retrieves level 5 program within this program hierarchy.	VARCHAR2(6)		FUNCTION	FOKODSF.F_GET_PROG_HIER
PROGRAM_STATUS		Current status of the associated program.	VARCHAR2(1)		FTVPROG	FTVPROG_STATUS_IND
PROGRAM_STATUS_1		Retrieves status of level 1 program within this program hierarchy.	VARCHAR2(1)		FUNCTION	FOKODSF.F_GET_PROG_HIER
PROGRAM_STATUS_2		Retrieves status of level 2 program within this program hierarchy.	VARCHAR2(1)		FUNCTION	FOKODSF.F_GET_PROG_HIER
PROGRAM_STATUS_3		Retrieves status of level 3 program within this program hierarchy.	VARCHAR2(1)		FUNCTION	FOKODSF.F_GET_PROG_HIER
PROGRAM_STATUS_4		Retrieves status of level 4 program within this program hierarchy.	VARCHAR2(1)		FUNCTION	FOKODSF.F_GET_PROG_HIER
PROGRAM_STATUS_5		Retrieves status of level 5 program within this program hierarchy.	VARCHAR2(1)		FUNCTION	FOKODSF.F_GET_PROG_HIER
TERMINATION_DATE	Termination Date	Date when this program is no longer in effect.	DATE		FTVPROG	FTVPROG_TERM_DATE
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: