Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Human Resources Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AP_BARGAINING_UNIT

Description Source composite view contains bargaining unit information relating to an employee.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
BARGAINING_UNIT Bargaining unit code associated with this person.    

PERBARG

PERBARG_BARG_CODE

 
BARGAINING_UNIT_DESC Bargaining unit code description.    

FUNCTION

GOKODSF.F_GET_DESC

 
CURRENT_DATE System current date (sysdate) or date the data was extracted.    

NA

SYSDATE

 
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined.    

NA

NA

 
EFFECTIVE_DATE Date on which the bargaining unit became effective for this person.    

PERBARG

PERBARG_EFFECTIVE_DATE

 
EFFECTIVE_END_DATE End effective date.    

PERBARG

PERBARG_END_DATE

 
EFFECTIVE_START_DATE Start effective date.    

PERBARG

PERBARG_EFFECTIVE_DATE

 
MIF_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
OFFICER_IND Indicates whether the person holds an officer position.    

NA

NA

 
PERSON_UID System generated, unique, internal identification number assigned to this person.    

PERBARG

PERBARG_PIDM

 
RELATIONSHIP_STATUS Relationship status the employee has with the selected bargaining unit.    

PERBARG

PERBARG_BURE_CODE

 
RELATIONSHIP_STATUS_DESC Relationship status the employee has with the selected bargaining unit.    

FUNCTION

GOKODSF.F_GET_DESC

 
SENIORITY_DATE Seniority date associated with this bargaining unit for this person.    

PERBARG

PERBARG_BARG_SENIORITY_DATE

 
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 


Ver: 8.3