RETURN TO COMPOSITE VIEW REPORTS LIST
Human Resources Composite View Reports

SGHE Operational Data Store
Composite View Target: AN_SUPERVISOR

Target Column Business Definition Database Data Type Source Name Source Column
CURRENT_DATE This is the system current date (sysdate) DATE    
DOMAIN_VALUE Domain column for future use, not currently populated. VARCHAR2(6)    
EFFECTIVE_DATE The Date that the Positions record becomes effective. DATE    
JOB_SUFFIX Position suffix. VARCHAR2(2)    
MIF_DESC The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(30)    
MIF_VALUE The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(6)    
PERSON_UID System generated number that is internally generated to uniquely identify the person. NUMBER(8)    
POSITION The position number this position is attached to. VARCHAR2(6)    
POSITION_CONTRACT_TYPE Indicates whether this is the (P)rimary, (S)econdary, or (O)verload position. VARCHAR2(1)    
POSITION_CONTRACT_TYPE_DESC Indicates whether this is the (P)rimary, (S)econdary, or (O)verload position. VARCHAR2(30)    
POSITION_STATUS The status of the position. Valid values are: A-active, B-leave without pay with benefits, L-leave without pay without benefits, F-leave with full pay and benefits, P-leave with partial pay and benefits, T-terminated. VARCHAR2(1)    
POSITION_STATUS_DESC Position Status description. VARCHAR2(40)    
POSITION_TITLE Description of the position. Defaults from the Position Title if left blank. VARCHAR2(30)    
SUPERVISOR_JOB_SUFFIX Suffix associated with the supervisors position. VARCHAR2(2)    
SUPERVISOR_POSITION The position number of the supervisor. VARCHAR2(6)    
SUPERVISOR_TITLE Title associated with the supervisors position. VARCHAR2(30)    
SUPERVISOR_UID Identification number of the supervisor for this position. NUMBER    
ZONE_VALUE Zone column for future use, not currently populated. VARCHAR2(6)    


Ver: 3.1