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

SGHE Banner Operational Data Store
Composite View Target: AN_PERSONNEL_ACTION_EARNING

Description Source composite view contains default earning code changes associated with personnel actions (PAF) transaction number for the employee over their time. Includes personnel actions with current status for applied and pending transactions.
Key & Frequency One row per person per PAF transaction number per approval type per position per suffix per earning code per effective date.

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
CURRENT_DATE Current Date   DATE      
DOMAIN_VALUE Domain Value Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)  

NA

NA

EARNINGS Earnings Identifies the transaction approval default earnings code. VARCHAR2(3)  

NORTERN

NORTERN_EARN_CODE

EARNINGS_DESC Earnings Description Earnings code long description. VARCHAR2(30)  

PTREARN

PTREARN_LONG_DESC

EARNINGS_END_DATE Earnings End Date Date on which this earnings code is canceled, ended or no longer applied to this position and job suffix for the person. DATE  

NORTERN

NORTERN_CANCEL_DATE

EARNINGS_HOURS Earnings Hours   NUMBER      
FEDERAL_EMPLOYMENT_HOURS Federal Employment Hours Hours for federal employment reporting. Used to report hours for Canadian Employment Insurance. NUMBER  

NORTERN

NORTERN_DEEMED_HRS

JOB_SUFFIX Job Suffix Suffix allows users to define a job with more precision. For example, a user could denote daytime faculty with one suffix and evening school with another. VARCHAR2(2)  

NORTERN

NORTERN_SUFF

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

NA

NA

MIF_VALUE MIF Value   VARCHAR2(6)      
PAF_APPLY_STATUS Paf Apply Status Status of the personnel action sequence number. Values may be A = Applied, P = Pending or C = Canceled. VARCHAR2(1)  

NORTERN

NORTERN_APPLY_STATUS_IND

PAF_APPROVAL_TYPE Paf Approval Type Approval type defaulted for the sequence number per approval category rules. Rule include one record for each basic type of action defined for the approval category, such as establishing a new job assignment or terminating an existing job assignment. VARCHAR2(6)  

NORTERN

NORTERN_APTY_CODE

PAF_APPROVAL_TYPE_DESC Paf Approval Type Description Approval type description. VARCHAR2(30)  

NTVAPTY

NTVAPTY_DESC

PAF_EARNING_ACTIVITY_DATE Paf Earning Activity Date Date of last activity on this record. DATE  

NORTERN

NORTERN_ACTIVITY_DATE

PAF_EFFECTIVE_DATE Paf Effective Date Date the personnel action record became effective. DATE  

NORTERN

NORTERN_EFFECTIVE_DATE

PAF_TRANSACTION_NUMBER Paf Transaction Number System-generated number that is created when you enter information pertaining to an Electronic Personnel Action. NUMBER  

NORTERN

NORTERN_TRANSACTION_NO

PAF_TRANSACTION_TYPE Paf Transaction Type Identifies if the transaction number includes transactions that are General, Earnings and or Labor Distributions. CHAR(4)  

CALCULATION

EARN

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

NOBTRAN

NOBTRAN_PIDM

POSITION Position Position number attached to the personnel action. VARCHAR2(6)  

NORTERN

NORTERN_POSN

SHIFT_NUMBER Shift Number Shift associated with earnings code. VARCHAR2(1)  

NORTERN

NORTERN_SHIFT

SPECIAL_RATE Special Rate Special rate (if applicable) to be used for this earnings code. NUMBER  

NORTERN

NORTERN_SPECIAL_RATE

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

NA

NA



Ver: