Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Human Resources Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: BARGAINING_UNIT

Description Contains bargaining unit information related to an employee.
Key & Frequency One row per person per bargaining unit per effective date.
Recommended Search Columns PERSON_UID
BARGAINING_UNIT, RELATIONSHIP_STATUS

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
BARGAINING_UNIT Bargaining unit code associated with this employee.    

PERBARG

PERBARG_BARG_CODE

 
BARGAINING_UNIT_DESC Bargaining unit code description.    

FUNCTION

GOKODSF.F_GET_DESC

 
EFFECTIVE_DATE Date from which this employee was eligible to be a member or was a member of the Bargaining Unit.    

PERBARG

PERBARG_EFFECTIVE_DATE

 
EFFECTIVE_END_DATE End effective date.    

PERBARG

PERBARG_END_DATE

 
EFFECTIVE_START_DATE Start effective date.    

PERBARG

PERBARG_EFFECTIVE_DATE

 
ID Person's or organization's current identification number.    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
MEMBERSHIP_STATUS Membership status the employee has with the selected bargaining unit.    

NA

PERBARG

NA

PERBARG_BURE_CODE

 
MEMBERSHIP_STATUS_DESC Membership status code description.    

NA

NA

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

NA

NA

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

NA

NA

 
NAME Name of the person (last name, first name, middle initial) or organization.    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
OFFICER_IND Indicates whether the employee holds an officer position.    

NA

NA

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

PERBARG

PERBARG_PIDM

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

NA

NA

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

PERBARG

PERBARG_BURE_CODE

 
RELATIONSHIP_STATUS_DESC Relationship status description.    

FUNCTION

GOKODSF.F_GET_DESC

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

PERBARG

PERBARG_BARG_SENIORITY_DATE

 


Ver: 8.3