Reporting View Target: PERSONNEL_ACTION

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

SGHE Banner Operational Data Store
Reporting View Target: PERSONNEL_ACTION_EARNING

Description Provides the data details for the person, transaction number and approval type when the default earning codes are changed by the personnel action. 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.
Recommended Search Columns PAF_TRANSACTION_NUMBER
PERSON_UID, PAF_TRANSACTION_NUMBER
PERSON_UID, PAF_TRANSACTION_NUMBER, POSITION, JOB_SUFFIX, EARNINGS

Target Column Business Definition Database Data Type Source Name Source Column

ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

EARNINGS Identifies the transaction approval default earnings code. VARCHAR2(63)
NORTERN

NORTERN_EARN_CODE

EARNINGS_DESC Earnings code long description. VARCHAR2(255)
PTREARN

PTREARN_LONG_DESC

EARNINGS_END_DATE End date for this earnings code. DATE
NORTERN

NORTERN_CANCEL_DATE

EARNINGS_HOURS Hours or units to default for this earnings code. NUMBER
NORTERN

NORTERN_HRS

FEDERAL_EMPLOYMENT_HOURS Hours for federal employment reporting. Used to report hours for Canadian Employment Insurance. NUMBER
NORTERN

NORTERN_DEEMED_HRS

ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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(63)
NORTERN

NORTERN_SUFF

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)
NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

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

MGKFUNC.F_GET_PERSON_INFO

PAF_APPLY_STATUS Status of the personnel action sequence number. Values may be A = Applied, P = Pending or C = Canceled. VARCHAR2(63)
NORTERN

NORTERN_APPLY_STATUS_IND

PAF_APPLY_STATUS_DESC Personnel action sequence status description. VARCHAR2(255)
FUNCTION

SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATIONWHERE TABLE_NAME = 'PAF_APPLY_STATUS' AND VALUE =PAF_APPLY_STATUS

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(63)
NORTERN

NORTERN_APTY_CODE

PAF_APPROVAL_TYPE_DESC Approval type description. VARCHAR2(255)
NTVAPTY

NTVAPTY_DESC

PAF_COMMENT_COUNT Number of comment records for this transaction and sequence number. NUMBER
FUNCTION

NOKODSF.F_GET_PAF_COMMENT_COUNT

PAF_EARNINGS_DEFAULT_IND Identifies the actions taken under this personnel action transaction number update employee data for the person. The details of these transactions maybe found in the PERSONNEL_ACTION _EARNING reporting view. Each transaction may also create data in one or more personnel action reporting views. VARCHAR2(1)
FUNCTION

MPKFUNC.F_GET_PERSONNEL_ACTION_IND

PAF_EARNING_ACTIVITY_DATE Date of last activity on this record. DATE
NORTERN

NORTERN_ACTIVITY_DATE

PAF_EFFECTIVE_DATE Date the personnel action record became effective. DATE
NORTERN

NORTERN_EFFECTIVE_DATE

PAF_GENERAL_CHANGE_IND Identifies the actions taken under this personnel action transaction number update either the name, ID, address, telephone number or other biographical data for the person. General changes may also include changes to columns on the employee and or job records. The details of these transactions maybe found in the PERSONNEL_ACTION_GENERAL reporting view. Each transaction may also create data in one or more personnel action reporting views. VARCHAR2(1)
FUNCTION

MPKFUNC.F_GET_PERSONNEL_ACTION_IND

PAF_LABOR_DISTRIBUTION_IND Identifies the actions taken under this personnel action transaction number update employee data for the person. The details of these transactions maybe found in the PERSONNEL_ACTION_LABOR_DIST reporting view. Each transaction may also create data in one or more personnel action reporting views. VARCHAR2(1)
FUNCTION

MPKFUNC.F_GET_PERSONNEL_ACTION_IND

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 Identifies if the transaction number includes transactions that are General, Earnings and or Labor Distributions. VARCHAR2(63)
CALCULATION

EARN

PAF_TRANSACTION_TYPE_DESC PAF transaction change type description. VARCHAR2(255)
FUNCTION

SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATIONWHERE TABLE_NAME = 'PAF_TRANSACTION_TYPE' AND VALUE = G.PAF_TRANSACTION_TYPE

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

NOBTRAN_PIDM

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

NORTERN_POSN

POSITION_TITLE Employee position description. Defaults from the position title if left blank. VARCHAR2(255)
FUNCTION

MPKFUNC.F_GET_EMPL_POSITION_INFO

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

SHIFT_NUMBER Shift associated with earnings code. VARCHAR2(63)
NORTERN

NORTERN_SHIFT

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

NORTERN_SPECIAL_RATE

Ver: 8.5

Description	Provides the data details for the person, transaction number and approval type when the default earning codes are changed by the personnel action. 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.
Recommended Search Columns	PAF_TRANSACTION_NUMBER PERSON_UID, PAF_TRANSACTION_NUMBER PERSON_UID, PAF_TRANSACTION_NUMBER, POSITION, JOB_SUFFIX, EARNINGS

Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
EARNINGS	Identifies the transaction approval default earnings code.	VARCHAR2(63)	NORTERN	NORTERN_EARN_CODE
EARNINGS_DESC	Earnings code long description.	VARCHAR2(255)	PTREARN	PTREARN_LONG_DESC
EARNINGS_END_DATE	End date for this earnings code.	DATE	NORTERN	NORTERN_CANCEL_DATE
EARNINGS_HOURS	Hours or units to default for this earnings code.	NUMBER	NORTERN	NORTERN_HRS
FEDERAL_EMPLOYMENT_HOURS	Hours for federal employment reporting. Used to report hours for Canadian Employment Insurance.	NUMBER	NORTERN	NORTERN_DEEMED_HRS
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
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(63)	NORTERN	NORTERN_SUFF
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PAF_APPLY_STATUS	Status of the personnel action sequence number. Values may be A = Applied, P = Pending or C = Canceled.	VARCHAR2(63)	NORTERN	NORTERN_APPLY_STATUS_IND
PAF_APPLY_STATUS_DESC	Personnel action sequence status description.	VARCHAR2(255)	FUNCTION	SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATIONWHERE TABLE_NAME = 'PAF_APPLY_STATUS' AND VALUE =PAF_APPLY_STATUS
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(63)	NORTERN	NORTERN_APTY_CODE
PAF_APPROVAL_TYPE_DESC	Approval type description.	VARCHAR2(255)	NTVAPTY	NTVAPTY_DESC
PAF_COMMENT_COUNT	Number of comment records for this transaction and sequence number.	NUMBER	FUNCTION	NOKODSF.F_GET_PAF_COMMENT_COUNT
PAF_EARNINGS_DEFAULT_IND	Identifies the actions taken under this personnel action transaction number update employee data for the person. The details of these transactions maybe found in the PERSONNEL_ACTION _EARNING reporting view. Each transaction may also create data in one or more personnel action reporting views.	VARCHAR2(1)	FUNCTION	MPKFUNC.F_GET_PERSONNEL_ACTION_IND
PAF_EARNING_ACTIVITY_DATE	Date of last activity on this record.	DATE	NORTERN	NORTERN_ACTIVITY_DATE
PAF_EFFECTIVE_DATE	Date the personnel action record became effective.	DATE	NORTERN	NORTERN_EFFECTIVE_DATE
PAF_GENERAL_CHANGE_IND	Identifies the actions taken under this personnel action transaction number update either the name, ID, address, telephone number or other biographical data for the person. General changes may also include changes to columns on the employee and or job records. The details of these transactions maybe found in the PERSONNEL_ACTION_GENERAL reporting view. Each transaction may also create data in one or more personnel action reporting views.	VARCHAR2(1)	FUNCTION	MPKFUNC.F_GET_PERSONNEL_ACTION_IND
PAF_LABOR_DISTRIBUTION_IND	Identifies the actions taken under this personnel action transaction number update employee data for the person. The details of these transactions maybe found in the PERSONNEL_ACTION_LABOR_DIST reporting view. Each transaction may also create data in one or more personnel action reporting views.	VARCHAR2(1)	FUNCTION	MPKFUNC.F_GET_PERSONNEL_ACTION_IND
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	Identifies if the transaction number includes transactions that are General, Earnings and or Labor Distributions.	VARCHAR2(63)	CALCULATION	EARN
PAF_TRANSACTION_TYPE_DESC	PAF transaction change type description.	VARCHAR2(255)	FUNCTION	SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATIONWHERE TABLE_NAME = 'PAF_TRANSACTION_TYPE' AND VALUE = G.PAF_TRANSACTION_TYPE
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	NOBTRAN	NOBTRAN_PIDM
POSITION	Position number attached to the personnel action.	VARCHAR2(63)	NORTERN	NORTERN_POSN
POSITION_TITLE	Employee position description. Defaults from the position title if left blank.	VARCHAR2(255)	FUNCTION	MPKFUNC.F_GET_EMPL_POSITION_INFO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
SHIFT_NUMBER	Shift associated with earnings code.	VARCHAR2(63)	NORTERN	NORTERN_SHIFT
SPECIAL_RATE	Special rate (if applicable) to be used for this earnings code.	NUMBER	NORTERN	NORTERN_SPECIAL_RATE