RETURN TO COMPOSITE VIEW REPORTS LIST
Human Resources Composite View Reports

SGHE 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
BARGAINING_UNIT Bargaining unit code associated with this person. VARCHAR2(2)

PERBARG

PERBARG_BARG_CODE

BARGAINING_UNIT_DESC Bargaining unit code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

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

PERBARG

PERBARG_EFFECTIVE_DATE

EFFECTIVE_END_DATE End effective date. DATE

PERBARG

PERBARG_END_DATE

EFFECTIVE_START_DATE Start effective date. DATE

PERBARG

PERBARG_EFFECTIVE_DATE

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

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

NA

NA

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER(8)

PERBARG

PERBARG_PIDM

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

PERBARG

PERBARG_BURE_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

PERBARG

PERBARG_BARG_SENIORITY_DATE

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

NA

NA



Ver: 3.1