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

Banner Operational Data Store
Composite View Target: AP_BARGAINING_UNIT

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

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
BARGAINING_UNIT Bargaining unit code associated with this person. VARCHAR2(2)

PERBARG

PERBARG_BARG_CODE

NO

NO
BARGAINING_UNIT_DESC Bargaining unit code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

NA

SYSDATE

NO

NO
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

NO

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

PERBARG

PERBARG_EFFECTIVE_DATE

NO

NO
EFFECTIVE_END_DATE End effective date. DATE

PERBARG

PERBARG_END_DATE

NO

NO
EFFECTIVE_START_DATE Start effective date. DATE

PERBARG

PERBARG_EFFECTIVE_DATE

NO

NO
MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

NO

NO
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

NO

NO
OFFICER_IND Indicates whether the person holds an officer position. VARCHAR2(0)

NA

NA

NO

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

PERBARG

PERBARG_PIDM

NO

NO
RELATIONSHIP_STATUS Relationship status the employee has with the selected bargaining unit. VARCHAR2(2)

PERBARG

PERBARG_BURE_CODE

NO

NO
RELATIONSHIP_STATUS_DESC Relationship status the employee has with the selected bargaining unit. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

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

PERBARG

PERBARG_BARG_SENIORITY_DATE

NO

NO
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA

NO

NO


Ver: