Target Column	Business Definition	Database Data Type	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	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.	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	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: