Target Column	Business Definition	Database Data Type	Source Name	Source Column
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
GEOGRAPHIC_DIVISION	Institution defined geographic division used to group together a set of geographic regions.	VARCHAR2(10)	GORSGEO	GORSGEO_GEOD_CODE
GEOGRAPHIC_DIVISION_DESC	Geographic division code description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
GEOGRAPHIC_REGION	Institution defined geographic region associated with a geographic division that will be associated with persons and institutions to group report those within a geographic location.	VARCHAR2(10)	GORSGEO	GORSGEO_GEOR_CODE
GEOGRAPHIC_REGION_DESC	Geographic region code description.	VARCHAR2(30)	STVGEOR	STVGEOR_DESC
GEOGRAPHIC_REGION_STATUS	Identifies the geographic region/division as active or inactive for the institution address.	VARCHAR2(1)	CALCULATION	DECODE(GORSGEO_STATUS_IND,NULL,'A','I')
GEOGRAPHIC_REGION_STATUS_DESC	Geographic region status description.	VARCHAR2(30)	CALCULATION	DECODE(GORSGEO_STATUS_IND,NULL,'ACTIVE','INACTIVE')
GEOGRAPHIC_SOURCE_USER_IND	Indicates whether the source for the geographic region/division was a user manual entry or assigned by the system using institution rules.	VARCHAR2(1)	CALCULATION	DECODE(GORSGEO_SOURCE_IND,'S','N','Y')
INSTITUTION	Source/background institution code.	VARCHAR2(6)	GORSGEO	GORSGEO_SBGI_CODE
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
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: